Bug Site crashed and is unavailable after trying to install vBanalytics

[cykelmyggen]

When trying to install this mod my site crashed and is stille unavailable - so help is nedded urgently.

Database error in vBulletin 4.1.10:

Invalid SQL:

	SELECT data FROM vbdbtech_vbanalytics_session_visits
	WHERE sessionhash = '3885bb0df60df147854c57b0f6872db6';

MySQL Error   : Table 'hw6005_vb.vbdbtech_vbanalytics_session_visits' doesn't exist
Error Number  : 1146
Request Date  : Monday, April 9th 2012 @ 10:55:25 AM
Error Date    : Monday, April 9th 2012 @ 10:55:25 AM
Script        : http://www.boggnasker.dk/
Referrer      : 
IP Address    : 95.166.113.159
Username      : Boris
Classname     : vB_Database
MySQL Version : 5.1.28-rc

 

[Pandemikk]

Hello,

For some reason that table wasn't created during the installation.

You'll need to edit config.php and add: define('DISABLE_HOOKS', true); to disable plugins (https://www.vbulletin.com/docs/html/disable_plugins).

After that, please run this query to create the table:

CREATE TABLE IF NOT EXISTS `dbtech_vbanalytics_session_visits` (
		`sessionhash` CHAR( 32 ) NOT NULL DEFAULT '',
		`data` MEDIUMTEXT NOT NULL DEFAULT '',
		PRIMARY KEY ( `sessionhash` )
);

Verify the table has been created and then it will be safe to disable debug mode.

 

[cykelmyggen]

Actually I disabled hooks and tried to uninstall vBanalytics to get my site up running. However I was not able to uninstall the product properly - it is still visible in the menu with asteriks around, but is gone in the products overview. So I guess restoring the table would not be such a good idea, or...?

Now I get this error:

Database error in vBulletin 4.1.10:

Invalid SQL:

	SELECT data FROM vbdbtech_vbanalytics_session_visits
	WHERE sessionhash = '3885bb0df60df147854c57b0f6872db6';

MySQL Error   : Table 'hw6005_vb.vbdbtech_vbanalytics_session_visits' doesn't exist
Error Number  : 1146
Request Date  : Monday, April 9th 2012 @ 11:47:40 AM
Error Date    : Monday, April 9th 2012 @ 11:47:40 AM
Script        : http://www.boggnasker.dk/
Referrer      : 
IP Address    : 95.166.113.159
Username      : Boris
Classname     : vB_Database
MySQL Version : 5.1.28-rc

EDIT: Now I get this one - and the config is made from the 4.1.10 version of vB - so I'm pretty confused about the mention of 3.6.+ in this message?

Configuration: includes/config.php exists, but is not in the 3.6+ format. Please convert your config file via the new config.php.new.

EDIT 2: Managed to get things up running again, reinstalled vBanalytics and only "error" now is that it is missing in the ACP menu? Tried to disable/enable and afterwards reinstall again, but still no menu in ACP.

 

[Pandemikk]

Please rebuild bitfields.

If you still are having issues please PM me with a ACP & FTP login so I can debug.

 

[cykelmyggen]

Problem solved, thanks