Accidental non-repeating SQL error

gruz
Topic Author
Offline
Premium Member

12 years 8 months ago - 12 years 7 months ago #24708 by gruz

Accidental non-repeating SQL error was created by gruz

While playing with CSS and reloading the page I got an SQL error once:

Code:

SELECT i.*, ie.type_id, ie.language, ty.name AS typename, value AS image, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM #__content AS i LEFT JOIN #__flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN #__flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN #__categories AS c ON c.id = rel.catid LEFT JOIN #__flexicontent_fields_item_relations AS firel ON ( i.id = firel.item_id AND firel.valueorder = 1 AND firel.field_id = 24 ) WHERE c.published = 1 AND i.state IN ( 1, -5 ) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-04-27 19:09' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-04-27 19:09' ) AND i.access <= 1 AND c.id IN (78) AND ie.type_id IN (4) GROUP BY i.id
Got error -1 from storage engine SQL=SELECT i.*, ie.type_id, ie.language, ty.name AS typename, value AS image, CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug, GROUP_CONCAT(rel.catid SEPARATOR ",") as itemcats FROM vcjgz_content AS i LEFT JOIN vcjgz_flexicontent_items_ext AS ie on ie.item_id = i.id LEFT JOIN vcjgz_flexicontent_types AS ty on ie.type_id = ty.id LEFT JOIN vcjgz_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id LEFT JOIN vcjgz_categories AS c ON c.id = rel.catid LEFT JOIN vcjgz_flexicontent_fields_item_relations AS firel ON ( i.id = firel.item_id AND firel.valueorder = 1 AND firel.field_id = 24 ) WHERE c.published = 1 AND i.state IN ( 1, -5 ) AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-04-27 19:09' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-04-27 19:09' ) AND i.access <= 1 AND c.id IN (78) AND ie.type_id IN (4) GROUP BY i.id LIMIT 0, 6

I didn't get it neither before, not after.

---

Didn't see it for a long time, maybe fixed.

J2.5
FC - 2.0 - Rev 1612 (since 17-00 30.12.2012)

Last edit: 12 years 7 months ago by gruz.

Please Log in or Create an account to join the conversation.

micker
Away
Administrator

12 years 8 months ago #24711 by micker

Replied by micker on topic Accidental non-repeating SQL error

stop to kick on flexicontent please !!!

on r1262 ?

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.