Question Invalid SQL

[IFireflyl]

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:

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.

 

[Fillip H.]

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?

 

[IFireflyl]

Awe. I was really happy that I was able to get that username on this site.

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

 

[Fillip H.]

Thanks.

As for the issue, try running this command manually before attempting install:

    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.

 

[IFireflyl]

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?

 

[Fillip H.]

Pro is an in-place upgrade, all of the necessary DB changes already exist in the Lite version

 

[IFireflyl]

That's sweet! You've resolved all of my issues. You can mark this as closed.

 

[DragonByte Technologies]

Hello @IFireflyl,

Your ticket regarding Advanced User Tagging has 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.