I had permissions issues on the whole site's directory but before I realized that I ended up removing the com_phocagallery directory, now the permissions are fixed but after reinstalling the component I noticed some wild behavior, probably due to erasing the folder in such way:
Going to the user tab gives me a 500 error:
Then I noticed also that I couldn't create any category (pardon my French hereTable 'comet.comet_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM comet_phocagallery_user AS a LEFT JOIN comet_languages AS l ON l.lang_code = a.language LEFT JOIN comet_users AS ua ON ua.id=a.userid LEFT JOIN comet_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM comet_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM comet_phocagallery AS i LEFT JOIN comet_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN comet_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Table 'comet.comet_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM comet_phocagallery_user AS a LEFT JOIN comet_languages AS l ON l.lang_code = a.language LEFT JOIN comet_users AS ua ON ua.id=a.userid LEFT JOIN comet_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM comet_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM comet_phocagallery AS i LEFT JOIN comet_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN comet_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 20 Table 'comet.comet_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM comet_phocagallery_user AS a LEFT JOIN comet_languages AS l ON l.lang_code = a.language LEFT JOIN comet_users AS ua ON ua.id=a.userid LEFT JOIN comet_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM comet_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM comet_phocagallery AS i LEFT JOIN comet_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN comet_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc
):
I would greatly appreciate some expert's help to hurt my database in the safest way.L'enregistrement a échoué avec l'erreur suivante : Category must have title
Thanks a bunch.
