I'm upgrading my site from 6.22 to 7.4. After enabling the related links block any node page I go to gives me the following error:

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'updated' at row 1: UPDATE {relatedlinks_tracker} SET updated = :updated WHERE nid = :nid; Array ( [:updated] => 1311786854 [:nid] => 1469 ) in _relatedlinks_update_tracker_timestamp() (line 709 of /[mypath]/sites/all/modules/relatedlinks/relatedlinks.module).

I ran update.php after reenabling Related Links, of course, and when I visit it now it tells me there are no db updates available. Yet my relatedlinks_tracker table has an 'updated' column of type tinyint(4) which is of course not big enough to hold a timestamp.

My guess is that this table did not get correctly updated and that tinyint(4) used to be appropriate. I can manually change the table to be of type timestamp, but this ought to be addresses for folks that are (rightly) more squamish than I about mucking around with the schema. Also, I could be wrong about the intended column type, right?

Comments

Zen’s picture

Status: Active » Postponed (maintainer needs more info)

hmm, I'm not sure if the updated column has ever been anything but an integer. How old is your installation?

At any rate, switching the column to an INT should fix the issue.
-K