DB Error after installing pro

[Big-Pete]

Hi ya, As i loved using the Lite version I thought i'd try the Pro version, Installation/upgrade seemed to go ok until i noticed an email telling me that there was a DB error, It looks like im missing a table in the DB, Can I just add a table called game.vboptimise??
I've had several similar emails with DB warnings..

Database error in vBulletin 4.0.3:

Invalid SQL:
select queries from vboptimise where dateline='Apr 21st';

MySQL Error : Table 'game.vboptimise' doesn't exist
Error Number : 1100
Request Date : Wednesday, April 21st 2010 @ 02:11:23 PM
Error Date : Wednesday, April 21st 2010 @ 02:11:24 PM
Script : http://mysite.com/cron.php?rand=1271855476
Referrer : http://mysite.com/f264/cms_content-55759.html#post59296
IP Address : ***-***-***-***
Username : Unregistered
Classname : vB_Database
MySQL Version :

 

[Deceptor]

Hi Big-Pete, when you installed the XML did you previously uninstall the Lite XML as instructed? If not the MySQL table may not have been created. To rectify the issue you'll need to follow a few steps:

1. Disable vB Optimise through the options
2. Uninstall the product via the ACP (leave the files intact).
3. If 2 produces an SQL error which is likely (as it will try to remove a table that does not exist), you'll need to edit the product and remove the "Uninstall Code" then save. Then re-try step #2.
4. Reinstall the pro product XML.
5. Re-enable vB Optimise and configure settings.

Let me know if you have any issues

 

[Big-Pete]

Cheers Mr Decepter All sorted...

 

[Big-Pete]

Just done the update to 2.0 and alls running well, I do like the activity plugin, I can see that your going to be bad for my wealth

 

[Deceptor]

Glad to hear it, btw just incase you missed it - there's a file edit required for Pro documented in the install file, however if you're running PHP 5.3 or greater it's not required, without it the vB Overload Cache feature won't work and that can do wonders if you run the CMS/Sidebar

Also, if you wish to be included on our public statistics (http://www.dragonbyte-tech.com/vboptimisesites.php) feel free to shoot me a PM with your URL and statistics password (if you set one)

 

[Big-Pete]

Yeah i see that thanks...