gallery style db error

Phoca Gallery - image gallery extension
coldclimber
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 18 Dec 2013, 14:25

gallery style db error

Post 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 #
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49144
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: gallery style db error

Post 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
If you find Phoca extensions useful, please support the project
Post Reply