Database error

[BrightStar]

Right, I've posted this in vbulletin forums as well but it seems people are not interested that much as this was caused because of a modification.


I installed something called macro google search and forget to disable/uninstall it before the upgrade from 3.8.4 to 4.0.1 https://vborg.vbsupport.ru/showthread.php?t=213169

Now I am continuously having issues. I have contacted the author and he hasnt got much to say.

Database error in vBulletin 4.0.1:

Invalid SQL:

REPLACE INTO _forumsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '65.55.207.51', 1, 'Admin', '', 'post.dateline', 'DESC', 0.00067, 1, '154,122', 1264426506, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{} s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:1;s:9:\" Admin\";}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\";}}', '56afe16364533af30d1ac1c02ae288fa');

MySQL Error : Table 'dgkhan_forum._forumsearch' doesn't exist
Error Number : 1146
Request Date : Monday, January 25th 2010 @ 01:35:06 PM
Error Date : Monday, January 25th 2010 @ 01:35:06 PM
Script : http://www.forums.org/forum/post_tha..._user_gave&u=1
Referrer :
IP Address : 65.55.207.51
Username : Unregistered
Classname : vB_Database
MySQL Version :


Please help :o

[Lynne]

You need to unintall it correctly. Read the install instructions and do it all backwards - that includes removing any files the author had to upload to the site.

[BrightStar]

I've uninstalled it from the products page and it doesnt appear in the forum anywhere. The mod only had one xml file uploaded. When I search in my forum, I don't get any sort of database error emails but some unregister users do it (God knows which way) and I get those emails.

56afe16364533af30d1ac1c02ae288fa keeps changing all the time.

[Lynne]

That is the searchhash, it should change all the time.

I just looked at the mod you linked to and I don't think it has anything to do with your error. Do you have a table called "_forumsearch" in your database?

[BrightStar]

Thanks Lynne. I've just checked and that's what I've got in the database

https://vborg.vbsupport.ru/external/2010/01/8.jpg

--------------- Added 1264885302 at 1264885302 ---------------

Actually searching the error brings quite a few result including this one.

https://vborg.vbsupport.ru/showthread.php?t=165869

Post no 5 suggests running this command in the above thread

ALTER TABLE search ADD prefixchoice MEDIUMTEXT NULL;

Would that fix it?

I am not sure where the error comes from because when I search in the forum, I dont get any erros?

[Lynne]

OK, I see what the problem is... that query is from an addon because there is no table called search (or, with your prefix, _forumsearch) any longer. So, disable the modification and the error will go away.

[BrightStar]

I am still getthing email database error email on regular basis? Someone please help me figure it out.

Database error in vBulletin 4.0.2:

Invalid SQL:

REPLACE INTO _forumsearch (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '213.180.209.11', 1, 'Username', '', 'post.dateline', 'DESC', 0.00078, 1, '9,1', 1268918496, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:1;s:9:\"Usernamer\";}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\";}}', '7be8713902c56850e20efb36319295f5');

MySQL Error : Table 'form_forum._forumsearch' doesn't exist
Error Number : 1146
Request Date : Thursday, March 18th 2010 @ 01:21:36 PM
Error Date : Thursday, March 18th 2010 @ 01:21:36 PM
Script : http://www.form.org/forum/post_thanks.php?do=findthanks&u=1
Referrer :
IP Address : 213.180.209.11
Username : Unregistered
Classname : vB_Database
MySQL Version :

[borbole]

it seems like the search table is missing. try to recreate it and see if it would help.