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,
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,