Bug introduced by CRM-7717: civicrm_task_action_temp% tables not deleted

[ken]

I get the following message in my 3.4.0 logs. It appears to be a side-effect of CRM-7717.

I think 'created_date' should be replaced by 'CREATE_TIME' in CRM/Core/BAO/Cache.php on line 181. However, further surgery appears to be required as lines 179 and 180 duplicate each other (logically A OR A is the same as A, so I suspect the author meant to change line 180).

May 02 08:43:37  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [ 0 ] => CRM_Core_Error
            [1] => handle
        )

    [ code ] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT TABLE_NAME as tableName
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_SCHEMA = ''
AND    ( TABLE_NAME LIKE 'civicrm_task_action_temp%'
 OR      TABLE_NAME LIKE 'civicrm_task_action_temp%' )
AND    created_date < date_sub( NOW( ), INTERVAL 2 day )
 [nativecode=1054 ** Unknown column 'created_date' in 'where clause']
    [type] => DB_Error
    [user_info] =>
SELECT TABLE_NAME as tableName
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_SCHEMA = ''
AND    ( TABLE_NAME LIKE 'civicrm_task_action_temp%'
 OR      TABLE_NAME LIKE 'civicrm_task_action_temp%' )
AND    created_date < date_sub( NOW( ), INTERVAL 2 day )
 [nativecode=1054 ** Unknown column 'created_date' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SELECT TABLE_NAME as tableName
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_SCHEMA = ''
AND    ( TABLE_NAME LIKE 'civicrm_task_action_temp%'
 OR      TABLE_NAME LIKE 'civicrm_task_action_temp%' )
AND    created_date < date_sub( NOW( ), INTERVAL 2 day )
 [nativecode=1054 ** Unknown column 'created_date' in 'where clause']"]
)


May 02 08:43:37  [info] $backTrace = /var/www/xxxx/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 205
, handle,
/var/www/xxxx/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 931
/var/www/xxxx/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 968
/var/www/xxxx/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 564
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2420
/var/www/xxxx/sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 1606
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 145
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/DAO.php, query, 869
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php, executeQuery, 185
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/BAO/Cache.php, cleanupCache, 126
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/Session.php, storeSessionToCache, 446
/var/www/xxxx/sites/all/modules/civicrm/CRM/Utils/System.php, storeSessionObjects, 1101
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/Page.php, civiExit, 183
/var/www/xxxx/sites/all/modules/civicrm/CRM/Event/Page/Tab.php, run, 182
/var/www/xxxx/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 223
/var/www/xxxx/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 355
, civicrm_invoke,
/var/www/xxxx/includes/menu.inc, call_user_func_array, 348
/var/www/xxxx/index.php, menu_execute_active_handler, 18

[Donald Lobo]

can u please file a new issue for this (and reference CRM-7717) We'll fix it before 3.4.1 (later this week)

thanx for the detective work

lobo

[websynapse]

Could a MySQL wiz please provide a quick way of removing them all? We now have hundreds of them.