upgrade old tables from 2.8 to 3.0.2 with SQL command

[anca]

I migrated the J1.5.23 to J1.7.0 and I installed on the new J1.7 the phoca gallery 3.0.2. I would like to export the content of the old databeses jos_phocagallery .... and import it to j17_phocagallery .....
Have you a SQL command for upgrade the old phoca gallery db (2.8.0) to update the version (3.0.2)?

[anca]

I have found a way for the import to the PhocaGallery 3.0.2
All categories and pictures are visible on the backend. On the frontend I can see the Thumbnail-Picture but if I click on it I get this error:

404 - PHOCAGALLERY_CATEGORY_IS_UNPUBLISHED

I published and authorized all categories but the error remain.

[Jan]

Hi, which view is this - in categories or category view? In category view, this is displayed in case, the selected category is unpublished - there is no other if clause - only if this is unpublished ...

[anca]

I think I found the problem. It's my fault. I migrated from 1.5 to 1.7 with jupgrade and now I prepare the 1.7 homepage before I copy the \jupgrade-Directory to the directory where is installed the active homepage. With jupgrade only the directory structure from the phoca image directory was created under the directory \jupgrade and not moved all the pictures. I think if I'm ready with the new template and the 1.7 site I move the \jupgrade files (new site under 1.7) to the original homepage directory and all will work fine.

Thank you for your support!

[Jan]

Ok