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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • 2.2 beta 3 database upgrade error
Pages: [1]

Author Topic: 2.2 beta 3 database upgrade error  (Read 1728 times)

genkml

  • Guest
2.2 beta 3 database upgrade error
February 27, 2009, 09:43:05 pm
I'm upgrading my test site to CiviCRM 2.2.Beta3 and encountered the following problem. The original site was using Joomla 1.5.7 with CiviCRM 2.1.0.

I duplicated my live site to my local Windows environment with XAMPP installed. Tested the duplicated site and confirmed it worked properly, before starting the upgrade procedure as described in http://wiki.civicrm.org/confluence/display/CRMUPCOMING/Upgrade+Joomla+Sites+to+2.2

Everything was working fine until I get to step 4, to run the Database Upgrade script. After running for a while it returned with error as below. Looks like it's trying to write some files into \xampp\tmp and failed. I guess something is not configure properly as \xampp\tmp should not be accessible anyway. The folder that's accessible should be \xampp\htdocs\....

Returning to the administrator homepage and rerun the Database Upgrade script, I get the message that "Your database has already been upgraded to CiviCRM 2.2.beta3". I'm still testing the 'upgraded' site and have not found any problem....so far.

A couple of questions:
* Any comments on why the error appeared to begin with?
* How do I confirm that the database has been upgraded properly?

Thanks

***************************************************************
Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Return to home page.
***************************************************************
Error Details:
Code: [Select]
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )
    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] =>
SHOW COLUMNS
FROM civicrm_option_value
LIKE 'description'
 [nativecode=1 ** Can't create/write to file '\xampp\tmp\#sql_c58_0.MYI' (Errcode: 13)]
    [type] => DB_Error
    [user_info] =>
SHOW COLUMNS
FROM civicrm_option_value
LIKE 'description'
 [nativecode=1 ** Can't create/write to file '\xampp\tmp\#sql_c58_0.MYI' (Errcode: 13)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
SHOW COLUMNS
FROM civicrm_option_value
LIKE 'description'
 [nativecode=1 ** Can't create/write to file '\xampp\tmp\#sql_c58_0.MYI' (Errcode: 13)]"]
)
[/code]

Deepak Srivastava

  • Ask me questions
  • ****
  • Posts: 677
  • Karma: 65
Re: 2.2 beta 3 database upgrade error
February 28, 2009, 10:00:31 am
Quote
* Any comments on why the error appeared to begin with?
We don't have windows experience but looks like a permissioning issue (http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html). Searching with the error code might give you more clues.

Quote
* How do I confirm that the database has been upgraded properly?
Check the value of 'version' column of 'civicrm_domain' table which would indicate the progress so far.
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) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 2.2 Release Testing »
  • 2.2 beta 3 database upgrade error

This forum was archived on 2017-11-26.