Error msg site down!!!!

[PlayfulGod]

My site wont show anything but this error msg

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT ' at line 2
File: /home/sbchix/public_html/sbc/Sources/TPortal.php
Line: 2115

I was trying to set up the frontpage and all was working fine b4 this

[Lesmond]

Please read the Posting Guidelines

Or try this Below to see is a block may be the problem!

http://yoursite.com/smf/index.php?action=forum;noblocks
or
http://yoursite.com/smf/index.php?noblocks

The first one will get you into your Forum without showing any blocks and the second one will get you to your FrontPage without any blocks.  You will need to change YourSite.com/smf in either one of them to your own Forum site address and you must be logged in as an Admin in order for this to work.  This is useful if you can't get into your Forum because of a block containing bad code.

ZarPrime

[PlayfulGod]

Link to my site: http://www.sportbikechix.com/sbc/index.php
SMF version: SMF ver. 1.1.11
TP version: TP ver. 1.0 beta 5
Theme name and version: Dark Purple
Browser Name and Version: Firefox 3.6
Mods installed: tinyportal, SMF Garage, SMF Media Gallery, Aeva ~ Auto-Embed Video & Audio, Ultimate Profile, Integrate Lightbox, No More Ugly Avatar Scrollbars, Paid Subscriptions, Ad Managment, SMF Arcade. Thats all I can recall atm.
Related Error messages: Database Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IFNULL(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT J' at line 2
File: /home/sbchix/public_html/sbc/Sources/TPortal.php
Line: 2115


I tried the 2 suggestions posted, but neither one worked.

And I've already tried to do a full restore and a database restore to no avail 8(

[PlayfulGod]

I fixed it, sorta, I deleted the entries in the db for the article n block I had created.

[ZarPrime]

PlayfulGod,

You say you fixed it by deleting the entries from the DB but, at this point, I can't even see your site.  I get a 404 error, site not found.

In fact, the problem is probably errant code in one of your blocks.  If you encounter this again, you should be able to get into your admin section by going to --> http://www.sportbikechix.com/sbc/index.php?action=admin;noblocks

Once you are there, turn off all the javascript blocks and the error should go away.  While you are in TP Admin, check your Panel seetings and make sure that "Hide panels when in admin section?" is selected as "Yes" so that you will be able to get to Admin in the future.

ZarPrime

[PlayfulGod]

Thanks, I have those set. Yea I had a reg .com front page b4 n redid the dir structure. Url is http://www.sportbikechix.com. I'm having a issue with another site of mine but I will start a new thread for it.

[ZarPrime]

OK, the we'll mark this topic solved then.

ZarPrime