4.0.0 SQL errors

[porwig]

Hi,

I installed Phoca Gallery 4.0.0 on a Joomla 3.0.3 site. I am seeing SQL errors on almost all of the Phoca Gallery Control Panel links. For example, for the Images link, this is what I see:

0 SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg FROM `b6ge3_phocagallery` AS a LEFT JOIN `b6ge3_languages` AS l ON l.lang_code = a.language LEFT JOIN b6ge3_users AS uc ON uc.id=a.checked_out LEFT JOIN b6ge3_users AS uua ON uua.id=a.userid LEFT JOIN b6ge3_phocagallery_categories AS c ON c.id = a.catid LEFT JOIN b6ge3_users AS ua ON ua.id = c.owner_id LEFT JOIN b6ge3_phocagallery_img_votes_statistics AS v ON v.imgid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Thanks for any suggestions and help, and thanks for creating and sharing this great component!

Best regards,

paul

[Jan]

Hi, hmm, I see no error in the sql, do you get the same problem on updated Joomla! (3.1.x)?

Jan

[pepiczek]

Hi Jan,
i have the same problem with SQL errors.

- Joomla 3.1.1
- Phoca Gallery 4.0.0

I don't know what's wrong.

[otoold]

Same problem here with all attempted links on the panel
-click image link
Error
SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc

[Jan]

Hi, I have tested all the queries in a test page, in Joomla! site and in phpMyAdmin and they are correct. Try to check (e.g. in your phpMyAdmin) if all Phoca Gallery tables are included in your database and if your database version meets Joomla! 3 requiremets

Code: Select all

SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc 

... OK

Code: Select all

SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 

... OK

Code: Select all

SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,i.title AS image_title, i.id AS image_id,c.title AS category_title, c.id AS category_id FROM `jos_phocagallery_img_votes` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_phocagallery AS i ON i.id = a.imgid LEFT JOIN jos_phocagallery_categories AS c ON c.id = i.catid GROUP BY a.id ORDER BY uc.username asc

... OK

[pepiczek]

Hi Jan,
I tried these SQL queries directly in phpMyAdmin. They generated SQL error:

Code: Select all

#1267 - Illegal mix of collations (utf8_slovak_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

I thing, Porwig, Otoold and probably some others with non english sites have problems with collation too.

Can you help us?
Thank you.

[porwig]

Hi Jan,

I checked with phpMyAdmin and no database tables were created for Phoca Gallery. I tried to uninstall but the Joomla Extension Manager said it didn't exist. So I downloaded a fresh version. It seemed to install okay but I had the same SQL errors and there are still no Phoca db tables.

Then I tried installing Phoca Gallery on localhost and it seems to work fine.

The first site I tried to install Phoca on (the one with problems) is on a shared server from HostGator. I haven't had any problems installing other extensions on it.

Do you have any suggestions for what I should try?

Thanks,

paul

[Jan]

Hi, no because all the installation is done by Joomla! itself, it copies the files and it manages the installation XML (it is standard installation XML like any other extensions) - Try to ask your webhosting, maybe there is no memory to upload large extension, maybe another problem - try to see:

https://www.phoca.cz/phocagallery/16-joo ... m-manually

and try to remove all the extension parts so there will be no conflict for new install and then try to reinstall.

Jan

[porwig]

I noticed Phoca Gallery shown in the Discover feature of the Joomla 3 Extension Manager. So I tried installing it from there and it appears to have worked.

Thanks for the help here for this issue!

[Jan]

OK