Upgrading 1.7.5 to 2.3.1.1 (windows server)

[briansmith]

I have gone through all the posts on the forums and still unable to upgrade to the latest version of fengoffice.

Everytime I try to upgrade I get an error saying

Code: [Select]

"Failed to execute DB schema transformations. MySQL said: Table 'fo_administration_tools' already exists"
Things I've done already.

followed the instructions on wiki

Made changes to the mysql_schema.php file (btree related changes)

made changes as indicated at forums.fengoffice.com/index.php?topic=15272.msg32176#msg32176


If im missing something, please let me know!

Thanks!

[briansmith]

Okay so I was able to move from the first error. Turns out I needed to delete all tables with the prefix "fo_" which were created by an earlier failed attempt at updating fengoffice.

Now I'm getting a new error while upgrading...

Code: [Select]

Failed to execute DB schema transformations. MySQL said: Out of range value for column 'priority' at row 1
Thanking everyone in advance!

[briansmith]

I was able to fix the issues by changing the MYSQL mode by following instructions given by palenholik at forums.fengoffice.com/index.php?topic=14907.0


I resolved the issue by changing MYSQL mode in my.ini (located in program files under mysql folder), like this.
1. Open my.ini and find "sql-mode"
2. Comment current settings by putting # key in fornt
3. Set new mode "sql-mode=MYSQL40"
4. Save and Restart MYSQL server,
5. finish Feng Office installation and return previous MYSQL mode.

[briansmith]

The only problem left is that the old linked files aren't working

secondly fo_processed_objects is still at 0

[franponce87]

Hi Brian!

It is really odd that you came across with so many issues.
Whenever we perform an upgrade from Feng 1 to Feng 2 for our clients (only 1% or 2% of them are using Feng 1 for special reasons, but soon will get to Feng 2) we just follow these steps, one by one, and it does work:

http://www.fengoffice.com/web/wiki/doku.php/installation:migration?&#upgrading_from_1x_to_2x

Anyway, I took the opportunity to improve the documentation a bit further there so you might want to try that again step by step.
Hope you find it useful.

Best regards,
Francisco