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
Error DB Query
-
- Phoca Newbie
- Posts: 2
- Joined: 18 Sep 2016, 23:24
-
- Phoca Newbie
- Posts: 2
- Joined: 18 Sep 2016, 23:24
Re: Error DB Query
Sorry, I found a typo in command creating mmktr_phocagallery_styles. After correctly creating the table, problem solved
-
- Phoca Hero
- Posts: 2819
- Joined: 28 Nov 2010, 17:20
Re: Solved: Error DB Query
Thank you for your information!
Kind regards, Christine
Kind regards, Christine