Page 1 of 1

gallery style db error

Posted: 17 Dec 2017, 23:00
by coldclimber
I have been through the forums and manually added the style table as described
but phoca gallery is looking for #__phocagallery_styles

and not my table lk4yc__phocagallery_styles

#__phocagallery_styles' doesn't exist SQL=SELECT a.id, a.filename, a.type FROM #__phocagallery_styles AS a

any help to make phoca look for my table and not #

Re: gallery style db error

Posted: 18 Dec 2017, 00:43
by Jan
Hi, SQL queries are prepared by Joomla! and Joomla! transforms #__ to your prefix.

I think, you should change
FROM:

Code: Select all

lk4yc__phocagallery_styles
TO:

Code: Select all

lk4yc_phocagallery_styles
(only one underscore - just check other tables in your database)

Jan