Page 1 of 1

Error DB Query

Posted: 18 Sep 2016, 23:52
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

Re: Error DB Query

Posted: 19 Sep 2016, 12:01
by mbogeholm
Sorry, I found a typo in command creating mmktr_phocagallery_styles. After correctly creating the table, problem solved

Re: Solved: Error DB Query

Posted: 19 Sep 2016, 12:38
by christine
Thank you for your information!

Kind regards, Christine