Bug Problem with "Advanced Registration Addons" + run query

[Eden]

Hello,

I currently have a problem installing the addons.

Here is the initial error message :


I've read about how to run a query and now I've tried to run the query that you asked me to do in a previous message.

It obviously worked as soon as I changed the FOREIGNK_KEY_CHECKS=1 key to O, then when I was done, I set the key back to 1.

However, after the change, the error message changed to this:

I asked for help from my host, but he doesn't know much about it and asks me to manage myself.

Just to make sure, it's in phpmyadmin that we run a query, right?


I thank you in advance for your precious help.

I also changed the PHP version to an earlier version compatible with vBulletin 4.2.5

 

[Eden]

From what I understand, I have to run a query, under "dbtech_registration_section" :



But I'm not sure, if I have to replace the first line, with my query or if I should write the query on another line....

 

[Eden]

The host of my site found the following errors and asked me to send them to you to try to correct the error found:

[17-Aug-2021 09:32:02 UTC] PHP Warning:  mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0),(1, 2, , 0),(1, 3, , 0),(1, 4, , 0),(1, 5, , 0),(1, 6, , 0),(1, 7, , 0),(...' at line 4 in /home/edengene/public_html/forum/includes/class_core.php on line 1386
[17-Aug-2021 09:47:29 UTC] PHP Warning:  mysqli_query(): (42S22/1054): Unknown column 'displayorder' in 'field list' in /home/edengene/public_html/forum/includes/class_core.php on line 1386

 

[Fillip H.]

You can run ALTER TABLE dbtech_registration_section ADD displayorder INT(10) UNSIGNED NOT NULL DEFAULT '0'

 

[Eden]

Thank you, the installation was almost done, but this time I have the same issue but with "dbtech_registration_instance_sections"

Database error in vBulletin 4.2.5:


Invalid SQL:


    REPLACE INTO `dbtech_registration_instance_field`
        (instanceid, fieldid, sectionid, displayorder)
    VALUES
        (1, 1, , 0),(1, 2, , 0),(1, 3, , 0),(1, 4, , 0),(1, 5, , 0),(1, 6, , 0),(1, 7, , 0),(1, 8, , 0),(1, 9, , 0),(1, 10, , 0),(1, 11, , 0),(1, 12, , 5),(1, 13, , 10),(1, 14, , 15),(1, 15, , 20),(1, 16, , 25),(1, 17, , 30),(1, 18, , 35),(1, 19, , 40),(1, 20, , 45),(1, 21, , 50),(1, 22, , 5),(1, 23, , 10),(1, 24, , 15),(1, 25, , 20),(1, 26, , 25),(1, 27, , 30),(1, 28, , 35),(1, 29, , 40),(1, 30, , 45),(1, 31, , 50);


MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0),(1, 2, , 0),(1, 3, , 0),(1, 4, , 0),(1, 5, , 0),(1, 6, , 0),(1, 7, , 0),(...' at line 4
Error Number  : 1064
Request Date  : Wednesday, August 18th 2021 @ 07:42:37 PM
Error Date    : Wednesday, August 18th 2021 @ 07:42:56 PM
Script        : http://forum.edengenesis.ws/admincp/plugin.php?do=productimport
Referrer      : http://forum.edengenesis.ws/admincp/plugin.php?do=productadd
IP Address    : 62.85.131.25
Username      : Eden
Classname     : vB_Database_MySQLi
MySQL Version : 10.3.30-MariaDB-cll-lve
Server        : 199.87.211.101
User Agent    :

I tried to run

ALTER TABLE dbtech_registration_section ADD displayorder INT(10) UNSIGNED NOT NULL DEFAULT '0'

by "dbtech_registration_section" replaced by "dbtech_registration_instance_sections" but it doesn't work.

 

[Eden]

I just noticed it worked, but I have to do it for "dbtech_registration_instance_field" and certainly other line too...

 

[Eden]

Now it's blocked at : dbtech_registration_section

Database error in vBulletin 4.2.5:


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
Request Date  : Wednesday, August 18th 2021 @ 08:28:03 PM
Error Date    : Wednesday, August 18th 2021 @ 08:28:10 PM
Script        : http://forum.edengenesis.ws/admincp/plugin.php?do=productimport
Referrer      : http://forum.edengenesis.ws/admincp/plugin.php?do=productadd
IP Address    : 62.85.131.25
Username      : Eden
Classname     : vB_Database_MySQLi
MySQL Version : 10.3.30-MariaDB-cll-lve
Server        : 199.87.211.101
User Agent    :

I tried to run

ALTER TABLE dbtech_registration_section ADD displayorder INT(10) UNSIGNED NOT NULL DEFAULT '0'

like I did for the other but it didn't work.

 

[Eden]

I feel like I'm going in circles, the error alternates between the following files:

dbtech_registration_instance_field
dbtech_registration_section
dbtech_registration_tracking

Database error in vBulletin 4.2.5:


Invalid SQL:


    REPLACE INTO `dbtech_registration_instance_field`
        (instanceid, fieldid, sectionid, displayorder)
    VALUES
        (1, 1, , 0),(1, 2, , 0),(1, 3, , 0),(1, 4, , 0),(1, 5, , 0),(1, 6, , 0),(1, 7, , 0),(1, 8, , 0),(1, 9, , 0),(1, 10, , 0),(1, 11, , 0),(1, 12, , 5),(1, 13, , 10),(1, 14, , 15),(1, 15, , 20),(1, 16, , 25),(1, 17, , 30),(1, 18, , 35),(1, 19, , 40),(1, 20, , 45),(1, 21, , 50),(1, 22, , 5),(1, 23, , 10),(1, 24, , 15),(1, 25, , 20),(1, 26, , 25),(1, 27, , 30),(1, 28, , 35),(1, 29, , 40),(1, 30, , 45),(1, 31, , 50),(1, 32, , 5),(1, 33, , 10),(1, 34, , 15),(1, 35, , 20),(1, 36, , 25),(1, 37, , 30),(1, 38, , 35),(1, 39, , 40),(1, 40, , 45),(1, 41, , 50),(1, 42, , 5),(1, 43, , 10),(1, 44, , 15),(1, 45, , 20),(1, 46, , 25),(1, 47, , 30),(1, 48, , 35),(1, 49, , 40),(1, 50, , 45),(1, 51, , 50),(1, 52, , 5),(1, 53, , 10),(1, 54, , 15),(1, 55, , 20),(1, 56, , 25),(1, 57, , 30),(1, 58, , 35),(1, 59, , 40),(1, 60, , 45),(1, 61, , 50);


MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 0),(1, 2, , 0),(1, 3, , 0),(1, 4, , 0),(1, 5, , 0),(1, 6, , 0),(1, 7, , 0),(...' at line 4
Error Number  : 1064
Request Date  : Wednesday, August 18th 2021 @ 08:37:55 PM
Error Date    : Wednesday, August 18th 2021 @ 08:38:14 PM
Script        : http://forum.edengenesis.ws/admincp/plugin.php?do=productimport
Referrer      : http://forum.edengenesis.ws/admincp/plugin.php?do=productadd
IP Address    : 62.85.131.25
Username      : Eden
Classname     : vB_Database_MySQLi
MySQL Version : 10.3.30-MariaDB-cll-lve
Server        : 199.87.211.101
User Agent    :

And as soon as I run a query, one or the other error is repeated.


So I'm still stuck.

What can I do and why does this kind of error always appear?

 

[Eden]

I wonder why these mistakes happen.
Have I done something wrong?

Also, I noticed that there is a new update for this mod.
Will the error be resolved if I pay, download and install the update?

 

[Eden]

Can anyone help me? I still can't install this mod.

I have reinstalled vbulletin but it doesn't seem to solve my problem.

 

[Fillip H.]

I've applied a potential hotfix to the v2.0.7pl2 files. Please try re-downloading a fresh copy and re-upload the files before trying another installation.

 

[Eden]

Hello,

As requested, I downloaded the latest update and uploaded and merged the FTP files.




Then, when I reinstalled the xml file, the installation got stuck at the following phase:

I hope I didn't make any mistake.

 

[Fillip H.]

Try running the query ALTER TABLE dbtech_registration_section ADD displayorder INT(10) UNSIGNED NOT NULL DEFAULT '0' again.

 

[Eden]

Thanks a lot! It worked this time !!!!! I didn't expect it to work, but finally, after running the request, the installation didn't stop until the installation was complete.

 

[DragonByte Technologies]

Hello @Eden,

We hope your ticket regarding Advanced Registration has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.

 

[DragonByte Technologies]

Hello @Eden,

As we have not heard back from you, your ticket regarding Advanced Registration has now been closed.

If your ticket has not been resolved, please feel free to start a new support ticket and link back to this ticket.

Thank you.


- DragonByte Technologies, Ltd.