1.7.3.1. Upgrade Problems

[fengy]

Hi,

I have fengoffice 1.7 installed and I'm trying to upgrade to the latest version.

I've downloaded 1.7.3.1 and extracted the contents of the file in the root of my  fengoffice installation while preserving my existing config files.

I go to public/upgrade and click on 'Upgrade' but I get 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.
Failed to execute DB schema transformations. MySQL said: Duplicate column name 'visible'
Error upgrading to version 1.7.3.1



I'm upgrading from 1.6.2 to 1.7.3.1
There is no '1.7' option in the Upgrade From select list!?...the last available version in the 'Upgrade From' list is 1.6.2 and it is pre-selected


Any suggestions are greatly appreciated!

[damendieta]

It's better if you upgrade first to 1.7 and then to 1.7.3.1...

[nextofsearch]

I have the same issue but the only difference is that I am trying to upgrade from 1.7 to 1.7.31 or 1.74. Neither of them work. public/upgrade page shows no option for 1.7 and I am wondering if we don't need to use public/upgrade page when upgrading from 1.7x to the lasted versions.

I am stucked here. Any help will be appreciated.

[franponce87]

It is as though as the script has already been ran before and some queries were executed, but others not.. You should have to look for the queries and see which have not been executed, and run them yourself.

Take into account that you ALWAYS need to go to public/upgrade AFTER having updated ALL the files in order to run the SQL script which would update the database.

Best regards,
Francisco