site update Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.ctID' in 'field list']
Permalink
HI,
after update site from 5.4.0.5 to 5.6.1.2 in normal situation file site.php look like that
<?php
/*
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', '2764');
define('BASE_URL', 'http://127.0.0.1');
define('DIR_REL', '/2764');
*/
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'admin');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'xyz');
define('BASE_URL', 'http://testdomain.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'xxxrShDxxxxoUrBFWbw6zDJMY8nBtBCLKtMpwxxxx');
?>
-------------------------------------------------------------------
in my it looks like that
<?php
/*
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', '2764');
define('BASE_URL', 'http://127.0.0.1');
define('DIR_REL', '/2764');
*/
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'admin');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'xyz');
define('BASE_URL', 'http://testdomain.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'xxxrShDxxxxoUrBFWbw6zDJMY8nBtBCLKtMpwxxxx');
?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.1.2');?>
------------------------------------------------------------------
When i remove last string <?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.1.2');?>
site not work. i heve error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054:
Unknown column 'Pages.ctID' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID
, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cFilename, Collections.cDateAdded
, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID
, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction
, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID
, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren
, ctName from Pages inner join Collections on Pages.cID = Collections.cID left join
PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID =
PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1") ' in
/home/host/domains/testdomain.com/public_html/concrete/libraries/3rdparty/adodb/
adodb-exceptions.inc.php:78 Stack trace: #0 /home/host/domains/testdomain.com/
public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adod in /home/
host/domains/testdomain.com/public_html/concrete/libraries/3rdparty/adodb/
adodb-exceptions.inc.php on line 78
---------------------------------------------------------------
When i leave last string and update /updates/concrete5.6.1.2 sites works ok.
Update string first showed up when i update to ver.5.6.1
update schedule
5.4.0.4
concrete5.4.1.1
concrete5.4.2.2
concrete5.5.0
concrete5.5.2.1
concrete5.6.0
concrete5.6.0.2
concrete5.6.1 update string
concrete5.6.1.2 update string
after update site from 5.4.0.5 to 5.6.1.2 in normal situation file site.php look like that
<?php
/*
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', '2764');
define('BASE_URL', 'http://127.0.0.1');
define('DIR_REL', '/2764');
*/
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'admin');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'xyz');
define('BASE_URL', 'http://testdomain.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'xxxrShDxxxxoUrBFWbw6zDJMY8nBtBCLKtMpwxxxx');
?>
-------------------------------------------------------------------
in my it looks like that
<?php
/*
define('DB_SERVER', '127.0.0.1');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', '2764');
define('BASE_URL', 'http://127.0.0.1');
define('DIR_REL', '/2764');
*/
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'admin');
define('DB_PASSWORD', 'password');
define('DB_DATABASE', 'xyz');
define('BASE_URL', 'http://testdomain.com');
define('DIR_REL', '');
define('PASSWORD_SALT', 'xxxrShDxxxxoUrBFWbw6zDJMY8nBtBCLKtMpwxxxx');
?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.1.2');?>
------------------------------------------------------------------
When i remove last string <?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php ?><?php define('DIRNAME_APP_UPDATED', 'concrete5.6.1.2');?>
site not work. i heve error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054:
Unknown column 'Pages.ctID' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID
, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cFilename, Collections.cDateAdded
, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID
, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction
, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID
, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren
, ctName from Pages inner join Collections on Pages.cID = Collections.cID left join
PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID =
PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1") ' in
/home/host/domains/testdomain.com/public_html/concrete/libraries/3rdparty/adodb/
adodb-exceptions.inc.php:78 Stack trace: #0 /home/host/domains/testdomain.com/
public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adod in /home/
host/domains/testdomain.com/public_html/concrete/libraries/3rdparty/adodb/
adodb-exceptions.inc.php on line 78
---------------------------------------------------------------
When i leave last string and update /updates/concrete5.6.1.2 sites works ok.
Update string first showed up when i update to ver.5.6.1
update schedule
5.4.0.4
concrete5.4.1.1
concrete5.4.2.2
concrete5.5.0
concrete5.5.2.1
concrete5.6.0
concrete5.6.0.2
concrete5.6.1 update string
concrete5.6.1.2 update string
When i rename updates/concrete5.6.1.2 to updates/_concrete5.6.1.2
I get error:
Warning: require(updates/concrete5.6.1.2/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
Warning: require(updates/concrete5.6.1.2/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
Fatal error: require() [function.require]: Failed opening required 'updates/concrete5.6.1.2/concrete/dispatcher.php' (include_path='.:/usr/local/php5/lib/php') in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
-------------------------------------------------------
My file
/home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php
<?php
if (defined('DIRNAME_APP_UPDATED') && (!isset($GLOBALS['APP_UPDATED_PASSTHRU']) || $GLOBALS['APP_UPDATED_PASSTHRU'] == false)) {
$GLOBALS['APP_UPDATED_PASSTHRU'] = true;
if (is_dir(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED)) {
require(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else {
require(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
}
exit;
}
-------------------------------------------------------------
Original file is a little different:
<?php
if (defined('DIRNAME_APP_UPDATED') && (!isset($GLOBALS['APP_UPDATED_PASSTHRU']) || $GLOBALS['APP_UPDATED_PASSTHRU'] == false)) {
$GLOBALS['APP_UPDATED_PASSTHRU'] = true;
if (is_dir(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED)) {
require(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else if(file_exists(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php')){
require(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else {
die(sprintf('Invalid "%s" defined. Please remove it from %s.','DIRNAME_APP_UPDATED', CONFIG_FILE));
}
exit;
}
---------------------------------------------------------
When I replace to org file i get
Invalid "DIRNAME_APP_UPDATED" defined. Please remove it from /home/host/domains/testdomain.com/public_html/config/site.php.
catalog updates/concrete5.6.1.2 is required to run site correctly?
I get error:
Warning: require(updates/concrete5.6.1.2/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
Warning: require(updates/concrete5.6.1.2/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
Fatal error: require() [function.require]: Failed opening required 'updates/concrete5.6.1.2/concrete/dispatcher.php' (include_path='.:/usr/local/php5/lib/php') in /home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php on line 8
-------------------------------------------------------
My file
/home/host/domains/testdomain.com/public_html/concrete/startup/updated_core_check.php
<?php
if (defined('DIRNAME_APP_UPDATED') && (!isset($GLOBALS['APP_UPDATED_PASSTHRU']) || $GLOBALS['APP_UPDATED_PASSTHRU'] == false)) {
$GLOBALS['APP_UPDATED_PASSTHRU'] = true;
if (is_dir(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED)) {
require(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else {
require(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
}
exit;
}
-------------------------------------------------------------
Original file is a little different:
<?php
if (defined('DIRNAME_APP_UPDATED') && (!isset($GLOBALS['APP_UPDATED_PASSTHRU']) || $GLOBALS['APP_UPDATED_PASSTHRU'] == false)) {
$GLOBALS['APP_UPDATED_PASSTHRU'] = true;
if (is_dir(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED)) {
require(DIR_BASE . '/' . DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else if(file_exists(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php')){
require(DIRNAME_UPDATES . '/' . DIRNAME_APP_UPDATED . '/' . DIRNAME_APP . '/' . 'dispatcher.php');
} else {
die(sprintf('Invalid "%s" defined. Please remove it from %s.','DIRNAME_APP_UPDATED', CONFIG_FILE));
}
exit;
}
---------------------------------------------------------
When I replace to org file i get
Invalid "DIRNAME_APP_UPDATED" defined. Please remove it from /home/host/domains/testdomain.com/public_html/config/site.php.
catalog updates/concrete5.6.1.2 is required to run site correctly?
any help
SITE_INSTALLED_APP_VERSION 5.5.2.1
SITE_APP_VERSION 5.6.1.2
APP_VERSION_LATEST 5.6.1.2
what I must change/improve in site to sleep peacefully :)