Bug Upgrade from Lite to Pro Doesn't Install a Table

[Mokonzi]

I noticed when running the upgrade from Lite to Pro, that it fails to install the vboptimise table in the database that holds the amount of queries saved.

Looking through the XML, it is there (the code to install) but isn't running (or didn't for me).

I installed the tables manually.

The code in question is:

$db->query("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "vboptimise` (
  `statid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queries` int(11) NOT NULL DEFAULT '0',
  `dateline` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`statid`),
  UNIQUE KEY `dateline` (`dateline`)
) ENGINE=MyISAM");
$db->query("insert into " . TABLE_PREFIX . "vboptimise (`dateline`) values ('Installation')");

I ran it twice in case I'd done something wrong, but even after the second time it didn't install.

I can't see the issue of the install process...

 

[Fillip H.]

From the readme.txt file:
Note: If you are upgrading from Lite, you should uninstall the Lite product first from your vB Admin CP (you can leave the files in place).

 

[Mokonzi]

Lol, that would make sense...

Should always read the Readmes...