Jump to content

Community

Ilya Hoilik

(RU4) URLs Transliteration

Recommended Posts

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...

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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 by media

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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 ^_^

Share this post


Link to post
Share on other sites
On 4/18/2015 at 10:55 PM, revaboss said:

Nice try , is very useful :thumbsup:

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 :P

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. 

Share this post


Link to post
Share on other sites

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! :sorcerer:  

Edited by MeMaBlue

Share this post


Link to post
Share on other sites

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 by MeMaBlue

Share this post


Link to post
Share on other sites

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 .

 

Share this post


Link to post
Share on other sites

@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

 

Share this post


Link to post
Share on other sites

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 by MeMaBlue

Share this post


Link to post
Share on other sites
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?????

 

Share this post


Link to post
Share on other sites

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...