import data from older version??

rjteeter · December 23rd, 2007, 11:01 AM

I just installed a fresh copy of photopost instead of doing an upgrade. I used the same directory the old version(5.31) was in and used a new databse. I am moving the data folder from the old version to the new version.

Now, which tables can I export from the old database to import into the new databse to reclaim all of the data I previously had?

rjteeter · December 23rd, 2007, 11:05 AM

I forgot to add the users database is being read from my VB3 DB.

Chuck S · December 23rd, 2007, 11:37 AM

You can not import data from older versions. You must correctly upgrade that older version to the latest version. So possibly run an install on the old database tables to get settings correct and then upgrade the tables with the upgrade script and select versions you need to run.

rjteeter · December 23rd, 2007, 02:46 PM

bah. i put everything back to the stock 5.31, uploaded all of the new hard files ino the gallery directory over writing the old files then ran the upgrade script and got these errors;

Error performing MySQL command: ALTER TABLE pp_photos ADD allowrate INT(1) DEFAULT '1' NOT NULL, ADD allowcoms INT(1) DEFAULT '1' NOT NULL;
Error: Duplicate column name 'allowrate'

Error performing MySQL command: INSERT INTO pp_settings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)
Error: Duplicate entry '220' for key 1

what did i get myself into?

rjteeter · December 23rd, 2007, 02:48 PM

then i continued the upgrade from 5.5 to 5.6 and got these errors:

Preparing to update database...

Error performing MySQL command: ALTER TABLE pp_users ADD lastphoto INT( 12 ) NOT NULL DEFAULT '0', ADD lastdate INT( 15 ) NOT NULL DEFAULT '0'
Error: Duplicate column name 'lastphoto'

Error performing MySQL command: CREATE TABLE pp_searchids ( 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 'pp_searchids' already exists

Error performing MySQL command: INSERT INTO pp_settings VALUES (221,'Require users to be registered to use search?','searchreg','','no',1,14)
Error: Duplicate entry '221' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (222,'Maximium number of search results to return?','searchmax','On larger sites, the less the better.','500',2,14)
Error: Duplicate entry '222' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (223,'Number of seconds between searches?','searchto','The number of seconds a user must wait between searches.','30',3,14)
Error: Duplicate entry '223' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (224,'Number of days to hold search results?','searchhold','','7',5,14)
Error: Duplicate entry '224' for key 1

Error performing MySQL command: INSERT INTO pp_settings VALUES (225,'Display who is viewing a category?','catonline','This option adds a query to the Show Gallery page.','yes',5,4)
Error: Duplicate entry '225' for key 1

rjteeter · December 23rd, 2007, 02:57 PM

heh. im on a roll. the tumbnails work but the larger images are missing.

http://nystreetscene.com/gallery/

scratch that. nothing shows now.

rjteeter · December 23rd, 2007, 05:27 PM

Code:

Content visible to verified customers only.

Is it just me or is this a typo?? Shouldn't it say only upgrade if you have 5.3x not 5.2x??

Chuck S · December 23rd, 2007, 06:13 PM

No there is an upgrade for every version through the latest one. Your photopost is not setup correctly from what I see. Duplicate mysql errors are not an issue. You just need to run the 5.3-6.0 upgrade scripts and also correct all the urls settings etc noted in the how to move thread since your new photopost is not located where your telling photopost it is at since you moved it. Your settings table has all the urls and paths.

rjteeter · December 23rd, 2007, 06:29 PM

If that is not a typo then there is no upgrade option for 5.3x

This is how im seeing it:

Click on "5.2x to 5.3" to upgrade from 5.2x - Get this message
"This install script will upgrade your 5.2x release to 5.3. Only run this upgrade if you have the 5.2x version of the database in place (either by previous upgrades or if upgrading in order to the latest)."

^^ that one is fine.

Click on "5.3x to 5.5" to upgrade from 5.3x **BUT** Get this message
"This install script will upgrade your 5.3x release to 5.5. Only run this upgrade if you have the 5.2x version of the database in place (either by previous upgrades or if upgrading in order to the latest)."

^^That does not look rite to me

and then this one
Click on "5.5 to 5.6" to upgrade from 5.5 and get this message;
" This install script will upgrade your 5.5 release to 5.6. Only run this upgrade if you have the 5.5 version of the database in place (either by previous upgrades or if upgrading in order to the latest)."

^^Thats one seems rite to.

Maybe I am totally missing something but the 5.3x to 5.5 conflicts with the following message that sais Only run this upgrade if you have the 5.2??

rjteeter · December 23rd, 2007, 06:31 PM

Quote:

Originally Posted by Chuck S

No there is an upgrade for every version through the latest one. Your photopost is not setup correctly from what I see. Duplicate mysql errors are not an issue. You just need to run the 5.3-6.0 upgrade scripts and also correct all the urls settings etc noted in the how to move thread since your new photopost is not located where your telling photopost it is at since you moved it. Your settings table has all the urls and paths.

I have been messing around with database and directory stuff all day so what you are seeing now is different that what i was posting about hours ago.

Chuck S · December 23rd, 2007, 06:46 PM

Nothing looks abnormal to me just run the upgrades ONCE from 5.2 to 6.0

Your issue has nothing to do with the upgrade you seem to have mistakenly replaced your config files with new ones which are causing issues because the proper data is not inputed there look at the error viewing your site tells me you have the wrong table prefix or database info as we can not find your settings table. So what info in your config is incorrect?

Quote:

Database not properly setup - unable to read pp_settings table. Contact administrator.

rjteeter · December 23rd, 2007, 07:03 PM

i am still confused about the wording but ill give what you just said a try as it seems a little more straight forward.

Thanks for sticking with me here, ive got myself in a bit of a mess

Chuck S · December 23rd, 2007, 07:22 PM

well as stated just make sure all the variables in the config-inc.php file are correct to find your correct photopost database with the proper prefix and you should be able to upgrade. My response is based on the error noted in my last post which is displayed on your site which has nothing to do with an upgrade.