Announcement

Collapse
No announcement yet.

Vbulletin 5 upgrade error

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

  • Vbulletin 5 upgrade error

    I am trying to upgrade vbulletin to v 5 connect but geeting this error in upgrade



    An error has occurred with your database. Please contact vBulletin Support for assistance.

    Module: 500a18, Step 1 Database Error:1054

    Unknown column 'about' in 'privatemessage'

    Query:

    ALTER TABLE privatemessage
    CHANGE about about ENUM('vote', 'vote_reply', 'rate', 'reply', 'follow', 'vm', 'comment', 'owner_to', 'owner_from', 'moderator', 'member')


  • #2
    The column doesn't exist in the table. It should have been added in the 500a1 upgrade steps as one of the original fields when the table was created. Either a step was skipped, there was a previous error, database conflict, or there is a permission issue on the database, or the field was dropped for some reason. There is really no way to tell with the information provided.

    You'll have to add the field before it can be changed. ALTER TABLE privatemessage ADD COLUMN about ENUM('vote', 'vote_reply', 'rate', 'reply', 'follow', 'vm', 'comment' );

    Then the upgrade script should pick up where it left off.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Thanks that helped upgrade went ahead but got this error now



      Upgrading to 5.0.0 Alpha 28
      ----------------------------------
      Step 6 - Error Unknown column 'nodeid' in 'field list'
      Last edited by tejas009; Tue 24 Nov '20, 5:44am.

      Comment


      • #4
        What version of vBulletin are you upgrading from?
        Before upgrading did you uninstall all Private Message related addons from the previous version?
        Did you encounter any errors in the earlier steps?

        What is the structure of your privatemessage table currently? Please run this query and post the output: SHOW CREATE TABLE privatemessage;.

        This table should be new in vBulletin 5 and the nodeid is the primary key.

        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment


        • #5
          I am upgrading from 4.0.2

          Before upgrading did you uninstall all Private Message related addons from the previous version?
          How to do it.. i unstalled all products before upgrade

          What is the structure of your privatemessage table currently? Please run this query and post the output: SHOW CREATE TABLE privatemessage;.
          | privatemessage | CREATE TABLE `privatemessage` (
          `privatemessageid` int(10) unsigned NOT NULL AUTO_INCREMENT,
          `folderid` smallint(6) NOT NULL,
          `userid` int(10) unsigned NOT NULL,
          `touserid` int(10) unsigned NOT NULL,
          `fromuserid` int(10) unsigned NOT NULL,
          `title` varchar(250) NOT NULL,
          `message` mediumtext NOT NULL,
          `dateline` int(10) unsigned NOT NULL,
          `showsignature` smallint(6) NOT NULL,
          `iconid` smallint(5) unsigned NOT NULL,
          `messageread` smallint(6) NOT NULL,
          `readtime` int(10) unsigned NOT NULL,
          `receipt` smallint(6) unsigned NOT NULL,
          `deleteprompt` smallint(6) unsigned NOT NULL,
          `multiplerecipients` smallint(6) unsigned NOT NULL,
          PRIMARY KEY (`privatemessageid`),
          KEY `userid` (`userid`)
          ) ENGINE=InnoDB AUTO_INCREMENT=320406 DEFAULT CHARSET=latin1 |


          After i used that query on this table error gone but facing new error in upgrade
          Upgrading to 5.0.0 Alpha 28
          ----------------------------------
          Step 6 - Error Unknown column 'nodeid' in 'field list'

          Also i never faced any error or warning in upgrade process in previous version..

          Comment


          • #6
            I don't know where that table came from. Though it does look like a vBulletin table. The default private message tables in vBulletin 3 and 4 are pm*. It might be from a really old version and wasn't deleted due to database permissions. The table 'privatemessage' should be new to vBulletin 5. The upgrade scripts try to add it in 500a1 (5.0.0. Alpha 1).

            If you can set your site to PHP 7.1, then I suggest upgrading to vBulletin 4.2.5 from your 4.0.2 backup. Make a new backup. Update the PHP configuration. Then upgrading to vBulletin 5.6.4.

            Make sure that your database user has all permissions on the database. If both the pm and privatemessage table exist in your 4.2.5 database, then delete privatemessage. You might want to compare the structure of your database with the mysql-schema.php file distributed with vBulletin 4.2.5 and delete all tables that aren't part of a default vBulletin installation. This will prevent conflicts while upgrading to vBulletin 5.
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment

            Related Topics

            Collapse

            Working...
            X