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.