Question MySQL Error in vBulletin 4.2.5:

[drikafigueiredo]

help use free version Advanced Registration

[DBTech] Advanced Registration v2 (vB4)

Mod Information Jump To Comments The Developer About Developer Visit Web Site

Mod Version: 2.0.7pl2, by DragonByte Tech (Coder)

Invalid SQL:

CREATE TABLE IF NOT EXISTS dbtech_registration_field_nonprofilefield (
fieldid INT( 10 ) UNSIGNED NOT NULL,
varname VARCHAR( 255 ) NOT NULL,
PRIMARY KEY ( fieldid ),
UNIQUE ( varname )
) ENGINE = MYISAM ;;

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071

 

[Fillip H.]

Try manually running this query:

CREATE TABLE IF NOT EXISTS dbtech_registration_field_nonprofilefield (
fieldid INT( 10 ) UNSIGNED NOT NULL,
varname VARCHAR( 150 ) NOT NULL,
PRIMARY KEY ( fieldid ),
UNIQUE ( varname )
) ENGINE = MYISAM ;

Then install the addon as usually.

 

[drikafigueiredo]

Try manually running this query:

CREATE TABLE IF NOT EXISTS dbte

[/CITAR]


sorry I'm kind of a layman where I put this code

 

[drikafigueiredo]

now gave me this error

CREATE TABLE IF NOT EXISTS `dbtech_registration_invite` (
        `inviteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,
        `userid` INT( 10 ) UNSIGNED NULL,
        `email` VARCHAR ( 255 ) NOT NULL,
        `dateline` INT( 10 ) UNSIGNED NOT NULL,
        PRIMARY KEY ( `inviteid` ),
        UNIQUE KEY ( `email` ),
        KEY ( `dateline` )
    ) ENGINE = MYISAM ;;

CREATE TABLE IF NOT EXISTS `dbtech_registration_email` (
        `email` VARCHAR ( 255 ) NOT NULL,
        `verified` ENUM('0', '1') DEFAULT '0',
        `verifyhash` CHAR( 32 )  NOT NULL DEFAULT '' ,
        PRIMARY KEY ( `email` ),
        KEY ( `verified` )
    ) ENGINE = MYISAM ;

Access to undeclared static property: REGISTRATION::$Array on line 248 in /home/u208724025/domains/site.com/public_html/Swing-Real/dbtech/registration/includes/class_register.php
#0 /home/u208724025/domains/site.com/public_html/Swing-Real/dbtech/registration/includes/class_register.php(194): REGISTRATION_REGISTER::cache_userinfo_criteria(Array)
#1 /home/u208724025/domains/site.com/public_html/Swing-Real/dbtech/registration/includes/class_register.php(75): REGISTRATION_REGISTER::is_matched_criteria(Array)
#2 /home/u208724025/domains/site.com/public_html/Swing-Real/dbtech/registration/includes/class_register.php(97): REGISTRATION_REGISTER::cache_matched_criterias()
#3 /home/u208724025/domains/site.com/public_html/Swing-Real/dbtech/registration/hooks/register_form_start.php(65): REGISTRATION_REGISTER::fetch_instance_by_criterias()
#4 /home/u208724025/domains/site.com/public_html/Swing-Real/register.php(1221) : eval()'d code(1): require('/home/u20872402...')
#5 /home/u208724025/domains/site.com/public_html/Swing-Real/register.php(1221): eval()
#6 {main}


thacks
changed everything to varchar 150

 

[drikafigueiredo]

Fillip H can you help me with the sima mistake

 

[drikafigueiredo]

sorted out
changed the relevant line to



p

                $val = $criteria['type'];
                return REGISTRATION::$$val;

 

[Fillip H.]

The relevant line already says what you posted in your post, can you please clarify?

 

[DragonByte Technologies]

Hello @drikafigueiredo,

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 @drikafigueiredo,

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.