Dreaded Mysql Error!!

Ohh nooo i got the dreaded mysql error.

Everything was working perfect, till i deleted some members, then some posts. Soon as i did the posts i got errors.

PHP Code:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid= 
mysql 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 '' at line 1

mysql error number: 1064

Date: Wednesday 21st of May 2003 11:26:12 PM
Script: [url]http://www.rapland.co.uk/forum/forum/showthread.php?threadid=12[/url]
Referer: [url]http://www.rapland.co.uk/forum/forumdisplay.php?forumid=36[/url] 


Ne ideas???

:ermm: :disappointed:

[MindTrix]

my bad.soz.

this is the only part i can find that has it

PHP Code:

$accesscache = array();
if ($bbuserinfo['userid']!=0 AND $enableaccess) {
  //Access table perms
  $accessperms=$DB_site->query("SELECT forumid,accessmask FROM access WHERE userid='$bbuserinfo[userid]'");
  while ($accessperm=$DB_site->fetch_array($accessperms)) {
    $accesscache["$accessperm[forumid]"] = $accessperm;
  }
  $DB_site->free_result($accessperms);
  unset($accessperm); 


[Boofo]

This is where the error is:

PHP Code:

SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid= 


That's what you need to find.

[MindTrix]

its not in either showthread.php or forumdisplay.php :s odd

[MindTrix]

i searched in functions.php and i found it

PHP Code:

//start user attachment add By All-the-vb
global $DB_site;
$attachment = $DB_site->query_first("SELECT COUNT(attachmentid) AS total FROM attachment WHERE userid=$post[userid]");
$attachcoun = $attachment[total];
//end user attachment add By All-the-vb 


so seems like its from a hack, but the code looks ok to meh

[MindTrix]

yeahhhhhhhhh i fixed it i jus removewd that, cause i searched the hacks thread and turns out people got the same prob so they uninstalled it, and the author stopped postin back lol. Thanks for everything boofo at least u took the time to help