Please help with MySql error

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.