Another SQL error...
 

Database error in vBulletin 2.3.4:

Invalid SQL: SELECT * FROM moderator WHERE userid= AND canviewprofile=1
mysql error: You have an error in your SQL syntax near 'AND canviewprofile=1' at line 1

mysql error number: 1064

Date: Wednesday 28th of January 2004 10:57:12 PM
Script: http://www.worldofcars.nu/forum/foru...ions&userid=25
Referer:

I dont know where its appearing since I recieved it in email as a report. Does any1 know ?

it was generated by one of your moderators id guess

i dont have any mods

razorownz,

open moderator.php

And make sure that this code exists in the moderator.php file

Because thats the line of coding thats not working or has been altered. The $bbuserinfo[userid] should produce an idea, but in the error it is not, this could also exist because perhaps and unauthorized user is accessing this page.

Regards,
g-force2k2

okay and if it doesnt exist, where do i put it?

that line looks like this:

} elseif ($permissions[ismoderator] or $ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND canviewprofile=1")) {

which exists in the moderator.php file

razorownz,

that is the correct problem, perhaps one way to fix this problem would be to add:

after:

Hopefully that will solve your problem.

Cheers,
g-force2k2

ive uploaded the new moderator.php with the stated changes, we'll see if any more errors occur... thanks once again