Error when creating a page after upgrade
Permalink
I tried to create a new page and I got the following error
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'cDateLastIndexed' in 'field list'] in EXECUTE("UPDATE PageSearchIndex SET cName='Gallery',cDescription='',cPath=NULL,cDatePublic='2011-10-25 13:45:00',content='Page Title\r\n This is text... ',cDateLastIndexed='2011-10-25 13:45:49' WHERE cID='106'") ' in /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'UPDATE PageSear...', false, Object(ADODB_mysql)) #1 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('UPDATE PageSear...', false) #2 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(174): ADOConnection->Execute('UPDATE PageSear...') #3 /usr/www/users/imageee/updates in /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'cDateLastIndexed' in 'field list'] in EXECUTE("UPDATE PageSearchIndex SET cName='Gallery',cDescription='',cPath=NULL,cDatePublic='2011-10-25 13:45:00',content='Page Title\r\n This is text... ',cDateLastIndexed='2011-10-25 13:45:49' WHERE cID='106'") ' in /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw('mysql', 'EXECUTE', 1054, 'Unknown column ...', 'UPDATE PageSear...', false, Object(ADODB_mysql)) #1 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012): ADOConnection->_Execute('UPDATE PageSear...', false) #2 /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-lib.inc.php(174): ADOConnection->Execute('UPDATE PageSear...') #3 /usr/www/users/imageee/updates in /usr/www/users/imageee/updates/concrete5.4.2.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Hmm, I'm not 100% sure, but my guess is that the table and/or column names are the wrong case. If you have access to your database, do the columns have the right camel-casing or is everything lowercase?
Hi beebs, had a look at my database and everything is fine in terms of the casing. I did restore the database to previous version.
I'm guessing I will have to try and update again and see if I get the error again then I will check the database.
I'm guessing I will have to try and update again and see if I get the error again then I will check the database.
