Artalk icon indicating copy to clipboard operation
Artalk copied to clipboard

Modify the Permalink of specified comment or Merge multiple page comments

Open bibicadotnet opened this issue 1 year ago • 2 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

bibicadotnet avatar Dec 19 '23 22:12 bibicadotnet

apt-get install sqlite3

sqlite3 /root/docker/artalk/data/artalk.db "UPDATE comments SET page_key = REPLACE(page_key, 'old page', 'new page');"

dianso avatar Dec 20 '23 02:12 dianso

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

bibicadotnet avatar Dec 20 '23 02:12 bibicadotnet