hey! great news! that means i do not have to hack the header sections back into joomla any more!
Hello Acrylian,
i don't know if zenpage is released now also, but i have downloaded newest SVN version and installed it into 1.2.1 release. Everything works fine, except of CombiNews. When I enable this option and open gallery an SQL error appears:
[b]
Zenphoto Error
MySQL Query ( (SELECT date, id, title, content, codeblock, titlelink, author FROM zp_zenpage_news ORDER BY date) UNION (SELECT images.date, images.id, images.title, images.desc, albums.folder, images.filename, albums.title FROM zp_images AS images, zp_albums AS albums WHERE albums.id = images.albumid ORDER BY images.mtime) ORDER By date DESC LIMIT 0,10 ) failed. Error: Illegal mix of collations for operation 'UNION'
[/b]
My config:
MySQL 5.0.45
Collation: utf8_unicode_ci
Thanks for great work on zenpage.
Actually I just released it...:-)
Thanks for the report. As the error says your tables have probably a different collation. That might be because of older zenphoto tables that are somehow different than the new ones zenpage created. Did you check that via phpmyadmin?
I did not encounter this in all the test though. Of course I will try to look into it.
Hello,
you are right about that I have different collations in my tables. At first look everything seem to be allright and set to utf8_unicode_ci on all tables. But when I look at rows for example in zp_images then I see that each row is set to utf8_general_ci... Now I don't know how to set collation to utf8_unicode_ci on all rows in DB, or table. Can you help me with this ?
Thanks