Upgrade problems...

[Timo_Denmark]

Hi I am going to upgrade my instalations off review, photo, classified.. but i kinda forgot what version that my instalations where when i did upload the new files - how do i find the version, or can i simply run all upgrade scripts from the beginning to ensure that everything is working ??

1) How does i locate my version number ?
2) Is it possible to just run all upgradescript from the beginning.. alike from 1->2 and so on?

Thanks!

[Timo_Denmark]

3) And if there where some error, during a install. Is it then possible to fix it by running the same, or upgrades from the beginning ?

[Timo_Denmark]

Okay - I kinda keept going and got trough the upgrade( lots of statement og dublicated inputs and warnings) there is just one minor issue..

The images is not showing, and after a little browsing i noticed that the error where very simple.. the files in the data store are named like this 1XXX.jpg but the reviewpost are looking after 11XXX.jpg - a extra 1 is apparently added to the url. How do i fix that ?

[Chuck S]

It would appear to me you can step3 of the 3.2 upgrade more than once where it specifically tells you not to.

You need to restore a backup of your photos table and run the required upgrades ONCE.

[Timo_Denmark]

Okay - So i basical reload the database, and start over with the upgrade.. I where wondering if the problem might have been that my version where not 2.8 bur mabye 2.9 ( found the version in the config file, wich might have been an older typo ) would that make the error ?

[Chuck S]

No the error you have is because of exactly why I posted you ran an upgrade twice that must only be ran once.

[Timo_Denmark]

Tried it twize - emptied the DB, loading the old version, and rerun the upgrade script, and excactly the same happens...

Any ideas ?

Gets a lot of these kind of messages :
"Error: Duplicate entry '239' for key 1

[Chuck S]

duplicates would mean your running a script that is not needed if your database is truly old

As far as the twice part you can only run an upgrade script ONCE. This is why you keep getting your issue because you run it twice where it says only run once therefore it prepends userids on the files twice not once

[Timo_Denmark]

Okay - this is what i did.

Deleted all tables in the databse, imported old database.
Did run the upgrade.php once..

Same error - did the above once more, and got same error..

duplicates would mean your running a script that is not needed if your database is truly old

So I should ignore the v.2.8 note and try 2.9-> or higher until i dont get the duplicate errors ? (1 delete tables, reload db, run upgrade)..

Thanks...

[Chuck S]

Yes you do not want to run the script where it updates filenames more than once

[Timo_Denmark]

Thanks.. Isent there some way of telling the correct version other than the config file - mine where as expected old 2.8 but i ended upgrading from 3.2 -3.32..

anyway going to upgrade classified, and post - so get ready for more questions

[Chuck S]

The version is listed right in the admin panel statistics