vb.org Archive - Database problem.

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

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

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

3lou 55

01-31-2014 09:02 AM

Database problem.

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

01-31-2014 10:51 AM

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

PHP Code:


		
			
 define('DISABLE_HOOKS', true);

So it looks like this:

PHP Code:


		
			
<?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

01-31-2014 12:20 PM

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

Lynne

01-31-2014 06:18 PM

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

Code:

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

02-01-2014 10:56 AM

Quote:

Originally Posted by Lynne (Post 2478251)

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

Code:

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

02-01-2014 05:45 PM

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

02-01-2014 06:47 PM

Try this

Code:

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

02-02-2014 09:35 AM

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.

Code:

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.

All times are GMT. The time now is 04:13 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01088 seconds Memory Usage 1,744KB 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 (4)bbcode_code_printable (2)bbcode_php_printable (1)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: