Activity Stream
48,167 MEMBERS
6976 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 5 of 5
  1.     
    #1
    Member
    Website's:
    hqmoviesforipad.com

    Lightbulb 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 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:

    PHP Code: 
    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  
    SaturdayDecember 11th 2010 06:29:46  PM
    Error Date    
    SaturdayDecember 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 

    PHP Code: 
    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  
    SaturdayDecember 11th 2010 06:30:12  PM
    Error Date    
    SaturdayDecember 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 

    PHP Code: 
    Database error in vBulletin 4.0.7:

    Invalid SQL:
    INSERT INTO  searchgroup (usernamecontenttypeidgroupiduseriddateline)
    VALUES '',  3901292244885 )
    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  
    MondayDecember 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 . 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
    Jedziemy z Koksem.

  2.   Sponsored Links

  3.     
    #2
    Respected Member
    Use something like heidisql and do a process list to find out what is locking the database.

  4.     
    #3
    Member
    Website's:
    hqmoviesforipad.com
    I'll try that. Anyone else have a clue?
    Jedziemy z Koksem.

  5.     
    #4
    Banned
    Website's:
    Warez-Town.info latestrelease.org freakshare.biz
    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

  6.     
    #5
    Member
    Website's:
    hqmoviesforipad.com
    Quote Originally Posted by Mr.WT View Post
    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
    Jedziemy z Koksem.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. traffic from search engines decreased x6 times
    By vab0las in forum Webmaster Discussion
    Replies: 3
    Last Post: 18th Jun 2011, 12:10 PM
  2. Rardownload doesn't work
    By banano in forum Forum and DDL Discussion
    Replies: 16
    Last Post: 1st Mar 2011, 05:10 PM
  3. DevilsDDL.com - Get More Traffic With a Minutes Work
    By MaXiCoM in forum Forum and DDL Discussion
    Replies: 26
    Last Post: 5th Nov 2010, 03:09 PM
  4. [TuT] 50$/day for 10 minutes of work [TuT]
    By powlow29 in forum Webmasters, Money Making
    Replies: 4
    Last Post: 14th Feb 2010, 03:50 AM
  5. [TuT] 50$/day for 10 minutes of work [TuT]
    By powlow29 in forum Tutorials and Guides
    Replies: 1
    Last Post: 13th Feb 2010, 05:07 PM

Tags for this Thread

BE SOCIAL