![]() |
Mysql error - lastpostby
hi, my forum - http://www.thugnature.net/forums has had an error when u visit the front page....
the messsage i am being given is - Database error in vBulletin 2.2.5: Invalid SQL: SELECT iconid,thread.title AS title FROM thread WHERE lastposter='Eli'Jah' AND thread.lastpost=1025437486 AND open!='10' ORDER BY lastpost DESC mysql error: You have an error in your SQL syntax near 'Jah' AND thread.lastpost=1025437486 AND open!='10' ORDER BY lastpost DESC' at line 1 mysql error number: 1064 Date: Tuesday 02nd of July 2002 12:47:48 PM Script: http://www.thugnature.net/forums/forums/ Referer: some1 told me there should be an addslashes there somewere, but i really dont know what to do as they didnt help me...cause they wouldnt tell me how to fix it... i have edited alot of the files for installing hacks, but have stuck to the instructions! but plz can some1 help! thanks |
What hack did you install there?
|
I think I know what's wrong, you have someone with a username of Eli'Jah, in thory, that one part of his name Eli' is causeing the troble (look at the red thing) because (remember, I'm just thinking if it is or not, I'm no PHP god) it's like ending it, I think for you to fix it is by changeing the line from:
PHP Code:
PHP Code:
in thory, it should work but, I don't know what I'm doing, but if this helps, I'll be surpise :D good luck ;) |
You want to have addslashes($forum['lastposter'])...
|
thanks firefly, learning something new everyday :)
|
i tried editing that, but it gave me a parse error.....are u sure i add that?
|
any other suggestions?
|
All times are GMT. The time now is 01:42 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|