error by edit images with backend phoca Gallery

[igonasu]

Hi!
joomla version: Joomla 1.7.3
Phoca Gallery 3.1.5

I just download thr phoca Gallery. I had to create the sql tables manually with your povided script.
I have now able to create a new gallery in a new category (provence-2011).
Now i wanted to modify the titel of each images but i cannot save the changes!
The following error is diaplayed instead of a button to submit:

Fatal error: Call to undefined method JFormFieldPhocaTags::setError() in /var/www/vhosts/dehedin.ch/httpdocs/dehjla173de/administrator/components/com_phocagallery/libraries/phocagallery/tag/tag.php on line 94
have you a idee what is wrong?
Thanks
igonasu

[Jan]

Hi, I fill fix the displaying of the error in next release.

Enable debug mode to see which error you get from database, seems like the tags table or column is missing


Jan

[Prepper]

Hi,
i´ve the same Problem, but Joomla 2.5.1
Phoca Gallery, Plugin, etc. : newest Version from your Downloads.

When i want to edit a Photo (Text, description etc.),
the following window is without any CSS-Styles an i got this Message:
COM_PHOCAGALLERY_FIELD_TAGS_LABEL
Database Error: Getting Selected Tags - Check "#__phocagallery_tags" or "#__phocagallery_tags_ref" table in your database.

Fatal error: Call to undefined method JFormFieldPhocaTags::setError() in /www/htdocs/xxxxxxx/xxxxx/administrator/components/com_phocagallery/libraries/phocagallery/tag/tag.php on line 94

There are no Buttons to save, cancel etc... nothing. only the fields.

And:
When i call the control-center, all Headlines are formattet (css?) but "COM_PHOCAGALLERY_TAGS" not.
When i click the link, i got this message:
Joomla!
500 - Es ist ein Fehler aufgetreten

Table 'd010189a.jos_phocagallery_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocagallery_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Table 'd010189a.jos_phocagallery_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocagallery_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc Table 'd010189a.jos_phocagallery_tags' doesn't exist SQL=SELECT a.*,uc.name AS editor FROM `jos_phocagallery_tags` AS a LEFT JOIN jos_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc

[Jan]

Hi,


Table 'd010189a.jos_phocagallery_tags' doesn't exist SQL ... means, that in your databse, some tables are missing, see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[Prepper]

Hi Jan,
first thanks for your fast reply!

On my Joomla-Installation (2.5.1) there was no way to add the lost Tables like the linked ways.
After some tricky trials, i added the lost tables..but it does not work...
A new Installation of phoca (repair,update) also does not work.
I read the forum comments an the documents to solve such problems...but no effect

Now, i solved the Problem in this way (hope it helps others):

1. I created a Database-Backup (SQL-Dumper)
2. I looked with mysqladmin at the existing Database and noticed all existing Tables with "phoca".
3. I deinstalled all Phoca Gallery Components, Plugins, etc.
4. I made a completely new and clean Install of newest Phoca-Gallery.
!!! After Activation all my Pictures, Descriptions, Comments lost !!! but:
5. Now, i looked again with mysqladmin at the "new" Database and noticed all existing Tables with "phoca".
6. I compared the table-entries of the old Database with the new one and noticed the distinctions as related to "phoca" entries. This difference are only a few Tables( for example *phocagallery_tags remember all this tables!!!).
7. At the last, i recovered all Database-Entries (select only the content of related tables with "phoca") by Sql-Dumper without the few Tables of Point 6.

The result:
Phoca-Gallery runs perfectly and with all Pictures, Descriptions, Folders, Comments...
And...that is important to me: adding, edition and managing the Pictures will work.

...a crazy way...perhaps.. but it works

[Jan]

Great it is working now.

Jan