I migrated all k2 content from one site (J1.5/k2ver2.5.7) to another (J2.5.7/k2ver2.5.7) by copying all tables from one database to another and replacing the respectives suffixes. I also updated the 'created_by' field. Content is present as expected but when usign k2 tools to display a tag cloud it displays nothing and yes, tags are correctly assigned.

By turning on debugging, I got the following message:

JDatabaseMySQL::query: 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 tag.published = 1' at line 4 SQL=SELECT tag.name, tag.id FROM qckil_k2_tags as tag LEFT JOIN qckil_k2_tags_xref AS xref ON xref.tagID = tag.id WHERE xref.itemID IN () AND tag.published = 1

My site info is as follows:

Web Server Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP version 5.2.17
MySQL version 5.1.52-cll
GD image library bundled (2.0.34 compatible)
Multibyte string support Enabled
Upload limit 25M
Memory limit 75M
Open remote files (allow url fopen) Yes

Thanks in advance,

Hi. Since you make the transtion by your own, it may be anything that is causing this. Make sure that you do have items and that the language field in the database is not empty. You need to ensure that both for #__k2_items and #__k2_categories tables. In case the field is empty you should add the asterisk value ('*') .

Thanks for your prompt answer,

I added the asterisk to language field in all rows at items/categories tables as told me to do. Still no results.

I'm attaching the k2 tables of my site.

Greetings,

Try to open K2 parameters and hit save. Do the same for the settings of the module. Also you need to change the access field. The default value in Joomla! 1.5 was 0 while in Joomla! 2.5 is 1.