The Arcive of Official vBulletin Modifications Site.

Only error I'm getting now -- no idea how to fix! · **Released**: 05-06-2003

Any help on this would be appreciated. It's the only error I'm getting. I did run the repair.php script but it didn't help (didn't think it would but I figured it'd be worth a shot).

Also, I did a search but it's kind of hard to search for an exact error:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
WHERE post.visible=1 AND post.threadid= AND 1=1 AND post.userid='166'
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 'AND 1=1 AND post.userid='166'' at line 2

mysql error number: 1064

Date: Monday 05th of May 2003 05:07:44 PM
Script: http://www.expectedmiracles.com/foru...&searchid=5271
Referer:

Crazy Pete · #12 05-10-2003, 12:43 PM

Thanks very much, Erwin. Sent.

Crazy Pete · #13 05-10-2003, 05:55 PM

Ok, I figured out that the error occurs when you do a "search for all posts made by this user" but I'm not sure what caused it or how to fix it, short of uploading a fresh version of search.php and readding the hacks back into that.

I might try that, though.

Crazy Pete · #14 05-11-2003, 12:34 AM

Ok, tried that. Confirmed it IS an error caused by Erwin's "Search Thread" hack. Starting with a fresh 2.3.0 search.php file, added in that hack step by step exactly. Went into a user's profile and clicked "Search for all posts made by this user." Search window came up as though it were searching, then when it went to displa the results, pulled up the error listed above.

Might want to merge this thread with his hack thread?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03816 seconds Memory Usage 2,229KB Queries Executed 18 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (3)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!