(RU4) URLs Transliteration

[media]

Also when I clear seo UPDATE forums_forums SET name_seo='', seo_last_title='', seo_last_name=''; this line all my last title last names are on the forum are GONE...

[ABGenc]

7 minutes ago, media said:

Thanks ABGenc,

I missed that but is there any complete list of this SQL queries???

UPDATE core_members SET members_seo_name='';
UPDATE forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE forums_topics SET title_seo='';

 

Since the table names require the prefix you have defined ( if any ) during setup, the complete list can not be given. But if you have it 3 queries were enough for my site.

[Ilya Hoilik]

UPDATE blog_blogs SET blog_seo_name='';
UPDATE blog_entries SET entry_name_seo='';
UPDATE calendar_calendars SET cal_title_seo='';
UPDATE cms_database_categories SET category_last_seo_title='';
UPDATE core_announcements SET announce_seo_title='';
UPDATE core_members SET members_seo_name='';
UPDATE downloads_categories SET cname_furl='';
UPDATE forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE forums_topics SET title_seo='';
UPDATE gallery_albums SET album_name_seo='';
UPDATE gallery_categories SET category_name_seo='';
UPDATE gallery_images SET image_caption_seo='';

But that's not all. As far as I see, there is missed query for Downloads files at least.

[media]

Ok I did run this:

UPDATE inv_core_members SET members_seo_name='';
UPDATE inv_forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE inv_forums_topics SET title_seo='';

and my last post link on the right side shows empty (GetNewComment)?

http://www.mysite.com/test/topic/417603-/?do=getNewComment

before ?do there suppose to be SEO Friendly link but not there

Everything else worked forum names / subforums / members and so on

Edited September 28, 2016 by media

[Ilya Hoilik]

Just visit that page, FURL will be generated automatically.

[media]

3 minutes ago, Ilya Hoilik said:

Just visit that page, FURL will be generated automatically.

I did it is not showing that Furl is recreated.... is there a way to recreate complete FURL including that line

[media]

UPDATE inv_forums_forums SET name_seo='', seo_last_title='', seo_last_name='';

Running this broke the site and I have no solution. Whatever I do still getting this

http://www.mysite.com/test/topic/417603-/?do=getNewComment

Please help

[Ilya Hoilik]

Send me please link to your community via PM. I should take a look, because it worked previously.

[media]

2 hours ago, Ilya Hoilik said:

Send me please link to your community via PM. I should take a look, because it worked previously.

Sent you a PM

Thank you for your help

[MeMaBlue]

On 4/18/2015 at 10:55 PM, revaboss said:

Nice try , is very useful

in my opinion
in the Greek language is not enough to convert one letter but the agreement for vowels ,syllables and consonants to understand it when someone read it

sometimes latin characters give "bugs" for this language (for the stated reason) and the bugs , bad SEO

Hidden Content

I hope didn't insult you I just made a reference to the Greek grammar

This is very correct. Greeklish would be the best way. 

[MeMaBlue]

hello! just downloaded it   and works brilliantly,  (am running 4.1.17 !)

when saving a link it automatically changes it to the translit url. 

and , there is a place where you can set your custom NEW substitutions! SUPER  @Ilya Hoilik  !! ! BRAVO!   

Edited January 8, 2017 by MeMaBlue

[MeMaBlue]

Greek to greeklish substitutions list  with the not helpful originals of the plugins, in parentheses

 

χ  =  ch   

γκ  =  g   (not gk)

φ = f  (not ph)

Υ=  y (not i) 

ω= w (not o)   (this is optional) 

β= v (not b)

 

edit i think i cannot have 2 characters have the same substitution. 

ideally both ξ and  χ   could end up in    the X latin character. but i think the plugin wont take  2   of the same substitutions. can it be ?

i used ch for x and it looks very well : 

xana chorismos       and   vrisko  instead of brisko

egyos instead of egkyos     . i didnt choose the w for ω,  maybe i will later on. 

 

 

Edited January 8, 2017 by MeMaBlue

[Speedo]

hello

What about tags ?

for example https://ipshelp.ru/tags/одноклассниках

thanks

Edited January 11, 2017 by Speedo

[MeMaBlue]

the (most) querys for the pre-existing links work, very nice ! 

but i have a problem, i am urgent seeking the query that will also involve  all links that end with        = get newcomment    because those are broken now! 

example is http://www.parentscafe.gr/forum/topic/6715-/?do=getNewComment        after the 6715-     the url is missing.

 if i edit the link ,  it will get the correct one, it will repair.  but i obviously cant edit all forum home page links - @Ilya Hoilik i have sent pm, but posting it if someone sees it earlier and knows what its about/how to solve .

 

[ABGenc]

@MeMaBlue have you tried the following one ?

UPDATE forums_topics SET title_seo='';

And if you can, can you check if the title_seo field in your database forums_topics table is empty or not ..

[MeMaBlue]

@ABGenc  hello and thank you for replying,  

from what i see this one was in the above longer list we did,

so its been done.

.....will check what you mentioned   [ title_seo field in your database forums_topics table  ] and get back to you

 

[MeMaBlue]

@Ilya Hoilik my problem is exactly what @media had , some posts above! What did you do to solve the problem?

[MeMaBlue]

@ABGenc @media and @Ilya Hoilik  attached is screenshot 

[Ilya Hoilik]

Unzip and upload php file to the community root and go to yourwebsite.com/fixfurl.php. If you have a lot of topics, you might see an error due to a time execution limit. In this case, you just need to run this script again.

fixfurl.zip

[Ilya Hoilik]

For those having this issue - try this file: fixfurl.zip

[MeMaBlue]

Hello @Ilya Hoilik

I would like to confirm that its running effectively for on 4.1.19  ,

the fixfurl.zip  though ,     caused a php fatal error  (allowed memory size of bytes 536870912 exhausted (tried to allocate 4104 bytes)  in ........ init.php(448) : eval()'d code on line 33 

my associate will run it again and see, will report further. 

Ok , he just ran it again, and now its working splendidly! 

THANK YOU again 

Edited April 19, 2017 by MeMaBlue

[media]

On ‎1‎/‎16‎/‎2017 at 4:22 PM, Ilya Hoilik said:

For those having this issue - try this file: fixfurl.zip

Hi @Ilya Hoilik zip link is not working anymore, would you please update that?

Thanks

[Ilya Hoilik]

@media do you mean you can't download zip file or script is not working properly? I downloaded it successfully and reviewed the code - it should works.

fixfurl.zip

[media]

thank you for fixing the zip file...

[media]

On ‎8‎/‎10‎/‎2017 at 11:04 AM, Ilya Hoilik said:

@media do you mean you can't download zip file or script is not working properly? I downloaded it successfully and reviewed the code - it should works.

fixfurl.zip

@Ilya HoilikI ran fixfurl.zip  but problem is still there:

it turns this link (every where in the board)

http://www.domain.com/forum/topic/126428-apple-is-growing/?do=getNewComment

to this:

http://www.domain.com/forum/topic/126428-/?do=getNewComment

omitting the topic name from getNewComment function and system does not recreate the link.

Even if you visit that page it is not recreating that link

Only and only if someone post something (NEW) under that topic then system recreates that link

How can I recreate those links without posting under that topic?????