vb.org Archive - Getting an error when making a new thread..

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

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Getting an error when making a new thread.. (https://vborg.vbsupport.ru/showthread.php?t=59241)

MaDCaT75

12-17-2003 08:30 PM

Getting an error when making a new thread..

I get this error when I create a new forum and make a new thread in it. The latest hack I installed was lesane's store 3.0....... can anyone help please?

PHP Code:


		
			
Database error in vBulletin 2.3.0:



Invalid SQL: UPDATE forum SET replycount=replycount+1,threadcount=threadcount+1,lastpost='1071699888',lastposter='?ilverWolf' WHERE forumid IN (47,)

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 17th of December 2003 05:24:48 PM

Script: [url]http://www.sims2forums.com/newthread.php[/url]

Referer: [url]http://www.sims2forums.com/newthread.php?s=&forumid=47[/url]

g-force2k2

12-17-2003 08:39 PM

there shouldn't be the space inbetwen lastposter

ie:

PHP Code:


		
			
lastposter

not

PHP Code:


		
			
lastpost  er

Also the end part if the sql doesn't need a comma if you're only using one forum instead just put

PHP Code:


		
			
WHERE forumid=47

instead of

PHP Code:


		
			
WHERE forumid IN (47,)

Regards,
g-force2k2

MaDCaT75

12-17-2003 08:45 PM

I'm looking thru my newthread.php right now.... I dont see any of those errors which you mention..... can you msg me on icq or aim or msn or something please?

g-force2k2

12-19-2003 10:48 AM

Sure, you can pm me your AIM screenname OR if you prefer you can send me the newthread.php file and I can see what changes have to be made.

The first change is probably just an error created when using php tags on vb.org, but as for the second change look for:

PHP Code:


		
			
WHERE forumid IN

You should find that code instance, it could be a variable and not numbers in the parentheses following that code. Hope that helps.

Regards,
g-force2k2

All times are GMT. The time now is 07:11 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01083 seconds Memory Usage 1,724KB 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 (6)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: