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 »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Upgrade to 3.3 failed
Pages: [1]

Author Topic: Upgrade to 3.3 failed  (Read 1127 times)

dcrane

  • Guest
Upgrade to 3.3 failed
December 24, 2010, 04:36:06 am
http://<mydomain.com>/civicrm/upgrade?reset=1

resulted in:
Sorry. A non-recoverable error has occurred.
--------------------------------------------------------------------------------
DB Error: syntax error
Error Details
Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `civicrm_group` MODIFY `visibility` enum('User and User Ad' at line 5, 1064
Additional Details:

[There were about 10 pages of SQL that followed.]

I have no idea how to handle this situation.

dcrane

  • Guest
Re: Upgrade to 3.3 failed
December 24, 2010, 01:45:07 pm
Well, I restored a backup from 19 December which was before I tried the 3.3 upgrade. and I can log in but get an error.  New members get the same error when trying to create a new ID.  However, I can return to the home page and I'm logged in (see last line of error msg).  They cannot. The error msg is

Sorry. A non-recoverable error has occurred.
DB Error: no such field
Error Details
Additional Details:

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

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_preferences
 
 WHERE (  civicrm_preferences.domain_id = 1 )  AND (  civicrm_preferences.is_domain = 1 )
 
 [nativecode=1054 ** Unknown column 'civicrm_preferences.domain_id' in 'where clause']"]
)

Return to home page.

dcrane

  • Guest
Re: Upgrade to 3.3 failed
December 24, 2010, 02:10:38 pm
Restored the database from 34 hours ago (before I began my upgrades} and at first got this error when logging in as webmaster:

Fatal error: Allowed memory size of 94371840 bytes exhausted (tried to allocate 64 bytes) in /home/<mydomain>/sites/all/modules/civicrm/packages/PEAR.php on line 884

But I continued and found myself logged in properly with the following error in pink at the top of the page:

user warning: Table 'drupal_pr.mollom_form' doesn't exist query: SELECT * FROM mollom_form WHERE form_id = 'page_node_form' in /home/woodyjones/projectrespect.com/members/modules/mollom/mollom.module on line 880.

I don't have an older copy of the DB that isn't months old.  Any suggestions?

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: Upgrade to 3.3 failed
December 24, 2010, 02:13:26 pm
Quote
user warning: Table 'drupal_pr.mollom_form' doesn't exist query: SELECT * FROM mollom_form WHERE form_id = 'page_node_form' in /home/woodyjones/projectrespect.com/members/modules/mollom/mollom.module on line 880.

This is error is not related to CiviCRM.

Did you log in as admin user when you tried upgrade ?

Kurund
Found this reply helpful? Support CiviCRM

dcrane

  • Guest
Re: Upgrade to 3.3 failed
December 24, 2010, 06:32:26 pm
Yes, I was logged in as admin and when it asked for primary user, I logged in as the first name in the user DB.

This error may no longer be associated with CIVICRM; it started out that way. Subsequent restores appear to have created a mismatch between the DB and the code level.  Or perhaps simply an error in the DB, though that's unlikely because it has been restored to the situation 34 hours ago.

So where can I go to find a solution?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Upgrade to 3.3 failed
December 25, 2010, 10:55:28 am
Perhaps the Mollom issue list at drupal.org would be a good place to ask about this...

Or try to uninstall Mollom and then reinstall.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • Drupal Installations (Moderator: Piotr Szotkowski) »
  • Upgrade to 3.3 failed

This forum was archived on 2017-11-26.