I recently started working on a website that was already up and running. There was this one error that kept showing up in the logs:
user error: Unknown column 'e.start' in 'field list' query: SELECT n.nid, n.title, n.status, n.moderate, e.start FROM node n INNER JOIN event e on n.nid = e.nid INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) WHERE na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0','node_privacy_byrole_role1','node_privacy_byrole_user0') AND n.type='event' AND n.status = 1 AND n.moderate = 0 AND e.start >= 1133323181 ORDER BY e.start LIMIT 0, 6 in /usr/www/users/**server info removed**/includes/database.mysql.inc on line 125.
Any suggestions?
Comments
Comment #1
drewish CreditAttribution: drewish commentedWhat node type are you using with the event module? Is it a flexinode?
Comment #2
jsimonis CreditAttribution: jsimonis commentedAs far as I can tell, it is the event module that came with CS, with some theme tweaks. There is no back-up of the module (and they were very good at leaving a backup of everything they edited), so the module hasn't been tweaked as far as I can tell. But I could be wrong.
The link is: node/add/flexinode-2
Comment #3
drewish CreditAttribution: drewish commentedUntil recently I don't think basicevent.module was included with the event module. And based on the link you provided it looks like it's a flexinode. I'm affraid I'm not much help in that department, I've never used it. Perhaps someone else can offer up some advice...
Comment #4
killes@www.drop.org CreditAttribution: killes@www.drop.org commentedThis version of event.module is no longer supported. Please update your site. If the issue is still valid, don't hesitate to re-open it against a more recent version.