Please help with MySql error

Next topic

Author	Message
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

Author

Message

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