Question MySQL Error in vBulletin 4.2.5:

Status
Not open for further replies.
help use free version Advanced Registration

[DBTech] Advanced Registration v2 (vB4)
Mod Information
Jump To Comments
The Developer
Last Online: Sep 2019
About Developer

Visit Web Site
Mod Version: 2.0.7pl2, by DragonByte Tech (Coder)
DragonByte Tech is offline




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.

Staff member
Owner
Developer
Try manually running this query:

SQL:
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.
 
now gave me this error
SQL:
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 ;;

SQL:
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
 
Last edited:

DragonByte Technologies

Company Information
Staff member
Company Info
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.
 
Status
Not open for further replies.

Advanced Registration

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
672
Customer rating
0.00 star(s) 0 ratings
Top