How can I replace source thumb url with an mysql query?
I originally imported thumbs from xhamster at 240x180. Now I've changed to a bigger thumb size on my site.
The xhamster source thumb url is of the smaller 240x180 thumb. If I regrab galleries from this thumb in tcms the crop profile makes it bigger to my new thumb size, but the quality looks awful and the proportions are off.
I need to regrab galleries from the bigger original xhamster url, but before I can do that I need to replace the source thumb url and tcms doesn't let me do that in mass edit.
I already have an export dump of all the gallery urls I want to update along with the new thumb source url next to it, how can I run this in mysql to replace the source thumb for the galleries?
Replace source thumb for galleries
Re: Replace source thumb for galleries
You have to unserialize data from gallery_content column
Probably you can do it with mysqll procedure but I don't have a ready-made one
Probably you can do it with mysqll procedure but I don't have a ready-made one
Don't forget to run script update