Page 1 of 1

Front End Users upgrade went wrong

Posted: Wed Jan 13, 2016 7:29 pm
by paulbaker
I was updating a site just now.
Started with 1.11.9. Aiming for 1.12.1.
Updated modules: all OK.
Updated core to 1.12.1: all OK.
Updated modules: most OK.
But it went wrong when I was updating FrontEnd Users to 1.31.

Error 500 and this PHP error:

Code: Select all

[13-Jan-2016 19:14:41 Europe/London] PHP Fatal error:  Uncaught cg_sql_error 'Duplicate column name 'disabled' -- Duplicate column name 'disabled'' in /home/xxxxx/public_html/modules/CGExtensions/lib/class.cge_utils.php:67
#0 /home/xxxxx/public_html/lib/adodb_lite/adodbSQL_drivers/mysql/mysql_driver.inc(369): cge_utils::{closure}('mysql', 'EXECUTE', 1060, 'Duplicate colum...', 'ALTER TABLE cms...', false, Object(pear_ADOConnection))
#1 /home/xxxxx/public_html/lib/adodb_lite/adodb.inc.php(316): mysql_driver_ADOConnection->do_query('ALTER TABLE cms...', -1, -1, false)
#2 /home/xxxxx/public_html/lib/adodb_lite/adodb-datadict.inc.php(329): ADOConnection->Execute('ALTER TABLE cms...')
#3 /home/xxxxx/public_html/modules/FrontEndUsers/method.upgrade.php(386): ADODB_DataDict->ExecuteSQLArray(Array)
#4 /home/xxxxx/public_html/lib/classes/class.CMSModule.php(1179): include('/home/xxxxx/pub...')
#5 /home/xxxxx/public_html/lib/classes/class.moduleoperations.inc.php(734): CMSModule->Upgrade('1.24', '1.31')
#6 /home/xxxxx/public_html/lib/classes/class.moduleoperations.inc.php( in /home/xxxxx/public_html/modules/CGExtensions/lib/class.cge_utils.php on line 67
FEU login page on the front end now shows with a <form> tag, hidden variables, field labels, a button as usual but crucially no input field tags for the 2 fields (username and password).

Also registration page shows OK - showing fields and labels but no button.

I can go to a backup and start the whole process again, but interested in other ideas to salvage this?

Thanks!

Re: Front End Users upgrade went wrong

Posted: Sat Jan 16, 2016 10:07 pm
by Dr.CSS
No system info..?