Error Saving Phoca Gallery Categories

[Jan]

Did you read this:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[morten44]

Hi
Had the same problem.
First time i Installed Phoca Gallery and it worked (Joomla 1.5.15 and Phoca 2.6.2)
After i installed the map plugin i started to get problems
I read one place to upgrade/unistall and install Phoca Gallary again and it would work.

It only made it worse

I localised the install.bak file in \Joomlaroot\administrator\components\com_phocagallery

I copied all content to the install.sql

In the phocagallery and phocagallery_categories tables I added the 2 lines anywhere:
`metakey` text,
`metadesc` text,

I then corrected the create table names from
#__phocagallery_categories to jos_phocagallery_categories (jos is my prefix. remember to remove 1 underscore)
#__phocagallery to jos_phocagallery (jos is my prefix. remember to remove 1 underscore)


When i now run the install.sql the tables where recreated and new one made
This resolved it for me

Regards
Morten

[Jan]

Ok

[efiminzer]

Hi

I'm getting an error message too, only mine is -

JDatabaseMySQL::query: 1146 - Table 'fwebcoil_jml3.jos_phocagallery_categories' doesn't exist SQL=SELECT a.*, cc.title AS parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid FROM jos_phocagallery_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.parent_id = c.parent_id ORDER BY a.ordering

I've built the tables in my database, but i'm stuck here! What should I do? Please help...

[Jan]

Hi, the "jos_phocagallery_categories" table still does not exist in your db, so it needs to be added with help of sql query.

https://www.phoca.cz/documents/16-joomla ... ent-errors

Jan