[Forum] Database error in vBulletin 4.0.1: Error 1146

[MrKramer]

I got this error many times a day:

Database error in vBulletin 4.0.1:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '66.249.65.xxx', 1, 'Pachicola', '', 'post.dateline', 'DESC', 7.64523, 1, '2216', 1265760954, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{ i:594;s:9:\"Pachicola\";}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\";}}', '3127e2226942c76362dc07f3f4985692');

MySQL Error : Table 'beasty1952.search' doesn't exist
Error Number : 1146
Request Date : Tuesday, February 9th 2010 @ 07:15:54 PM
Error Date : Tuesday, February 9th 2010 @ 07:16:18 PM
Script : "**many different**"
Referrer :
IP Address : 66.249.65.xxx
Username : Niet geregistreerd
Classname : vB_Database
MySQL Version :

i looked in ACP-->Settings-->search type and that is standing on "DB Search" (it's the only option)

Does anyone know how this can be fixed?

[Lynne]

That is from a modification. There is no table called 'search' in vb4. There was in vB3 though. So, turn off the modification and you should stop getting the errors.

[MrKramer]

I found the problem, it was in my "Thank You hack"

But thanks for your reaction!

[fabioski]

I found the problem, it was in my "Thank You hack"

It's the same for me. How did you solve the problem? Now I have stopped the mod but it is very appreciated from users so I need to repair it. Any idea?
Thanks.

[Phaedrus]

Good question. My population loves that hack. Which table would it run instead?

[Paul M]

The equivelent table is called searchlog.

However, the table definition and contents are not exactly the same, so you cannot just change the name in any code.

[Phaedrus]

Man, this upgrade has been unpleasant. Hacks I thought would be available are not, when I try to fix them I find out that even the simplest functions have been made complex and that I have to add thirty plugins to render things...

I'm going to need to take a class on this...

[Phaedrus]

Anyway, I simply shut off the profile links that put in a search link and it stopped all the database errors. I would just like to fix that particular part if I can. Is there some blog or something that covers new search functionality in vb4?