Register with your xenforo.com Username then start a conversation at xenforo.com w/Bob and provide the following:
    1. Your XenForo License Validation Token
    2. The Domain Name associated with the License
    NOTE: Your account will be validated once ALL requirements are verified/met. Thank you for your patience.

Renaming Showcase to something else...

Discussion in 'Showcase Support' started by Postal, Aug 13, 2013.

  1. Bob

    Bob Developer Staff Member

    Nothing has changed since SC 1.0.0 Beta 1 with that phrase or its use.

    The phrase 'nflj_showcase_menu_main_tab' is in every single XML file for every single version of showcase (only takes a few seconds to GREP that info lol).

    Here you can see that the phrase in question is part of the Master Language.



    My GUESS is that the Phrase has been deleted OR (and I've seen this one a lot) someone exported a language file, did a search and replace to the Language XML file on the term 'showcase' and ended up replacing PHRASE TITLES which you can not do (phrase Titles can not be changed, only Phrase TEXT can be changed).

    You can always run the Showcase UPGRADE again which will replace all the MASTER DATA. If you have other languages, you might have to add it back if deleted or change the phrase title if you did a search and replace and replaced phrase titles by mistake.
    Mike Edge likes this.
  2. Mike Edge

    Mike Edge Member Showcase Sportsbook Pickem Power Rankings Survivor

    Weird upgraded, reinstalled even and still searching phrases it doesn't find it. But going through all phrases I found it though and was able to change it.
  3. Bob

    Bob Developer Staff Member

    Searching Phrases finds it just fine. Altho, I have no idea why you are searching for it when you know the Phrase Name. If you know the phrase name, you can just filter the phrase index page using the phrase name as a filter.

    The Phrase TEXT is 'Showcase' so the ONLY search you can do for the TEXT CONTAINS part of the phrase search would be the term 'Showcase' which is going to return 100's of phrases with the term showcase in them.

    If you search using TITLE CONTAINS, you can find it with partial searches like this for example.. 'main_tab'


    Mike Edge likes this.
  4. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    For some reason, I can't search or find the phrase that would rename the "Search Showcase" sub-nav tab?

  5. Bob

    Bob Developer Staff Member


    Phrase: nflj_showcase_tab_link_search_showcase (all nav links have their own phrases)
    Solari likes this.
  6. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    Thanks. It's been a bit tedious replacing all those phrases -- I'm wondering if someone MySQL savvy could whip up some sort of MySQL search and replace function we could pop into phpMyAdmin...
  7. Bob

    Bob Developer Staff Member

    The XF2 version of Showcase doesn't use the term 'showcase' as much as the XF1 version does.

    @alfa1 had a custom addon developed specifically to do search and replace for Phrases.
    alfa1 likes this.
  8. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    I did try the add-on that's available and it was hit or miss. I did manage to figure out search and replace in MySQL as follows (backing up the database first is *strongly* recommended):

    update xf_phrase set phrase_text = replace(phrase_text,'showcase','Database');
    ...this search is not case insensitive so rather than muck around with a fancier version, I ran it again as:

    update xf_phrase set phrase_text = replace(phrase_text,'Showcase','Database');
    ...and it seems to have done the trick just about overall. The only place I am still seeing an instance of "showcase" showing up is in the search results:

    Screen Shot 2018-11-09 at 11.50.28 AM.png

    Do you know where I can find that specifically? Thanks!

  9. Bob

    Bob Developer Staff Member

    That one is a CONTENT TYPE specific phrase (those are unique to each content type). If you filter the phrase list by the content type (in this case, showcase_item), you will see that it pulls up 2 phrases (one being the plural of the content type)

    Selection_664.png Selection_665.png
  10. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    EDIT: Spoke too soon -- those above phrases I already changed to Database but Showcase is still showing in search results? I made sure to flush cache and all, too.

  11. Bob

    Bob Developer Staff Member

    The search results template is using the phrase showcase_item (as shown below).


    My guess is that your queries are not handling ALL of the post save actions when editing a phrase via the GUI.

    Did you actually check those phrases in the Admin CP to see if the Phrase Text has changed?
  12. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    Yes, here's a screenshot:

    Screen Shot 2018-11-09 at 12.20.03 PM.png
  13. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    Oh wait I see the master value was changed -- this was from the add-on I initially used to do phrase changes. Ouch. How do I fix that?

  14. Bob

    Bob Developer Staff Member

    Edit the PHRASE and save it (making sure that you are editing the MASTER PHRASE).
  15. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    I don't have the ability to edit the master phrase, just the phrase text per above.

    Sorry for the mess, I've uninstalled that particular search and replace add-on to avoid using it in the future. Should have went with MySQL search and replace in the first place!

  16. Bob

    Bob Developer Staff Member

    You can put your site into DEBUG mode and when doing so, you'll have access to MASTER data (Phrases and Templates). You can then edit the MASTER PHRASE, save it and then take your site out of DEBUG mode.

    You can also run the Showcase XML again, which will rebuild all of the master data.
  17. Solari

    Solari Member Showcase Premium Sportsbook Pickem

    Doh, that did the trick, thank you very much. It also solved the original problem. ; )

    Just to be clear for those following: I don't recommend using available search and replace add-on for this as you saw above. Using the MySQL search and replace did the trick much easier with the exception of you needing to edit two additional phrases per above because they're outside the query scope.

    Thanks again, Bob. Am loving the power behind your Showcase!
    Bob likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.