please, I really really need urgently help:
I prepared an upgrade from vB
3.0.x to 3.6.4 and from Photopost 4.81 to 5.62 locally. I changed styles etc. and everything went fine.
Today I tried to upgrade my production server, which is heavily visited nowadays.
- I closed vB and photopost,
- uploaded all files for vB
- run upgrade-script for vB
- all went fine - vB is 3.6.4
- I uploaded all files for PP
- run upgrade script
- first choice was "4.82" (but this gives a blank page)
- so I started with "4.85/.86" - scripts worked till last one,
- I got an error:
PhotoPost Upgrade |
Preparing to update database...
Error performing MySQL command: CREATE TABLE search ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 5 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'search' already exists
Upgrade complete! You should continue to next step
Whoow, was what that?! No I have heavy problems:
Photopost looks like shown on attachment: the upgrade on the categories must have gone wrong
and vB is not running anymore
, because table "search" was deleted - from PP I cannot believe!
What went wrong - is vB
3.6.4 not compatible with PP 5.62 because they own a same called table? How can that be? And what is this category problem? Trying to show some photos is successfull.
And furthermore I am logged in in vB
, Photopost recognizes me but does not show me the admin-link and trying to open adm-index.php says "you are not a valid adminsitrator".
I really need urgent help - what to do?
Thanks a lot in advance!