Announcement

Collapse
No announcement yet.

Table for topic urls

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Blackhorse
    started a topic Table for topic urls

    Table for topic urls

    Hello,

    At which MySQL table are Vb 5 connect Topics' urls stored?

    Is there anyway to update table in database to be the same as topic name??

    Thanx

  • Blackhorse
    replied
    Hello Wayne Luke

    For update:

    1- I was able to convert the column urlident to arabic and update it in the converted database, all url and links now are correct with pure arabic and i have restored back the external google links redirect

    2- What are not converted in database is html entities, although they are read well on the forums

    Please, Do you have a command or steps to follow to try converting them in database?


    Thanx

    Leave a comment:


  • Blackhorse
    replied
    Originally posted by Blackhorse View Post
    Hello Wayne,

    Here is the ticket:
    https://www.vbulletin.com/issue.php?...hcode=7d1a321b

    ============

    I have converted the column urlident OUTSIDE Database into Arabic, it can not be converted while it is in the database with the whole process.

    How could i add it to the database and drop the old urlident?
    Here is the solution to upgrade column (e.g: urlident) in a database (e.g: dbname1) from another column (e.g: urlident) in a different database (e.g: dbname2)

    update dbname1.node, dbname2.node
    set dbname1.node.urlident = dbname2.node.urlident
    where dbname1.node.nodeid = dbname2.node.nodeid;

    Leave a comment:


  • Blackhorse
    replied
    Hello Wayne,

    Here is the ticket:
    https://www.vbulletin.com/issue.php?...hcode=7d1a321b

    ============

    I have converted the column urlident OUTSIDE Database into Arabic, it can not be converted while it is in the database with the whole process.

    How could i add it to the database and drop the old urlident?

    Leave a comment:


  • Blackhorse
    replied
    Originally posted by Wayne Luke View Post
    I don't know if I can fix your newer copy. You'd have to make both available to me via a Support Ticket.
    Oh No, not again : )))

    I have a ticket there since 24 march - (Ticketid: 2296977).

    I will upload both and update you there

    Thank you

    Leave a comment:


  • Wayne Luke
    replied
    I don't know if I can fix your newer copy. You'd have to make both available to me via a Support Ticket.

    Leave a comment:


  • Blackhorse
    replied
    I could give you a query to set the title for every node to be the exact same string of text.
    Please yes i am really in a big need for your help

    I am just trying to make any possible solution which would be disastrous as i am not experienced, but i have no other option except your interference and saving My vBulletin site

    ======


    Do you still have a backup of the pre-conversion database? If so and you give me a copy, I can try converting it.
    Yes, please, please try and help me, i am sure you will have the best insight and professionalism.

    I am keeping two versions, one version two months old before conversion to innodb and utf8

    and the current online version (3 days old) BUT this is a converted version (was converted using your vBulletin tools)

    After it was converted i find Arabic didn't appear, so i had to convert it another time and the result that Arabic came back

    I suggest you use the newest one - Can I send you the details on private?

    Thank you so much Wayne

    Leave a comment:


  • Blackhorse
    replied
    Originally posted by Wayne Luke View Post
    I am guessing that you're using Arabic. It is the only language that causes problems. Mostly because the characters were stored as HTML entities and not characters at all.
    I am thinking this is because Arabic can be written with many layers (all accents and versions can be represented on same word) يدرب = يُدرب= يُدّرب = يُدَرِّب= يُدَرِّبْ
    I have no idea about html storing.

    =============

    No. There isn't. The URL for a topic is built automatically from the title of the node already stored in the database.
    Well, That is a very good starting point, I have checked Node, I realized that:

    1- The title part of the url is automatically taken from html title to be slugged in urlindent
    2- this urlindent field is the only gibberish field i have !!
    3- I noticed this gibberish characters push the node id in an url area which makes it difficult to be key factor or recognized by redirected links!!

    ====

    Here what worked for now:

    4- As long as All Title and html title values are clear Arabic and perfectly converted ! and,
    5- As long as it will build url automatically
    6- then there is no harm from emptying all urlident which i did !- to allow to take url from title again which will do in clear arabic (as title is well read)
    7- And only Task is to just re-write urlident for over 100 Channels and forums (one day task)

    What about the other millions titles???

    they will be directed but with no title (only by node number) which hopefully will be recognized, and hopefully they will get the title automatically back

    Please Wayne, review the links again,

    This is the new converted url:

    hurras.org/new/forum/ظظطط-طظطظططظ-طظططظط-ظطظططظططھ/ظطظ-طظطططھظپطططططھ-ظطظطظطھططط%C2%ADططھ-طظطظطظظ-طظظظطططططھ-ظطظططظطظططھ/57374-طظٹطظظ-ظطططظ-ظظ-ططظ-ظطظطھظ-ططظٹط-طظظٹططظ

    here it is encoded:

    http://www.hurras.org/new/forum/%D8%...D8%B8%E2%80%B9
    it was: hurras.org/new/forum/ظظطط-طظطظططظ-طظططظط-ظطظططظططھ/ظطظ-طظطططھظپطططططھ-ظطظطظطھططط%C2%ADططھ-طظطظطظظ-طظظظطططططھ-ظطظططظطظططھ/57374-طظٹطظظ-ظطططظ-ظظ-ططظ-ظطظطھظ-ططظٹط-طظظٹططظ

    it beomes: org/new/forum/منبر-الأقسام-العامة-والخدمات/قسم-الاستفسارات-والإقتراحات-الشكاوى-المناسبات-والإعلانات/57374-
    it beomes: org/new/forum/channel-name/forum-name/nodeid-

    I only changed the channel and forum title, the title urlident was emptied node id restored to its place and now it open and you can change between the two sites (ar - new) even if there is no sluged topic title !.. I think this is a short term solution or the best one if it is really generated automatically, as i re-checked and still urlident fiels is empty!

    =========
    Last edited by Blackhorse; Tue 16th Apr '19, 12:22pm.

    Leave a comment:


  • Wayne Luke
    replied
    Do you still have a backup of the pre-conversion database? If so and you give me a copy, I can try converting it.

    Leave a comment:


  • Wayne Luke
    replied
    Sure there is an update or command to ask MySQL to update urls according to topic titles right?
    No. There isn't. The URL for a topic is built automatically from the title of the node already stored in the database.

    As far as vBulletin knows the URLS all look like this in the database:
    Code:
    forum/main\-forum/forum\-1\-1/(?P<nodeid>[0-9]+)(?P<title>(-[^!@\#\$%\^&\*\(\)\+\?/:;"'\\,\.<>= \[\]]*)*)(?:/contentpage(?P<contentpagenum>[0-9]+))?(?:/page(?P<pagenum>[0-9]+))?
    I could give you a query to set the title for every node to be the exact same string of text.

    I am pretty sure that you didn't cast your values correctly in converting them from ASCII to UTF-8 in the database. Our own scripts to do this are still in testing. Arabic is the most problematic language they encounter.

    And where in DB the save after edit page is stored?
    Node titles are stored in the node table within the title field.

    Leave a comment:


  • Blackhorse
    replied
    What I notice now Wayne Luke ,

    When i edit page in site builder, changing the link to be exact as the new arabic title, to resemble the old one and click save, it works well.

    BUT i will not do it one by one through millions of urls!!

    Sure there is an update or command to ask MySQL to update urls according to topic titles right?

    And where in DB the save after edit page is stored?

    Thanx

    Leave a comment:


  • Blackhorse
    replied
    I am using UTF-8 ((for 3 days now)) in Admincp.. This is phenomenal : ) as it is the 1st time for this 14 years old site to use. I don't know from where you get that the HTML character set is ar not UTF-8? .. then i think there would be another place that must be corrected

    the AdminCP for sure as in the picture up: I use:

    HTML Character Set = UTF-8
    UTF-8 Local for Arabic.
    The locale i exchange between ar_EG.utf8 and ar_SA.utf8

    As it is case sensitive, I get the locale from my server

    [root@host ~]# localectl list-locales | grep ^ar

    ar_AE
    ar_AE.iso88596
    ar_AE.utf8
    ar_EG
    ar_EG.iso88596
    ar_EG.utf8
    ar_SA
    ar_SA.iso88596
    ar_SA.utf8

    Leave a comment:


  • Blackhorse
    replied
    Hello Wayne,

    Here is the configuration for Language Arabic and English

    Click image for larger version

Name:	1.png
Views:	29
Size:	162.8 KB
ID:	4413228

    Leave a comment:


  • Wayne Luke
    replied
    Originally posted by Blackhorse View Post
    Hello Wayne,



    I understand your point, but what i meant is that the old title is different in characters now from the new so the encoded url must be different.

    ====
    This is the new converted url:

    hurras.org/new/forum/ظظطط-طظطظططظ-طظططظط-ظطظططظططھ/ظطظ-طظطططھظپطططططھ-ظطظطظطھططط%C2%ADططھ-طظطظطظظ-طظظظطططططھ-ظطظططظطظططھ/57374-طظٹطظظ-ظطططظ-ظظ-ططظ-ظطظطھظ-ططظٹط-طظظٹططظ

    here it is encoded:

    https://www.hurras.org/new/forum/%D8...D8%B8%E2%80%B9

    ==========

    If you try to just change ar to new you will get broken link
    Your site isn't using UTF-8. It seems you have the HTML character set as ar in the AdminCP. This won't work properly. You need to use the UTF-8 Character set and will most likely need to use the UTF-8 Local for Arabic. The locale should be something like ar_SA.UTF-8. Both the character set and the locale are Case Sensitive.

    Don't use vBulletin 4.X language files.

    Leave a comment:


  • Blackhorse
    replied
    For 2, attachments only use a nodeid. Are stored by UserID. Both of these are numbers.
    This is good news, it means i would get a solution for image problem

    After conversion, avatars broken except the default avatar.

    To solve i changed storing image to file system but (ALL pictures - except file data! disappeared) so i returned back to storing in database (most returned) but still avatars all missing. I mistakenly thought it is due to change in url scheme !

    Please Wayne, adopt the site for just one day : )

    Leave a comment:

Related Topics

Collapse

Working...
X