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

eZ debug

Timing:	Jan 19 2025 04:44:04
Script start
Timing:	Jan 19 2025 04:44:04
Module start 'layout'
Timing:	Jan 19 2025 04:44:04
Module start 'content'
Timing:	Jan 19 2025 04:44:05
Module end 'content'
Timing:	Jan 19 2025 04:44:05
Script end

Main resources:

Total runtime	1.1575 sec
Peak memory usage	4,096.0000 KB
Database Queries	59

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	589.2734	152.6406
Module start 'layout'	0.0059	0.0028	741.9141	39.4766
Module start 'content'	0.0087	1.1473	781.3906	564.1250
Module end 'content'	1.1560	0.0014	1,345.5156	8.1484
Script end	1.1574		1,353.6641

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2716	16	0.0002
Check MTime	0.0013	0.1092	16	0.0001
Mysql Total
Database connection	0.0007	0.0626	1	0.0007
Mysqli_queries	1.1155	96.3711	59	0.0189
Looping result	0.0006	0.0504	57	0.0000
Template Total	1.1259	97.3	2	0.5630
Template load	0.0017	0.1455	2	0.0008
Template processing	1.1242	97.1295	2	0.5621
Template load and register function	0.0001	0.0124	1	0.0001
states
state_id_array	0.0012	0.1073	1	0.0012
state_identifier_array	0.0011	0.0938	2	0.0005
Override
Cache load	0.0014	0.1204	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0488	3	0.0002
Fetch class attribute name	0.0008	0.0698	4	0.0002
XML
Image XML parsing	0.0005	0.0463	3	0.0002
class_abstraction
Instantiating content class attribute	0.0000	0.0022	4	0.0000
General
dbfile	0.0008	0.0665	15	0.0001
String conversion	0.0000	0.0005	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs