Error DB Query

Phoca Gallery - image gallery extension
mbogeholm
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 18 Sep 2016, 23:24

Error DB Query

Post by mbogeholm »

Hi,

I have upgraded from J2.5.x with Phoca gallery 3.2.8 to Joomla 3.6.2 and Phoca Gallery 4.3.0 (did not upgrade to 4.3.1 yet)

I have created table 'mmktr_phocagallery_styles' which were missing (https://www.phoca.cz/documents/2-phoca-g ... em-solving) and the records ('insert into' from install.utf8.sql)

I get following errors:

Frontend Menu:
Phoca Gallery » List Of Categories (Categories View) » List Of Categories (Categories View)

Result:
1146 - Table ‘<db_name>.#__phocagallery_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM #__phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

Backend:
In the Components - Phoca Gallery - Styles:

Result:
Table '<db_name>.#__phocagallery_styles' doesn't exist SQL=SELECT a.id, a.filename, a.type FROM #__phocagallery_styles AS a

But I expected <db_name>.mmktr_phocagallery_styles
Since my prefix is ‘mmktr'!

What did I miss? Kindly advice, thank you

NB:
<db_name> is replacing my real database name
Last edited by mbogeholm on 19 Sep 2016, 12:03, edited 1 time in total.

Tags:
mbogeholm
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 18 Sep 2016, 23:24

Re: Error DB Query

Post by mbogeholm »

Sorry, I found a typo in command creating mmktr_phocagallery_styles. After correctly creating the table, problem solved
christine
Phoca Hero
Phoca Hero
Posts: 2737
Joined: 28 Nov 2010, 17:20

Re: Solved: Error DB Query

Post by christine »

Thank you for your information!

Kind regards, Christine
Post Reply