It depends, especially if you have other plugins extending K2's queries (which is possible).

If you can get me a detailed error log and given it's indeed a K2 issue (and not related to some 3rd party plugin), I'll fix it on the spot.

Hi! I have been using K2 (Version 2.10.3) on an old Joomla 3.9.24. I have recently upgraded the server (Microsoft-IIS/8.5) to PHP 7.4.7 and MySQL 8.0.23.

Although Joomla works ok, it seems that I can't post new K2 items since (MySQL "syntax 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").

My question is, is there any workaround, or should I downgrade MySQL?

Thanks in advance

Hi,
I need help with K2 User Login and Logout functionality. Actually, my customer wants to have, for their staff, a login via Frontend like on the old website.
Sometimes, I can log-in, but not logout. I tried to set many many different login module settings, settings for the user, etc, but not successful:

Warnung

The security token did not match. The request was aborted to prevent any security breach. Please try again.

I use last Joomla installation 3.9.23, and all plugins are updated to the last version.
Here is my FPA:
Forum Post Assistant (v1.6.2) : 4-Dec-2020 wrote:
Basic Environment :: wrote:
Joomla! Instance :: Joomla! 3.9.23-Stable (Amani) 24-November-2020
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: none | Shared sessions: false | SSL: 0 | Error Reporting: none | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.23: Yes | Database Supports J! 3.9.23: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-1127.19.1.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br | System TMP Writable: Yes | Free Disk Space : 634.49 GiB |

PHP Configuration :: Version: 7.4.13 | PHP API: fpm-fcgi | Session Path Writable: Yes | Display Errors: | Error Reporting: 22527 | Log Errors To: | Last Known Error: | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: on | Open Base: | Uploads: 1 | Max. Upload Size: 50M | Max. POST Size: 75M | Max. Input Time: 60 | Max. Execution Time: 60 | Memory Limit: 256M

Database Configuration :: Version: 10.4.15-MariaDB (Client:mysqlnd 7.4.13) | Database Size: 20.54 MiB | #of Tables with config prefix: 205 | #of other Tables: 0 | User Privileges : GRANT ALL
Detailed Environment :: wrote:
PHP Extensions :: Core (7.4.13) | date (7.4.13) | libxml (7.4.13) | openssl (7.4.13) | pcre (7.4.13) | zlib (7.4.13) | filter (7.4.13) | hash (7.4.13) | Reflection (7.4.13) | SPL (7.4.13) | session (7.4.13) | standard (7.4.13) | cgi-fcgi (7.4.13) | bcmath (7.4.13) | bz2 (7.4.13) | calendar (7.4.13) | ctype (7.4.13) | curl (7.4.13) | dba (7.4.13) | dom (20031129) | mbstring (7.4.13) | fileinfo (7.4.13) | ftp (7.4.13) | gd (7.4.13) | gettext (7.4.13) | gmp (7.4.13) | iconv (7.4.13) | imap (7.4.13) | intl (7.4.13) | json (7.4.13) | ldap (7.4.13) | exif (7.4.13) | mysqlnd (mysqlnd 7.4.13) | PDO (7.4.13) | pgsql (7.4.13) | Phar (7.4.13) | posix (7.4.13) | shmop (7.4.13) | SimpleXML (7.4.13) | soap (7.4.13) | sockets (7.4.13) | sodium (7.4.13) | sqlite3 (7.4.13) | sysvmsg (7.4.13) | sysvsem (7.4.13) | sysvshm (7.4.13) | tokenizer (7.4.13) | xml (7.4.13) | xmlwriter (7.4.13) | xsl (7.4.13) | mcrypt (1.0.3) | mysqli (7.4.13) | pdo_mysql (7.4.13) | pdo_pgsql (7.4.13) | pdo_sqlite (7.4.13) | xmlreader (7.4.13) | xmlrpc (7.4.13) | apcu (5.1.19) | brotli (0.11.1) | imagick (3.4.4) | mailparse (3.1.1) | ssh2 (1.2) | zip (1.19.2) | ionCube Loader (10.4.5) | Zend OPcache (7.4.13) | Zend Engine (3.4.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No
Folder Permissions :: wrote:
Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (750) |

Elevated Permissions (First 10) ::
Database Information :: wrote:
Database statistics :: Uptime: 242285 | Threads: 33 | Questions: 58181121 | Slow queries: 3138261 | Opens: 254823 | Flush tables: 1 | Open tables: 400 | Queries per second avg: 240.135 |
Extensions Discovered :: wrote:
Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party::

Components :: Admin ::
Core :: com_associations (3.7.0) 1 | com_plugins (3.0.0) 1 | com_checkin (3.0.0) 1 | com_tags (3.1.0) 1 | com_banners (3.0.0) 0 | com_ajax (3.2.0) 1 | com_cpanel (3.0.0) 1 | com_postinstall (3.2.0) 1 | com_content (3.0.0) 1 | com_users (3.0.0) 1 | com_messages (3.0.0) 1 | com_templates (3.0.0) 1 | com_admin (3.0.0) 1 | com_redirect (3.0.0) 1 | com_search (3.0.0) 1 | com_privacy (3.9.0) 1 | com_cache (3.0.0) 1 | com_menus (3.0.0) 1 | com_languages (3.0.0) 1 | com_finder (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_fields (3.7.0) 1 | com_installer (3.0.0) 1 | com_media (3.0.0) 1 | com_newsfeeds (3.0.0) 0 | com_config (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_login (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_categories (3.0.0) 1 | com_modules (3.0.0) 1 |
3rd Party:: Smart Slider 3 (3.4.1.14) 1 | FlexiContact (12.11.01) 1 | COM_K2 (2.10.3) 1 | Akeeba (7.4.0.1) 1 | com_uniterevolution2 (4.6.5 b1) 1 | com_mobilemenuck (1.2.7) 1 | System - Mobile Menu CK (1.2.7) 1 |

Modules :: Site ::
Core :: mod_articles_categories (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_banners (3.0.0) 0 | mod_menu (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_users_latest (3.0.0) 1 | mod_login (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_search (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_feed (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_syndicate (3.0.0) 1 |
3rd Party:: K2 Content (2.10.3) 1 | JF Mobile Menu (1.3) 1 | Unite Revolution Slider 2 (4.6.5 b1) 1 | K2 User (2.10.3) 1 | sigplus (1.5.0.284) 1 | K2 Comments (2.10.3) 1 | News Show Pro GK5 (2.0.1) 1 | K2 Tools (2.10.3) 1 | K2 Users (2.10.3) 1 | Smart Slider 3 Module (3.4.1.14) 1 |

Modules :: Admin ::
Core :: mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_status (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_title (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_quickicon (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_version (3.0.0) 1 | mod_login (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_feed (3.0.0) 1 |
3rd Party:: K2 Quick Icons (admin) (2.10.3) 1 | K2 Stats (admin) (2.10.3) 1 |

Libraries ::
Core ::
3rd Party:: file_fof30 (3.7.0) ? |

Plugins ::
Core :: PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_webinstaller (2.1.2) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_user_profile (3.0.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_joomla (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_pagebreak (3.0.0) 1 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_redirect (3.0.0) 0 | plg_system_fields (3.7.0) 1 | plg_system_updatenotification (3.5.0) 0 | plg_system_logrotation (3.9.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_remember (3.0.0) 1 | plg_system_sef (3.0.0) 1 | plg_system_log (3.0.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_privacyconsent (3.9.0) 0 | plg_system_cache (3.0.0) 0 | plg_system_debug (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_p3p (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_cookie (3.0.0) 0 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_tags (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 |
3rd Party:: plg_editors_tinymce (4.5.12) 1 | plg_editors_codemirror (5.56.0) 0 | Smart Slider 3 Updater Plugin (3.4.1.14) 1 | Josetta - K2 Items (2.6.9) 1 | Josetta - K2 Categories (2.6.9) 1 | PLG_ACTIONLOG_AKEEBABACKUP (7.4.0.1) 0 | User - K2 (2.10.3) 1 | User - Profile - SecSignID (1.4.1) 0 | plg_content_sigplus (1.5.0.284) 1 | PLG_SYSTEM_BACKUPONUPDATE (7.4.0.1) 0 | System - Add Print Stylesheet (1.1) 0 | System - K2 (2.10.3) 1 | System - Mobile Menu CK (1.2.7) 1 | Smart Slider 3 System Plugin (3.4.1.14) 1 | Consent Manager CMP (consentmanager (1.0.0) ? | plg_finder_k2 (2.10.3) 0 | plg_quickicon_akeebabackup (7.4.0.1) 1 | Search - K2 (2.10.3) 1 | plg_search_sigplus (1.5.0.284) 1 | plg_editors-xtd_sigplus (1.5.0.284) 1 |
Templates Discovered :: wrote:
Templates :: Site :: jpss (1.0) 1 | protostar (1.0) 1 | buckle (2.2.3) 1 | beez3 (3.1.0) 1 |
Templates :: Admin :: wisadmin (1.1) 1 | hathor (3.0.0) 1 | isis (1.0) 1 |

Pass along the SQL error to your hosting company so they can adjust the server's my.cnf configuration accordingly (they probably need to enable innodb_large_prefix).

I get "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 'LIMIT 1' at line 1" every time i try to create or edit a catalog in my k2. items works fine, any sugestions ?

a) What's your MySQL version?
b) Are you using any third-party extensions with K2? E.g. some multi-categorization extension for K2?

Hello fotis

I try to use again this component after 8 day again the same. in data base i take this error mesage

/libraries/classes/Dbi/DbiMysqli.php#199: mysqli->query(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
integer 0,
)
./libraries/classes/DatabaseInterface.php#316: PhpMyAdmin\Dbi\DbiMysqli->realQuery(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
,
integer 1,
)
./libraries/classes/DatabaseInterface.php#1698: PhpMyAdmin\DatabaseInterface->tryQuery(
string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`',
integer 256,
integer 1,
boolean false,
)
./libraries/classes/Table.php#766: PhpMyAdmin\DatabaseInterface->fetchValue(string 'SELECT COUNT(*) FROM `mydatabase`.`kos_k2_items`')
./libraries/classes/Controllers/Database/StructureController.php#1065: PhpMyAdmin\Table->countRecords(boolean true)
./libraries/classes/Controllers/Database/StructureController.php#931: PhpMyAdmin\Controllers\Database\StructureController->getValuesForInnodbTable(
array,
integer 92845121,
)
./libraries/classes/Controllers/Database/StructureController.php#381: PhpMyAdmin\Controllers\Database\StructureController->getStuffForEngineTypeTable(
array,
integer 92845121,
integer 24,
)
./libraries/classes/Controllers/Database/StructureController.php#172: PhpMyAdmin\Controllers\Database\StructureController->displayTableList()
./db_structure.php#56: PhpMyAdmin\Controllers\Database\StructureController->index(array)
./index.php#101: include(./db_structure.php)

is this because the k2_item again deleteted?

Hello Guys,
I am having this error when trying to open K2 tag pages:
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 t.published = 1' at line 4

The error is intermittently and just occurs when use the browser in Incognito Mode. The problem is causing Google crawl problems affecting our SEO.
I have read the forum and checked similar issues, so I have disabled some plugins and modules, but the problem still continue.

Any idea?
Thanks.

Hi all, hope you are well and safe.

To cut a very long and probably quite boring story short, I've had to rebuild a Joomla site running under localhost (Xampp) after a hard disk failure. I'm having to do this because the site backup was corrupt (you can imagine what a happy day that was). I've created a new Joomla instance, and imported all the old tables as .sql files into it. No problem. All the data is there.

But I am left with an odd problem. Now, all the hyperlinks are invisible in the K2 items. Invisible until I hover my mouse over them, when they magically appear, yet when I do that they are showing as plain text (although they do actually work as hyperlinks). Oh, this applies to K2 Category titles as well. They are similarly invisible until I hover over them.

I am assuming this is an issue with css somewhere - either K2.css, or possibly the template .css, but I cannot see where the error is. Would any of you kind people have an idea what has gone wrong and how it can be fixed? Sadly I cannot give you a URL to investigate as it's running on a local server. I'm using Favthemes' Favourite template, if that helps.

I should be very grateful for any help with this problem as this website represents three years' work and I obviously want to get it running again!

Many thanks !

Andy.

Perhaps your server is overloaded and the SQL query that is executed to delete these comments never finishes, thus the error.

This is most likely to happen on shared hosting environments.

For now, I would recommend disabling (or protecting) comments. If the spam comments are unpublished, you can just delete them all in one go with "delete all unpublished comments" (top right in the Comments admin page).

Hi All,
I'm slowly learning how to build a site with Joomla (just on my PC at the moment and I'll transfer it later on OVH to replace my old current B&B site).
I just bought Falang and after activating it, my site worked fine but when I activated all the Falang plugins I suddenly got a blank screen:
"An error has occured.
0 class 'K2Model'not found
Return to control panel"

I cannot return to the control panel! Nothing works! I cannot even log out! I only get this error message.

I've found on the net that I should maybe try this:
Use Phpmyadmin to disable the plugin in the #_extensions table. Change "enabled" 1/0
I have installed XAMPP on my PC and when I click on MySQL Admin I can get to phpMyAdmin but after that I don't know how to get to the #_extensions table ( or K2 for that matter?)

HELP please! I feel desperate. I've spend weeks on creating this new site....
If you have the answer please give me step by step instructions as I'm far from being computer savvy!
Cheers,
Patrick

Dear Fotis

Thank you so much for your instruction. It all news for me, but I try to learn.
Now I know how to export and import sql database with alot of trouble!

I have created a new database and my current database. I could import the current database now.
There are a lot of K2 tables. I hope I could found every K2 related tables.


I dont want to lost everything again. So I decided to download the backup and the database on my harddisk.

I try with XAMPP first.
I have my full website data on host and a database created.

TROUBLE: I try under the configurate.php

public $list_limit = '20';
public $access = '1';
public $dbtype = 'mysqli';
public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'quangharvest28april2020';
public $dbprefix = 'dfaa_';
public $secret = '';
public $gzip = '1';
public $error_reporting = 'default';
public $helpurl = 'help.joomla.org/proxy?keyref=Help{major}{minor}:{keyref}&lang={langcode}';
public $ftp_host = '127.0.0.1';
public $ftp_port = '21';
public $ftp_enable = '0';
public $tmp_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/tmp';
public $log_path = 'G:/Alle Programme/xampp/htdocs/quangharvest/default-website/logs';

I GOT THIS WARNING:
Warning: session_start(): Failed to read session data: user (path: G:\Alle Programme\xampp\tmp) in G:\Alle Programme\xampp\htdocs\quangharvest\default-website\libraries\joomla\session\handler\native.php on line 260
Error: Failed to start application: Failed to start the session

I cant do anything more. I search a lot of support on google. But I nothing help.
Please tell me what to do.

I dont set any password on host phpMyAdmin. So I hope the username: root and pw: `"nothingspace" korrect?

A 500 error means the server is overloaded. Not because of your site but because of other sites on it.

If this happens regularly, you might want to consider changing hosts.

Updating to Joomla latest does not put additional load on the site, let alone when you're using K2 which is lighter in terms of SQL queries compared to Joomla articles. Overall the combo Joomla/K2 is far more performant than many other CMSs. I'm just referencing this in case they slap on the "Joomla is crap at performance, go with WordPress" motto. Which is an epic lie for the record...

Hallo,

I face an error after creating or modifying a category.

Is this a bug of 2.10.2?

Error:
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 'LIMIT 1' at line 1

Thank you

I would say the best one is from JoomReem: www.joomreem.com/extensions-store/jr-maps-for-k2

Fotis wrote: If this is a plugin for easily embedding maps, there are many alternatives out there.

i have searched a while but could not find any map except styleware to show a map of k2 articles with geo locations of a category and all subcategories and jump to article after clicking map-marker.
can you recommend a few to me?

None of the Styleware K2 extensions have been supported since 2016, including swmap. I used to have some of their extensions and have had to phase them out when the developers stopped communicating and bringing out updates. Up to then they were great, apart from SWtabs which was very buggy.

I have recently reported their extensions as abandonware so hopefully they will be taken off the Joomla site soon.

Try my suggestions. Enable them all EXCEPT redis, mongodb, newrelic, luasandbox, mysqli (that's correct, you use the newer module already which is mysqlnd), odbc.

If you get a specific conflict error, share it back with us and I'll tell you what to do.

I can only assume the plugin "swmap" is pretty outdated and won't work with the latest version of K2 or possibly your server's PHP if it's been upgraded. If this is a plugin for easily embedding maps, there are many alternatives out there. And even if you don't like one, you can always create a "textarea" type extra field and just embed maps as iframes.

dear team!

after i click on save-button while editing existing oder creating new k2-category i get the following error:

Es ist ein Fehler aufgetreten!

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 'LIMIT 1' at line 1
JROOT/libraries/joomla/database/driver/mysqli.php:665

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:665
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
3 JDatabaseDriver->loadResult() JROOT/plugins/k2/swmap/v2.php:121
4 plgK2swmap->prepareItem() JROOT/plugins/k2/swmap/base.php:343
5 SWMapsBase->onAfterK2Save() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
7 JEventDispatcher->trigger() JROOT/administrator/components/com_k2/models/category.php:138
8 K2ModelCategory->save() JROOT/administrator/components/com_k2/controllers/category.php:27
9 K2ControllerCategory->save() JROOT/administrator/components/com_k2/controllers/category.php:39
10 K2ControllerCategory->apply() JROOT/libraries/src/MVC/Controller/BaseController.php:710
11 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/administrator/components/com_k2/k2.php:147
12 require_once() JROOT/libraries/src/Component/ComponentHelper.php:402
13 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
14 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/AdministratorApplication.php:101
15 Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT/libraries/src/Application/AdministratorApplication.php:159
16 Joomla\CMS\Application\AdministratorApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
17 Joomla\CMS\Application\CMSApplication->execute() JROOT/administrator/index.php:51

a little digging resulted that in JROOT/plugins/k2/swmap/v2.php on line 120 where the following code is listed the $item->catid is empty:
$db->setQuery("SELECT alias FROM #__k2_categories WHERE id = {$item->catid} LIMIT 1");

this occures on joomla v3.9.15 with k2 in version 2.10.2, 2.10.1 and 2.10.0 but not on 2.9.0, in this version no error occures?

could you tell me if this bug is allready known and/or when it will be solved?

cheers daniel