Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Modify the Permalink of specified comment or Merge multiple page comments #704

Open
bibicadotnet opened this issue Dec 19, 2023 · 2 comments
Labels
enhancement New feature or request

Comments

@bibicadotnet
Copy link

bibicadotnet commented Dec 19, 2023

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

@dianso
Copy link

dianso commented Dec 20, 2023

apt-get install sqlite3

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

@bibicadotnet
Copy link
Author

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

@qwqcode qwqcode added the enhancement New feature or request label Dec 20, 2023
@qwqcode qwqcode changed the title Change Permalink Modify the Permalink of specified comment or Merge multiple page comments May 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants