Problem after Update to Phoca gallery 2.1.0

[kessi54]

After Update to 2.1.0 the categories are disappeared. If I want to create a new category with the same name the dissapeared category had, I get an error: "Error Saving Phoca Gallery Categories".
What can I do?
Regards
kessi54

[caro84g]

Hi,

check if 6 tables with prefix_phocagallery_something are in the database...

If not, see: https://www.phoca.cz/documents/2-phoca-g ... ca-gallery
(the part about 'updating the MySQL database..')

Regards, Carolien

[kessi54]

Hi Carolien,
What I found when I followed your link seems to be exactly the right thing to solve my problem. But is there anybody who can explain me in German what exactly I have to do because I never before manupulated my database.
Here is what I have to do:

Updating the MySql database after a manual upgrade from Phoca Gallery 1.x.x to 2.x.x

If you upgrade PhocaGallery manually, there is an issue with the MySQL database if upgrading from PhocaGallery 1.x.x. to PhocaGallery 2.x.x. PhocaGallery 1.x.x has 2 tables in the MySQL database and PhocaGallery 2.x.x has 6 tables.

You must run SQL queries of tables which don't currently exist in the database. The automatic upgrade script knows that it should add only the new 4 tables... but if you got an error while upgrading, or you choose to upgrade manually you will have to run the SQL query manually.

You should use install.bak file, but here there are SQL queries for all 6 tables, so you must run only SQL queries for the 4 new tables (tables which are not already created in your database), not all 6 tables, because if you add the first 2 tables (phoca gallery, phoca gallery categories) then these existing tables will be overwritten (and all data will be removed)

You will find the install.sql (install.bak) file in the Phoca Gallery component ZIP package. Just copy the SQL queries of the 4 new tables and run them in e.g. phpMyAdmin. But beware, because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you must rename them:

* #__phocagallery to TablePrefix_phocagallery
* #__phocagallery_categories to TablePrefix_phocagallery_categories

TablePrefix is the prefix you selected while installing Joomla! 1.5 (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore}

Best regards
Klemens

[Jan]

try to see it with google translator:

https://www.phoca.cz/documents/2-phoca-g ... ry-via-ftp

(use the google translator in the top of the site)

http://66.102.9.104/translate_c?hl=en&l ... eYfZ7US-gA

[kessi54]

Hi Carolien,
I solved my problem by following the instructions of your link, thank you very much.
@Jan: thank you for your help but the google translator is very bad, what it does has nothing to do with German language. I looked for some words at leo.org and for the future it seems to be better to improve my English.
Best regards and Merry Christmas
Klemens

[Jan]

[kessi54]

Hi Jan,
your link doesn`t function.
MfG
Klemens

[Jan]

??? I have no problems with the links

site.png