Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Topic ID Permalink issue
Avatar
Yao Li
Member
sp_UserOfflineSmall Offline
Oct 29, 2016 - 12:05 am

I installed Topic ID Permalink plugin. The urls of new topics are using ID now, but the original topics are still using the title name instead of ID.

Can I have all topics with ID urls?Thanks.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 29, 2016 - 12:35 am

more info on the plugin: https://simple-press.com/docum.....permalink/

the topic id permalink only happens for new topics since you installed the plugin...

you could use the forum tools and edit any existing topic slug but obviously if you have lots of topics that would be quite painful...

you should be able to write a short phpmyadmin myslq statement to update those...  something like:

UPDATE wp_sftopics SET topic_slug = topic_id

note - you wpdb prefix might be other than wp_... note2 - This is untested as I have not tried it... would suggest making a database backup before executing it...

Avatar
Yao Li
Member
sp_UserOfflineSmall Offline
Oct 29, 2016 - 1:20 am

aha, that SQL statement works, thank you.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Oct 29, 2016 - 3:48 am

You're welcome

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626