event_start not being set [#65609]

I upgraded from Drupal 4.5.8 to 4.7.1 following the instructions of disabling event and flexinode first then moving to 4.6.0, 4.6.x and finally 4.7.1. I then got Drupal running correctly. I added flexinode 4.7.0 and event 4.7.0.

I can add events to my event calendar, but they all produce the following error: Unknown column 'e.event_start' in 'field list' query: SELECT n.nid, n.title, n.type, n.status, n.moderate, n.changed, e.event_start FROM node n INNER JOIN event e ON n.nid = e.nid WHERE n.status = 1 AND n.moderate = 0 AND e.event_start >= 1148596507 ORDER BY event_start in /usr/local/apache/vhosts/drupal/includes/database.mysql.inc on line 120.

I have found a number of fixed/closed bugs about the error. But none of the solutions work for me.

I notice that all start dates are set to zero (Dec 31, 1969).

Comments

Comment #1

royar CreditAttribution: royar commented 26 May 2006 at 01:27

I fixed the error by changing the event.mysql file to include a conditional 'drop table' command.

DROP table if exists event;
CREATE TABLE event (
nid int(10) unsigned NOT NULL default '0',
event_start int(10) unsigned NOT NULL default '0',
event_end int(10) unsigned NOT NULL default '0',
timezone int(10) NOT NULL default '0',
PRIMARY KEY (nid),
KEY event_start (event_start)
);

Actually, I just logged into the mysql server and ran the commands directly. But I assume it would work if the script ran at install or were fed as stdin to the correct mysql command. Perhaps this will help someone else who is seeing the error. There were quite a few reported at the beginning of 2006.