Another SQL error...

[razorownz]

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 ?

[Zachery]

Originally Posted by razorownz

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

[razorownz]

i dont have any mods

[g-force2k2]

razorownz,

open moderator.php

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

PHP Code:

WHERE userid=$bbuserinfo[userid] AND canviewprofile=1 


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

[razorownz]

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

[razorownz]

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

[g-force2k2]

razorownz,

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

PHP Code:

if ( !$bbuserinfo['userid'] ) :
      show_nopermission (  ) ;
endif ; 


after:

PHP Code:

require ( './global.php' ) ; 


Hopefully that will solve your problem.

Cheers,
g-force2k2

[razorownz]

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