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:
* 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:
* 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:
* 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
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?