Error upgrading to version 1.5.3

[tamalita]

I was attempting to upgrade from 1.4.2 to 1.5.3. I have not upgraded regularly from 1.4.2 on because anything I tried to do broke my installation and I don't have time to deal with that I use my installation constantly.

So, today, since it is Friday, I decided to spend some time and try to upgrade. I have not been able to do an automatic upgrade through admin for quite some time and have to do a manual upgrade.

 I deleted all old files off the server and replaced with new files. I went to the upgrade location and started the upgrade process.

The first error that I received was:

Code: [Select]

    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Table 'og_template_parameters' already exists
    * Error upgrading to version 1.5.3
So I deleted the table 'og_template_parameters' from my database and ran the upgrade again and received the following error:

Code: [Select]

    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Table 'og_gs_borderstyles' already exists
    * Error upgrading to version 1.5.3
So I deleted the table 'og_gs_borderstyles' and of course had to re-delete the table 'og_template_parameters' from my database. I ran the upgrade again and received this error:

Code: [Select]

    * Config file found and loaded.
    * File '/config/config.php' exists and is writable
    * Folder '/config' exists and is writable
    * Folder '/cache' exists and is writable
    * Folder '/tmp' exists and is writable
    * Folder '/upload' exists and is writable
    * Extension 'mysql' is loaded
    * Extension 'gd' is loaded
    * Extension 'simplexml' is loaded
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Upgrade script has connected to the database.
    * Test query has been executed. Its safe to proceed with database migration.
    * Failed to execute DB schema transformations. MySQL said: Duplicate column name 'cc'
    * Error upgrading to version 1.5.3
I do not know which column this is referring to

Code: [Select]

Duplicate column name 'cc'
And now I have a non-working installation.

I am going to do a completely new installation, but will I be able to add all of my old data?

[Pet]

If it were me, assuming I had a data backup, is try to do consecutive installs starting back at 1.4.2.

[tamalita]

yes, I have a backup of everything. thank you.