Forums / Developer / Help with Keywords ..!

Help with Keywords ..!

Author Message

Craig Hirsch

Sunday 28 September 2003 10:36:43 am

I have added a Keywords datatype to my Information Page content class. I can add keywords with no problem via the admin interface, and see them in the correck ezkeywords database table. However, using template code from the EZ documentation to display the keywords, I get the following SQL errors showing in my EZ Debug (I'm using EZ 3.2 stable):

Error: eZMySQLDB Sep 28 2003 13:34:05
Query error: Unknown column 'Array' in 'where clause'. Query: SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=Array AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id

Any ideas?

--
chirsch{AT}gmail{d.t}com

Eirik Alfstad Johansen

Monday 29 September 2003 3:44:09 am

Hi Craig,

The SQL query can't be performed because you are asking for the value "Array" for "ezcontentobject_tree.contentobject_id" (check out the start of the "WHERE"-part of the query).

I don't know how the SQL query is created, but my guess is that you are passing a value to the SQL creation process that is an array instad of an ordinary variable.

Does that make any sense?

Sincerely,

Eirik Johansen
http://www.netmaking.no/

Sincerely,

Eirik Alfstad Johansen
http://www.netmaking.no/

Selmah Maxim

Monday 29 September 2003 4:01:30 am

Hi ..

I have the same problem :
___________
{let related=$node.object.data_map.keyword.content.related_objects}
{section show=$related}
<h2>Related documents</h2>
<ol>
{section name=Related loop=$related}
<li><a href={$:item.url_alias|ezurl}>{$:item.name}</a></li>
{/section}
</ol>
{/section}
{/let}
_____________

I get this error msg also :

---------------------------

Query error: Unknown column 'Array' in 'where clause'. Query: SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name
FROM ezcontentobject_tree,
ezcontentobject,
ezcontentclass
WHERE ezcontentobject_tree.contentobject_id=Array AND
ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id AND
ezcontentobject_tree.contentobject_id=ezcontentobject.id AND
ezcontentclass.version=0 AND
ezcontentclass.id = ezcontentobject.contentclass_id
----------------------------

error i the table name !

how this work in ez.no and its using version 3.2 ?!
in the old versions i used to get php error.

eZ debug

Timing: Jan 18 2025 19:12:26
Script start
Timing: Jan 18 2025 19:12:26
Module start 'content'
Timing: Jan 18 2025 19:12:27
Module end 'content'
Timing: Jan 18 2025 19:12:27
Script end

Main resources:

Total runtime0.8090 sec
Peak memory usage4,096.0000 KB
Database Queries196

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0063 588.7422180.8438
Module start 'content' 0.00630.6686 769.5859590.6406
Module end 'content' 0.67490.1340 1,360.2266336.7734
Script end 0.8090  1,697.0000 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00450.5529210.0002
Check MTime0.00190.2332210.0001
Mysql Total
Database connection0.00100.117910.0010
Mysqli_queries0.725389.65001960.0037
Looping result0.00190.23431940.0000
Template Total0.772795.520.3863
Template load0.00260.318720.0013
Template processing0.770195.183420.3850
Template load and register function0.00010.015010.0001
states
state_id_array0.00140.171910.0014
state_identifier_array0.00120.145120.0006
Override
Cache load0.00230.2870600.0000
Sytem overhead
Fetch class attribute can translate value0.00140.170140.0003
Fetch class attribute name0.00190.231050.0004
XML
Image XML parsing0.00150.188140.0004
class_abstraction
Instantiating content class attribute0.00000.001150.0000
General
dbfile0.00470.5761330.0001
String conversion0.00000.000630.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
3content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
8content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
5content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 20
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs