CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • CiviEvent
Pages: [1] 2

Author Topic: CiviEvent  (Read 3298 times)

ToddFur

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
CiviEvent
March 07, 2009, 08:31:19 pm
I upgraded my civiCRM to take advantage of the new feature that allowed you to register multiple particpants to the same email address (this was new for 2.2 release). However when I went to check that box and clicked on "save" I got the following:
Code: [Select]
Sorry. A non-recoverable error has occurred.
DB Error: no such field

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

Return to home page.

Error Details:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = NULL , registration_start_date = 20090127000000 , registration_end_date = 20090408000000 , intro_text = 'Select your CKD Bells -- CKD INTRO INFO (J-Net can type whatever here....)  (No pix, attachment ability)' , footer_text = 'Footer Area... J-Net can type whatever here (No pix, attachment ability)' , confirm_title = 'Confirm Your Registration Information' , confirm_text = 'Thank you...  CKD DAY INFO, ETC (No pix, attachment ability)' , confirm_footer_text = 'Can type something here (No pix, attachment ability)' , is_email_confirm = 1 , confirm_email_text = 'confirmation email here!' , confirm_from_name = 'Ben\'s Bells' , confirm_from_email = 'bensbells@bensbells.org' , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You for Registering' , thankyou_text = 'Thank u text here....(No pix, attachment ability)' , thankyou_footer_text = 'can type something here (No pix, attachment ability)' , is_multiple_registrations = 1 , allow_same_participant_emails = 1   WHERE (  civicrm_event.id = 1 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = NULL , registration_start_date = 20090127000000 , registration_end_date = 20090408000000 , intro_text = 'Select your CKD Bells -- CKD INTRO INFO (J-Net can type whatever here....)  (No pix, attachment ability)' , footer_text = 'Footer Area... J-Net can type whatever here (No pix, attachment ability)' , confirm_title = 'Confirm Your Registration Information' , confirm_text = 'Thank you...  CKD DAY INFO, ETC (No pix, attachment ability)' , confirm_footer_text = 'Can type something here (No pix, attachment ability)' , is_email_confirm = 1 , confirm_email_text = 'confirmation email here!' , confirm_from_name = 'Ben\'s Bells' , confirm_from_email = 'bensbells@bensbells.org' , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You for Registering' , thankyou_text = 'Thank u text here....(No pix, attachment ability)' , thankyou_footer_text = 'can type something here (No pix, attachment ability)' , is_multiple_registrations = 1 , allow_same_participant_emails = 1   WHERE (  civicrm_event.id = 1 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = NULL , registration_start_date = 20090127000000 , registration_end_date = 20090408000000 , intro_text = 'Select your CKD Bells -- CKD INTRO INFO (J-Net can type whatever here....)  (No pix, attachment ability)' , footer_text = 'Footer Area... J-Net can type whatever here (No pix, attachment ability)' , confirm_title = 'Confirm Your Registration Information' , confirm_text = 'Thank you...  CKD DAY INFO, ETC (No pix, attachment ability)' , confirm_footer_text = 'Can type something here (No pix, attachment ability)' , is_email_confirm = 1 , confirm_email_text = 'confirmation email here!' , confirm_from_name = 'Ben\'s Bells' , confirm_from_email = 'bensbells@bensbells.org' , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You for Registering' , thankyou_text = 'Thank u text here....(No pix, attachment ability)' , thankyou_footer_text = 'can type something here (No pix, attachment ability)' , is_multiple_registrations = 1 , allow_same_participant_emails = 1   WHERE (  civicrm_event.id = 1 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']"]
)
[/code]

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent
March 07, 2009, 08:59:07 pm

did u run the upgrade script?

index.php?q=civicrm/upgrade&reset=1

i just checked the upgrade script, and we do add that column to the civicrm_event table

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ToddFur

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
Re: CiviEvent
March 07, 2009, 09:26:11 pm
Here is what it says at that page:

"Upgrade CiviCRM to Version 2.2.beta4
Your database has already been upgraded to CiviCRM 2.2.beta4

Return to CiviCRM home page."

How can I re-set it so that I can re-run the upgrade command again?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent
March 08, 2009, 02:23:52 pm

1. can u detail your upgrade steps. i.e. what version u started with and what upgrades did you apply. We should start keeping an upgrade log so we can track errant behavior better

2. Can you check your database, specifically the  civicrm_payment_processor_type and check if the "Elavon" processor type definition exists (do a select name from civicrm_payment_processor_type on the table, should be the last entry

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ToddFur

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
Re: CiviEvent
March 08, 2009, 04:05:10 pm
Pretty much from CiviCRM 2.1 to 2.2Beta4 --- I followed the instructions... but it is obvious that the upgrade did not execute correctly as I'm missing some database fields for the new features that are part of version 2.2

I used this: http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.2

As for civicrm_payment_processor_type in my database I only see:

Dummy, PayPal_Standard, PayPal, PayPal_Express, Google_Checkout,
Moneris, AuthNet_AIM, PayJunction, eWay, Payment_express, ClickAndPledge

I do not see "Elavon"

ToddFur

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
Re: CiviEvent
March 09, 2009, 09:02:31 am
I am in hurry to get a resolution.... Maybe it's not worth the time trying to figure out why the upgrade script did not work.

I have 2 more questions:

1) If I were to delete my current CiviCRM directory (2.2beta4) and upload the entire civicrm directory that I saved from version 2.1, would it work? (it does not seem like the database structure was ever changed)

--OR---

2) If I were to delete my current civicrm (2.2beta4) directory and upload the civicrm (2.2beta4) version -- but follow the full install instructions rather than "2.1 upgrade to 2.2" instructions. Would it still connect to my old database and not lose any information?

 

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent
March 09, 2009, 11:36:03 am

I would start off with a copy of your 2.1 code and db and then do the upgrade to 2.2.beta4. Do ensure that you have a working 2.1 civicrm before you do the upgrade

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ToddFur

  • I post occasionally
  • **
  • Posts: 52
  • Karma: 0
Re: CiviEvent
March 09, 2009, 04:23:31 pm
Ok, well I went back to 2.1 (uploaded my saved civicrm directory before the 2.2beta4 upgrade)

It now says version 2.1 but when I search on a contact I get:

Fatal error: CRM_Core_Component::require_once() [function.require]: Failed opening required 'CRM/Case/Info.php' (include_path='.:/var/chroot/home/content/b/e/n/bensbells/html/drupal/sites/all/modules/civicrm:/var/chroot/home/content/b/e/n/bensbells/html/drupal/sites/all/modules/civicrm/packages:.:/usr/local/php5/lib/php') in /home/content/b/e/n/bensbells/html/drupal/sites/all/modules/civicrm/CRM/Core/Component.php on line 99

ryanpitt

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: CiviEvent
March 17, 2009, 12:57:10 pm
Do we have resolution on this error?
I am getting the same thing...

DB Error: no such field
Database Error Code: Unknown column 'allow_same_participant_emails' in 'field list', 1054

I upgraded from 2.1 to 2.2.

Thanks
Ryan

ryanpitt

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: CiviEvent
March 17, 2009, 01:15:35 pm
Here are more details about the error.
When I go to the upgrade link, the system tells me that I have already upgraded.

Code: [Select]
Error Details:


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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'REQUEST A PACKET NOW' , registration_start_date = NULL , registration_end_date = NULL , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirmation' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 0 , confirm_email_text = NULL , confirm_from_name = NULL , confirm_from_email = NULL , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 3 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'REQUEST A PACKET NOW' , registration_start_date = NULL , registration_end_date = NULL , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirmation' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 0 , confirm_email_text = NULL , confirm_from_name = NULL , confirm_from_email = NULL , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 3 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'REQUEST A PACKET NOW' , registration_start_date = NULL , registration_end_date = NULL , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirmation' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 0 , confirm_email_text = NULL , confirm_from_name = NULL , confirm_from_email = NULL , cc_confirm = NULL , bcc_confirm = NULL , thankyou_title = 'Thank You' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 3 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']"][/code]

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent
March 17, 2009, 01:20:51 pm

1. whats your version of mysql?

2. when you first upgraded from 2.1 -> 2.2 did it throw any error?

3. can you run the following sql on your box and see if it works:

ALTER TABLE `civicrm_event`
  ADD `allow_same_participant_emails` tinyint(4) default '0' COMMENT 'if true - allows the user to register multiple registrations from same email address.';

4. can we get ssh access to your box along with a clean copy of 2.1.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ryanpitt

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: CiviEvent
March 18, 2009, 11:41:20 am
Hi Donald,

Thanks for the reply.

Answers here:
1. Server version: 5.0.67-community
2. I do not remember seeing an error during the upgrade process.
3. I ran that update on the server and it added the field successfully.  I have also tested the page where I was getting the error and it is now working correctly!  The question now would be, how many other fields were not created.
4. This is on a hosted site and I do not have ssh access.  I use phpmyadmin for mysql access.
Where can I send a clean copy of 2.1 to? It is a 3.5MB zip file.

A Note on the process.  As part of this upgrade I moved the application to my hosted site from a test server.  In order to import the sql file successfully on the hosted site through phpmyadmin, I had to check the option for "Disable Foreign Key Checks".  Once the import was successful and I had the same version running on the new server, I then replaced the 2.1 files with 2.2 and ran the upgrade script.

Thanks again.
Ryan

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CiviEvent
March 18, 2009, 01:11:43 pm

Can you email the 2.1.6 db to lobo at yahoo dot com

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

ryanpitt

  • I post occasionally
  • **
  • Posts: 42
  • Karma: 0
Re: CiviEvent
March 18, 2009, 01:16:55 pm
Quote from: Donald Lobo on March 18, 2009, 01:11:43 pm

Can you email the 2.1.6 db to lobo at yahoo dot com

lobo


On its way! 
Thank you.

vshura

  • I post occasionally
  • **
  • Posts: 59
  • Karma: 1
  • CiviCRM version: 4.6.0
  • CMS version: Wordpress 4.1.1
Re: CiviEvent
March 25, 2009, 09:09:33 am
I'm afraid I have the same problem

Code: [Select]

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such field

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

    Return to home page.

Error Details:

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

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'Sign up now for this event!' , registration_start_date = 20090324000000 , registration_end_date = 20090501174500 , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirm Your Registration Information' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'Dublin Buddhist Centre' , confirm_from_email = 'info@dublinbuddhistcentre.org' , cc_confirm = NULL , bcc_confirm = 'vajrashura@dublinbuddhistcentre.org' , thankyou_title = 'Thank You for Registering' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 32 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [type] => DB_Error
    [user_info] => UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'Sign up now for this event!' , registration_start_date = 20090324000000 , registration_end_date = 20090501174500 , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirm Your Registration Information' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'Dublin Buddhist Centre' , confirm_from_email = 'info@dublinbuddhistcentre.org' , cc_confirm = NULL , bcc_confirm = 'vajrashura@dublinbuddhistcentre.org' , thankyou_title = 'Thank You for Registering' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 32 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="UPDATE  civicrm_event  SET is_online_registration = 1 , registration_link_text = 'Sign up now for this event!' , registration_start_date = 20090324000000 , registration_end_date = 20090501174500 , intro_text = NULL , footer_text = NULL , confirm_title = 'Confirm Your Registration Information' , confirm_text = NULL , confirm_footer_text = NULL , is_email_confirm = 1 , confirm_email_text = NULL , confirm_from_name = 'Dublin Buddhist Centre' , confirm_from_email = 'info@dublinbuddhistcentre.org' , cc_confirm = NULL , bcc_confirm = 'vajrashura@dublinbuddhistcentre.org' , thankyou_title = 'Thank You for Registering' , thankyou_text = NULL , thankyou_footer_text = NULL , is_multiple_registrations = 0 , allow_same_participant_emails = 0   WHERE (  civicrm_event.id = 32 )   [nativecode=1054 ** Unknown column 'allow_same_participant_emails' in 'field list']"]
)

I did update from 2.1 to 2.2 on Drupal a week or so ago, and there were errors in the upgrade, which I haven't, unfortunately, recorded (I'll take more note next time!).  I deleted the install manually, uploaded the files again, and then tried the update script again - index.php?q=civicrm/upgrade&reset=1.  That time, and now when I tried it again, I get the message

Code: [Select]
Your database has already been upgraded to CiviCRM 2.2.0
I thought that this had then worked, but it looks now like it hasn't changed the database.  Is there a way to reset it so that the install can work properly?  I have backups from just before the upgrade but I have done work on it since then and I'd be loath to have to do it again.

Thanks,
VS.
[/code]
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • CiviEvent

This forum was archived on 2017-11-26.