We noticed that our search page wasn't filling in information any more after upgrading K2 to the current version.

www.glasspatterns.com/en/search-tutorials.html?f[g][4][]=3

If I click K2>Users I get a white page but without any relevant errors.

When I go into the back end and click on K2>Items I get a white page. With error reporting turned on I get:

Any idea what I need to do? for additional plugins I know we are using Filter For K2 and plg_searcher_k2 by Styleware

I had problem with error The table '#__finder_tokens' is full when I was trying to put lots of text in the items.
As suggested on the joomla site forums I turned off ALL Smart search plugins. The error was gone BUT now categories are not sorted at all. Changing the Sorting type of the category in the backend does not do anything at all. Pagination don't work on some modules. It is not working at all even after enabling all Smart search plugins.

Also I get this error when I try go access the items over jEvents module:

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 ' 0)) WHERE m.published = 1 AND module = 'mod_k2_eo' LIMIT 1' at line 1

I'm starting to panic since half of my client site is not working.
Any suggestions?

TNX!
Gorast

Fixed in mod_k2_comments (error in SQL query) - please try this github.com/getk2/k2/archive/master.zip once more.

Hello,
We have a comments module on the homepage in a multilanguage website (4) on a php 7.2 server.
After the update the module gives a serious error. Before the k2 update to 2.9 there was no problem.
I think it has something to do with the helper.php file.

Here's the error i get:

Unknown column 'c.language' in 'where clause'
/var/www/vhosts/huisjeaandekust.nl/httpdocs/libraries/joomla/database/driver/mysqli.php:661

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:661
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691
3 JDatabaseDriver->loadObjectList() JROOT/modules/mod_k2_comments/helper.php:92
4 modK2CommentsHelper::getLatestComments() JROOT/modules/mod_k2_comments/mod_k2_comments.php:49
5 include() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
6 Joomla\CMS\Helper\ModuleHelper::renderModule()
7 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:629
9 Joomla\CMS\Helper\ModuleHelper::moduleCache() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
10 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
11 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491
12 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
13 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
14 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041
15 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780
16 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201
17 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49

could you take a look if this is perhaps a error in the commentsmodule on k2 2.9 in a multilanguage configuration?

For those having trouble with the SQL that Alan posted, here is SQL I ran that successfully replaced the bad metadata json.

I first ran this to check if my search target was correct
SELECT * FROM `tablePREFIX_k2_items` WHERE `metadata` = '{"robots":"","author":""}'

Then I ran:

UPDATE `tablePREFIX_k2_items` SET `metadata` = replace(metadata, '{"robots":"","author":""}', 'robots=author=')

Don't forget to use your own tablePREFIX

This did the trick

Hi,

I just found out that there's an error when I try to save some changes in the user details / user profile in the frontend:
After pressing "save"-button it shows an HTTP 500 ERROR saying "ERROR: 0 - USING $THIS WHEN NOT IN OBJECT CONTEXT" ...

The changes are saved though but the error is strange ...
So i tried to change the code in k2.php like it was told here recently ... The error is gone BUT it does not save the changes now. So I like it better with error and saving ;-)

Any ideas?


Web-Server Apache
PHP-Version 7.1.11-nmm1
MySQL-Version 5.7.21-nmm1-log
K2 Version 2.8.0
Joomla Version 3.8.10


... and is there some news about any k2-Updates to 2.8 or the new version 3.0? Long time no hear ... ;-)

All the best and thank you
Chris

Hello,
I have installed K2 and Allvideos on the latest Joomla. When trying to index in smart search, I get a "Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; plgContentJw_allvideos has a deprecated constructor in / var / www / joomla / plugins / content / jw_allvideos / jw_allvideos .php on line 18 Unknown column 'acdate' in 'order clause' "and indexing will end. I tried to disable the allvideos plugin and even uninstall it, but it did not help. The error still occurs. I do not know what to do next. Can you please help me?
Thank you in advance for your reply.

(PHP: 7.0.27-0+deb9u1, MySQL: 5.5.5-10.1.26-MariaDB-0+deb9u1

Regards
LD

This error continues still on Joomla 3.8.7.
[EDIT]
Local environment:[/EDIT]

If I have enabled the plugin, I got the error as shown in the first attached image:


If I dissable the plugin, this error just dissapear showing the list of articles with the same tag, as in the second attached image:


Bassically, is the same error, so I think is not related with Joomla, but else with the plugin itself.

My environment:
Joomla 3.8.7
PHP 7.0
MySQL 5.6.35

Bonjour à tous,

Tout nouveau dans le monde de Joomla, j'aurai besoin d'un petit coup de main, voici mon problème :

J'ai un petit souci lorsque je souhaite créer un élément sous K2. Au moment de l'enregistrer, j'ai le message suivant qui s'affiche : ERREUR S'EST PRODUITE - 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

On m'invite ensuite à retourner au panneau de contrôle, à partir de là les ennuis commencent. Impossible de modifier l'article bien que ce dernier soit créé etc. Mes investigations m'ont amené à aller voir la BD et j'ai remarqué que lorsque je modifiais l'ID de l'article qui vient d'être créer, ça refonctionne. A priori, lorsque la valeur de l'ID est 0, ça plante tout. Si je la repasse en valeur >0 c'est bon. Le type du champ ID est int(11). Dois je tout simplement modifier le type de champ pour qu'il accepte la valeur 0.... ?

Je comptais bien aller faire un tour du côté du fichier php générant la requête mais c'est à partir de là que mes maigres compétences ne suffisent manifestement plus... lequel est ce ? pk l'apparition de cette erreur suite à la migration du site en local vers l'hébergeur (1and1 en l’occurrence) ? et enfin, quand bien même je trouverai le fichier générant la requête, je ne sais pas quoi écrire en php pour supprimer le problème.

J'espère avoir été suffisamment clair bien que ma demande soit un peu longue... mais autant être d'emblée le plus exhaustif possible :)

Merci d'avance pour vos réponses/aides !

Your solution solwing my problem.
Please, if you know, what will be correct SQL query to change all {"robots":"","author":"","rights":"","xreference":""},
to
robots= author=

My mistake
www.joomlaworks.net/forum/k2-en/46914-0-error-decoding-json-data-syntax-error?start=30#166410
solution solving problem
Can anybody help me, what will be correct SQL query to change all {"robots":"","author":"","rights":"","xreference":""},
to
robots= author=

Thx

hello there,

i'm using the k2 registration form with the option "Enable reCaptcha on registration form" set to "NO" (in k2's anti-spam settings). but when i try to register a new user in the form i get this error: "Empty solution not allowed."

i've set joomla's error report to "maximum" but it doesn't show anything relevant. also, i don't have any override for this form.

joomla version: 3.8.5
k2 version: 2.8.0
php version: 7.0.25
sql version: 5.5.56-cll-lve

please advise how to solve this issue or find the source of it - currently users are unable to register to the site.

late addition: i also have a strange problem with reCaptcha on k2's comment which i've noticed just now - when submitting a comment i'm shown a blank screen with this wierd message:
{"message":"\u05ea\u05d5\u05d3\u05d4 \u05e2\u05dc \u05d4\u05d3\u05e2\u05d4 \u05e9\u05dc\u05da!
\n\u05d4\u05ea\u05d2\u05d5\u05d1\u05d4 \u05e9\u05dc\u05da \u05ea\u05e4\u05d5\u05e8\u05e1\u05dd \u05d1\u05d3\u05e7\u05d5\u05ea \u05d4\u05e7\u05e8\u05d5\u05d1\u05d5\u05ea.","cssClass":"k2FormLogSuccess"}

when i refresh this blank page, the message changes to this:
{"message":"Could not verify that you are not a robot","cssClass":"k2FormLogError"}

but when i go back to the previous page, the comment is published....

hope that will help find the problem.

thank you

Hello,

I am currently using Joomla 3.8.5, my PHP Version is 7.1.13, my MySQL-Version is 5.5.56.

Since the update to Joomla 3.8.4 frontend login it is not possible any more. Instead of showing a page with the K2 Users Menu there is only a completely white page with the following message:

Error: Using $this when not in object context: Using $this when not in object context

Could anyone help me with a solution to this problem, please? Backend login is working fine.

Kind regards.

Hi guys.....can you advise on this?

Joomla 3.83, K2 2.80, PHP 7.1, MySQL 5.6 is the setup.

The rating stars just keep spinning when clicked.....it was working fine but now does this.

Error in console shows:

index.php?option=com_k2&view=item&task=vote&format=raw&user_rating=5&itemID=30 Failed to load resource: the server responded with a status of 500 (Internal Server Error)

I've checked Hosting side and no errors registering and even installed K2 again.

Turned cache, GZip on and off no difference.

Strange thing is that an identical copy to this one is working without issue.

Any ideas?

I was having this issue and ended up on this thread which helped me narrow down the issue, but before going to SQL I tried one last thing that worked through the joomla control panel.

I went and listed all K2 items, clicked the checkbox to select them all and clicked 'batch'. It allowed me to set an existing user as the author for all k2 items and got rid of the error/warning message on the front end.

Just thought I'd share in case it helps someone else.

Hi,

I've had this problem intermittently on K2 items - each time I've resolved by deleting tags on the item, saving & then reapplying tags & saving.

But I'm now getting this on a menu item. The error is as follows:

Oh, dear, we have a 0

DateTime::__construct(): Failed to parse time string (-1-11-30) at position 5 (-): Double timezone specification

The menu is a K2 Categories menu K2 » Item listings » Categories
index.php?option=com_k2&view=itemlist&layout=category&task=category&id=4

Here are the params for this menu item:
{"inheritFrom":"0","catMetaDesc":"","catMetaKey":"","catMetaRobots":"","catMetaAuthor":"Eddie","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":"0","catFeedIcon":"0","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":"100","catItemExtraFields":"1","catItemHits":"0","catItemCategory":"1","catItemTags":"1","catItemAttachments":"0","catItemAttachmentsCounter":"1","catItemVideo":"1","catItemVideoWidth":"","catItemVideoHeight":"","catItemAudioWidth":"","catItemAudioHeight":"","catItemVideoAutoPlay":"1","catItemImageGallery":"1","catItemImageGalleryWidth":"","catItemImageGalleryHeight":"","catItemDateModified":"0","catItemReadMore":"1","catItemCommentsAnchor":"1","catItemK2Plugins":"1","itemDateCreated":"1","itemTitle":"1","itemFeaturedNotice":"1","itemAuthor":"0","itemFontResizer":"0","itemPrintButton":"0","itemEmailButton":"0","itemSocialButton":"0","itemVideoAnchor":"1","itemImageGalleryAnchor":"1","itemCommentsAnchor":"1","itemRating":"0","itemImage":"1","itemImgSize":"Large","itemImageMainCaption":"1","itemImageMainCredits":"1","itemIntroText":"1","itemFullText":"1","itemExtraFields":"1","itemDateModified":"0","itemHits":"0","itemCategory":"1","itemTags":"1","itemAttachments":"1","itemAttachmentsCounter":"1","itemVideo":"1","itemVideoWidth":"","itemVideoHeight":"","itemAudioWidth":"","itemAudioHeight":"","itemVideoAutoPlay":"0","itemVideoCaption":"1","itemVideoCredits":"1","itemImageGallery":"1","itemImageGalleryWidth":"","itemImageGalleryHeight":"","itemNavigation":"1","itemComments":"1","itemTwitterButton":"0","itemFacebookButton":"0","itemGooglePlusOneButton":"0","itemAuthorBlock":"0","itemAuthorImage":"0","itemAuthorDescription":"0","itemAuthorURL":"0","itemAuthorEmail":"0","itemAuthorLatest":"0","itemAuthorLatestLimit":"5","itemRelated":"1","itemRelatedLimit":"5","itemRelatedTitle":"1","itemRelatedCategory":"1","itemRelatedImageSize":"0","itemRelatedIntrotext":"0","itemRelatedFulltext":"0","itemRelatedAuthor":"0","itemRelatedMedia":"0","itemRelatedImageGallery":"0","itemK2Plugins":"1"}


Sys Info:
J! 3.8.2
K2 2.8.0

Web Server Apache
PHP version 7.0.25
MySQL version 5.6.36-82.1-log
GD image library bundled (2.1.0 compatible)
Multibyte string support Enabled
Upload limit 128M
Memory limit 768M
Open remote files (allow url fopen) Yes

Directory permissions

cache Writable
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

K2 Modules
mod_k2_comments Installed
mod_k2_content Installed
mod_k2_tools Installed
mod_k2_user Installed

K2 Plugins

Finder - K2 Installed - Enabled
Search - K2 Installed - Enabled
System - K2 Installed - Enabled
User - K2 Installed - Enabled
mod_k2_users Installed
mod_k2_quickicons (administrator) Installed
mod_k2_stats (administrator) Installed

I've gone thro the database to make sure each K2 item has a created & modified data.

Any suggestions?

Thanks,

Joomla! 3.8.1
Hikashop 3.2.0

I was in the control panel of Hikashop and tried to edit the window "sales of the month", because it shows nothing, but have orders.
But suddenly I get this error message when I click in the control panel of Hikashop.

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 ' CONCAT('',prod.order_product_name, ' - ' ,c.category_name) as type FROM #__h' at line 1

screen: imgur.com/a/mO6F4

What can I do? I need urgently help please.

Thanks in advance
Simone

Since you dont have a current backup you should probably do a mysql dump of the site just in case of the worst before making other changes.
First try to edit your configuration.php file and turn error reporting to ‘E_ALL | E_STRICT’ and hopefully you may see an error instead of a blank page that may lead you to know what going on.
Later you may need to:
I would unzip the k2 package file and ftp the entire com_k2 directories on top of your exisiting ones and see if that helps
Since it Broke Joomla, you may have to do the same thing with your current version of Joomla as well
but try to find out whats going on first

(Joomla 3.7.5, MySQL 5.6.32)

I upgraded K2 to 2.8.0 yesterday as it the admin page was prompting me to do so. Previous version was 2.6.7. I made the mistake of doing it in a hurry, and foolishly didn't take a full site backup immediately beforehand :-(

The upgrade process completed quickly, but gave the following error messages:

Warning
JFolder: :delete: Path is not a folder. Path: /home1/handsom1/public_html/components/com_k2/js
JFolder: :delete: Path is not a folder. Path: /home1/handsom1/public_html/components/com_k2/sef_ext
Duplicate column name 'ip' SQL=ALTER TABLE `#__k2_users` ADD `ip` VARCHAR( 15 ) NOT NULL , ADD `hostname` VARCHAR( 255 ) NOT NULL , ADD `notes` TEXT NOT NULL
Error
Error installing component

After this, accessing the web site simply returns a blank page (seems to be giving a Server Error 500). The admin login is available, but after authentication just get blank screen again. I tried reverting back to the daily site & DB backup, but this made no difference to the results. I have subsequently reverted back even further, but to no avail.. I have even tried reinstalling the original version of K2, but get a similar SQL error.

On further investigation, it appears that some of the admin pages are available if I enter the full URL directly, such as the list of K2 items, but trying to open an item just gives blank page again. I am unable to use the 'Manage Extensions' dashboard, although the 'Install Extensions' page is available.

What might be broken here, and why is the file restore not fixing it? I have cleared the caches wherever I can.

As I can't access the Global Properties, I cannot switch debug on. How else can I find out what is failing here?

Any help would be much appreciated to get us back on line :-)

Hi,
Upgraded K2 this afternoon & am now getting the following when creating/editing a K2 item

Fatal error: Cannot declare class upload, because the name is already in use in /home/...../public_html/administrator/components/com_k2/lib/class.upload.php on line 624

Joomla! Info:
PHP Version 7.0.22
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.7.5 Stable [ Amani ] 14-August-2017 12:09 GMT

MySQL version 5.6.36-82.1-log
GD image library bundled (2.1.0 compatible)
Multibyte string support Enabled
Upload limit 128M
Memory limit 768M
Open remote files (allow url fopen) Yes

Any suggestions?

Thanks,
Eddie