[Fixed] search for all posts by this user

[JCC]

Generates this error: Database error in vBulletin 2.3.1:
Invalid SQL:
SELECT
post.postid, thread.visible
FROM
post LEFT JOIN thread ON thread.threadid=post.threadid
WHERE
post.visible=1 AND thread.visible=1 AND 1=1 AND post.userid='551'
ORDER BY
post.dateline DESC,post.dateline DESC
LIMIT 0,

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 9
mysql error number: 1064
Date: Thursday 07th of August 2003 07:20:46 PM
Script: http://www.nestreetriders.com/forum/forum/search.php?s=&action=showresults&searchid=12709 (http://www.nestreetriders.com/forum/forum/search.php?s=&action=showresults&searchid=12709)
Referer:

[nuno]

Confirmed

[RUBiK]

Confirmed here as a result of upgrading to 2.3.1 as well. :(

[Steve Machol]

http://www.vbulletin.com/forum/showpost.php?p=508174&postcount=3

[solo]

while we don't have the new version add a

$perpage = 25;

after the error_report line in your search.php to do a quick workaround to that problem.

[stalizard]

while we don't have the new version add a

$perpage = 25;

after the error_report line in your search.php to do a quick workaround to that problem.

that is basically what I did to fix the problem. Except I put a if statement in there.

if($perpage == "")
{
$perpage=25;
}