View Full Version : upgrade done, saw 1 error
August 14th, 2013, 06:01 AM
My upgrade is complete, and gallery appears to be working now. There was an error, but it allowed me to continue to the next step and finish. I'm not quite sure what this error means, or if I even need to worry about it.
Error performing MySQL command: ALTER TABLE pp_invites CONVERT TO CHARACTER SET utf8;
Error: Table 'power_cbpbacom.pp_invites' doesn't exist
August 14th, 2013, 08:06 AM
Keith is this a result of you hand renaming database tables and not running through the install script like I suggested to make sure you fixed your table issue you where doing by hand.
There most indeed should be an invites table in photopost. That was added way back in PhotoPost 5.62
Likewise if this was some upgrade from an old version and you did not properly run through all upgrades you should do this. You can safely run 5.62 forward again.
The point is you need to run install and or upgrade to make sure make sure you do not have any other issues from the hands on work you did renaming tables etc.
August 15th, 2013, 05:19 AM
That makes sense now. I recall we originally did not have a PP_ database table prefix for many years, and that created some headaches with VBulletin.
So next step would be to backup the SQL database, data/uploads directories, and run an upgrade process from 5.62 forward?
August 15th, 2013, 07:08 AM
I am just suggesting the easiest solution for your issue. Every single issue now since you upgraded seems to be a result of you missing tables either as a result of you not renaming all your tables by hand like you did or missing upgrades I can not say I did not do your upgrade.
I am just saying running through our upgrade process from 5.62 would ensure all tables that are suppose to be there are there and anything missing exists. You should be able to just upload the install directory and run the upgrade script. There is no need to back up data or uploads folders when doing this.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.