vb.org Archive - Database error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - Database error (https://vborg.vbsupport.ru/showthread.php?t=234489)

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.

Quote:

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

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.

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.

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?

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 [DATE]1264885302[/DATE] at [TIME]1264885302[/TIME] ---------------

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

Quote:

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?

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.

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

Quote:

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_thank...findthanks&u=1
Referrer :
IP Address : 213.180.209.11
Username : Unregistered
Classname : vB_Database
MySQL Version :

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01150 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: