Database problem.

[3lou 55]

Hello there,

So we recently transfered hosts, and the host actually transfered the database for us too.
(Still on the same host, but another hosting plan actually).
The transfer seems to be done okay, but we still are encouraging problems with the forums.
Table 'grind007_forumsv4.tagcontent' doesn't exist.
That is the error that we keep getting when trying to uninstall/install/disable plugins.
Alot of plugins are also not working anymore because of this, we had a shoutbox from vbshout on it, which is not working anymore, it keeps stuck on "Loading...", and I am not able to uninstall the plugin and install it again, because we keep getting this database error.

Altho when we look at the database on phpmyadmin, the tagcontent table is still there.
Does anyone have a solution for this?

We are using vbulletin 4.2.2

Cheers,
Jordy

[ozzy47]

Open your includes/config.php file and below<?php add this line:

define('DISABLE_HOOKS', true);

So it looks like this:
<?php
define('DISABLE_HOOKS', true);
/*================================================= =====================*\
|| ################################################## ################## ||
|| # vBulletin 4.2.2

Then see if the issues still persist.

If not, then I would suggest updating all your mods with the latest versions.

[3lou 55]

Nope tried that also :/ I just can't manage to uninstall anything.

[Lynne]

And if you open the database, do you see the tagcontent table? Here is the query to add it:

CREATE TABLE tagcontent (
tagid INT UNSIGNED NOT NULL DEFAULT 0,
contenttypeid INT UNSIGNED NOT NULL,
contentid INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY tag_type_cid (tagid, contenttypeid, contentid),
KEY id_type_user (contentid, contenttypeid, userid),
KEY user (userid),
KEY dateline (dateline)
)

[3lou 55]

And if you open the database, do you see the tagcontent table? Here is the query to add it:

CREATE TABLE tagcontent (
tagid INT UNSIGNED NOT NULL DEFAULT 0,
contenttypeid INT UNSIGNED NOT NULL,
contentid INT UNSIGNED NOT NULL DEFAULT '0',
userid INT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY tag_type_cid (tagid, contenttypeid, contentid),
KEY id_type_user (contentid, contenttypeid, userid),
KEY user (userid),
KEY dateline (dateline)
)

Nope getting the same error.
https://vborg.vbsupport.ru/external/2014/02/48.png
damn,
I have tried it in phpmyadmin too.

[Lynne]

You will need to get help from your host in making sure that table is completely gone (all three files associated with it) and then recreating it.

[ForceHSS]

Try this

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tagcontent`
-- ----------------------------
DROP TABLE IF EXISTS `tagcontent`;
CREATE TABLE `tagcontent` (
`tagid` int(10) unsigned NOT NULL default '0',
`contenttypeid` int(10) unsigned NOT NULL,
`contentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`tagid`,`contenttypeid`,`contentid`),
KEY `id_type_user` (`contentid`,`contenttypeid`,`userid`),
KEY `user` (`userid`),
KEY `dateline` (`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

[3lou 55]

Okay, my host had to delete it and readd it again, everything seems to work fine now.
The only thing is that I am not able to install one plugin.

Database error in vBulletin 4.2.2:

Invalid SQL:

INSERT INTO dbtech_vbshout_shout
(userid, dateline, message)
VALUES
('-1', 1391337188, 'Congratulations on your installation of DragonByte Tech: vBShout! We have taken the liberty of setting some default options for you, but you should enter the AdminCP and familiarise yourself with the various settings. Use the /prune command to get rid of this message, or double-click it and click the Delete button. Enjoy your new Shoutbox!');

MySQL Error : Failed to read auto-increment value from storage engine
Error Number : 1467
Request Date : Sunday, February 2nd 2014 @ 10:33:08 AM
Error Date : Sunday, February 2nd 2014 @ 10:33:13 AM
Script : http://forum.grinderscape.org/admincp/plugin.php?do=productimport
Referrer : http://forum.grinderscape.org/admincp/plugin.php?do=productadd
Classname : vB_Database
MySQL Version : 5.5.34-cll

But I will ask the plugin maker about this, thanks for the help y'all.