I tried to upgrade from 4.4.1 to 4.4.2.
I followed the upgrade instructions and ran upgrade.php
My computer crashed (unrelated problem) and I then went to my site and all seemed well until I tried to login and received this error:
user error: Unknown column 'timestamp' in 'field list' query: UPDATE users
SET timestamp = '1088967990' WHERE uid = '1' in
/public_html/includes/database.mysql.inc on line 97.
warning: Cannot modify header information - headers already sent by (output
started at /public_html/includes/common.inc:400) in
/public_html/modules/user.module on line 612.
warning: Cannot modify header information - headers already sent by (output
started at /public_html/includes/common.inc:400) in
/public_html/includes/common.inc on line 239.
I am very new to Drupal and probably have made a stupid error. I would be very grateful for your help please.
Many thanks!
Ros

Comments

Steven’s picture

4.4.2 has no database changes with 4.4.1 (as the release said) so running update.php was unnecessary. Still running it should not do anything. The missing field 'timestamp' was renamed to 'changed' in the development branch. This change is not present in the 4.4.2 version, I just checked the tar.gz archive on this site.

Are you sure you downloaded the right version? Check the file CHANGELOG.txt in your Drupal root. If the first item is "Drupal x.xx", not "Drupal 4.4.2" then you got the development version.

infotech’s picture

I downloaded from the link on the main page. I have just checked the CHANGELOG/txt file and it is the correct version. I also could not understand the error since I also understand there were no database changes!

Thank you for replying.

grohk’s picture

I just upped to 4.4.2 from 4.4.1 and I am experiencing the same issue. I do not think I ran the update.php...I did direct my browser to mydomain.com/update.php, but the resulting page said that it was unnessesary, so I did not proceed.

Here is my CHANGELOG.txt:
Drupal 4.4.2, 2004-07-04
------------------------

- fixed bugs: no critical bugs were identified.

Dries’s picture

The database scheme of the users table in both Drupal 4.4.0 and Drupal 4.4.1 have a 'timestamp' field. Does your users table have a 'changed' field instead?

(The Drupal 4.4.1 release, not the Drupal 4.4.2 release, was incorrectly packaged for a few hours: we packaged the HEAD branch instead of the DRUPAL-4-4 branch. We fixed that as explained in the release announcement. Are you an early upgrader affected by this?)

grohk’s picture

Hmmm. I did indeed have the "early edition" of 4.4.1. I changed it to timestamp and this it is all better now. Thanks Dries!

infotech’s picture

Thank you Dries for the explanation and all is now well!

Kind regards,

Ros