Search doesn't work, times-out the entire site for 2 minutes. nd more

[fileserve-links]

Hello, My board, www.fileserve-links.com is experiencing problems.

Whenever I search for anything through VB search system my website times-out for several seconds and goes offline. Or just take 5-10 for results to be found.

I used to have a forum with 30,000 threads and search did not take that long for sure.

Also, I used to moderate posts for newbies. Now I can't becouse this feature is not working properly on my forum. Lets say I have 30 topics to approve, i press validate and approve. and the site just loads, never finishes.

I do not know what to do. At some point earlier in my old forum I had 1,000 posts to moderate and it worked just fine.

Here are some DB errors that have been emailed to me, I guess from other users when they experienced it. VB emailed me automatically.

This is on a fresh DB and vbulletin set up. I have no idea what's wrong.

I have about 15 reports like that:

Database error in vBulletin 4.0.7:

Invalid SQL:

REPLACE INTO  searchlog
(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
(0,'92.251.70.58','42eec0f448e46ea1207e70d6d63d26a8','defaultdateline','desc',0,1292081386,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:1:{i:0;a:2:{s:4:\"word\";s:6:\"aikido\";s:6:\"joiner\";N;}}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:6:\"aikido\";s:29:\"\0vB_Search_Criteria\0titleonly\";i:0;s:27:\"\0vB_Search_Criteria\0filters\";a:0:{}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:15:\"defaultdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:3;s:31:\"\0vB_Search_Criteria\0searchterms\";a:1:{s:5:\"query\";s:6:\"aikido\";}s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:1:{s:8:\"keywords\";s:32:\"Keyword(s):  <b><u>aikido</u></b>\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:1:{i:0;s:6:\"aikido\";}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:6:\"common\";}','');

MySQL  Error   : Lock wait timeout exceeded; try restarting transaction
Error  Number  : 1205
Request Date  : Saturday, December 11th 2010 @ 06:29:46  PM
Error Date    : Saturday, December 11th 2010 @ 06:30:37  PM
Script        : http://fileserve-links.com/search.php?do=process
Referrer       : http://fileserve-links.com/movies/index3.html
IP  Address    : XXXXXXXXXXXXXXXXXXX
Username      : Unregistered
Classname     :  vB_Database
MySQL Version : 

Database error in vBulletin 4.0.7:

Invalid SQL:

REPLACE INTO  searchlog
(userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,criteria,results)
VALUES
(0,'77.100.138.161','0c83ee47efb8a8e8d0e9bdb06db71b16','defaultdateline','desc',0,1292081412,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:1:{i:0;a:2:{s:4:\"word\";s:4:\"knox\";s:6:\"joiner\";N;}}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:4:\"knox\";s:29:\"\0vB_Search_Criteria\0titleonly\";i:0;s:27:\"\0vB_Search_Criteria\0filters\";a:0:{}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:15:\"defaultdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:3;s:31:\"\0vB_Search_Criteria\0searchterms\";a:1:{s:5:\"query\";s:4:\"knox\";}s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:1:{s:8:\"keywords\";s:30:\"Keyword(s):  <b><u>knox</u></b>\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:1:{i:0;s:4:\"knox\";}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:6:\"common\";}','');

MySQL  Error   : Lock wait timeout exceeded; try restarting transaction
Error  Number  : 1205
Request Date  : Saturday, December 11th 2010 @ 06:30:12  PM
Error Date    : Saturday, December 11th 2010 @ 06:31:04  PM
Script        : http://fileserve-links.com/search.php?do=process
Referrer       : http://fileserve-links.com/adult-18/38262-sasha-knox********puppets.html
IP  Address    : xxxxxxxxxxxx
Username      : Unregistered
Classname     :  vB_Database
MySQL Version : 

Database error in vBulletin 4.0.7:

Invalid SQL:
INSERT INTO  searchgroup (username, contenttypeid, groupid, userid, dateline)
VALUES ( '',  3, 9, 0, 1292244885 )
ON DUPLICATE KEY UPDATE  username = VALUES(username),  contenttypeid = VALUES(contenttypeid), groupid = VALUES(groupid), userid =  VALUES(userid), dateline = VALUES(dateline);

MySQL Error   : Lock wait  timeout exceeded; try restarting transaction
Error Number  : 1205
Request  Date  : Monday, December 13th 2010 @ 03:54:45 PM
Error Date    : Monday,  December 13th 2010 @ 03:55:36 PM
Script        : http://fileserve-links.com/newreply.php?do=postreply&t=234
Referrer       : http://fileserve-links.com/adult-entertainment-18-aka-porn/234-adult-glory-collection-dp-dap-a2m-gangbang-bukkake-blowbang.html
IP  Address    : xxxxxxxxxxxxxx
Username      : midnight
Classname     :  vB_Database
MySQL Version : 

fileserve-links Reviewed by fileserve-links on 13th Dec 2010. Search doesn't work, times-out the entire site for 2 minutes. nd more Hello, My board, www.fileserve-links.com is experiencing problems. Whenever I search for anything through VB search system my website times-out for several seconds and goes offline. Or just take 5-10 for results to be found. I used to have a forum with 30,000 threads and search did not take that long for sure. Also, I used to moderate posts for newbies. Now I can't becouse this feature is not working properly on my forum. Lets say I have 30 topics to approve, i press validate and Rating: 5

[Lock Down]

Use something like heidisql and do a process list to find out what is locking the database.

[fileserve-links]

I'll try that. Anyone else have a clue?

[Mr.WT]

Follow instruction

Download 4.0.7 Vbulletin> Do no upload>Tools php

Tools.php upload inside install folder on ur root
no Command
yourdomain.com/tools

Prob Solve

[fileserve-links]

Follow instruction

Download 4.0.7 Vbulletin> Do no upload>Tools php

Tools.php upload inside install folder on ur root
no Command
yourdomain.com/tools

Prob Solve

Thank You.
Saved my life.

Although I didn't know what to press when I loaded tools.php, I just repaired some tables. It worked ;p