Hi,
From the Piwigo forum, I have learned how to handle a few special characters in my Gallery3 migration. However, the # character is still a problem for me in about 20 records of my Gallery3 database.
In my Gallery3 database, I have # characters in the name and title fields, %23 is substituted for the # characters in the relative_path_cache field, and - is substituted for the # characters in the relative_url_cache field.
My question is this: Which of those four Gallery3 database fields do I need to modify to ensure that the syncronisation step and the rest of the Menalto2Piwigo migration run correctly?
I assume that I need to get the # characters out of the name field. What about the title field?
Do I need to make any changes to the relative_path_cache and relative_path_cache fields, or will changing the content of those fields break links that are necessary for the migration to run properly?
Thank you for reading my post and for any advice that you can offer.
Piwigo 2.9.4
PHP: 5.4.45 (Show info) [2019-02-12 20:46:20]
MySQL: 5.6.41-84.1 [2019-02-12 20:46:20]
Piwigo URL: http://jeffersoncityjays1967.com/photos
Offline
Hello
you should search on the web with "MySQL Search and Replace Query "
Offline
Thank you for your suggestion, flop25.
I think I may not have expressed my problem clearly. I am familiar with the mechanics of changing the contents of the database.
I wanted to know whether the # character had to be removed from all fields in which it appeared, or only from the name field.
By experimentation, I have determined that removing the # character from the name field (and leaving it in other fields) is sufficient to make the migration work.
Offline
Oooh
Yes that's just the filename due to url encoding potential issues
Offline