[fixed] vBulletin (forum) Database error!

[tariqalali]

I installed 2.2.1 and fully operational. I get this error frequently. Does anyone have any clue why ?

Invalid SQL: SELECT privatemessage.*,touser.username AS tousername,fromuser.username AS fromusername,icon.title AS icontitle,icon.iconpath FROM privatemessage,user AS touser,user AS fromuser LEFT JOIN icon ON icon.iconid=privatemessage.iconid WHERE privatemessage.userid='347' AND folderid=0 AND touser.userid=privatemessage.touserid AND fromuser.userid=privatemessage.fromuserid AND messageread=0 AND privatemessage.fromuserid<> AND privatemessage.fromuserid<>120 AND privatemessage.fromuserid<>112 AND privatemessage.fromuserid<>56 ORDER BY dateline DESC mysql error: You have an error in your SQL syntax near 'AND privatemessage.fromuserid<>120 AND privatemessage.fromuserid<>112 AND privat' at line 1

mysql error number: 1064

Date: Tuesday 11th of December 2001 04:30:22 PM
Script: http://alazraq.com/diwania/diwania/usercp.php?s=
Referer:


Thank you.

-Tariq

[Wayne Luke]

Because there is a bug in the code...

Open up usercp.php and find the following line:

$ignoreusers="AND privatemessage.fromuserid<>".implode(" AND privatemessage.fromuserid<>",explode(" ",$bbuserinfo[ignorelist]));


Change it to:

$ignoreusers="AND privatemessage.fromuserid<> 0".implode(" AND privatemessage.fromuserid<>",explode(" ",$bbuserinfo[ignorelist]));

[tariqalali]

thank you for your quit reply.

-Tariq
ALAZRAQ.com