[resolved] Problems with various features of Gallery MySQL

Phoca Gallery - image gallery extension
AMurray
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 18 Jun 2011, 02:51

[resolved] Problems with various features of Gallery MySQL

Post by AMurray »

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
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9984
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: [resolved] Problems with various features of Gallery MyS

Post by Benno »

Well done! :twisted:
Solved

Kind regards,
Benno
Post Reply