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

Hallo zusammen,
ich habe das Update auf die neue Joomla Version 3.5 durchgeführt. Seit dem bekomme ich beim Speichern von K3 Items folgenden Fehler:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')}' at line 1

Zudem funktionieren Untermenüs (2. Verkettung Menu/Submenu1/Submenu2) nicht mehr. Die Zuordnung ist noch da. Wenn ich Submenu2 an das Hauptmenü anbinde geht es. Wenn ich es an Submenu1 anbinde nicht mehr.

Bin für jeden Tipp dankbar.

Hello. I'm getting the following error after save the item:

23000 SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-536' for key 'PRIMARY'

I'm not sure if this began after made the update to Joomla 3.5 or k2 7.

After migration from J2.5 to J3 I get this error:


Table 'deb87237n14_jolanda.mmp_o12eq_k2_comments' doesn't exist SQL=SELECT COUNT(*) FROM mmp_o12eq_k2_comments WHERE itemID=1 AND published=1

on all pages. Look here:
jolanda.p100.nl/mmp_upgrade/index.php?option=com_k2&view=item&layout=item&id=1&Itemid=713

Hab

Hi,
I'm constantly getting an error with the tags

1054 Unknown column 'header' in 'field list' SQL=SELECT `new_url`,`header`,`published` FROM `#__redirect_links` WHERE `old_url` = 'www.southwestfilm.co.uk/blog' LIMIT 0, 1

any ideas?

Hello,
I'm working with version 3 of K2.
I get a MySQL Error if I go to a module that is not related with K2.

the error, in module administration, is this one:

Error: 1054 Unknown column 'c.name' in 'field list' SQL=SELECT c.name AS name, c.id AS id, c.parent AS parent FROM #__k2_categories AS c WHERE published = 1 AND trash = 0 ORDER BY c.name, c.parent ASC

and it appears on the "title tag" of the page.
the module is BT Content Slider by bowthemes.com

bowthemes.com/joomla-extensions/bt-content-slider.html

any idea?
thanks in advance
denis

I am also unable to delete after Joomla 3.5 upgrade

1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM #__fpss_slides WHERE Array = '6'

I'm trying to delete a slide and i get...

1054 Unknown column 'Array' in 'where clause' SQL=SELECT * FROM #__fpss_slides WHERE Array = '88'

www.livingwithdogs.gr

After a server upgrade I am suddenly getting a blank page with this error on all K2 pages

Fatal error: Call to undefined function mb_regex_encoding() in /home/...../..../...../components/com_k2/helpers/route.php on line 94

Joomla! 3.4.8
K2 v2.6.9
PHP 5.5.33
MySQL 5.6.29
Apache/2.4.18

I know I can comment out the calls for mb_regex_encoding in k2category.php , k2item.php and route.php and the problem will go away, but I would like to know what is going on.

K2, also a new record, edit article or as a result of any action;
This site is unreachable.
The connection was reset.
ERR_CONNECTION_RESET

Coming error and white page. On the other hand Joomla's running smoothly all the components. K2 works fine on localhost.

Thank you for your help ...

www.redklaus.com

Joomla 3.4.8
K2 v2.6.9
MySQL 5.6.29
PHP Version 5.5.28

Hello,

I am getting a mySQL error in your site www.ohiovarsity.com/schools/chagrin-valley-conference/berkshire-badgers

This is caused by a module. Once you find which module is causing this (unpublish them one by one), this might solve the speed issue.

When you goto my website, you get the following message

Fatal error: Class 'K2HelperUtilities' not found in /www/htdocs/w00d9e99/Joomla/administrator/components/com_k2/helpers/html.php on line 56

Joomla ver 2.5.28
K2 ver - 2.6.7
PHP version 5.4.45
MySQL version 5.5.46

I can log into admin site but website front page showing the error stated above.
site = pfc.renncenter-hamburg.de/

Can anyone please tell me what i can do to resolve this??

buenas, he instalado k2 y cuando entro en usuario me sale este error:
1054 Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM josrm_users as juser LEFT JOIN josrm_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN josrm_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN josrm_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc

sabeis de que puede ser?

gracias

Buenas, he instalado k2 pero me sale este error en los usuarios
Unknown column 'juser.usertype' in 'order clause' SQL=SELECT juser.*, k2user.group, k2group.name as groupname FROM josrm_users as juser LEFT JOIN josrm_k2_users as k2user ON juser.id=k2user.userID LEFT JOIN josrm_k2_user_groups as k2group ON k2user.group=k2group.id LEFT JOIN josrm_user_usergroup_map as `map` ON juser.id=map.user_id WHERE juser.id>0 GROUP BY juser.id ORDER BY juser.usertype asc

gracias

Hi,

We're using the latest version of Joomla3. Also, the latest plugin. When we alter a module on the homepage, and add a K2 Data source, the homepage shows as Error 1064. There is no SQL statement shown. It also mentions the page cannot be found.
Can you advise what the issue might be please?
Thanks :)

After an update from 1.5 to Joomla! 3.4.6 I have problems with the database of K2. Regularly chrasht _K2items the table with the following error:

145
Table './geloofen/j25_k2_items' is marked as crashed and should be repaired SQL=SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM j25_k2_items as i LEFT JOIN j25_k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2015-12-18 11:26:28' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2015-12-18 11:26:28' ) AND i.id=671
It appears that the page you were looking for does not exist.

The website does it again after I fixed the table, but this is not the intention that the website is still out.
What can I do?

Hi,

Simple Image Gallery PRO does not execute any SQL queries. It has no database tables. The queries that are failing are triggered by the Joomla! installer.

Make sure that you have the latest versions of Joomla! and Simple Image Gallery PRO.

Hello every one ,

after installing Plugin Simple Image Gallery (by JoomlaWorks) v3.0.1_j1.5-3.x . i get this message error when try to acces to plugins manager on backend ?

Error

Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `bute_extensions` AS a LEFT JOIN bute_users AS uc ON uc.id=a.checked_out LEFT JOIN bute_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 784 Unknown column 'a.id' in 'where clause' SQL=SELECT a.extension_id , a.name, a.element, a.folder, a.checked_out, a.checked_out_time, a.enabled, a.access, a.ordering,uc.name AS editor,ag.title AS access_level FROM `bute_extensions` AS a LEFT JOIN bute_users AS uc ON uc.id=a.checked_out LEFT JOIN bute_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 784 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `bute_extensions` AS a LEFT JOIN bute_users AS uc ON uc.id=a.checked_out LEFT JOIN bute_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 784

Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM bute_extensions WHERE state=0 AND a.id != 784 Unknown column 'a.id' in 'where clause' SQL=SELECT *,2*protected+(1-protected)*enabled as status FROM bute_extensions WHERE state=0 AND a.id != 784 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM bute_extensions WHERE state=0 AND a.id != 784

Any help please ?

Hello our K2 Comment system went down 2 weeks ago. Before then, it was working for maybe 2 years.


Here is the entire error message for referance

TableK2Comment: :store failed
Duplicate entry '621447' for key 'PRIMARY' SQL=INSERT INTO `e8if4_k2_comments` (`itemID`,`userName`,`commentDate`,`commentText`,`commentEmail`,`commentURL`,`published`) VALUES ('1702','Jess','2015-10-06 23:11:46','TESTING','[email protected]','http://www.vegasintervention.com','0')

---

We are willing to do anything, except reformat or erase the database and start over, because we have over 2,000 ( two thousand ) articles from the past 2 Years. Is it possible to reload k2 without destroying previous work? Any suggestions? And no upgrading to Joomla 3 has been taken off the table until be get past this issue.

Also we have tried other Commenting Systems like CC Comments and JComments, but it seems they are not able to read K2 Categories?
Has anyone else come across this problem?

Sincerely,

Granville

Bonjour,
suite à une copie d'item k2 sur un joomla 3.4.4 et K2 2.69 j'ai mon site bloqué en erreur 1064 :

YOU HAVE AN ERROR IN YOUR SQL SYNTAX; CHECK THE MANUAL THAT CORRESPONDS TO YOUR MYSQL SERVER VERSION FOR THE RIGHT SYNTAX TO USE NEAR 'DESC LIMIT 0,9' AT LINE 21 SQL=SELECT CONTENT.ID AS ID FROM Y3ES2_K2_ITEMS AS CONTENT WHERE CONTENT.PUBLISHED = 1 AND CONTENT.TRASH = 0 AND CONTENT.ACCESS IN (1,1) AND ( CONTENT.PUBLISH_UP = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_UP <= '2015-10-05 19:51:17' ) AND ( CONTENT.PUBLISH_DOWN = '0000-00-00 00:00:00' OR CONTENT.PUBLISH_DOWN >= '2015-10-05 19:51:17' ) AND ( CONTENT.CATID = 4 ) ORDER BY CONTENT. DESC LIMIT 0,9;

j'ai upgradé en version de dev 2.70, supprimé l'élément, recréé un autre, re créé une catégorie , mais rien n'y fait ...