I have some mysql issues on my vBulletin 4.2 P3 forum. I'm wondering if there is a possible fix for the issues that we are having on the site. Here is the database error I get when I try to fix the unique indexes on my database:
In addition we are getting errors saying that certain tables no longer are there. The tables that are not there are:
vbcontenttype
vbsearchgroup
vbsearchlog
vbtag
vbtagcontent
Will I have to reinstall or would it be possible to run the upgrade script to see if these tables cannot be replaced. I looked at the database tables and these tables are indeed missing. Thanks for your help.
Code:
Database error in vBulletin 4.2.0: Invalid SQL: SHOW KEYS FROM vbcontenttype; MySQL Error : Table 'forum1_forums.vbcontenttype' doesn't exist Error Number : 1146 Request Date : Monday, April 1st 2013 @ 05:36:36 PM Error Date : Monday, April 1st 2013 @ 05:36:37 PM Script : http://xxxxxxx.com/forums/admincp/repair.php?do=fixunique Referrer : http://xxxxxxx.com/forums/admincp/repair.php?do=list IP Address : 71.226.100.133 Username : user Classname : vB_Database MySQL Version : 5.1.68-cll
vbcontenttype
vbsearchgroup
vbsearchlog
vbtag
vbtagcontent
Will I have to reinstall or would it be possible to run the upgrade script to see if these tables cannot be replaced. I looked at the database tables and these tables are indeed missing. Thanks for your help.
Comment