Question Invalid SQL

Status
Not open for further replies.

IFireflyl

Customer
When I attempt to add the xml for vb4 titled product-dbtech_usertag.xml in the product page I am hit with this fun response:

Code:
Database error in vBulletin 4.2.5:

Invalid SQL:

    CREATE TABLE IF NOT EXISTS `dbtech_usertag_hashsubscription`
    (
        `hash` varchar(250) NOT NULL,
        `userid` int(10) unsigned NOT NULL,
        PRIMARY KEY (`hash`,`userid`)
    ) ENGINE=MyISAM;

MySQL Error   : Specified key was too long; max key length is 1000 bytes
Error Number  : 1071
Request Date  : Tuesday, September 17th 2019 @ 05:43:50 PM
Error Date    : Tuesday, September 17th 2019 @ 05:43:56 PM
Script        : http://lionheartforums.net/forums/acp/plugin.php?do=productimport
Referrer      : https://lionheartforums.net/forums/acp/plugin.php?do=productadd
IP Address    : ***.***.***.**
Username      : IFireflyl
Classname     : vB_Database_MySQLi
MySQL Version : 10.2.25-MariaDB
Server        : 194.59.164.206
User Agent    :

Is there any way I could get some advice on how to get around this? I'm using PHP 7.1 and vBulletin 4.2.5.
 
Before we get to that, I'll need you to pick another user name. Can you let me know what you want your username to be instead?
 
Awe. I was really happy that I was able to get that username on this site. :D

You can change it to IFireflyl (that's a capital i at the beginning, and lowercase L at the end).
 
Thanks.

As for the issue, try running this command manually before attempting install:
Code:
    CREATE TABLE IF NOT EXISTS `dbtech_usertag_hashsubscription`
    (
        `hash` varchar(200) NOT NULL,
        `userid` int(10) unsigned NOT NULL,
        PRIMARY KEY (`hash`,`userid`)
    ) ENGINE=MyISAM;
I'm not sure if that'll work since I don't know how your specific MySQL version computes index length, but it should work.
 
It worked perfectly! Thanks for the quick response. A quick side question, if I decide to get the PRO version of this later, is it pretty easy to update it? Or will I have to completely uninstall it and re-install the PRO version?
 
Pro is an in-place upgrade, all of the necessary DB changes already exist in the Lite version :)
 
Status
Not open for further replies.

Legacy Advanced User Tagging

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
2,502
Customer rating
0.00 star(s) 0 ratings
Back
Top