CiviCRM Community Forums (archive)

I am trying to upgrade from 4.1 to 4.4  In joomla 2.5 

Please any insights will be appreciated.

I get the following error:

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'refresh_date' in 'where clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
UPDATE civicrm_group g
SET    refresh_date = 20140206232803
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20140206232303) < 5
AND    refresh_date IS NULL
 [nativecode=1054 ** Unknown column 'refresh_date' in 'where clause']
    [type] => DB_Error
    [user_info] =>
UPDATE civicrm_group g
SET    refresh_date = 20140206232803
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20140206232303) < 5
AND    refresh_date IS NULL
 [nativecode=1054 ** Unknown column 'refresh_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="
UPDATE civicrm_group g
SET    refresh_date = 20140206232803
WHERE  TIMESTAMPDIFF(MINUTE, cache_date, 20140206232303) < 5
AND    refresh_date IS NULL
 [nativecode=1054 ** Unknown column 'refresh_date' in 'where clause']"]
)

I seem to remember getting a similar error on one of the upgrades- following the Scheme Integrity instruction below fixed it

http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades