Benno wrote: ↑27 Sep 2024, 12:17
I'm reading this for the first time. How did you carry out the import?
Hello Benno,
I went back to my first post and I must apologize, I thought I had written this, apparently not. very sorry.
Here is how I made the migration of the pictures (I write that based on my notes):
1) In Phoca Gallery, I created a ROOT folder
2) With FTP, I copied the pictures from joomgallery/originals folder to phocagallery/root
3) I run 2 SQL quieries (found on this page:
https://magazine.joomla.org/all-issues/ ... y-to-phoca
4) First query for category data:
Code: Select all
Insert into `xcfy2_phocagallery_categories` (id, parent_id, owner_id, title, alias, published, userfolder) select cid, parent_id, owner, name, alias, published, catpath from `xcfy2_joomgallery_catg`
5) Second query for image data
Code: Select all
Insert into `xcfy2_phocagallery` (id, catid, title, alias, filename, date, published, approved, hits) select id, catid, imgtitle, alias, imgfilename, imgdate, published, approved, hits from `xcfy2_joomgallery`
6) I made an additional operation to change the source path of pictures in the phocagallery database so pictures can be found by phoca.
7) Then I could go to Phoca Images and the thumbnails started to be generated .
8) All images are now visible in Phoca image
Thank you for your help
Patrice