Announcement

Collapse
No announcement yet.

What is htmlstate and where it is coming from when upgrading

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

  • Cruisey
    replied
    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 10th May '18, 5:07am.

    Leave a comment:


  • Cruisey
    replied
    Originally posted by Mark.B View Post
    ...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

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • 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?

Related Topics

Collapse

Working...
X