What is htmlstate and where it is coming from when upgrading

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Cruisey
    Member
    • Apr 2018
    • 53
    • 4.2.x

    What is htmlstate and where it is coming from when upgrading

    Im my new job, Im in charge of upgrading an old vb4 database to the latest vb5. I used mysqldump to get a dump, installed a fresh copy of vb5, imported the old vb4 in a table and pointed the vb5 installs to use that old vb4 dump then ran the upgrade, both command line and browser. It always fail on:
    Code:
    Unknown column 'text.htmlstate' in 'field list'
    I see that the old vb4 had some table columns with "htmlstate" but for the life of me, the error message is not very clear. I removed all traces of "htmlstate" in my sql file and still getting the error. Ive looked at most xml files to see if anything inside can help but nothing really. Is this a bug? What file to edit to skip this? This would help: how "*.htmlstate" is call or generated?
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    What you've done there won't really work. You need to put the vB4 database up, point an uninstalled copy of vB5 at it (via the config file) and run the upgrade script.

    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • Cruisey
      Member
      • Apr 2018
      • 53
      • 4.2.x

      #3
      Originally posted by Mark.B
      ...You need to put the vB4 database up, and run the upgrade script.
      Use the vB4 database? Ok


      ...point an uninstalled copy of vB5 at it (via the config file)...
      I dont understand this bit but I take it you meant: In a vB5 config, point it to the vB4 database and run the upgrade script in an uninstalled copy of vB5 using
      Code:
      php -f upgrade.php
      I'll try this and return

      Comment

      • Cruisey
        Member
        • Apr 2018
        • 53
        • 4.2.x

        #4
        Done what you have said. Ive used an uninstalled copy of vb5 and in the config I pointed it to use the exported vb4 database from a vb4 forum. I did used the upgrade script in my command prompt on windown 10, it fails at:

        Code:
        Upgrading to 5.0.1 Alpha 1
        ----------------------------------
        Step 1 - Skipping step, not needed
        Step 2 - Skipping step, not needed
        Step 3 - Updating cron table
        Step 4 - Fixing imported blog information.
                 Skipping step, not needed
        Step 5 - Fixing imported blog options.
                 Skipping step, not needed
        Step 6 - Updating permission table
        Step 7 - Unknown column 'bt.htmlstate' in 'field list'
        To explain, Im on my local machine, in a vb5 folder that is not yet installed.

        vB4 config was using mysql and the vB5 config is on mysqli. Would that be an issue?

        EDIT

        So I figured it all out. I searched the entire folder for the missing column and it turns out bt is an alias for blog_text so to fix:

        Code:
        ALTER TABLE blog_text ADD htmlstate enum('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br'
        that solved the issue
        Last edited by Cruisey; Thu 10 May '18, 5:07am.

        Comment

        Related Topics

        Collapse

        Working...