Search Problem

[drisley]

I'm running a board at http://forum.pcmech.com.

A user has pointed out to me that when they try to search by username without entering a search term, they get an error:

Warning: MySQL: Unable to save result set in /usr/www/users/path/pathname/forum/admin/db_mysql.php on line 93

There seems to have been a slight problem with the PC-Media Tech Forums database.
Please try again by pressing the refresh button in your browser.

Then it proceeds to give mea Invalid SQL query.

Any ideas?

[Steve Machol]

I just did a search like this on your forums and there was no problem. What was the complete contents of that error message?

[drisley]

No, its still doing it. Go to my search page, then type in "drisley" for the username. Do not type any search terms in for the keywords. Then, search by the username. You'll see the error.

[Steve Machol]

Sorry, but once again it worked fine.

[drisley]

Anyone else? I have no doubt you're doing the wrong thing. I just tried again, and its still doing it. And this is server-side, so my browser isn't going to be a factor.

Doesn't make any sense. Would my membership make a difference?

[Steve Machol]

I tried it again and this time I got the error. By the way it would have been helpfukl if you had posted the contents of the error message like I asked in my first post. From the page source:

<!-- Database error in vBulletin 2.2.2:

Invalid SQL: SELECT searchid FROM search WHERE showposts='0' AND query=' 1=1 AND NOT (thread.forumid=\'23\' OR thread.forumid=\'10\' OR thread.forumid=\'29\' OR thread.forumid=\'16\' OR thread.forumid=\'7\')' AND postids='13203,13313,13315,13479,13486,13493,21476,21478,21635,21636,21701,21859,21896,218 99,21901,22590,22748,22807,22808,22809,22995,23001,23003,24643,25339,25340,29857,29890,299 48,29974,30023,30026,30242,30244,30318,30320,30755,30783,30790,30848,30971,30984,31055,314 24,31426,31433,31752,49189,34707,34794,34795,34816,34823,34954,34960,34964,34968,34975,349 78,34982,35094,35095,35173,35174,35178,35271,35310,35480,35482,35487,35624,36127,36171,362 56,36259,36263,36268,36277,36558,36561,36583,36588,36590,36594,36603,36606,36607,36617,366 30,44301,44428,44429,44717,47762,53215,53219,53228,53236,53312,53316,53333,54109,54290,542 92,54815,55406,55412,55632,55935,57936,59271,61749,62458,62471,62601,62840,62976,64490,674 33,68028,68032,68434,72882,72883,73769,74099,74124,74390,74396,74519,74704,75038,75487,756 33,75659,75764,75766,76432,76437,76451,76461,76478,76479,76483,76503,76825,76835,76974,777 59,77769,78037,78044,78258,78354,78356,80007,80172,80741,80744,80747,82635,82645,83100,837 61,85311,86059,87290,87293,87294,89586,91101,100130,100131,103190,103284,103288,103348,103 475,103889,105958,105959,108184,108414,108537,108539,108722,108746,108772,108779,109695,10 9841,109842,109844,109972,109983,109986,110012,110115,110128,110485,110920,111224,111322,1 12233,112542,119658,120524,120526,127370,127635,128070,128823,128910,138797,138832,139148, 142248,142689,142716,142764,145459,146501,146507,146508,146513,146522,146860,146862,147108 ,147112,147368,151771,152069,152072,152074,152375,152387,152402,152424,152432,152668,15273 2,155131,155178,157399,167321,173151,174102,174106,174107,174269,174441,175876,175878,1758 80,176349,176542,176546,176847,177066,177338,177748,178454,178456,178458,178518,179201,179 759,181116,181438,182579,183291,184172,184669,184670,184683,184701,184876,185229,185608,18 6579,186580,186818,186863,186971,187016,187040,187052,187323,187462,187492,187493,187530,1 87543,187559,187583,187725,188308,188520,188654,190777,190779,190845,190872,190958,190959, 191793,192137,192197,192199,192237,192275,192278,192569,192631,193157,193501,193505,193852 ,193857,194108,194110,195144,195153,195336,195720,195742,195919,195929,196142,196146,19628 5,196340,196345,196416,196421,196422,196515,196548,196957,196963,197296,197299,197302,1976 03,197990,198004,198060,198085,198153,198220,198224,199441,199749,199754,200080,' AND querystring=''
mysql error:

mysql error number: 0

Date: Tuesday 16th of April 2002 02:56:17 PM
Script: http://forum.pcmech.com/search.php
Referer: http://forum.pcmech.com./search.php?
-->

I suggest you upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory and run it from your browser.

[drisley]

Will give it a try. Should I shut the forum down while I do it? Its a fairly busy forum.

[Steve Machol]

Yes, it's best to shutdown the forum first. Good luck!