By gmills@gregmills.com on

My upgrade went pretty good. It looks like I need to re-up the images in my galleries. I also have yet to re-install my template.

But then there's this problem with the events module. I get the following error:

user error: Unknown column 'e.end' in 'where clause'
query: SELECT DISTINCT(n.nid) FROM event e INNER JOIN node n USING (nid) WHERE n.status = 1 AND ((e.start > 1114923600 AND e.start < 1117601999) OR (e.end > 1114923600 AND e.end < 1117601999) OR (e.start < 1114923600 AND e.end > 1117601999)) ORDER BY e.start in /home/.illustrator/gregmills/miamichurch.org/includes/database.mysql.inc on line 66.

To view the error go to my site (miamichurch.org). You'll see the events listed on the right. Click on "more" at the bottom of that list. I added flexinode and ran the upgrade script. I don't really have any idea where to take it from there. Any help is greatly appreciated.

Comments

gmills@gregmills.com’s picture

gmills@gregmills.com commented

I fixed that error but somehow in the process the dates have been disassociated with the events. I'm sure they are still in the database because the list view on the homepage shows how many days until the event. When you click on the event there's no date or time. There's also no place to input the date or time when adding an event.

Any ideas?