Ciao a tutti, ho riscontrato il seguente errore: "Invalid backend response. Data is not JSON.", di solito ottimizzavo il php.ini dal pannello di controllo del mio hosting adesso non lo fa fare più, nel senso che non si può ottimizzare perchè è già predisposto ed io non riesco a sistemare questo errore, qualcuno può aiutarmi? Grazie mille in anticipo.
Seguono le caratteristiche del sistema:
Versione Joomla (Hai già l'ultima versione di Joomla, la 3.4.1)
Versione K2 2.7.2
Informazioni di sistema

Server web Apache
Versione PHP 5.6.30
Versione MySQL 5.5.54-38.6-log
Libreria GD per le immagini bundled (2.1.0 compatible)
Supporto alle stringhe multibyte Abilitato
Limite del caricamento 25M
Limite di memoria 256M
Apri i files remoti (abilita url fopen) Sì

Hello. This is the error:

jDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')}' at line 1 SQL=DELETE FROM jos_k2_tags_xref WHERE itemID={intval()}

Suddenly i am facing with this issue. When i am trying to save a new article i see the below msg and nothing is getting save.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB 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 = '1' WHERE id =

This is on joomla 1.5.22

Hola buenos días a todos.

Agradezco de antemano y espero puedan ayudarme, he perdido la capacidad de crear artículos en K2 de Joomla, al tratar de hacer un artículo, regresa el siguiente error:


TableK2Item: :almacenamiento fallido
Table './codigo75/zdfs_k2_items' is marked as crashed and last (automatic?) repair failed SQL=INSERT INTO `zdfs_k2_items` (`id`,`title`,`alias`,`catid`,`published`,`introtext`,`fulltext`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`created`,`created_by`,`created_by_alias`,`publish_up`,`publish_down`,`access`,`ordering`,`featured`,`metadata`,`metadesc`,`metakey`,`params`,`language`) VALUES ('','hola','hola','1','1','

hola-test
','','','','','','2017-03-09 03:47:25','83','','2017-03-09 03:47:25','0000-00-00 00:00:00','1','','0','robots=\nauthor=','','','{\"catItemTitle\":\"\",\"catItemTitleLinked\":\"\",\"catItemFeaturedNotice\":\"\",\"catItemAuthor\":\"\",\"catItemDateCreated\":\"\",\"catItemRating\":\"\",\"catItemImage\":\"\",\"catItemIntroText\":\"\",\"catItemExtraFields\":\"\",\"catItemHits\":\"\",\"catItemCategory\":\"\",\"catItemTags\":\"\",\"catItemAttachments\":\"\",\"catItemAttachmentsCounter\":\"\",\"catItemVideo\":\"\",\"catItemVideoWidth\":\"\",\"catItemVideoHeight\":\"\",\"catItemAudioWidth\":\"\",\"catItemAudioHeight\":\"\",\"catItemVideoAutoPlay\":\"\",\"catItemImageGallery\":\"\",\"catItemDateModified\":\"\",\"catItemReadMore\":\"\",\"catItemCommentsAnchor\":\"\",\"catItemK2Plugins\":\"\",\"itemDateCreated\":\"\",\"itemTitle\":\"\",\"itemFeaturedNotice\":\"\",\"itemAuthor\":\"\",\"itemFontResizer\":\"\",\"itemPrintButton\":\"\",\"itemEmailButton\":\"\",\"itemSocialButton\":\"\",\"itemVideoAnchor\":\"\",\"itemImageGalleryAnchor\":\"\",\"itemCommentsAnchor\":\"\",\"itemRating\":\"\",\"itemImage\":\"\",\"itemImgSize\":\"\",\"itemImageMainCaption\":\"\",\"itemImageMainCredits\":\"\",\"itemIntroText\":\"\",\"itemFullText\":\"\",\"itemExtraFields\":\"\",\"itemDateModified\":\"\",\"itemHits\":\"\",\"itemCategory\":\"\",\"itemTags\":\"\",\"itemAttachments\":\"\",\"itemAttachmentsCounter\":\"\",\"itemVideo\":\"\",\"itemVideoWidth\":\"\",\"itemVideoHeight\":\"\",\"itemAudioWidth\":\"\",\"itemAudioHeight\":\"\",\"itemVideoAutoPlay\":\"\",\"itemVideoCaption\":\"\",\"itemVideoCredits\":\"\",\"itemImageGallery\":\"\",\"itemNavigation\":\"\",\"itemComments\":\"\",\"itemTwitterButton\":\"\",\"itemFacebookButton\":\"\",\"itemGooglePlusOneButton\":\"\",\"itemAuthorBlock\":\"\",\"itemAuthorImage\":\"\",\"itemAuthorDescription\":\"\",\"itemAuthorURL\":\"\",\"itemAuthorEmail\":\"\",\"itemAuthorLatest\":\"\",\"itemAuthorLatestLimit\":\"\",\"itemRelated\":\"\",\"itemRelatedLimit\":\"\",\"itemRelatedTitle\":\"\",\"itemRelatedCategory\":\"\",\"itemRelatedImageSize\":\"\",\"itemRelatedIntrotext\":\"\",\"itemRelatedFulltext\":\"\",\"itemRelatedAuthor\":\"\",\"itemRelatedMedia\":\"\",\"itemRelatedImageGallery\":\"\",\"itemK2Plugins\":\"\"}','*')

I have K2 v2.7.1 :: Joomla 3.6.5
SITE INFORMATION
OS Linux i
PHP 5.6.24
MySQLi 5.6.31
Caching Disabled
Gzip Disabled


I am not able to save images.
I have reviewed the fix located at: www.joomlaworks.net/forum/k2-en/45116-image-upload-error-k2-7-and-j3-5

My system file is not the same (see details below) I still have the problem.
How can i edit the item.php file to ensure images are saved to the database?? ::

CODING

//Image
if ((int)$params->get('imageMemoryLimit'))
{
ini_set('memory_limit', (int)$params->get('imageMemoryLimit').'M');
}
$existingImage = JRequest::getVar('existingImage');
if (($files == 0 || $existingImage) && !JRequest::getBool('del_image'))
{

if ($files == 0)
{
$image = $files;
}
else
{
$image = JPATH_SITE.DS.JPath::clean($existingImage);
}

$handle = new Upload($image);
$handle->allowed = array('image/*');
$handle->forbidden = array('image/tiff');

if ($handle->file_is_image && $handle->uploaded)
{
//Image params
$category = JTable::getInstance('K2Category', 'Table');
$category->load($row->catid);
$cparams = class_exists('JParameter') ? new JParameter($category->params) : new JRegistry($category->params);

if ($cparams->get('inheritFrom'))
{
$masterCategoryID = $cparams->get('inheritFrom');
$query = "SELECT * FROM #__k2_categories WHERE id=".(int)$masterCategoryID;
$db->setQuery($query, 0, 1);
$masterCategory = $db->loadObject();
$cparams = class_exists('JParameter') ? new JParameter($masterCategory->params) : new JRegistry($masterCategory->params);
}

$params->merge($cparams);

//Original image
$savepath = JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'src';
$handle->image_convert = 'jpg';
$handle->jpeg_quality = 100;
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = md5("Image".$row->id);
$handle->Process($savepath);

$filename = $handle->file_dst_name_body;
$savepath = JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache';

//XLarge image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_XL';
if (JRequest::getInt('itemImageXL'))
{
$imageWidth = JRequest::getInt('itemImageXL');
}
else
{
$imageWidth = $params->get('itemImageXL', '800');
}
$handle->image_x = $imageWidth;
$handle->Process($savepath);

//Large image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_L';
if (JRequest::getInt('itemImageL'))
{
$imageWidth = JRequest::getInt('itemImageL');
}
else
{
$imageWidth = $params->get('itemImageL', '600');
}
$handle->image_x = $imageWidth;
$handle->Process($savepath);

//Medium image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_M';
if (JRequest::getInt('itemImageM'))
{$imageWidth = JRequest::getInt('itemImageM');}
else
{
$imageWidth = $params->get('itemImageM', '400');
}
$handle->image_x = $imageWidth;
$handle->Process($savepath);

//Small image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_S';
if (JRequest::getInt('itemImageS'))
{
$imageWidth = JRequest::getInt('itemImageS');
}
else
{
$imageWidth = $params->get('itemImageS', '200');
}
$handle->image_x = $imageWidth;
$handle->Process($savepath);

//XSmall image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_XS';
if (JRequest::getInt('itemImageXS'))
{
$imageWidth = JRequest::getInt('itemImageXS');
}
else
{
$imageWidth = $params->get('itemImageXS', '100');
}
$handle->image_x = $imageWidth;
$handle->Process($savepath);

//Generic image
$handle->image_resize = true;
$handle->image_ratio_y = true;
$handle->image_convert = 'jpg';
$handle->jpeg_quality = $params->get('imagesQuality');
$handle->file_auto_rename = false;
$handle->file_overwrite = true;
$handle->file_new_name_body = $filename.'_Generic';
$imageWidth = $params->get('itemImageGeneric', '300');
$handle->image_x = $imageWidth;
$handle->Process($savepath);

if ($files == 0)
$handle->Clean();

}
else
{
$mainframe->enqueueMessage(JText::_('K2_IMAGE_WAS_NOT_UPLOADED'), 'notice');
}

}

if (JRequest::getBool('del_image'))
{

$current = JTable::getInstance('K2Item', 'Table');
$current->load($row->id);
$filename = md5("Image".$current->id);

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'src'.DS.$filename.'.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'src'.DS.$filename.'.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_XS.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_XS.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_S.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_S.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_M.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_M.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_L.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_L.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_XL.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_XL.jpg');
}

if (JFile::exists(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_Generic.jpg'))
{
JFile::delete(JPATH_ROOT.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.$filename.'_Generic.jpg');
}

$row->image_caption = '';
$row->image_credits = '';

}

I tried running your query like this [note my database prefix is 'jml3_']

SELECT * FROM `jml3_k2_items` SET `metadata` = 'robots=author=' WHERE `metadata` = '{"robots":"","author":"","rights":"","xreference":""}'

but I got the following message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SET `metadata` = 'robots=author=' WHERE `metadata` = '{"robots":"","author":"","' at line 1


I tried this query as suggested by someone else on the first page of this forum:

UPDATE `jml3_k2_items` SET `metadata` = ''

This one went through but in the SQL query page, but in Joomla in K2, the error message when opening any item didn't dissapear.

Finally, I tried changing the view.html.php file as suggested by Mohamed Abdelaziz on the first page, and that did work in removing the error message in K2 and allowing me to see my items. However, I fear that perhaps I might not be able to use metadata in my K2 items anymore by carrying out his solution. So I was wondering Concerto Designs LLC if you know why I'm getting this error message in the SQL query page when running your query with the correct database prefix?

Thanks!

Good day!

We're in the process of mgirating our joomla website to a more robust server in microsoft's azure cloud services.
Since we can't use our regular migration method (create a backup with akeeba backup and restore in the final server) I've been tasked with doing the migration manually.

When I attempted to install the latest k2 release (2.7.0), I get the following errors:
JInstaller: :Install: Can't find Joomla XML setup file.
JInstaller: :Install: Can't find XML setup file.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near '`'. SQL=ALTER TABLE #__k2_categories ADD `language` CHAR(7) NOT NULL

I'm not sure how to proceed here. Is there a way that we can install k2 in microsoft's azure database? Or is it better to find a similar component?

Thanks in advance

Hi
i'm upgrading an old W2 website (Joomla 1.5.x) to the last version.
I'm starting with a new installation and I want to import the K2 tables in the new db.
I have seen the K2 items table structure is different between the 2 versions. So I cannot use the old table as it is (I get a SQL error)

What is the right procedure to import the data of old tables in a new ones


thank you

Hello,

Try clearing your site's cache.
If that does not do the trick, try repairing your db's tables.

All of a sudden my users are getting the following error for an item that does exist:

126
Incorrect key file for table './blabber9_joom1/#__k2_items.MYI'; try to repair it SQL=UPDATE #__k2_items SET `hits` = (`hits` + 1) WHERE `id` = '75124'
It appears the page you were looking for doesn't exist. Sorry about that.

Does anyone know what it is and or how to repair it?

Thanks!

Hallo
The extrafield in k2 generate the error "1054" when insert any word that start with "inf" eg: "information, info@", "infact" ecc. in input text, textarea, ecc.

DB Version: 5.7.16-0ubuntu0.16.04.1
PHP Version: 7.0.8-0ubuntu0.16.04.3
Web Server: Apache/2.4.18 (Ubuntu)

Many tnx!

Could use some help here, while installing the Takai Quick Package, I keep getting this error :

HTTP Request Error
HTTP Status: 500 (Internal Server Error)
Internal status: error
XHR ReadyState: 4
Raw server response:

Server info (All with default settings):
Windows 2003
MySQL 5.6.27
PHP 5.4.45
Base Joomla 3.2.0
Apache 2.4

Appreciate any help, thanks.

when I click on extra fields button I have this error message: __k2_extra_fields' doesn't exist SQL=SELECT COUNT(*) FROM #__k2_extra_fields WHERE id>0 AND published=1

Hi everyall, i'm sorry but i dont speack english verry well (i'm french)

I come because i ave problème with my site. When i whant click on tag in k2 content, a message come with error 1064. This is the message :

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 * FROM #__k2_categories WHERE id=

Can you help me ?
Thank's.

ps: exemple of problème
tag on the bottom of content :
www.actugame.net/actu-jeux-video/1019-final-fantasy-xv-les-details-du-patch-day-one

résult after clicking :
www.actugame.net/actu-jeux-video/tag/PS4

Bonjour à tous, je viens vers vous pour vous exposer mon problème, sachant que je suis novice et que le code n'est vraiment pas mon truc...



Depuis quelques temps, je me retrouve avec une erreur sql si je clique sur les tags rentrés dans mes articles (composant k2) sur mon site joomla.

exemple de page ici :

www.actugame.net/les-vid%C3%A9os/tag/microsoft



le message :

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 * FROM #__k2_categories WHERE id=

Si vous avez une idée de solution je suis prenneur car là, je suis largué. Merci de vulgariser au maximum pour mes pauvres compétences. :)

we had the same issue, but only after importing Joomla articles into K2. Seems there is leftover metadata that creates the problem.
A solution is to clear the column "metadata" in k2 table "k2_items" here's the sql query:

UPDATE `tableprefix_k2_items` SET `metadata` = ''

NOTE: You will of course loose your metadata if there was any.

Hello Krikor,

Thanks for the link to the JoomlaShack topic, I checked it. update [prefix]_modules set params="" WHERE params = "{"\"\"}";
is the first thing I did. I got a return of 0 rows updated.

I saw further down in the Github conversation that it was argued this is not a Joomla core issue and it is an extensions issue to do with the extensions not being able to handle this higher level of error handling, if I've understood it correctly.

I have also implemented the #116713 solution and defined the following in the top of my index.php file:

unset($this->_scripts[JURI::root(true).'/components/com_k2/js/k2.js?v2.7.1&sitepath='.JURI::root(true).'/']);

And I'm still getting the error. I thought disabling the javascript would resolve the JSON error? Am I wrong?

I have currently resorted to deleting the old K2 items and replacing them with new ones (after copying the content directly out from the SQL) this works but it is far from an ideal solution.

Any ideas?

Dear All,

I hope someone can tell me whats goes wrong.
When i Save a new item i got the following error message

Error 1146 :
Table 'groenpo_jos1.joox_k2_tags_xref' doesn't exist SQL=SELECT tr.id, tr.itemID, tr.tagId, t.name FROM joox_k2_tags_xref AS tr INNER JOIN joox_k2_tags AS t ON t.id = tr.tagID WHERE t.published = 1 AND tr.itemID = 12

You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a search engine that has an out-of-date listing for this site
a mistyped address
you have no access to this page
The requested resource was not found.
An error has occurred while processing your request.

I see there is some problem with de Dbase, but i doesn't know how to solve

Please tell me what to do.

Grtz From holland
Manfred vd Waarsenburg

Though there were some updates, these were only admin interface changes. The really much anticipated version 3, which I've tested, is far from production ready, and doesn't have the much needed feature improvements. Judging from the activity on GitHub (and the participation of the developers in this discussion), I don't think there will be a 3.0 version any time soon.

I've looking into alternatives. Seblod I couldn't get installed. A lot of install sql-errors. Zoo, out of the box seems really complex to set up.
I've found EasyBlog a really fantastic option, which I'm investigating into detail. It has a K2 migration tool and lots of features that are either missing or only available with (commercial) third party plugins for K2. And very good support.

Info update:

1) Swiffy Animations -- I think you are right that K2 and Swiffy animations have a Javascript conflict. When both are installed they may cause a recursion problem. Later, I found out that this also happens with Swiffy animations and Rockettheme's Roksprocket extension. My solution is that I just cannot use Swiffy animations with certain Joomla extensions.

2) Fatal error: Cannot redeclare pma_tableheader() -- I now believe that this a bug in myAdminPHP. I posted the issue in Github. github.com/phpmyadmin/phpmyadmin/issues/12558 . I also opened a support ticket with my web hosting service to update their version of myAdminPHP.

3) "Problems with indexes of table `tbl_user_keys`
The indexes series and series_3 seem to be equal and one of them could possibly be removed.
The indexes series and series_2 seem to be equal and one of them could possibly be removed."
I followed the error message's advice and dropped table rows for index series_3 and series_2, which solved the problem.

Summary:
In my initial post, I assumed that all of these issues were caused by K2 because I had just installed and uninstalled K2 when I noticed the problems.
Now, I think that it was just coincidence, and I apologize for putting the blame on K2. If you concur, we could marked this issue as resolved. Thank you for replying and helping.