Seo easydiscuss easysocial
By Athanasios Zisopoulos on Monday, 22 October 2018
Posted in General Issues
Likes 0
Views 825
Votes 0
dear support i have enabled sef on my easydiscuss and easysocial.. as profile i use the easydiscuss section of profiles
my problem is when sef is enabled and i click a profile the link shows the id of easysocial profile plus the name and the like domain.com/62-admin.... is there a way to hide the numbers of the ids?

The same happens in the easydiscuss post links domain.com/κεντρική-forum/46584-prosthios-epixeilios-plakoyntas.
How can i rid off the id number <<46584>>?


I enabled Unicode characters and new posts have links in Greek but old ones don't
example<<<prosthios-epixeilios-plakoyntas>>> is in latin not Greek.

fist of all

[ 1) i want the id numbers to disappear in profiles and posts...if its possible.Joomla 3 has an option to hide the ids from articles is there a hack to override them too somehow? if not i can live with it ]

[And 2) a way to delete and recreate all the post aliases]

there should be a way to do it within a database command right? something like UPDATE 'jos_discuss_posts`
SET `alias=replace(replace(lower (`title`),' ','-'),"'",'') i don't know the right syntax i added it as an example so you can understand what i want..

thanks.
Hi Athanasios,

1) Unfortunately currently this is not possible in EasyDiscuss without disabling the unicode aliases setting.

2) Why do you want to delete and recreate post alias? Since post alias has to be different for each post, it is advisable to change the post alias individually instead of in the database to avoid cases where two posts have the same alias.
Raymond
·
Tuesday, 23 October 2018 12:17
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok i know it has to be different but i have 36.000 post in latin tell me how to change the alias then individually? how many years and working hours would it take for someone to alter them? there must be a way to do it somehow...thats why there is the id number right? is there a third party tool maybe that can scan aliases and find the duplicates to alter them manually?
Athanasios Zisopoulos
·
Tuesday, 23 October 2018 17:18
·
0 Likes
·
0 Votes
·
0 Comments
·
for the next release it would be nice in the post review page on back end were the title and ip and user are shown to add and the alias to show bellow or before the post ip on them, and to be able to filter posts by id ,title, ip, user and alias. now i change an alias manually and i must to open the post to see witch of them need to be altered. and to be able to alter the alias from the edit in frontpage as admin.
Athanasios Zisopoulos
·
Tuesday, 23 October 2018 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Athanasios,
there must be a way to do it somehow...thats why there is the id number right?
Actually the post id is not stored in the alias column(eg: http://take.ms/wWEmP), it only shows in the discussion links when unicode aliases setting is enabled.
is there a third party tool maybe that can scan aliases and find the duplicates to alter them manually?
There is no 3rd party tool that I can think of which can do this.

You can change discussion post alias using the following database query, but you still have to modify the query to change the alias for each post.


UPDATE #__discuss_posts AS jdp INNER JOIN #__discuss_thread AS jdt ON jdp.id = jdt.post_id SET jdp.alias = 'new-alias-here', jdt.alias = 'new-alias-here' WHERE jdt.post_id = 2093;
Basically the post_id is the id that you can get from the list by running the query below.


select title, alias, post_id from #__discuss_thread order by id desc;
Do note that changing the alias this way will not check for duplicate alias or typos causing alias mismatch between both tables(discuss_posts and discuss_thread)., unlike saving it from the backend where a number will be appended at the back of the alias if it already exists.
Raymond
·
Tuesday, 23 October 2018 18:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Οκ i understand..if possible add in the next release in the backend post section a field for alias under each post title to make it easier when someone needs to compare alias.
Athanasios Zisopoulos
·
Tuesday, 23 October 2018 19:29
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Athanasios,

We will see what we can do in the future to make the alias visible in the backend.

Regards.
Raymond
·
Tuesday, 23 October 2018 19:44
·
0 Likes
·
0 Votes
·
0 Comments
·
thanks
Athanasios Zisopoulos
·
Monday, 03 December 2018 06:57
·
0 Likes
·
0 Votes
·
0 Comments
·
You're most welcome Athanasios.

Regards.
Raymond
·
Monday, 03 December 2018 13:58
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post