4.2 Updating error : class 'CRM_Core_Config_Variables' not found

[Deepak Srivastava]

SemperFi,

Ok i verified your database. They do show indexes but constraints are missing. None of your tables have constraints present.

You will have to rebuild your schema - http://wiki.civicrm.org/confluence/display/CRMDOC42/Ensuring+Schema+Integrity+on+Upgrades.

[SemperFi]

Hello Deepak,

Following your instructions, I rebuilt the schema (use 4.1.5 structure + my custom fields tables structure + import my data).
Then relaunched the update : I got the exact same message error at stage 1 : [Error: Upgrade DB to 4.2.alpha1] DB Error: unknown error (details have been provided sooner in the post cf. text file 4.2.alpha1 error).

FYI, I've also activated drupal debbugging and got these notice messages :

Code: [Select]

Notice : Constant CIVICRM_USE_MEMCACHE already defined dans include_once() (ligne 306 dans /xxx/sites/default/civicrm.settings.php).
    Notice : Constant CIVICRM_MEMCACHE_HOST already defined dans include_once() (ligne 312 dans /xxx/sites/default/civicrm.settings.php).
    Notice : Constant CIVICRM_MEMCACHE_PORT already defined dans include_once() (ligne 317 dans /xxx/sites/default/civicrm.settings.php).
    Notice : Constant CIVICRM_MEMCACHE_TIMEOUT already defined dans include_once() (ligne 323 dans /xxx/sites/default/civicrm.settings.php).
    Notice : Constant CIVICRM_MEMCACHE_PREFIX already defined dans include_once() (ligne 333 dans /xxx/sites/default/civicrm.settings.php).
I really don't know what's going on. I've always been able to update my civicrm database since now.
Any idea ??

Tks again for the time spent on this. Much appreciated.

[Deepak Srivastava]

Could you paste the outputs of following sql statements -

SHOW CREATE TABLE civicrm_contribution_page;
SHOW CREATE TABLE civicrm_event;
SHOW CREATE TABLE civicrm_group;

If the output doesn't include any lines starting with "CONSTRAINT" you schema is still not built correctly and you will need to investigate further on how you doing the rebuild.

[SemperFi]

Hello Deepak
Please find enclosed the required sql statements.
Let me know if you find anything in there.
Thanks

[Kurund Jalmi]

Just a thought:

Do you have a backup of your old civicrm in your modules folder? If yes can you move it out of modules and try upgrade again.

HTh
Kurund

[SemperFi]

Hello Kurund,
This was initially the case, but I removed it.
Now I've just the current civicrm version folder in the "modules" folder.
Tks

[Deepak Srivastava]

SemperFi,

sqlfile looks correct. Could you jump on irc & i can help you debug the problem. Would be faster.

[SemperFi]

Deepak
I won't be able to jump on IRC - I'll try this week-end to solve the issue by installing a fresh 4.2 version and uploading our data in it. I'll let you know.
Thanks for your help.

[SemperFi]

Hello
I'm coming back.... with a good news. It's now working !!
Here is what I did :
1- Drop all the tables in the database
2- Rebuild civicrm database structure using this file : civicrm.mysql from 4.1.5 install package
3- Restore my database values from a 4.1.5 backup
4- Run the upgrade to 4.2 => It worked

Before doing that I tried to install a brand new version and during the database requirements check, it warns me that the mysql version of the server where the Drupal database is installed was 5.0.9 and that it requires at least 5.1.x.
So I moved my Drupal DB to the same mysql server than the one used for my CiviCRM DB. This is the only thing I made differently compared to my previous tries.

If the DB_ERROR came from this difference of version, maybe it will be worthy to specify that both CiviCRM and Drupal needs to be running on a 5.1.x mysql server.

Anyway, thanks again for your time and help. You made me explore ways and finally help me find the way.
Best regards !