Updated today a Drupal 5 site with Event 5.x-1.0 to Drupal 6 with Event 6.x-2.x-dev and when I ran update.php this was the error:

warning: mysql_query() [http://www.mysql.com/doc]: Unknown column 'e.nid' in 'field list' in E:\ApacheRoot\JECDrupal6\includes\database.mysql.inc on line 108.

The full page is attached, showing the failed SQL queries. This site has, obviously, a set of existing Event nodes. When I now edit an existing event, all times are zero. Not surprising, I guess, considering the error above. :)

CommentFileSizeAuthor
update.zip13.77 KBFredJones

Comments

killes@www.drop.org’s picture

Status: Active » Postponed (maintainer needs more info)

Can you try to first update to 5.2 and then to 6.2?

FredJones’s picture

I tried that and I got almost the same thing when I ran the update:

warning: mysql_query() [http://www.mysql.com/doc]: Unknown column 'e.nid' in 'field list' in E:\ApacheRoot\mysite\includes\database.mysql.inc on line 153.

Here is some sample SQL:

# Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND AS event_start, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND AS event_end, e.timezone, 0, 0 FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 0
# Failed: INSERT INTO {event} (nid, event_start, event_end, timezone, start_in_dst, end_in_dst) SELECT e.nid, IF((9763200 <= e.event_start <= 22982400) OR (41817600 <= e.event_start <= 55036800) OR (73267200 <= e.event_start <= 86486400) OR (104716800 <= e.event_start <= 117936000) OR (136166400 <= e.event_start <= 149385600) OR (167616000 <= e.event_start <= 180835200) OR (199670400 <= e.event_start <= 212889600) OR (231120000 <= e.event_start <= 244339200) OR (262569600 <= e.event_start <= 275788800) OR (294019200 <= e.event_start <= 307238400) OR (325468800 <= e.event_start <= 338688000) OR (356918400 <= e.event_start <= 370137600) OR (388972800 <= e.event_start <= 402192000) OR (420422400 <= e.event_start <= 433641600) OR (451872000 <= e.event_start <= 465091200) OR (483321600 <= e.event_start <= 496540800) OR (514771200 <= e.event_start <= 527990400) OR (546220800 <= e.event_start <= 559440000) OR (578275200 <= e.event_start <= 591494400) OR (609724800 <= e.event_start <= 622944000) OR (641174400 <= e.event_start <= 654393600) OR (672624000 <= e.event_start <= 685843200) OR (704073600 <= e.event_start <= 717292800) OR (736128000 <= e.event_start <= 749347200) OR (767577600 <= e.event_start <= 780796800) OR (799027200 <= e.event_start <= 812246400) OR (830476800 <= e.event_start <= 843696000) OR (861926400 <= e.event_start <= 875145600) OR (893376000 <= e.event_start <= 906595200) OR (925430400 <= e.event_start <= 938649600) OR (956880000 <= e.event_start <= 970099200) OR (988329600 <= e.event_start <= 1001548800) OR (1019779200 <= e.event_start <= 1032998400) OR (1051228800 <= e.event_start <= 1064448000) OR (1083283200 <= e.event_start <= 1096502400) OR (1114732800 <= e.event_start <= 1127952000) OR (1146182400 <= e.event_start <= 1159401600) OR (1177632000 <= e.event_start <= 1190851200) OR (1209081600 <= e.event_start <= 1222300800) OR (1240531200 <= e.event_start <= 1253750400) OR (1272585600 <= e.event_start <= 1285804800), FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_start) + INTERVAL ez.offset HOUR_SECOND) AS event_start, IF((9763200 <= e.event_end <= 22982400) OR (41817600 <= e.event_end <= 55036800) OR (73267200 <= e.event_end <= 86486400) OR (104716800 <= e.event_end <= 117936000) OR (136166400 <= e.event_end <= 149385600) OR (167616000 <= e.event_end <= 180835200) OR (199670400 <= e.event_end <= 212889600) OR (231120000 <= e.event_end <= 244339200) OR (262569600 <= e.event_end <= 275788800) OR (294019200 <= e.event_end <= 307238400) OR (325468800 <= e.event_end <= 338688000) OR (356918400 <= e.event_end <= 370137600) OR (388972800 <= e.event_end <= 402192000) OR (420422400 <= e.event_end <= 433641600) OR (451872000 <= e.event_end <= 465091200) OR (483321600 <= e.event_end <= 496540800) OR (514771200 <= e.event_end <= 527990400) OR (546220800 <= e.event_end <= 559440000) OR (578275200 <= e.event_end <= 591494400) OR (609724800 <= e.event_end <= 622944000) OR (641174400 <= e.event_end <= 654393600) OR (672624000 <= e.event_end <= 685843200) OR (704073600 <= e.event_end <= 717292800) OR (736128000 <= e.event_end <= 749347200) OR (767577600 <= e.event_end <= 780796800) OR (799027200 <= e.event_end <= 812246400) OR (830476800 <= e.event_end <= 843696000) OR (861926400 <= e.event_end <= 875145600) OR (893376000 <= e.event_end <= 906595200) OR (925430400 <= e.event_end <= 938649600) OR (956880000 <= e.event_end <= 970099200) OR (988329600 <= e.event_end <= 1001548800) OR (1019779200 <= e.event_end <= 1032998400) OR (1051228800 <= e.event_end <= 1064448000) OR (1083283200 <= e.event_end <= 1096502400) OR (1114732800 <= e.event_end <= 1127952000) OR (1146182400 <= e.event_end <= 1159401600) OR (1177632000 <= e.event_end <= 1190851200) OR (1209081600 <= e.event_end <= 1222300800) OR (1240531200 <= e.event_end <= 1253750400) OR (1272585600 <= e.event_end <= 1285804800), FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset_dst HOUR_SECOND, FROM_UNIXTIME(e.event_end) + INTERVAL ez.offset HOUR_SECOND) AS event_end, e.timezone, IF((9763200 <= e.event_start <= 22982400) OR (41817600 <= e.event_start <= 55036800) OR (73267200 <= e.event_start <= 86486400) OR (104716800 <= e.event_start <= 117936000) OR (136166400 <= e.event_start <= 149385600) OR (167616000 <= e.event_start <= 180835200) OR (199670400 <= e.event_start <= 212889600) OR (231120000 <= e.event_start <= 244339200) OR (262569600 <= e.event_start <= 275788800) OR (294019200 <= e.event_start <= 307238400) OR (325468800 <= e.event_start <= 338688000) OR (356918400 <= e.event_start <= 370137600) OR (388972800 <= e.event_start <= 402192000) OR (420422400 <= e.event_start <= 433641600) OR (451872000 <= e.event_start <= 465091200) OR (483321600 <= e.event_start <= 496540800) OR (514771200 <= e.event_start <= 527990400) OR (546220800 <= e.event_start <= 559440000) OR (578275200 <= e.event_start <= 591494400) OR (609724800 <= e.event_start <= 622944000) OR (641174400 <= e.event_start <= 654393600) OR (672624000 <= e.event_start <= 685843200) OR (704073600 <= e.event_start <= 717292800) OR (736128000 <= e.event_start <= 749347200) OR (767577600 <= e.event_start <= 780796800) OR (799027200 <= e.event_start <= 812246400) OR (830476800 <= e.event_start <= 843696000) OR (861926400 <= e.event_start <= 875145600) OR (893376000 <= e.event_start <= 906595200) OR (925430400 <= e.event_start <= 938649600) OR (956880000 <= e.event_start <= 970099200) OR (988329600 <= e.event_start <= 1001548800) OR (1019779200 <= e.event_start <= 1032998400) OR (1051228800 <= e.event_start <= 1064448000) OR (1083283200 <= e.event_start <= 1096502400) OR (1114732800 <= e.event_start <= 1127952000) OR (1146182400 <= e.event_start <= 1159401600) OR (1177632000 <= e.event_start <= 1190851200) OR (1209081600 <= e.event_start <= 1222300800) OR (1240531200 <= e.event_start <= 1253750400) OR (1272585600 <= e.event_start <= 1285804800), 1, 0), IF((9763200 <= e.event_end <= 22982400) OR (41817600 <= e.event_end <= 55036800) OR (73267200 <= e.event_end <= 86486400) OR (104716800 <= e.event_end <= 117936000) OR (136166400 <= e.event_end <= 149385600) OR (167616000 <= e.event_end <= 180835200) OR (199670400 <= e.event_end <= 212889600) OR (231120000 <= e.event_end <= 244339200) OR (262569600 <= e.event_end <= 275788800) OR (294019200 <= e.event_end <= 307238400) OR (325468800 <= e.event_end <= 338688000) OR (356918400 <= e.event_end <= 370137600) OR (388972800 <= e.event_end <= 402192000) OR (420422400 <= e.event_end <= 433641600) OR (451872000 <= e.event_end <= 465091200) OR (483321600 <= e.event_end <= 496540800) OR (514771200 <= e.event_end <= 527990400) OR (546220800 <= e.event_end <= 559440000) OR (578275200 <= e.event_end <= 591494400) OR (609724800 <= e.event_end <= 622944000) OR (641174400 <= e.event_end <= 654393600) OR (672624000 <= e.event_end <= 685843200) OR (704073600 <= e.event_end <= 717292800) OR (736128000 <= e.event_end <= 749347200) OR (767577600 <= e.event_end <= 780796800) OR (799027200 <= e.event_end <= 812246400) OR (830476800 <= e.event_end <= 843696000) OR (861926400 <= e.event_end <= 875145600) OR (893376000 <= e.event_end <= 906595200) OR (925430400 <= e.event_end <= 938649600) OR (956880000 <= e.event_end <= 970099200) OR (988329600 <= e.event_end <= 1001548800) OR (1019779200 <= e.event_end <= 1032998400) OR (1051228800 <= e.event_end <= 1064448000) OR (1083283200 <= e.event_end <= 1096502400) OR (1114732800 <= e.event_end <= 1127952000) OR (1146182400 <= e.event_end <= 1159401600) OR (1177632000 <= e.event_end <= 1190851200) OR (1209081600 <= e.event_end <= 1222300800) OR (1240531200 <= e.event_end <= 1253750400) OR (1272585600 <= e.event_end <= 1285804800), 1, 0) FROM {event_backup} e INNER JOIN {event_timezones} ez ON e.timezone = ez.timezone WHERE ez.dst_region = 1
japerry’s picture

Status: Postponed (maintainer needs more info) » Closed (outdated)

Event for Drupal 8 is unrelated to older versions. If an issue similar to this one exists, please open a new issue with the 8.x branch.