The Arcive of vBulletin Modifications Site.

Dreaded Mysql Error!! · **Released**: 05-22-2003

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:

Xenon · #2 05-22-2003, 05:37 PM

WHERE userid=

you should enter a valu behind =

MindTrix · #3 05-22-2003, 06:35 PM

ne ideas how too go about fixin it??

MindTrix · #4 05-23-2003, 03:58 PM

Ne one ? plzzzzzzzzzz :'(

Boofo · #5 05-23-2003, 06:15 PM

Have you tried running update counters in the Admin CP?

MindTrix · #6 05-23-2003, 06:26 PM

Yeah i ran them all

and still nothing. Damn mysql

now i cant use my forum till its fixed :S

Boofo · #7 05-23-2003, 06:32 PM

Show us that code in your showthread.php and we'll see if we can figure it out. Is it from a hack?

MindTrix · #8 05-23-2003, 06:40 PM

i tried like 5 times to post it, but im getting a fatal error here so i wont post the whole thing etc.

heres the jist of the error on this site

Fatal error: Maximum execution time of 15 seconds exceeded in

functions.php on line 2805

dunno if that matters. Ne wayz ill attach my file cause it wont let me post it

Boofo · #9 05-23-2003, 06:50 PM

Take that file down, please. You are not allowed to post vb files on here.

Boofo · #10 05-23-2003, 06:52 PM

The code you need is in the forumdisplay.php. I didn't look at the error very well the first time. Just post that query.