this error BIGINT UNSIGNED value is out of range in '(`dbusername`.`#__menu`.`level` - 1)' could be because I changed the collation to utf8mb4_unicode_ci. Changing from two byte representations of the data to four byte representation of the data would raise this kind of error.

I was reading arguments like the following and decided to use Akeeba Admin Tools to change the collation from utf8mb4_general_ci to utf8mb4_unicode_ci. There are many tables in the database that used 2 byte utf8_unicode_ci and others that used utf8_general_ci, others that use utf8mb4_unicode_ci and yet others that used utf8mb4_general_ci. those didn't change after changing to utf8mb4_unicode_ci.

There is also a mix of various database engines as well, INNODB, and MYiSAM

Note: Since MySQL 5.5.3 you should use utf8mb4 rather than utf8. They both refer to the UTF-8 encoding, but the older utf8 had a MySQL-specific limitation preventing use of characters numbered above 0xFFFD.

Accuracy

utf8mb4_unicode_ci is based on the Unicode standard for sorting and comparison, which sorts accurately in a very wide range of languages.

utf8mb4_general_ci fails to implement all of the Unicode sorting rules, which will result in undesirable sorting in some situations, such as when using particular languages or characters.

Performance

utf8mb4_general_ci is faster at comparisons and sorting, because it takes a bunch of performance-related shortcuts.

On modern servers, this performance boost will be all but negligible. It was devised in a time when servers had a tiny fraction of the CPU performance of today's computers.

utf8mb4_unicode_ci, which uses the Unicode rules for sorting and comparison, employs a fairly complex algorithm for correct sorting in a wide range of languages and when using a wide range of special characters. These rules need to take into account language-specific conventions; not everybody sorts their characters in what we would call 'alphabetical order'.

This is probably Postgres specific (kudos for running Joomla on it) at this line: github.com/joomlaworks/allvideos/blob/master/plugin/jw_allvideos/includes/elements/template.php#L24

If you're familiar with Postgres-specific SQL notation, you can adapt that line and send it back to us to merge into the plugin. A quick search revealed these solutions: stackoverflow.com/questions/5111338/error-operator-does-not-exist-character-varying-integer

i just installed all videos on a joomla site i administer, and i get an error when i try to bring up the settings panel from the plugins manager, and the {youtube} tags are not being processed in the articles.

"ERROR: operator does not exist: character varying = integer LINE 1: ... FROM vv2su_template_styles WHERE client_id = 0 AND home = 1 ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts."

my joomla version is 3.9.2; my plugins all appear to be up to date. the database is PostgreSQL 9.4, php is a trifle old at 5.4.45, host OS is centos 6 linux.

please advise on how to address this.

thanks,
richard

When trying to order the News in the News order field there was not possible to select an option.

Client Side JS throws this error: Uncaught TypeError: JSON.decode is not a function
at HTMLDivElement.<anonymous> (class.datasources.js:20)

There is no such function as JSON.decode instead use JSON.parse.
Please fix it in the next release.

Although when i try to change the News sort order from ASC to DESC or the other way than the complete Website crashes.
It is because the News order field was empty and there is no valid table to sort.
Server Side should never depend on Client Side, instead use some validation if everything is right during data saving.
MySQL Error "ORDER BY contact. DESC" No valid table found.

The problem was in this file /modules/mod_news_pro_gk5/data_sources/com_k2/module.php
Line 207

And i solve it so

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,