Forums / Install & configuration / Please help with MySql error

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Please help with MySql error

Previous topic

Install & configuration

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

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