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=SELECT `catid` FROM xxxxx_k2_additional_categories WHERE `itemID` = {intval()}

Specifics
New Joomla 3.1 install
New K2 install from download link Date: 4/26
PHP 5.4
LAMP

How to reproduce:
Administrator>Control Panel
Click on "Add New Item"

Same result if you go to items page and click "+New"

Edit:
Reading the error I am unsure why it is trying to select since it is a new install and there have never been any items added.

If I knew where to find the query in the page I could debug but I don't know where you have the query code nested.

PHP MyAdmin

xxxxx_k2_additional_categories

Row Statistics
Format static
Collation utf8_general_ci
Rows 0
Next autoindex 1
Creation Apr 26, 2013 at 06:16 PM
Last update Apr 26, 2013 at 06:16 PM

SELECT `id` , `catid` , `itemID`
FROM `xxxxxxxx_joomla`.`xxxxx_k2_additional_categories`
MySQL returned an empty result set (i.e. zero rows). ( Query took 1.3554 sec )

Again from PHP MyAdmin

SELECT `catid`
FROM `xxxxx_k2_additional_categories`
WHERE `itemID` = '1'

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0019 sec )


Best guess:
{intval()} should not be getting passed to the query.
In other words.
The value of i (intval) should be getting passed to the query not the actual variable.

Hmm, If you can log into the admin try to clear all finder and smart finder terms. (be sure to delete them from the trash as well).

If that doesn't resolve the issue you might want to look for professional assistance or restore a full backup of your db.

After restored the finder_taxonomy_map table, I get new warning:

Duplicate entry '13-1' for key 'PRIMARY' SQL=INSERT INTO `zacw3_finder_links_termsd` (`link_id`, `term_id`, `weight`) SELECT 13, `term_id`, ROUND(SUM(`context_weight`), 8) FROM `zacw3_finder_tokens_aggregate` WHERE `map_suffix` = 'd' GROUP BY `term` ORDER BY `term` DESC

I already restored the db table from a clean new installation.
:(

Maybe you should restore a backup, maybe the db maintenance and optimization caused this.

I think this caused from com_finder though not 100% sure though.

When I try to install K2 Ver.2.6.6 gives me the following error:

500 SQL = SHOW FULL COLUMNS FROM `y41s2_k2_categories`

Joomla version: 3.0.3.0.2

That may be happening?.

K2 directly download it from the official website.

thanks

Cuando intento instalar K2 Ver.2.6.6 me da el siguiente error:

500 SQL=SHOW FULL COLUMNS FROM `y41s2_k2_categories`

Versión de Joomla: 3.0.3.0.2

Que puede estar sucediendo?.

K2 directamente lo descargue desde la pagina oficial.

Gracias

Please, other suggestion to fix the issue?

Hello, I'm using K2 in almost all work and I have had serious problems with the translation (pt-br).
Despite using the latest versions, the translation problems still have data msql error regarding the date and now errors to load the pages in the site.
In the new project, while saving the Iten and access the page, there was a 404. Had to resave the item pair to error correcting. I enabled the English language and the error stopped.

I think I have to seriously review the translation system of K2, because I do not know if it occurs in other languages​​, but it is very bad to work well.
It is a suggestion to improve the K2. Hugs.

_____________________________________________________________

Olá, estou usando o K2 em quase todos trabalhos e venho tendo problemas serios com a tradução (pt-br).
Apesar de usar as versões mais recentes, a tradução tem dados problemas ainda de erro de msql em relação a data e agora também erros para carregar as páginas no site.
Em novo projeto, ao salvar o Iten e acessar a página, ocorria o erro 404. Tinha que salvar novamente o item par ao erro corrigir. Habilitei o idioma Inglês e o erro parou.

Creio que tenho que rever seriamente o sistema de tradução do K2, pois não sei se não ocorre em outros idiomas, mas está muito ruim trabalhar assim.
Fica a sugestão para melhorar o K2. Abraços.

It is J! 2.5.9 with K2 2.6.6 and I've just done some db maintenance and optimization

Hello,

Update Joomla!, K2 and make sure your DB structure is up to date.

Hi

saving and publishing K2 items I get this error in backend:

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 `zacw3_finder_taxonomy_map` SET `link_id`='2',`node_id`='5' WHERE


can you help me to fix this?

Thanks

Hello, the K2 team. Thank you for the extension, I love it a lot.
I have a little concern about the safety of this extension,
after the tests of vulnerability with "Backtrack" be the score shows that the extension has a sql injection vulnerability, I think it's about the first version of 52?

here is the message:

19 # 16
Info -> Component: com_k2 (sectionid) SQL Injection Vulnerability
Versions Effected: 1.0.1 Beta <=
Check: / components/com_k2 /
Exploit: / index.php? Com_k2 option = & view = category & itemlist = null 'and 1 = 2 union select 1, concat (username, 0x3a, password), 3,4,5,6,7,8,9,10,11, usertype from jos_users Where 12,13,14 0x53757065722041646d696e6973747261746f72 = -
Vulnerable? No

this is what sql injection for the latest version 2.6.6 of k2?

Another thing, I tried to inject this code in my site for testing:

mysite.com / index.php? com_k2 option = & view = category & itemlist = null 'and 1 = 2 union select 1, concat (username, 0x3a, password), 3,4,5,6,7,8,9,10,11 , 12,13,14 usertype from jos_users Where 0x53757065722041646d696e6973747261746f72 = -


the Result


a large page with multiple items k2????? this is not normal right?


Another time my friends, I also tried this code in a site that uses k2 (city-adm.lviv.ua/)
the site gave me a 404 error page!!


how I can add this error page to redirect links sql type attacks.

thank you, I need your help, before the launch of my site

Luciano wrote: Hello, a big THANKS to all JW crew, you guys rocks! :lol:

Yes, same issue here. :huh:

"Invalid backend response. Data is not JSON."

Fresh Joomla 1.7.2 + K2 2.5.1 setup!

KingHost Shared plan specs:

Web Server Apache/2.2.15
PHP version 5.2.17
MySQL version 5.1.56
GD image library bundled (2.0.34 compatible)
Multibyte string support Enabled
Upload limit 100M
Memory limit 128M
Open remote files (allow url fopen) Yes

Browsers:
FireFox 7.0.1
IE 8.0.6001.18702

SOLVED!!!!! - Now running Joomla - 2.5.9 and K2 - 2.6.5

Hi,

After a lonnng try/error/try/error.. I solved this issue!

Was needed 2 steps.

FIRST:
The problem of server reporting. I need to turf off this feature at my Joomala backend config. Your configuration.php must have the right chmod to change it.

- Log @ backend > Go to System > Global configuration > Server - Set "Error reporting" to "none".
- SAVE IT.

Thanks to
getk2.org/community/New-to-K2-Ask-here-first/520-Cant-Browse-Server-invalid-backend-response?limit=20&start=40#166108


SECOND:
Go to file: "elFinderVolumeDriver.class.php"

File Directory: on local host or web hosting search:

/administrator/components/com_k2/lib/elfinder

File: "elFinderVolumeDriver.class.php"

Open the file with an editor:

Go to line 752 where the line "$this->_checkArchivers();" should be! And disable this line by adding double slashes "//" (Example: //$this->_checkArchivers();)

Thanks to
getk2.org/community/New-to-K2-Ask-here-first/159715-RESOLVEDInvalid-backend-responseData-is-empty#159730

uploading the files didn't change the situation. Is there a way to disable the component from mysql?

I'm sorry to bother, but I'm a little worried....

It's ok to use this?

K2 v2.5.4 (stable) for Joomla! 1.5 - 1.7


--

uploading the files didn't change the situation. Is there a way to disable the component from mysql?

Hi,

I am using Joomla 2.5.9 and installed K2 v2.6.5 on it. When I am trying to create new category i am getting below error message:

Table 'test.bcp_finder_types' doesn't exist SQL=SELECT `id` FROM `bcp_finder_types` WHERE `title` = 'K2 Item'

Thanks,
Vaishali

Why when i install the joomla in "www.mydomain.gr/joomla" the k2 pluggin is working and when i install joomla in www.mydomain.gr is not working? I get the error above

i did the migration from the beginning again and this time completely manually. (without using SP upgrade for the database).

but i have the same error.

i even cant save any k2 content/items/tags....
there is following error:

TableK2Category: :store fehlgeschlagen!
Unknown column 'language' in 'field list' SQL=UPDATE `ug25_k2_categories` SET `name`='Skillgames',`alias`='skillgames',`description`='',`parent`='0',`extraFieldsGroup`='1',`published`='1',`access`='1',`params`='{\"inheritFrom\":\"0\",\"theme\":\"\",\"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\":\"\"}',`language`='*' WHERE `id`='1'

any advice would be great.
thanks.

Hi Francisco José.

Finally I have adapt the code that you were raising in your post some time ago in order that my K2 calendar shows the children categories, but now I have a problem: when I click on the date in the calendar it jumps to a blank page. I am not a programmer and I don´t know what could be the reason, please could you (or someone) help me?

The code I have introduced in helper.php after replace itemlist.php is:

function getDateLink($day, $month, $year) {
$mainframe = JFactory::getApplication();
$user = JFactory::getUser();
$aid = $user->get('aid');
$db = JFactory::getDBO();
$jnow = JFactory::getDate();
$now = K2_JVERSION == '15' ? $jnow->toMySQL() : $jnow->toSql();
$nullDate = $db->getNullDate();
$languageCheck = '';
if (K2_JVERSION != '15')
{
$accessCheck = " access IN(".implode(',', $user->getAuthorisedViewLevels()).") ";
if ($mainframe->getLanguageFilter())
{
$languageTag = JFactory::getLanguage()->getTag();
$languageCheck = " AND language IN (".$db->Quote($languageTag).", ".$db->Quote('*').") ";
}
}
else
{
$accessCheck = " access <= {$aid}";
}
$query = "SELECT COUNT(*) FROM #__k2_items WHERE YEAR(created)={$year} AND MONTH(created)={$month} AND DAY (created)={$day} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) AND trash=0 AND {$accessCheck}
{$languageCheck} AND EXISTS(SELECT * FROM #__k2_categories WHERE id= #__k2_items.catid AND published=1 AND trash=0 AND
{$accessCheck} {$languageCheck})";
$catid = $this->category;
if ($catid > 0)
$categories = modK2ToolsHelper::getCategoryChildren($catid);
$categories[] = $catid;
$categories = @array_unique($categories);
$sql = @implode(',', $categories);
$query .= " AND catid IN ({$sql})";
$db->setQuery($query);
$result = $db->loadResult();
if ($db->getErrorNum())
{
echo $db->stderr();
return false;
}
if ($result > 0)
{
if ($catid > 0)
return JRoute::_(K2HelperRoute::getDateRoute($year, $month, $day, $catid));
else
return JRoute::_(K2HelperRoute::getDateRoute($year, $month, $day));
}
else
{
return false;
}
}

My K2 version is 2.6.5 and inks on dates are like this: .../joomla/index.php/component/k2/itemlist/date/2013/2/4?catid=115 and "catid" changes in consecutive numbers (115=February, 116 = March, etc ...)...
Thanks!
Helena



(Por fin he conseguido adaptar el código que planteabas en tu post de hace tiempo para que mi K2 calendar muestre las subcategorías, pero ahora tengo un problema y es que al pulsar sobre la fecha en el calendario me salta a una página en blanco. No soy programadora y no sé a qué se debe, ¿me puedes ayudar?
El código que he introducido en helper.php después de modificar el archivo itemlist.php es:
....
....
Mi versión de K2 es la 2.6.5 y el tipo de enlace que me sale en las fechas es: .../joomla/index.php/component/k2/itemlist/date/2013/2/4?catid=115 donde "catid" cambia por meses en números consecutivos (115=February, 116 = March, etc ...)...

Gracias!)