vb.org Archive - Dreaded Mysql Error!!

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Dreaded Mysql Error!! (https://vborg.vbsupport.ru/showthread.php?t=53243)

MindTrix

05-22-2003 05:45 PM

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:

Xenon

05-22-2003 06:37 PM

WHERE userid=

you should enter a valu behind =

MindTrix

05-22-2003 07:35 PM

ne ideas how too go about fixin it??

MindTrix

05-23-2003 04:58 PM

Ne one ? plzzzzzzzzzz :'(

Boofo

05-23-2003 07:15 PM

Have you tried running update counters in the Admin CP?

MindTrix

05-23-2003 07:26 PM

Yeah i ran them all :p and still nothing. Damn mysql :( now i cant use my forum till its fixed :S

Boofo

05-23-2003 07: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

05-23-2003 07: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

05-23-2003 07:50 PM

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

Boofo

05-23-2003 07: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.

All times are GMT. The time now is 12:20 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01013 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: