PDA

View Full Version : Little help


cshellworld
02-26-2014, 07:28 PM
recently i move my vbulletin forums to other hosting and i receive almost 200-300 mail with this error. can anyone help me to fix it ?

The error is

Database error in vBulletin 4.2.1:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '66.249.78.59', 1, 'baubau', '', 'post.dateline', 'DESC', 0.00175, 1, '6439,5934', 1393434704, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:527;s:6:\"baubau\";}s:6:\"forums\";i:0;s:7:\"options\";a:3:{s:11:\"starteronly\";i:0;s:11:\"childforums\";i:1;s:6:\"action\";s:7:\"process\";}}', 'f434112a001b2be47336fe66b00e77c4');

MySQL Error : Table 'cshellwo_forum.search' doesn't exist
Error Number : 1146
Request Date : Wednesday, February 26th 2014 @ 05:11:44 PM
Error Date : Wednesday, February 26th 2014 @ 05:11:44 PM
Script : http://www.cshellworld.com/post_thanks.php?do=findthanks&u=527
Referrer :
IP Address : 66.249.78.59
Username : Unregistered
Classname : vB_Database
MySQL Version :


Thanks

Lynne
02-26-2014, 11:38 PM
There is no search table in 4.2.1 - your error is from a modification. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

ForceHSS
02-27-2014, 01:20 AM
Thats abe1 thanks mod fix here (https://vborg.vbsupport.ru/showthread.php?p=2249550#post2249550)

CAG CheechDogg
02-27-2014, 02:03 AM
I get this every once in a while myself too...haven't figured out what causes it...sucks ...