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 »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Updated - Dashboard Error after error correction in upgrade
Pages: [1]

Author Topic: Updated - Dashboard Error after error correction in upgrade  (Read 2155 times)

milapunk

  • Guest
Updated - Dashboard Error after error correction in upgrade
December 02, 2009, 02:07:24 pm
I am getting this error when I try to upgrade from 2.2.7 to 3.0.0
The code that came along with it is as follows
Any help would be great.

Thanks!

Code: [Select]
Sorry. A non-recoverable error has occurred.

    DB Error: a515ac9c2796ca0e23adbe92c68fc9fc

    Database Error Code: Field 'max_participants' doesn't have a default value, 1364

    Return to home page.

Error Details:

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

    [code] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => INSERT INTO civicrm_event
        (is_template, template_title, event_type_id, default_role_id, participant_listing_id, is_public, is_monetary, is_online_registration, is_multiple_registrations, allow_same_participant_emails, is_email_confirm, contribution_type_id, fee_label, confirm_title, thankyou_title, confirm_from_name, confirm_from_email, is_active)
    VALUES
        (1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null,  null, null,             null,                                    null,                      null,                   null,                          1),
        (1, 'Free Meeting with Online Registration',    4, 1, 1, 1, 0, 1, 1,    1,    0,     null, null,             'Confirm Your Registration Information', 'Thanks for Registering!', null,                   null,                          1),
        (1, 'Paid Conference with Online Registration', 1, 1, 1, 1, 1, 1, 1,    1,    1,     4,    'Conference Fee', 'Confirm Your Registration Information', 'Thanks for Registering!', 'Event Template Dept.', 'event_templates@example.org', 1) [nativecode=1364 ** Field 'max_participants' doesn't have a default value]
    [type] => DB_Error
    [user_info] => INSERT INTO civicrm_event
        (is_template, template_title, event_type_id, default_role_id, participant_listing_id, is_public, is_monetary, is_online_registration, is_multiple_registrations, allow_same_participant_emails, is_email_confirm, contribution_type_id, fee_label, confirm_title, thankyou_title, confirm_from_name, confirm_from_email, is_active)
    VALUES
        (1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null,  null, null,             null,                                    null,                      null,                   null,                          1),
        (1, 'Free Meeting with Online Registration',    4, 1, 1, 1, 0, 1, 1,    1,    0,     null, null,             'Confirm Your Registration Information', 'Thanks for Registering!', null,                   null,                          1),
        (1, 'Paid Conference with Online Registration', 1, 1, 1, 1, 1, 1, 1,    1,    1,     4,    'Conference Fee', 'Confirm Your Registration Information', 'Thanks for Registering!', 'Event Template Dept.', 'event_templates@example.org', 1) [nativecode=1364 ** Field 'max_participants' doesn't have a default value]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="INSERT INTO civicrm_event
        (is_template, template_title, event_type_id, default_role_id, participant_listing_id, is_public, is_monetary, is_online_registration, is_multiple_registrations, allow_same_participant_emails, is_email_confirm, contribution_type_id, fee_label, confirm_title, thankyou_title, confirm_from_name, confirm_from_email, is_active)
    VALUES
        (1, 'Free Meeting without Online Registration', 4, 1, 1, 1, 0, 0, null, null, null,  null, null,             null,                                    null,                      null,                   null,                          1),
        (1, 'Free Meeting with Online Registration',    4, 1, 1, 1, 0, 1, 1,    1,    0,     null, null,             'Confirm Your Registration Information', 'Thanks for Registering!', null,                   null,                          1),
        (1, 'Paid Conference with Online Registration', 1, 1, 1, 1, 1, 1, 1,    1,    1,     4,    'Conference Fee', 'Confirm Your Registration Information', 'Thanks for Registering!', 'Event Template Dept.', 'event_templates@example.org', 1) [nativecode=1364 ** Field 'max_participants' doesn't have a default value]"]
)
[/code]
« Last Edit: December 02, 2009, 04:00:58 pm by milapunk »

milapunk

  • Guest
Re: Field 'max_participants' doesn't have a default value
December 02, 2009, 03:38:04 pm
So I went into phpmyadmin and added a value in the default field of 'max_participants' field of civicrm_events

I no longer receive that error during the upgrade.

I have a new problem now that the upgrade was successful though.

The dashboard page is rendering on the left hand side of the page in a column over the normal menu.
Anyone ever see a similar problem

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Updated - Dashboard Error after error correction in upgrade
December 02, 2009, 09:43:12 pm
Do you have any custom css for your site? Also make sure resource url is correct.

Kurund
Found this reply helpful? Support CiviCRM

milapunk

  • Guest
Re: Updated - Dashboard Error after error correction in upgrade
December 02, 2009, 10:55:35 pm
Where do I check the resource URL?
The site doesn't have any custom css as far as I know, and has very few modules.

Quote from: Kurund Jalmi on December 02, 2009, 09:43:12 pm
Do you have any custom css for your site? Also make sure resource url is correct.

Kurund

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Updated - Dashboard Error after error correction in upgrade
December 02, 2009, 11:00:09 pm
Quote
Where do I check the resource URL?
Check Global Settings>> Resource Urls.

Kurund
Found this reply helpful? Support CiviCRM

milapunk

  • Guest
Re: Updated - Dashboard Error after error correction in upgrade
December 02, 2009, 11:03:45 pm
Quote from: Kurund Jalmi on December 02, 2009, 11:00:09 pm
Quote
Where do I check the resource URL?
Check Global Settings>> Resource Urls.

Kurund

Thanks, I will check those first thing when I get to the server tomorrow and let you know what I find.

milapunk

  • Guest
Re: Updated - Dashboard Error after error correction in upgrade
December 03, 2009, 10:10:07 am
Quote from: Kurund Jalmi on December 02, 2009, 11:00:09 pm
Quote
Where do I check the resource URL?
Check Global Settings>> Resource Urls.

Kurund

Resource URLS are
/sites/all/modules/civicrm/
and
/sites/default/files/civicrm/persist/contribute/

Seems like the same urls from before the install
I can't figure out why it would suddenly stop working like that :(
« Last Edit: December 03, 2009, 02:21:39 pm by milapunk »

milapunk

  • Guest
Re: Updated - Dashboard Error after error correction in upgrade
December 03, 2009, 03:51:17 pm
New information:
So I loaded up the page in IE and although it gave a waring of an error on the page, the menus loaded fine.
The error seems to be preventing firefox from loading the page properly.

I cleared the cache on Firefox and the menus are working now.

Thanks All!

Mila
« Last Edit: December 03, 2009, 03:53:43 pm by milapunk »
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Updated - Dashboard Error after error correction in upgrade

This forum was archived on 2017-11-26.