Artalk
Artalk copied to clipboard
Modify the Permalink of specified comment or Merge multiple page comments
I'm synthesizing some of the articles on the site, some of the content is too outdated, so I've adjusted the permalinks accordingly.
/webinoly-mot-su-thay-hoan-hao-cho-easyengine/ -> /webinoly-lemp-stack-don-gian-manh-me/
At this time, old comments on Artalk will no longer appear
Is there any way to solve this?
PS: I temporarily handled it by downloading the database and replacing the old link with the new link
Then delete the database on Artalk and then re-upload the new database with the corrected link
apt-get install sqlite3
sqlite3 /root/docker/artalk/data/artalk.db "UPDATE comments SET page_key = REPLACE(page_key, 'old page', 'new page');"
Well, thank you, I did it more manually, but I think the command structure you gave exactly the problem I was having
I think the author should add more options in administration to make adjustments more intuitive