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.
Devami...