Error 1054

[RRanch]

I am upgrading my website from Joomla 1.5 to 3.4.1. I am using a subfolder to test and upgrade so nothing is disturbed for my visitors.

I installed Phoca Gallery in the new site and when I click on categories, this error message appears. Can you tell me how to fix it?

An error has occurred.
1054 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `gt5ki_phocagallery_categories` AS a LEFT JOIN `gt5ki_languages` AS l ON l.lang_code = a.language LEFT JOIN gt5ki_users AS uc ON uc.id=a.checked_out LEFT JOIN gt5ki_viewlevels AS ag ON ag.id = a.access LEFT JOIN gt5ki_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN gt5ki_users AS ua ON ua.id = a.owner_id LEFT JOIN gt5ki_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM gt5ki_phocagallery_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Also, no images show up in the images panel, even though I have copied all the images to the new subfolder.

[Jan]

Hi, there, some columns are missing:

- you should migrate from 1.5 to 2.5:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

- and then from 2.5 to 3:
https://www.phoca.cz/documents/50-phoca/ ... o-joomla-3
Jan

[RRanch]

Uggghhh!

Ok, thanks. I will try it.