Can't delete page
Permalink
Hi I've tried to delete the search page, but it comes up with the below error can anyone advise. Thanks
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1366: Incorrect integer value: '' for column 'cPendingActionTargetCID' at row 1] in EXECUTE("update Pages set cPendingAction = 'DELETE', cPendingActionUID = 1, cPendingActionDatetime = '2010-02-27 10:44:24', cPendingActionTargetCID = '' where cID = 52") ' in C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1366, 'Incorrect integ...', 'update Pages se...', false, Object(ADODB_mysql)) #1 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(1017): ADOConnection->_Execute('update Pages se...', false) #2 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(766): ADOConnection->Execute('update Pages se...', false) #3 [internal function]: ADOConnection->Query('update Pages se...') #4 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\database.php(73): call_user_func_array(Array, Array) #5 [internal function]: Database->__call('query', Array) #6 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\models\page.php(1297): Database->query('update Pages se...') #7 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\startup\process.php(233): Page->markPendingAction('DELETE') #8 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\dispatcher.php(204): require('C:\Domains\ourb...') #9 C:\Domains\ourbetterlife.co.uk\wwwroot\index.php(2): require('C:\Domains\ourb...') #10 {main} thrown in C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1366: Incorrect integer value: '' for column 'cPendingActionTargetCID' at row 1] in EXECUTE("update Pages set cPendingAction = 'DELETE', cPendingActionUID = 1, cPendingActionDatetime = '2010-02-27 10:44:24', cPendingActionTargetCID = '' where cID = 52") ' in C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php:78 Stack trace: #0 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(1042): adodb_throw('mysql', 'EXECUTE', 1366, 'Incorrect integ...', 'update Pages se...', false, Object(ADODB_mysql)) #1 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(1017): ADOConnection->_Execute('update Pages se...', false) #2 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb.inc.php(766): ADOConnection->Execute('update Pages se...', false) #3 [internal function]: ADOConnection->Query('update Pages se...') #4 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\database.php(73): call_user_func_array(Array, Array) #5 [internal function]: Database->__call('query', Array) #6 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\models\page.php(1297): Database->query('update Pages se...') #7 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\startup\process.php(233): Page->markPendingAction('DELETE') #8 C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\dispatcher.php(204): require('C:\Domains\ourb...') #9 C:\Domains\ourbetterlife.co.uk\wwwroot\index.php(2): require('C:\Domains\ourb...') #10 {main} thrown in C:\Domains\ourbetterlife.co.uk\wwwroot\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78