By CodeCutter on

Followed all steps as per upgrade.txt

I am getting following error when I access mydomain.com/update.php

# Notice: date_default_timezone_set() [function.date-default-timezone-set]: Timezone ID '-18000' is invalid in drupal_session_initialize() (line 262 of /home/codecutter/public_html/includes/session.inc).
# PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'weight' at row 1: UPDATE {system} SET weight=:db_update_placeholder_0 WHERE (filename = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1000 [:db_condition_placeholder_0] => profiles/standard/standard.profile ) in system_update_files_database() (line 2233 of public_html/modules/system/system.module)

Any help is appreciated to resolve the issue.

Thanks.

⋅ Categories: Drupal 6.x

Comments

CodeCutter’s picture

CodeCutter commented

Also get 1 more message

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ssid' in 'where clause': SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => efd1a08710db3bf02012e978f21285a7 [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 204 of /home/udaykale/public_html/includes/session.inc).

I am still logged in as user 1. I am not sure if I can log back in; if I log out and try log-in again in another session.

CodeCutter’s picture

CodeCutter commented

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'weight' at row 1: UPDATE {system} SET weight=:db_update_placeholder_0 WHERE (filename = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1000 [:db_condition_placeholder_0] => profiles/standard/standard.profile ) in system_update_files_database() (line 2233 of /public_html/modules/system/system.module).

select max(weight) from system gives value as 99
so I am not sure how it is getting 1264 mentioned in error message.
Any idea?
Thanks.

CodeCutter’s picture

CodeCutter commented

Wanted to gove a solution to my problem.
While researching, I found thread http://drupal.org/node/1007038
The mentioned in that thread, I renamed profile folder to #profile and then the upgrade was successful.
Hope that this will help others.