PDA

View Full Version : problem with database error


pbforum
09-01-2012, 05:52 AM
Database error in vBulletin 4.2.0:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '107.21.85.246', 1, 'ਅਣਖੀਲ਼ਾਂ ਗੱਭਰੂ', '', 'post.dateline', 'DESC', 0.02521, 1, '1435,1434,1420,1419,1394,1379,941,923,922,781,748 ,746,662,661,494,491,350,210,209,163,145,144,143,1 42,125,113,66', 1346459235, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:11;s:85:\"ਅਣਖੀਲ਼ਾਂ ਗੱਭਰੂ\";}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\";}}', 'bad01b17f26b9057db3622b4801b93c8');

MySQL Error : Table 'punjabi_vbulletin.search' doesn't exist
Error Number : 1146
Request Date : Friday, August 31st 2012 @ 08:27:15 PM
Error Date : Friday, August 31st 2012 @ 08:27:15 PM
Script : http://mysite.com/forum/post_thanks.php?do=findthanks&u=11
Referrer :
IP Address : 107.21.85.246
Username : Unregistered
Classname : vB_Database
MySQL Version :

borbole
09-01-2012, 09:59 AM
Database error in vBulletin 4.2.0:

Invalid SQL:

REPLACE INTO search (userid, ipaddress, personal, searchuser, forumchoice, sortby, sortorder, searchtime, showposts, orderedids, dateline, displayterms, searchhash)
VALUES (0, '107.21.85.246', 1, 'ਅਣਖੀਲ਼ਾਂ ਗੱਭਰੂ', '', 'post.dateline', 'DESC', 0.02521, 1, '1435,1434,1420,1419,1394,1379,941,923,922,781,748 ,746,662,661,494,491,350,210,209,163,145,144,143,1 42,125,113,66', 1346459235, 'a:6:{s:5:\"words\";a:0:{}s:9:\"highlight\";a:0:{}s:6:\"common\";a:0:{}s:5:\"users\";a:1:{i:11;s:85:\"ਅਣਖੀਲ਼ਾਂ ਗੱਭਰੂ\";}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\";}}', 'bad01b17f26b9057db3622b4801b93c8');

MySQL Error : Table 'punjabi_vbulletin.search' doesn't exist
Error Number : 1146
Request Date : Friday, August 31st 2012 @ 08:27:15 PM
Error Date : Friday, August 31st 2012 @ 08:27:15 PM
Script : http://mysite.com/forum/post_thanks.php?do=findthanks&u=11
Referrer :
IP Address : 107.21.85.246
Username : Unregistered
Classname : vB_Database
MySQL Version :


The error message says it all.

MySQL Error : Table 'punjabi_vbulletin.search' doesn't exist

ForceHSS
09-01-2012, 12:05 PM
Looks like the error for the plugin in my sig if so download the search fix from my sig and next time post in the plugin post for support

pbforum
09-01-2012, 05:22 PM
i cannot understand .. what r u talking ?

i have to many emails about this database error

snakes1100
09-01-2012, 05:25 PM
The table doesnt exist as the error states, they are telling you to create the table in the database.

pbforum
09-01-2012, 06:11 PM
now can anyone tell me how i can solve this problem

borbole
09-01-2012, 06:48 PM
now can anyone tell me how i can solve this problem

Unbelievable that you are still asking about this. And with attitude too. Use common sense and you will find the solution to your problem. It is not rocket science.

ForceHSS
09-01-2012, 07:13 PM
the table in question no longer belongs to the vb version you are running so take the time and look over on vbulletin.com site for the fix or put in a support ticket

pbforum
09-02-2012, 10:46 AM
Unbelievable that you are still asking about this. And with attitude too. Use common sense and you will find the solution to your problem. It is not rocket science.


i know what is common sense ..

i cannot talk with any attitude

u dont want to ask me how i can solve no problem

thanks

New Joe
09-02-2012, 11:56 AM
What is the problem?
Maybe ask for some help over on vbulletin.com
Or ask your hosting.
Or pay someone to fix it.
Or fix it by going on what the few other posters have said
Or....

borbole
09-02-2012, 03:27 PM
i know what is common sense ..

i cannot talk with any attitude

u dont want to ask me how i can solve no problem

thanks


I don''t want to argue with you, but if you know what common sense is, then use it. You have been told numerous times above what the problem is. Not to mention that it is very obvious at the error message too. And you still ask what is the problem and tell me how can I solve it in a commanding way, no please no nothing. That is attitude to me.

Lynne
09-02-2012, 04:17 PM
In vb4.2.0, there is no search table. So, your error is from a modification. You either need to disable the modification or you need to fix it.