error upgrading frontendusers

[tonyg]

hi, i am upgrading a couple of cms 1.11 to 2.1.6. I am using apache 2.4x64 and php7.1x64 on windows server 2012r2. the upgrade seemed to go fine, but i cannot upgrade the frontenduser module. when i try to i get this error

Code: Select all

[Tue Jan 03 20:23:42.344345 2017] [php7:error] [pid 3496:tid 984] [client 10.1.1.82:60980] PHP Fatal error:  Uncaught cg_sql_error 'Duplicate column name 'force_chsettings' -- Duplicate column name 'force_chsettings'' in D:\\Websites\\wwwstage\\modules\\CGExtensions\\lib\\class.cge_utils.php:109\n#0 D:\\Websites\\wwwstage\\lib\\adodb_lite\\adodbSQL_drivers\\mysqli\\mysqli_driver.inc(359): cge_utils::{closure}('mysqli', 'EXECUTE', 1060, 'Duplicate colum...', 'ALTER TABLE cms...', false, Object(pear_ADOConnection))\n#1 D:\\Websites\\wwwstage\\lib\\adodb_lite\\adodb.inc.php(315): mysqli_driver_ADOConnection->do_query('ALTER TABLE cms...', -1, -1, false)\n#2 D:\\Websites\\wwwstage\\lib\\adodb_lite\\adodb-datadict.inc.php(329): ADOConnection->Execute('ALTER TABLE cms...')\n#3 D:\\Websites\\wwwstage\\modules\\FrontEndUsers\\method.upgrade.php(567): ADODB_DataDict->ExecuteSQLArray(Array)\n#4 D:\\Websites\\wwwstage\\lib\\classes\\class.CMSModule.php(1117): include('D:\\\\Websites\\\\www...')\n#5 D:\\Websites\\wwwstage\\lib\\classes\\class.moduleoperations.inc.php(830): CMSModule->Upgrade('1.23.3', '2.2.0.6')\n#6 D:\\Websites\\wwwstage\\lib\\classes\\class.moduleoperations.inc. in D:\\Websites\\wwwstage\\modules\\CGExtensions\\lib\\class.cge_utils.php on line 109, referer: https://stage.ultra-fei.com/

i have googled, but do not see anything like this....

i would appreciate any help you can offer

thanks in advance

[milehigh]

Ran into a similar error doing a similar upgrade from 1.11.9 up to 2.1.6.

Here is how I got around it...using the 'duplicate column name' in the error message as my clue:

On method.upgrade.php comment out lines 566 and 567. My installation of FrontEndUsers already had that column in that table that that particular line was trying to add thus causing that error. Once I commented out that line I was able to complete the upgrade.

Code: Select all

EDIT: removed

[tonyg]

thanks for the reply, i will give that a try