Only error I'm getting now -- no idea how to fix!

[Crazy Pete]

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/forums/forums/search.php?s=&action=showresults&searchid=5271
Referer:

[Xenon]

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]

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]

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]

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]

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]

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

[Erwin]

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]

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]

Sure, PM it to me.

[Crazy Pete]

Thanks very much, Erwin. Sent.

[Crazy Pete]

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]

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?