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:

Xenon · #2 05-06-2003, 04:04 PM

Code:

SELECT COUNT(*) AS posts FROM post
WHERE post.visible=1 AND post.threadid= AND

and post.threadid= ???????????

there you should add an value

Crazy Pete · #3 05-06-2003, 10:59 PM

Hm, ok. Well I think this error is related to Erwin's "Search Thread" hack, and here's the query that I have in my search.php.

$getnum=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post
".
iif(strlen(strpos($search[query],"thread."))," LEFT JOIN thread ON thread.threadid=post.threadid ","").
" WHERE post.visible=1 AND $newpostsql $searchthreadquery $search[query]");

Is that what it should be or no? I'm guessing no.

But I did follow the instructions correctly.

Erwin · #4 05-07-2003, 02:17 AM

You installed my hack wrongly. Uninstall it, and install again. That line of code you posted is ALL WRONG.

Too many closing brackets - what did you do???

Crazy Pete · #5 05-07-2003, 03:13 AM

Starting from a fresh 2.3.0 search.php file, added your code to the T, this is the query now...

$getnum=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post
".
iif(strlen(strpos($search[query],"thread."))," LEFT JOIN thread ON thread.threadid=post.threadid ","").
" WHERE post.visible=1 AND $newpostsql $searchthreadquery $search[query]");

Crazy Pete · #6 05-07-2003, 03:16 AM

And here's the original (un-hacked at all) query...

$getnum=$DB_site->query_first("SELECT COUNT(*) AS posts FROM post
".
iif(strlen(strpos($search[query],"thread."))," LEFT JOIN thread ON thread.threadid=post.threadid ","").
" WHERE post.visible=1 AND $newpostsql $search[query]");

Crazy Pete · #7 05-08-2003, 11:02 PM

Still getting that same error...but the query is right according to the directions in that hack.

Erwin · #8 05-08-2003, 11:23 PM

That query looks right. Did you install the bit that tells the file what the variable $searchthreadquery is meant to be? If not, then that line will produce an error.

Crazy Pete · #9 05-08-2003, 11:48 PM

I did. Since it looks like I'm just running around in circles here, would it be possible for me to send you my search.php file for you to look at?

If you would, that would be excellent.

Erwin · #10 05-10-2003, 03:50 AM

Sure, PM it to me.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06864 seconds Memory Usage 2,284KB Queries Executed 23 (?)
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)bbcode_code (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 (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)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!