Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
media Posted September 28, 2016 Posted September 28, 2016 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 Posted September 28, 2016 Posted September 28, 2016 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 Posted September 28, 2016 Author Posted September 28, 2016 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. ram108 1
media Posted September 28, 2016 Posted September 28, 2016 (edited) 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 Posted September 28, 2016 Author Posted September 28, 2016 Just visit that page, FURL will be generated automatically.
media Posted September 28, 2016 Posted September 28, 2016 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 Posted September 29, 2016 Posted September 29, 2016 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 MeMaBlue 1
Ilya Hoilik Posted September 29, 2016 Author Posted September 29, 2016 Send me please link to your community via PM. I should take a look, because it worked previously.
media Posted September 29, 2016 Posted September 29, 2016 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 Posted December 28, 2016 Posted December 28, 2016 On 4/18/2015 at 10:55 PM, revaboss said: Nice try , is very useful in my opinionin 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 Posted January 8, 2017 Posted January 8, 2017 (edited) 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 Ilya Hoilik 1
MeMaBlue Posted January 8, 2017 Posted January 8, 2017 (edited) 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 Ilya Hoilik 1
Speedo Posted January 11, 2017 Posted January 11, 2017 (edited) hello What about tags ? for example https://ipshelp.ru/tags/одноклассниках thanks Edited January 11, 2017 by Speedo
MeMaBlue Posted January 14, 2017 Posted January 14, 2017 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 Posted January 14, 2017 Posted January 14, 2017 @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 1
MeMaBlue Posted January 14, 2017 Posted January 14, 2017 @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 Posted January 15, 2017 Posted January 15, 2017 @Ilya Hoilik my problem is exactly what @media had , some posts above! What did you do to solve the problem?
MeMaBlue Posted January 15, 2017 Posted January 15, 2017 @ABGenc @media and @Ilya Hoilik attached is screenshot
Ilya Hoilik Posted January 16, 2017 Author Posted January 16, 2017 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 MeMaBlue 1
Ilya Hoilik Posted January 16, 2017 Author Posted January 16, 2017 For those having this issue - try this file: fixfurl.zip MeMaBlue and mdmx 2
MeMaBlue Posted April 19, 2017 Posted April 19, 2017 (edited) 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 Posted August 10, 2017 Posted August 10, 2017 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 Posted August 10, 2017 Author Posted August 10, 2017 @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 Posted August 12, 2017 Posted August 12, 2017 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?????
Recommended Posts