error messages after installing Phoca gallery

Phoca Gallery - image gallery extension
sony666
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 11 Apr 2016, 07:19

Re: error messages after installing Phoca gallery

Post by sony666 »

Hi
i have problem :x
my joomla is 2.8.28 and my phoca gallery is up date for this joomla

when i go to phoca gallery control panel and click on user or comment or anything display for me " error 500" :

able 'mahdnama_original.r3av8_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `r3av8_phocagallery_comments` AS a LEFT JOIN `r3av8_languages` AS l ON l.lang_code = a.language LEFT JOIN r3av8_users AS ua ON ua.id=a.userid LEFT JOIN r3av8_users AS uc ON uc.id=a.checked_out LEFT JOIN r3av8_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc Table 'mahdnama_original.r3av8_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `r3av8_phocagallery_comments` AS a LEFT JOIN `r3av8_languages` AS l ON l.lang_code = a.language LEFT JOIN r3av8_users AS ua ON ua.id=a.userid LEFT JOIN r3av8_users AS uc ON uc.id=a.checked_out LEFT JOIN r3av8_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc LIMIT 0, 20 Table 'mahdnama_original.r3av8_phocagallery_comments' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS commentuserid, ua.username AS commentusername, ua.name AS commentname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `r3av8_phocagallery_comments` AS a LEFT JOIN `r3av8_languages` AS l ON l.lang_code = a.language LEFT JOIN r3av8_users AS ua ON ua.id=a.userid LEFT JOIN r3av8_users AS uc ON uc.id=a.checked_out LEFT JOIN r3av8_phocagallery_categories AS c ON c.id = a.catid WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc"


please help me to solve this problem

note : the " mahdnama_original " is my name database
thanks
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: error messages after installing Phoca gallery

Post by Jan »

Hi, as the sql query message says, the phocagallery_comments table is missing in your database.

See the file:
administrator\components\com_phocagallery\install\sql\mysql\install.utf8.sql
There are instructions for adding the table to the database.
https://www.phoca.cz/documents/16-joomla ... ent-errors

Jan
If you find Phoca extensions useful, please support the project
Post Reply