- Posts: 21
COMMUNITY FORUM
[SOLVED] Error when you want to delete K2 items
- Conversal
- Topic Author
- Offline
- Junior Member
Less
More
8 years 7 months ago #152825
by Conversal
Error when you want to delete K2 items was created by Conversal
Hello,
After updating, we always get this error when we want to delete an item from the overview page:
Unknown column 'Array' in 'where clause' SQL=SELECT c.id, c.title, c.alias, c.introtext, c.fulltext, c.image_caption, c.image_credits, c.video_caption, c.video_credits, c.extra_fields, c.extra_fields_search, c.metakey, c.metadesc, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM #__k2_items as c LEFT JOIN #__falang_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='k2_items' AND jfc.language_id=3 LEFT JOIN #__languages as jfl ON jfc.language_id=jfl.lang_id WHERE c.id=Array ORDER BY c.title
After updating, we always get this error when we want to delete an item from the overview page:
Unknown column 'Array' in 'where clause' SQL=SELECT c.id, c.title, c.alias, c.introtext, c.fulltext, c.image_caption, c.image_credits, c.video_caption, c.video_credits, c.extra_fields, c.extra_fields_search, c.metakey, c.metadesc, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM #__k2_items as c LEFT JOIN #__falang_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='k2_items' AND jfc.language_id=3 LEFT JOIN #__languages as jfl ON jfc.language_id=jfl.lang_id WHERE c.id=Array ORDER BY c.title
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 7 months ago #152834
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error when you want to delete K2 items
Are you using 2.7 and Falang?
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Conversal
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 21
8 years 7 months ago #152843
by Conversal
Replied by Conversal on topic Error when you want to delete K2 items
Yes inded, but we've updated Falang to the latest version, released today. Is this because of Falang?
Please Log in or Create an account to join the conversation.
- Javi Mata
- Offline
- Senior Member
8 years 7 months ago #152847
by Javi Mata
Twitter: @Javi_Mata
Web: www.javimata.com
Replied by Javi Mata on topic Error when you want to delete K2 items
this is ok?
c.id=Array ??? don't be simple value???
c.id=Array ??? don't be simple value???
Twitter: @Javi_Mata
Web: www.javimata.com
Please Log in or Create an account to join the conversation.
- Conversal
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 21
8 years 7 months ago #152858
by Conversal
Replied by Conversal on topic Error when you want to delete K2 items
Hi,
No, it's still there. As well in Falang 2.2.2 as in latest falang version we have this issue.
Jeroen
No, it's still there. As well in Falang 2.2.2 as in latest falang version we have this issue.
Jeroen
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 7 months ago #152917
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error when you want to delete K2 items
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- ISU ITSS
- Offline
- New Member
Less
More
- Posts: 1
8 years 7 months ago #153016
by ISU ITSS
Replied by ISU ITSS on topic Error when you want to delete K2 items
I have same problem.
Using latest master from k2 repository and also latest Falang 2.5 with k2 2.4 content element.
When I try to unpublish the item I get this:
An error has occurred.
1054 Unknown column 'Array' in 'where clause' SQL=SELECT c.id, c.title, c.alias, c.introtext, c.fulltext, c.image_caption, c.image_credits, c.video_caption, c.video_credits, c.extra_fields, c.extra_fields_search, c.metakey, c.metadesc, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM #__k2_items as c LEFT JOIN #__falang_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='k2_items' AND jfc.language_id=3 LEFT JOIN #__languages as jfl ON jfc.language_id=jfl.lang_id WHERE c.id=Array ORDER BY c.title
Using latest master from k2 repository and also latest Falang 2.5 with k2 2.4 content element.
When I try to unpublish the item I get this:
An error has occurred.
1054 Unknown column 'Array' in 'where clause' SQL=SELECT c.id, c.title, c.alias, c.introtext, c.fulltext, c.image_caption, c.image_credits, c.video_caption, c.video_credits, c.extra_fields, c.extra_fields_search, c.metakey, c.metadesc, jfc.id as jfc_id, jfc.value as titleTranslation, jfc.modified as lastchanged, jfc.published as published, jfc.language_id, jfl.title as language, jfc.reference_id as jfc_refid FROM #__k2_items as c LEFT JOIN #__falang_content as jfc ON c.id=jfc.reference_id AND jfc.reference_field='title' AND jfc.reference_table='k2_items' AND jfc.language_id=3 LEFT JOIN #__languages as jfl ON jfc.language_id=jfl.lang_id WHERE c.id=Array ORDER BY c.title
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 7 months ago #153076
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error when you want to delete K2 items
Thank you for reporting this.
I am reporting this on github as well, we will look into it and let you know.
I am reporting this on github as well, we will look into it and let you know.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.
- Gorast
- Offline
- Premium Member
Less
More
- Posts: 137
8 years 7 months ago #153739
by Gorast
Replied by Gorast on topic Error when you want to delete K2 items
Was this fixed? I'm trying to find a fix but everything I tried its not working. I have the exact same error message.
Please Log in or Create an account to join the conversation.
- Krikor Boghossian
- Offline
- Platinum Member
Less
More
- Posts: 15920
8 years 7 months ago #153788
by Krikor Boghossian
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Replied by Krikor Boghossian on topic Error when you want to delete K2 items
Hello Gorast,
We are still working on it.
We are still working on it.
JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)
Please Log in or Create an account to join the conversation.