CiviCRM Community Forums (archive)

Trying to upgrade from 4.2.4 to 4.2.5 and getting the error below.

I was going to just add the is_quick_config column in table 'cps', but there is no table 'cps' or 'cpse' or 'cpse1'.  I'm clearly not understanding something here.

I have been clicking the 'skip' button during the upgrade script to see what would happen and, very slowly, the progress bar has been inching across the screen.  After about 1000 clicks, I am at the extreme right hand side of the bar with less than a millimetre to go.  Not sure if I will ever make it past all the hurdles, but thought I would mention what the current state was. 

Any suggestions much appreciated.

Thanks,
Lewis

[Error: Upgrade DB to 4.2.5]

Error Field   Error Value
Type   DB_Error
Code   -19
Message   DB Error: no such field
Mode   16

UserInfo   SELECT cpse.entity_id, cpse.price_set_id FROM `civicrm_price_set_entity` cpse LEFT JOIN civicrm_price_set cps ON cps.id = cpse.price_set_id LEFT JOIN civicrm_price_set_entity cpse1 ON cpse1.price_set_id = cpse.price_set_id WHERE cpse.entity_table = 'civicrm_event' AND cps.is_quick_config = 1 GROUP BY cpse.id HAVING COUNT(cpse.price_set_id) > 1 AND MIN(cpse1.id) <> cpse.id [nativecode=1054 ** Unknown column 'cps.is_quick_config' in 'where clause']

DebugInfo   SELECT cpse.entity_id, cpse.price_set_id FROM `civicrm_price_set_entity` cpse LEFT JOIN civicrm_price_set cps ON cps.id = cpse.price_set_id LEFT JOIN civicrm_price_set_entity cpse1 ON cpse1.price_set_id = cpse.price_set_id WHERE cpse.entity_table = 'civicrm_event' AND cps.is_quick_config = 1 GROUP BY cpse.id HAVING COUNT(cpse.price_set_id) > 1 AND MIN(cpse1.id) <> cpse.id [nativecode=1054 ** Unknown column 'cps.is_quick_config' in 'where clause']

The backtrace is here:


# Function                                                                                                                 Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error))                                           unknown:unknown
1 call_user_func(Array, Object(DB_Error))                                                     /home/euangelion/www/www/sites/all/modules/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: no suc…', -19, 16, Array, ' SELECT cpse.ent…')            /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB.php:968
3 DB_Error->DB_Error(-19, 16, Array, ' SELECT cpse.ent…')                          /home/euangelion/www/www/sites/all/modules/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -19, null, null, ' SELECT cpse.ent…', 'DB_Error', true)                      /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/common.php:1903
5 DB_common->raiseError(-19, null, null, null, '1054 ** Unknown …')               /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError()                                                 /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery(' SELECT cpse.ent…')                     /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/common.php:1216
8 DB_common->query(' SELECT cpse.ent…')                       /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:2421
9 DB_DataObject->_query(' SELECT cpse.ent…')                /home/euangelion/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php:1613
10 DB_DataObject->query(' SELECT cpse.ent…')                                /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:155
11 CRM_Core_DAO->query(' SELECT cpse.ent…', true)                         /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php:922
12 CRM_Core_DAO::executeQuery(' SELECT cpse.ent…')                            /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Upgrade/Incremental/php/FourTwo.php:315
13 CRM_Upgrade_Incremental_php_FourTwo->upgrade_4_2_5('4.2.5')                                       /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Upgrade/Form.php:555
14 CRM_Upgrade_Form::doIncrementalUpgradeStep(Object(CRM_Queue_TaskContext), '4.2.5', '4.2.4', '4.2.5', '/tmp/civicrm-pos…')                                   unknown:unknown
15 call_user_func_array(Array, Array)                                             /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Queue/Task.php:79
16 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))                                  /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Queue/Runner.php:187
17 CRM_Queue_Runner->runNext(true)                                         /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:44
18 {closure}()                                                                      /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Queue/ErrorPolicy.php:80
19 CRM_Queue_ErrorPolicy->call(Object(Closure))                        /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Queue/Page/AJAX.php:47
20 CRM_Queue_Page_AJAX::runNext(Array)                                          unknown:unknown
21 call_user_func(Array, Array)                                                            /home/euangelion/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php:179
22 CRM_Core_Invoke::invoke(Array)                                            /home/euangelion/www/www/sites/all/modules/civicrm/drupal/civicrm.module:500
23 civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')                          unknown:unknown
24 call_user_func_array('civicrm_invoke', Array)                                  /home/euangelion/www/www/includes/menu.inc:517
25 menu_execute_active_handler()                                                          /home/euangelion/www/www/index.php:21
26 {main}  


The error is somewhat baffling.

1. Have you modified any civicrm core files?
2. Do you have any custom modules?
3. Also, is there any reason why you're going to 4.2.5 and not 4.2.1.3 (or is that the plan?)
4. What things are you "skipping"? Just this error?