[resolved] Problems with various features of Gallery MySQL
Posted: 18 Jun 2011, 03:35
I have several issues after installing Phoca Gallery, mySQL or script errors in various parts of the admin back-end.
The 'Facebook' option gives me this error (and more):
Table 'andrewsh_AndrewHP.jos_phocagallery_fb_users' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocagallery_fb_users` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc
The first error that says the db table doesn't exist is weird. IS there are a plug in required for the Facebook option? Something else that creates the required tables in the database?
I tried also installing the Facebook comments module, but this doesn't fix the above problem(s).
Thanks
I managed to solve this issue - by installing the SQL tables which didn't get installed in the initial installation of the component. Using the install.bak.sql file in the ZIP folder of the component download
The 'Facebook' option gives me this error (and more):
Table 'andrewsh_AndrewHP.jos_phocagallery_fb_users' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `jos_phocagallery_fb_users` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc
The first error that says the db table doesn't exist is weird. IS there are a plug in required for the Facebook option? Something else that creates the required tables in the database?
I tried also installing the Facebook comments module, but this doesn't fix the above problem(s).
Thanks
I managed to solve this issue - by installing the SQL tables which didn't get installed in the initial installation of the component. Using the install.bak.sql file in the ZIP folder of the component download
