Cannot upgrade from 4.0.8 to 4.1.0 on Drupal 7

[yshah]

I'm following the Upgrade guide for Dupal 7 to 4.1.  I've hit an issue that when I go to http://<your_drupal_home>/civicrm/upgrade?reset=1 it gives me the 'Site under maintenance" message.  Did I do something wrong.  If I try to use another browser and go to http://<your_drupal_home>/?q=user it gives me an error:

Initialization Error

Code: [Select]

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]"]
)

Did I miss something?

[Kurund Jalmi]

Can you try:

http://<your_drupal_home>/?q=civicrm/upgrade?reset=1

Kurund

[yshah]

It goes to the site maintenance page when I try that.  Should I take the site out of maintenance mode?

[Hershel]

Yes

EDIT: Actually, no, what you need to do is login first as user id #1 and then you can run the update in maintenance mode. But if you can't access ?q=user then you may need to MOVE the CiviCRM module code up one directory temporarily, then login, then put it back and then upgrade.

[yshah]

Ok, I could login now.  When I ran the http://<your_drupal_home>/civicrm/upgrade?reset=1 script I get the message:

"The connection was reset
The connection to the server was reset while the page was loading."

Could it be the upgrade script resetting the connection?  Do you know what directory this would be in so I can look for a possible error_log?

Thank you.

[yshah]

Ok so I restored my civicrm db and it looks like some of the tables were deleted when it was originally upgrading.

I disabled the module and rebuilt the drupal modules, then tried re-enable it.  After I enabled the civicrm again and tried to run the civicrm upgrade script I get the following error:

Initialization Error

Code: [Select]

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

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]
    [type] => DB_Error
    [user_info] =>
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::simpleHandler prefix="" info="
SELECT name, group_name, value
FROM   civicrm_setting
WHERE  ( group_name = 'Directory Preferences'
OR       group_name = 'URL Preferences' )
 [nativecode=1146 ** Table 'icnasc_civicrm4.civicrm_setting' doesn't exist]"]
)


[Donald Lobo]

First ensure that 4.0.8 is working before u try the upgrade

I suspect your 4.0.8 DB has invalid config and hence the below error

lobo

[yshah]

I restored my drupal 7 - civicrm 4.0.8 and that seems to be ok.  I still don't see any civicrm_settings table, is that suppose to be there?  I didn't see it in my pre-4.0.8  backup either.  Can I recreate this? 

I tried to go back to 4.1.0 but it gives me a connection reset page.  I can't get any further than this.  I'm not seeing the error from before, so I guess that's good.   Any ideas?

I realized that I recently turned off FastCGI on my apache server, but I don't think that could be causing any issues, do you?

Thank you.

[Donald Lobo]

the settings table is introduced in 4.1

sorry, dont know the connection reset error

lobo

[yshah]

Ok I changed my server settings to the original ones and went back to 4.0.8.  Now when I try to go to http://<your_drupal_home>/civicrm/upgrade?reset=1 I just get the site maintenance page.  Any ideas how to get to the civicrm upgrade page?

Thank you.

[Hershel]

Go to http://<your_drupal_home>/user and login as user #1. Then run the upgrade

[yshah]

Ok, now I get an internal 500 error.  Where can I go to see the error?

Thanks.

[Hershel]

You should ask your host or sysadmin for assistance with that.

[yshah]

Ok it seems When I rebuilt Apache I had it set to PHP 5.3.10 and that's the reason it broke.  When I set it to PHP 5.2.17 it works great.  Any ideas on why that is?