My K2 have An error.
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 SQL=UPDATE `xxx_finder_taxonomy_map` SET `link_id`='26',`node_id`='3' WHERE

But no have error when creating new joomla article.

I am using K2 ver 2.6.7 and joomla 3.1.1

Dear members, need help :

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 ') AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-20 09:4' at line 1 SQL=SELECT a.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams FROM yql4k_k2_items as a LEFT JOIN yql4k_k2_categories c ON c.id = a.catid WHERE a.published = 1 AND a.access IN(1,1,5) AND a.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND (a.created_by = 0 OR a.modified_by = 0) AND a.catid IN() AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-07-20 09:49:47' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-07-20 09:49:47' ) ORDER BY a.ordering ASC

How do I fix this ?

Prezados membros,

De que forma, posso corrigir isto ?

When trying to resize an image with Media Manager using resize option, the following happens:
- POP with the image appears
- Layout of the items appears to be wrong
- When the values have been changed and you click apply it causes an error to occur:

"Image dose not rotated" (yes that's how is exactly how it is produced, spelling mistake and all).

I have tried different backend templates, disabled pretty much every plugin and tried multiple variation of Jquery settings but nothing resolves this issue.

I have the following:
Joomla 3.1
k2 2.6.7 (2.6.6. did the same but didn't show the cancel/apply button, so some progress was made).
PHP 5.4.7
MSQL 5.5.27
Apache/2.4.3

Any help would be appreciated.

Krikor Boghossian wrote: The truth is I have tested it with multiple of 2.5.11 sites and all updated without a hassle so I wiil need some more information on your setup since I will try to reproduce the error.

Which version of PHP are you using?
What other extensions are you using?
Is your site native 2.5.x or it started as a 1.7.x?

Sorry for sounding a bit like a Gestapo Officer but I want to reproduce the error.

Regards.

From information tab in K2 section

System information
Check Result

Web Server Apache
PHP version 5.3.24
MySQL version 5.5.32-cll
GD image library bundled (2.0.34 compatible)
Multibyte string support Enabled
Upload limit 10M
Memory limit 64M
Open remote files (allow url fopen) Yes
Directory permissions
Check Result

media/k2 Writable
media/k2/attachments Writable
media/k2/categories Writable
media/k2/galleries Writable
media/k2/items Writable
media/k2/users Writable
media/k2/videos Writable
cache Writable
K2 Modules
Check Result

mod_k2_comments Installed
mod_k2_content Installed
mod_k2_tools Installed
mod_k2_user Installed
mod_k2_users Installed
mod_k2_quickicons (administrator) Installed
mod_k2_stats (administrator) Installed
K2 Plugins
Check Result

Finder - K2 Installed - Enabled
Search - K2 Installed - Enabled
System - K2 Installed - Enabled
User - K2 Installed - Enabled
Third-party Extensions
Check Result

AllVideos (plugin) Installed
Simple Image Gallery Pro (plugin) Installed

----extensions enabled are---
akeeba
alphauserpoints
Kunena
JCE Editor
Jevents
Menu Accordeon CK
Community Builder
b2j social sharer
Disqus for K2
jAntispam
uddeim (not using)
Sexy Contact Form
ByeByeGenerator
System-AntiCopy

And i've always used Joomla 2.5 and only upgraded with every new update for that version. Never used 3.0 or 1.7.

Clicking this link leads to an error:
Database connection error (2): Could not connect to MySQL.

Salve,

ogni volta che voglio aggiungere un articolo mi compare questo errore:

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 6 SQL=UPDATE jos_k2_items SET video_caption = '', video_credits = '', extra_fields = '[]', extra_fields_search = '' , published = '0' WHERE id =

e andando a controllare il DB mi risulta che l'ID dell'articolo è 0 ed ogni volta devo andare a modificare questo parametro...

Potete per favore aiutarmi?
Grazie

Yes, it's now fixed :)

Chicos!

Arreglado en getk2.org/community/New-to-K2-Ask-here-first/179340-K2-Tagcloud-not-working-as-multilanguage

Seguid el link que aparece en el bug report y al final hallaréis la solucion!.

Saludos.

Hi all,

I'm trying to enable the module k2tools as TagCloud in a multilanguage site.
I'm recieving this error when I enable the tagcloud for any language:

Error: 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 ') AND tag.published = 1' at line 4 SQL=SELECT tag.name, tag.id FROM cfubg_k2_tags as tag LEFT JOIN cfubg_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN () AND tag.published = 1

Any ideas what I'm doing wrong?

Joomla 3.1.1 and k2-svn

Hola,

Estoy intentando configurar el tagcloud module para multiidioma y me sale esto:

Error: 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 ') AND tag.published = 1' at line 4 SQL=SELECT tag.name, tag.id FROM cfubg_k2_tags as tag LEFT JOIN cfubg_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN () AND tag.published = 1

Uso K2-svn en Joomla 3.1.1

I've just discovered K2 and would apologize for the basic question. I'm using a template from rockettheme, with a rocketlauncher install. When I try to import the existing articles over as items in K2, I am getting an error and can't do it. This would save so much time - has anyone come across this before? Thanks for and assistance!!

An error has occurred.
0 SQL=INSERT INTO `sec_k2_categories` (`id`,`name`,`alias`,`description`,`parent`,`published`,`image`,`access`,`ordering`,`params`,`trash`,`language`) VALUES ('2','Uncategorised','uncategorised','','0','1','','1','4','{\"theme\":\"default\",\"num_leading_items\":\"2\",\"num_leading_columns\":\"1\",\"leadingImgSize\":\"Large\",\"num_primary_items\":\"4\",\"num_primary_columns\":\"2\",\"primaryImgSize\":\"Medium\",\"num_secondary_items\":\"4\",\"num_secondary_columns\":\"1\",\"secondaryImgSize\":\"Small\",\"num_links\":\"4\",\"num_links_columns\":\"1\",\"linksImgSize\":\"XSmall\",\"catCatalogMode\":\"0\",\"catFeaturedItems\":\"1\",\"catOrdering\":\"\",\"catPagination\":\"2\",\"catPaginationResults\":\"1\",\"catTitle\":\"1\",\"catTitleItemCounter\":\"1\",\"catDescription\":\"1\",\"catImage\":\"1\",\"catFeedLink\":\"1\",\"catFeedIcon\":\"1\",\"subCategories\":\"1\",\"subCatColumns\":\"2\",\"subCatOrdering\":\"\",\"subCatTitle\":\"1\",\"subCatTitleItemCounter\":\"1\",\"subCatDescription\":\"1\",\"subCatImage\":\"1\",\"itemImageXS\":\"\",\"itemImageS\":\"\",\"itemImageM\":\"\",\"itemImageL\":\"\",\"itemImageXL\":\"\",\"catItemTitle\":\"1\",\"catItemTitleLinked\":\"1\",\"catItemFeaturedNotice\":\"0\",\"catItemAuthor\":\"1\",\"catItemDateCreated\":\"1\",\"catItemRating\":\"0\",\"catItemImage\":\"1\",\"catItemIntroText\":\"1\",\"catItemIntroTextWordLimit\":\"\",\"catItemExtraFields\":\"0\",\"catItemHits\":\"0\",\"catItemCategory\":\"1\",\"catItemTags\":\"1\",\"catItemAttachments\":\"0\",\"catItemAttachmentsCounter\":\"0\",\"catItemVideo\":\"0\",\"catItemVideoWidth\":\"\",\"catItemVideoHeight\":\"\",\"catItemAudioWidth\":\"\",\"catItemAudioHeight\":\"\",\"catItemVideoAutoPlay\":\"0\",\"catItemImageGallery\":\"0\",\"catItemDateModified\":\"0\",\"catItemReadMore\":\"1\",\"catItemCommentsAnchor\":\"1\",\"catItemK2Plugins\":\"1\",\"itemDateCreated\":\"1\",\"itemTitle\":\"1\",\"itemFeaturedNotice\":\"1\",\"itemAuthor\":\"1\",\"itemFontResizer\":\"1\",\"itemPrintButton\":\"1\",\"itemEmailButton\":\"1\",\"itemSocialButton\":\"1\",\"itemVideoAnchor\":\"1\",\"itemImageGalleryAnchor\":\"1\",\"itemCommentsAnchor\":\"1\",\"itemRating\":\"1\",\"itemImage\":\"1\",\"itemImgSize\":\"Large\",\"itemImageMainCaption\":\"1\",\"itemImageMainCredits\":\"1\",\"itemIntroText\":\"1\",\"itemFullText\":\"1\",\"itemExtraFields\":\"1\",\"itemDateModified\":\"1\",\"itemHits\":\"1\",\"itemCategory\":\"1\",\"itemTags\":\"1\",\"itemAttachments\":\"1\",\"itemAttachmentsCounter\":\"1\",\"itemVideo\":\"1\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemAudioWidth\":\"\",\"itemAudioHeight\":\"\",\"itemVideoAutoPlay\":\"0\",\"itemVideoCaption\":\"1\",\"itemVideoCredits\":\"1\",\"itemImageGallery\":\"1\",\"itemNavigation\":\"1\",\"itemComments\":\"1\",\"itemTwitterButton\":\"1\",\"itemFacebookButton\":\"1\",\"itemGooglePlusOneButton\":\"1\",\"itemAuthorBlock\":\"1\",\"itemAuthorImage\":\"1\",\"itemAuthorDescription\":\"1\",\"itemAuthorURL\":\"1\",\"itemAuthorEmail\":\"0\",\"itemAuthorLatest\":\"1\",\"itemAuthorLatestLimit\":\"5\",\"itemRelated\":\"1\",\"itemRelatedLimit\":\"5\",\"itemRelatedTitle\":\"1\",\"itemRelatedCategory\":\"0\",\"itemRelatedImageSize\":\"0\",\"itemRelatedIntrotext\":\"0\",\"itemRelatedFulltext\":\"0\",\"itemRelatedAuthor\":\"0\",\"itemRelatedMedia\":\"0\",\"itemRelatedImageGallery\":\"0\",\"itemK2Plugins\":\"1\",\"catMetaDesc\":\"\",\"catMetaKey\":\"\",\"catMetaRobots\":\"\",\"catMetaAuthor\":\"\"}','0','*')
Return to Control Panel

Hello,

I have a problem in the administration of K2 elements.
For an hour, when I leave safeguarding a K2 item, I have the following error message:

500 - Une erreur s'est produite

Column count doesn't match value count at row 1 SQL=INSERT INTO `zqbo7_finder_tokens` (`term`,`stem`,`common`,`phrase`,`weight`,`context`) VALUES ('toto', 'toto', 0, 0, 0,2667, 1)

Retour au panneau de contrôle


I recently installed the Glossary component 288J2, there may be a link there.

Do you have any idea to solve my problem.

Thank you very much.

Thank you for your reply, I tried any reinstall and reordering possible. The strange thing is I am the only one in the world getting this specific error, not just considering the interaction between K2 and CComment :P The strange thing is they say there is no integration with K2 backend, so it's strange the issue happens here.
Maybe I will switch to a different comment system like Disqus if I can't solve soon, but if someone from K2 could have a suggestion about what could be the cause of this error, it would be nice ;)
Unluckily my host provider doesn't give me much control over mysql, otherwise I could check if there is some weird query that fails or something like that.

hi
i have joomla 2.5.11 with k2 2.6.6 when "Cache Settings" is on (Conservative or Progressive) the categories pages display the error:

"Warning: mysqli_close() [function.mysqli-close]: Couldn't fetch mysqli in /home/rabenu/public_html/libraries/joomla/database/database/mysqli.php on line 141"


what can i do?
please help.

thanks

Ah, getting closer to a resolution. It appears to be something I changed in the form style. When I set the form style to "-default-" instead of my custom style, that fixes the problem.

In case anyone else ever makes the same mistake, I'll update here when I figure out exactly what I changed that caused the issue.

PS - Everything works fine from the backend.

Hello,
I'm building a new site with K2 2.6.6 and Joomla 3.0. I am trying to setup a site that users can contribute to. Users can open and edit an article form with no problem, but on trying save the article, the site throws this error:

---

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 'AND trash = 0' at line 1 SQL=SELECT MAX(ordering) FROM joom_k2_items WHERE catid = AND trash = 0

---

I am using sh404sef, but the error occurs whether the component is enabled or not. Any ideas?

Thanks,
Nelson

Hello,
I need help. My site is out!

This morning I have received this error: calenar.setup


I tried to load the new version of K2 (26.6)
but now it is stopped again with tihs error:
"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 '44,11,15,20,37,38' at line 1 SQL=SELECT ordering AS value, title AS text FROM hvhgu_k2_items WHERE catid=10,44,11,15,20,37,38"
I'm nont an expert.
Some one can help me pleaee?

Hello Aleksandra,

Double posting never solved anyone's issue faster.

I just installed K2 on a brand new 3.1.1 Joomla! site and it worked fine. Which version are you using?

@Tacops

Try reinstalling please on top of the old installation. Also, please describe your setup.

it didn't help. brand new joomla installation with new k2. sql error.