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) »
  • 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
Pages: [1]

Author Topic: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise  (Read 2466 times)

dgreenbergz

  • Guest
1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 15, 2008, 08:51:42 am
I'm at Step 7.

i"Point your web browser to the following URL (you should already be logged in to Drupal with administrator-level permissions):  http://<your_drupal_home>/index.php?q=civicrm/upgrade&reset=1"

I took site offline logging out in the process. When I try to login as admin I get this error, although I can see Drupal behind it: I used civicrm_41.mysql to upgrade the new 2.0 Database, then reimported old data

Thanks, Douglas

-----------------------------------------------------------

"  Sorry. A non-recoverable error has occurred.

Database Error Code: Table 'civicrmtestsitenew.civicrm_component' doesn't exist, 1146

Return to home page.

Error Details:


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

       
Code: [Select]
=> -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT *
 FROM civicrm_component
 
 
 
 
 
 [nativecode=1146 ** Table 'civicrmtestsitenew.civicrm_component' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT *
 FROM civicrm_component
 
 
 
 
 
 [nativecode=1146 ** Table 'civicrmtestsitenew.civicrm_component' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT *
 FROM civicrm_component
 
 
 
 [nativecode=1146 ** Table 'civicrmtestsitenew.civicrm_component' doesn't exist]"]





Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 15, 2008, 09:45:25 pm
Quote
I took site offline logging out in the process. When I try to login as admin I get this error

The expected error you see is because your database is not yet upgraded to 2.0. And should go away for the url "http://<your_drupal_home>/index.php?q=civicrm/upgrade&reset=1" provided you have followed steps on wiki - http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0

Quote
although I can see Drupal behind it: I used civicrm_41.mysql to upgrade the new 2.0 Database, then reimported old data

I guess you talking about step 4. If so, it actually doesn't upgrade you database. It only makes sure that your schema is inline with what is expected by upgrade process. 

Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

dgreenbergz

  • Guest
Re: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 16, 2008, 04:09:38 am
I will try this. Where on http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Drupal+Sites+to+2.0

is upgrading the database described, other than step seven wherein you point browser at:

http://<your_drupal_home>/index.php?q=civicrm/upgrade&reset=1  ??? That is suppose to upgrade the database, (which remove the expected error I get while trying to do step 7) Seems like a circular issue here.

The error won't occur if database is upgraded, but step seven database upgrade script produces the error.

Should I, and how would I manually updgrade database? If I manually can do it, I can skip step seven, correct?

Thank you so much,

Douglas

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 16, 2008, 06:12:04 am
Quote
Should I, and how would I manually updgrade database? If I manually can do it, I can skip step seven, correct?

You can't manually upgrade the db, nor can you complete the upgrade without this step. 

Making your browser point to url "http://<your_drupal_home>/index.php?q=civicrm/upgrade&reset=1" should take you to a screen which will guide you what to do next to convert your db to v2.0. And if you don't see this screen means either something is wrong with your code-base or your code-base is not of v2.0.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

dgreenbergz

  • Guest
Re: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 16, 2008, 06:37:35 am
Pranams...

What is your best suggetion in this case?  I downloaded 2.13 tarball from sourceforge originally.

 Should I delete, upload, and extract the codebase again?

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise
May 16, 2008, 07:00:40 am
Yes, you can try the latest release v2.0.3 (http://sourceforge.net/project/showfiles.php?group_id=177914)
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 1.9>2.0 upgrade script won't run, get Database Error Code- Please Advise

This forum was archived on 2017-11-26.