CiviCRM Community Forums (archive)

Civi 2.2 alpha3

Steps to reproduce (on my system):

1 - Go to edit previously entered PCP
2 - Edit information and save (I was trying to upload a picture)

The following backtrace results (user-specific info replaced by ".."):

../sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138
, handle,
../sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
../sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966
../sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
../sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
../sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898
../sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
../sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216
../sites/all/modules/civicrm/packages/DB/DataObject.php, query, 2394
../sites/all/modules/civicrm/packages/DB/DataObject.php, _query, 442
../sites/all/modules/civicrm/CRM/Core/DAO.php, find, 814
../sites/all/modules/civicrm/CRM/Contribute/Form/PCP/Campaign.php, commonRetrieve, 203
../sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
../sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, mainProcess, 152
../sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Upload.php, realPerform, 129
../sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
../sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
../sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
../sites/all/modules/civicrm/CRM/Contribute/Page/PCPInfo.php, run, 245
../sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
../sites/all/modules/civicrm/drupal/civicrm.module, invoke, 318
, civicrm_invoke,
../includes/menu.inc, call_user_func_array, 348
../index.php, menu_execute_active_handler, 18
Followed by the following CiviCRM error:

Sorry. A non-recoverable error has occurred.

DB Error: no such field

Database Error Code: Unknown column 'notify_email' in 'field list', 1054

Return to home page.

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT  notify_email 
 FROM civicrm_pcp_block
 
 WHERE (  civicrm_pcp_block.entity_table  = 'civicrm_contribution_page' )  AND (  civicrm_pcp_block.entity_id = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'notify_email' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT  notify_email 
 FROM civicrm_pcp_block
 
 WHERE (  civicrm_pcp_block.entity_table  = 'civicrm_contribution_page' )  AND (  civicrm_pcp_block.entity_id = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'notify_email' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT  notify_email 
 FROM civicrm_pcp_block
 
 WHERE (  civicrm_pcp_block.entity_table  = 'civicrm_contribution_page' )  AND (  civicrm_pcp_block.entity_id = 1 )
 
 
 
 [nativecode=1054 ** Unknown column 'notify_email' in 'field list']"]
)
This is as of alpha3 - alpha1 (as far as I tested) didn't exhibit this behavior.[/code]

I upgraded following the upgrade procedure, as requested. I suppose I should do a fresh install?

2.2 alpha1. That's the only possible upgrade path at the moment, correct? (I know that alpha2 was short-lived.)

I downloaded and decompressed the files and then ran the upgrade following the instructions here: http://wiki.civicrm.org/confluence/display/CRMUPCOMING/Upgrade+Drupal+Sites+to+2.2

I then ran the upgrade command: http://<your_drupal_home>/civicrm/upgrade?reset=1 and it all checked out. Any ideas? Thanks!

Nope - as I said, I upgraded from alpha1. So it would probably be a good idea to check the upgrade routine, no?

Thanks, Kurund. Just so it's noted. I'm actually waiting for alpha4,which I expect will have the iCal CiviEvent feed fix and perhaps a solution to Date calendar incompatibility in Views2. Thanks for the tip - always nice to know I'm not losing my mind... 

On the iCal feed, I'm just referring to this thread here:

http://forum.civicrm.org/index.php/topic,6312.msg27804.html#msg27804

You said

the url issue is fixed and will be part of alpha 4

- is that not the case? Just trying to figure out what's up - I know you must have your hands full.

Back on topic: I realize that a "fresh install" is kinda what I already did; the only way to make it "fresher," I suppose, would be to delete the db and start over. So the upgrade procedure from alpha1 to alpha3 (which we were asked to test) is evidently lacking.

If this is addressed in alpha4/Beta, I'll just wait - the Event integration is pretty important, so I'm at a bit of a standstill here.

Thanks for taking the time - greatly appreciated!

YAY! Worked beautifully! Thank you SO much - especially for responding so quickly. Woo hoo!