Announcement

Collapse
No announcement yet.

Database error in vBulletin 4.2.5

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

  • [Forum] Database error in vBulletin 4.2.5

    Hello,

    I am writing to you because I'm having a database error in vBulleton 4.2.5.

    After importing the files then installing the .xml file of the "Advanced Registration" plugin from DragonByteTech, I first got the following error message:
    PHP Warning: mysqli_query (): (42S22 / 1054): Unknown column 'displayorder' in 'field list' in .... / includes / class_core.php on line 1386

    After the following new error appeared : Invalid SQL: REPLACE INTO dbtech_registration_section (sectionid, title, description, displayorder) VALUES (1, 'Required Information', 'Required Fields', 1); MySQL Error: Unknown column 'displayorder' in 'field list' Error Number: 1054

    After reading my message, the developer then asked me to try running this query: ALTER TABLE dbtech_registration_section ADD displayorder INT (10) UNSIGNED NOT NULL DEFAULT '0'

    My host took care of it, but after importing the xml file again, the same error persists: Invalid SQL: REPLACE INTO dbtech_registration_field (displayorder) VALUES (5); MySQL Error: Unknown column 'displayorder' in 'field list' Error Number: 1054

    As the developer still did not reply to my last message and the host of my forum replied that the problem came from a missing column, they could not help me further and advised me to contact you.

    I typed the Error Number : 1054 on Google and noticed it's a known issue, generally happening when upgrading from vB 3 to vB4.

    Anticipating your questions, here is some information that I think will help you find a solution to my problem: according to my cPanel, my PHP version is 7.3.6 and phpMyAdmin version is: 4.9.5. My host had to downgrade the php version so that I could install vB 4. I maintained this version because I have a lot of Mods purchased and it is the most customizable version. Hope you can help me find a solution to this problem which is significantly delaying the reopening of my forum after a long hiatus.

  • #2
    Originally posted by Eden Genesis View Post
    Hello,

    I am writing to you because I'm having a database error in vBulleton 4.2.5.

    After importing the files then installing the .xml file of the "Advanced Registration" plugin from DragonByteTech, I first got the following error message:
    PHP Warning: mysqli_query (): (42S22 / 1054): Unknown column 'displayorder' in 'field list' in .... / includes / class_core.php on line 1386

    After the following new error appeared : Invalid SQL: REPLACE INTO dbtech_registration_section (sectionid, title, description, displayorder) VALUES (1, 'Required Information', 'Required Fields', 1); MySQL Error: Unknown column 'displayorder' in 'field list' Error Number: 1054

    After reading my message, the developer then asked me to try running this query: ALTER TABLE dbtech_registration_section ADD displayorder INT (10) UNSIGNED NOT NULL DEFAULT '0'

    My host took care of it, but after importing the xml file again, the same error persists: Invalid SQL: REPLACE INTO dbtech_registration_field (displayorder) VALUES (5); MySQL Error: Unknown column 'displayorder' in 'field list' Error Number: 1054

    As the developer still did not reply to my last message and the host of my forum replied that the problem came from a missing column, they could not help me further and advised me to contact you.

    I typed the Error Number : 1054 on Google and noticed it's a known issue, generally happening when upgrading from vB 3 to vB4.

    Anticipating your questions, here is some information that I think will help you find a solution to my problem: according to my cPanel, my PHP version is 7.3.6 and phpMyAdmin version is: 4.9.5. My host had to downgrade the php version so that I could install vB 4. I maintained this version because I have a lot of Mods purchased and it is the most customizable version. Hope you can help me find a solution to this problem which is significantly delaying the reopening of my forum after a long hiatus.
    you're missing the displayorder column in dbtech_registration in your database.

    Comment


    • #3
      How can I solve this issue?

      I have reuploaded the file in the vBulletin, but there seems to be an error with all the plugins I install since the issue happened.
      What could have happened?

      Should I reinstall vBulletin again?

      Comment


      • #4
        This is really something that Dragonbyte Tech should be helping with - we cannot provide support for third party add ons.

        I would uninstall the add on completely at this point. You can then try installing it again.
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.6.4 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          Thank you for your prompt reply.

          Since DragonByte Tech customer service could not help me correct this problem, I decided to reinstall vBulletin.

          The problem is that when I re-uploaded the vBulletin files and started the installation, I got the following error message:

          HTML Code:
          Deprecated: The behavior of unparenthesized expressions containing both '.' and '+' / '-' will change in PHP 8: '+' / '-' will take a higher precedence in /home/edengene/public_html/forum/includes/class_core.php on line 5842
          
          Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/edengene/public_html/forum/includes/functions.php on line 466
          
          Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/edengene/public_html/forum/includes/functions.php on line 914
          
          Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/edengene/public_html/forum/includes/functions.php on line 4022
          
          Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/edengene/public_html/forum/includes/functions.php on line 6965
          
          Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/edengene/public_html/forum/includes/functions_navigation.php on line 588
          
          Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /home/edengene/public_html/forum/includes/functions_navigation.php on line 612
          
          Warning: Use of undefined constant MYSQL_NUM - assumed 'MYSQL_NUM' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/init.php on line 119
          
          Warning: Use of undefined constant MYSQL_ASSOC - assumed 'MYSQL_ASSOC' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/init.php on line 119
          
          Warning: Use of undefined constant MYSQL_BOTH - assumed 'MYSQL_BOTH' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/init.php on line 119
          
          Warning: Use of undefined constant file - assumed 'file' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 1267
          
          Warning: Use of undefined constant file - assumed 'file' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 1267
          
          Warning: Use of undefined constant file - assumed 'file' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 1267
          
          Warning: Use of undefined constant file - assumed 'file' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 1267
          
          Warning: Use of undefined constant file - assumed 'file' (this will throw an Error in a future version of PHP) in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 1267
          
          Warning: Cannot modify header information - headers already sent by (output started at /home/edengene/public_html/forum/includes/class_core.php:5842) in /home/edengene/public_html/forum/install/includes/class_upgrade_ajax.php on line 669
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Deprecated: Function create_function () is deprecated in /home/edengene/public_html/forum/install/includes/class_upgrade.php on line 434
          
          Warning: Cannot modify header information - headers already sent by (output started at /home/edengene/public_html/forum/includes/class_core.php:5842) in /home/edengene/public_html/forum/install/includes/class_upgrade_ajax.php on line 745
          
          Warning: Cannot modify header information - headers already sent by (output started at /home/edengene/public_html/forum/includes/class_core.php:5842) in /home/edengene/public_html/forum/install/includes/class_upgrade_ajax.php on line 746
          How can I go about correcting these errors?
          I contacted my webhosting for help...

          I might delete every files and just keep config.php and then re-upload vBulletin hoping it will work normally this time....

          Comment


          • #6
            You need to make sure that you are using a version of PHP no higher than 7.1.33. vBulletin 4.X will not work on newer versions of PHP.

            Reinstalling will delete all your data. You could simply uninstall the problematic addon under Hooks & Products -> Product Manager.
            Translations provided by Google.

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

            Comment


            • #7
              Thank you for your reply. I modified the PHP version and now everything work. I just have issues with installing some mods. I was wondering if you'll add some features of some mods in the future version of vbulletin 5.

              I'm using vb 4 because it's an excellent platform for customization and many mods works on it. However, if vB 5 added many features like vBactivity; vB thanks, vB Donate, etc, it'd be awesome.

              Comment


              • #8
                Things may be considered but only if they're in the Tracker as a Feature Request. That said, there's no guarantee that everything added there will be added to the software as there's plenty of sites where these add-ons would not be needed/used therefore it's simply bloating the software. They're probably best left as add-ons by third parties.
                Vote for:

                - *Admin Settable Paid Subscription Reminder Timeframe*
                -
                *PM - Add ability to reply to originator only*
                - Add Admin ability to auto-subscribe users to specific channel(s)
                - "Quick Route" Interface...

                Comment


                • #9
                  The developper finally helped me but even with the mod update, I had to run a query in phpMyAdmin.

                  Comment


                  • #10
                    There are many tutorials on using phpMyAdmin available on the Web. Most cPanel based hosting providers offer one. Here is one tutorial on using phpMyAdmin to run queries on a database:

                    https://www.siteground.com/tutorials/phpmyadmin/query/
                    Translations provided by Google.

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

                    Comment


                    • #11
                      Thank you for your help, I'll try to use the tutorial and train myself.

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X