Forums / Install & configuration / Please help with MySql error
aarif ahmed
Wednesday 07 July 2004 11:07:50 pm
Can anyone tell me what this error means
Query error: Unknown column 'user_id' in 'field list'. Query: SELECT data, user_id FROM ezsession WHERE session_key='c91990c299c71a92c46937511a555207'
Query error: Unknown column 'ezuser_role.limit_identifier' in 'field list'. Query: SELECT DISTINCT ezrole.id, ezrole.name, ezuser_role.limit_identifier, ezuser_role.limit_value FROM ezrole, ezuser_role WHERE ezuser_role.contentobject_id IN ( 42,4,10 ) AND ezuser_role.role_id = ezrole.id
Michael Zielinski
Wednesday 07 July 2004 11:29:43 pm
Well, if you would like to know what the errors themselves mean, here we go:
In Query1 you try to retrieve information from adatabase table called ezsession and you limit your search to a specific session_key. However the table does not contain one of the fields mentioned in your query, user_id, and therfore the query fails and you get that error.The same with the second query just a different field_name and table.
Michael
Kåre Køhler Høvik
Thursday 08 July 2004 1:17:16 am
Looks like you've upgraded from 3.3 to 3.4 withoutrunning the DB updates.
Kåre Høvik
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0001 secs