Trying to upgrade from CiviCRM 4.4.5 to 4.7.11 in Wordpress 4.5/4.4 (problem doesn't change for either WP version) because it stopped working and just printed this when trying to view /wp-admin/admin.php?page=CiviCRM
Sorry but we are not able to provide this at the moment.
DB Error: unknown error
I downloaded v4.7.11, removed the old civicrm code and unpacked the new one, then addressed the settings file (I ended up generating a new settings file via /wp-admin/options-general.php?page=civicrm-install, dropping the database tables that where created, then putting in the DB credentials for the existing CiviCRM database).
Now I ran the database update script - /wp-admin/admin.php?page=CiviCRM&q=civicrm/upgrade&reset=1
- and it looked good, I clicked the button, the progress bar started moving... then this:
[Error: Upgrade DB to 4.5.beta9: SQL]
Error Field Error Value
Type DB_Error
Code -19
Message DB Error: no such field
Mode 16
UserInfo UPDATE `civicrm_dashboard` SET `permission` = 'access my cases and activities,access all cases and activities', `permission_operator` = 'OR' WHERE `name` = 'casedashboard' [nativecode=1054 ** Unknown column 'name' in 'where clause']
DebugInfo UPDATE `civicrm_dashboard` SET `permission` = 'access my cases and activities,access all cases and activities', `permission_operator` = 'OR' WHERE `name` = 'casedashboard' [nativecode=1054 ** Unknown column 'name' in 'where clause']
PEAR_Exception: DB Error: no such field in unknown on line unknown
- DB_Error: DB Error: no such field in unknown on line unknown
Exception trace
Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
1 call_user_func(Array, Object(DB_Error)) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: no suc…', -19, 16, Array, 'UPDATE `civicrm_…') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/DB.php:976
3 DB_Error->DB_Error(-19, 16, Array, 'UPDATE `civicrm_…') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -19, null, null, 'UPDATE `civicrm_…', 'DB_Error', true) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1905
5 DB_common->raiseError(-19, null, null, null, '1054 ** Unknown …') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php:895
6 DB_mysql->mysqlRaiseError() /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php:328
7 DB_mysql->simpleQuery('UPDATE `civicrm_…') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/packages/DB/common.php:1216
8 DB_common->query('UPDATE `civicrm_…') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Utils/File.php:333
9 CRM_Utils_File::sourceSQLFile('mysql://kansas:4…', '-- CRM-15211 UPD…', null, true) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php:196
10 CRM_Upgrade_Form->source('-- CRM-15211 UPD…', true) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php:387
11 CRM_Upgrade_Form->processLocales('/home/kansas/www…', '4.5.beta9') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Form.php:421
12 CRM_Upgrade_Form->processSQL('4.5.beta9') /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Upgrade/Incremental/Base.php:80
13 CRM_Upgrade_Incremental_Base::runSql(Object(CRM_Queue_TaskContext), '4.5.beta9') unknown:unknown
14 call_user_func_array(Array, Array) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/Task.php:88
15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/Runner.php:214
16 CRM_Queue_Runner->runNext(true) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:52
17 CRM_Queue_Page_AJAX::{closure}() /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/ErrorPolicy.php:106
18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Queue/Page/AJAX.php:54
19 CRM_Queue_Page_AJAX::runNext() unknown:unknown
20 call_user_func(Array) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:278
21 CRM_Core_Invoke::runItem(Array) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:86
22 CRM_Core_Invoke::_invoke(Array) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm/CRM/Core/Invoke.php:54
23 CRM_Core_Invoke::invoke(Array) /home/kansas/www/dev/krc_wordpress/wp-content/plugins/civicrm/civicrm.php:1227
24 CiviCRM_For_WordPress->invoke('') unknown:unknown
25 call_user_func_array(Array, Array) /home/kansas/www/dev/krc_wordpress/wp-includes/plugin.php:524
26 do_action('toplevel_page_Ci…') /home/kansas/www/dev/krc_wordpress/wp-admin/admin.php:222
27 {main}
Seems to me that the update script is trying to modify a table and needs the 'name' column, but there is no 'name' column..
Any help would be GREATLY GREATLY APPRECIATED!!!!