Bug Vbulletin 3.6.9 mysql error at install

[oloman]

Hello,
i am trying to install tagging on a vbulletin3.6 but I get this mysql error when I try to install it:

Thank you for your help

Database error in vBulletin 3.6.9:


Created Table: dbtech_usertag_mention
Created Table: dbtech_usertag_tag
Altered Table: administrator
Altered Table: user
Altered Table: usergroup
Updating Version Number To: 1.0.0

Altered Table: forum
Altered Table: user

Invalid SQL:

INSERT INTO `bbcode`
(`bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`)
VALUES (
'mention',
'@%1;',
'[mention]Username[/mention]',
'Mention an user to alert him or her to this post!',
0,
'Mention',
'dbtech/usertag/images/mention.png',
31
);

MySQL Error : Champ 'options' inconnu dans field list
Error Number : 1054
Classname : vB_Database

 

[Fillip H.]

Open /dbtech/usertag/install/110.php

Find:

    self::$db->query_write("
        INSERT INTO `" . TABLE_PREFIX . "bbcode`
            (`bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`)
        VALUES (
            'mention',
            '@%1$s;',
            '[mention]Username[/mention]',
            'Mention an user to alert him or her to this post!',
            0,
            'Mention',
            'dbtech/usertag/images/mention.png',
            31
        )
    ");

Replace with

    self::$db->query_write("
        INSERT INTO `" . TABLE_PREFIX . "bbcode`
            (`bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`)
        VALUES (
            'mention',
            '@%1$s;',
            '[mention]Username[/mention]',
            'Mention an user to alert him or her to this post!',
            0,
            'Mention',
            'dbtech/usertag/images/mention.png'
        )
    ");

 

[oloman]

Thanks, Install has been a success.

But when I tried to post @run I got this error:

Invalid SQL:

SELECT
user.userid, username, usergroupid, membergroupids, displaygroupid, infractiongroupids, user.dbtech_usertag_excluded AS excluded, relationid, userlist.type, friend, dbtech_usertag_settings, email
, NULL AS dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = 20901)

WHERE username IN('run','run t','run te','run tes','run test')
ORDER BY username DESC;

MySQL Error : Champ 'friend' inconnu dans field list
Error Number : 1054
Date : Friday, March 9th 2012 @ 06:38:51 PM
Classname : vB_Database

---------- Post added at 17:42 ---------- Previous post was at 17:41 ----------

Champ 'friend' inconnu dans field list = Field 'friend' unknown in field list

 

[Fillip H.]

Open up
/dbtech/usertag/actions/threadtag.php
/dbtech/usertag/hooks/blog_fpdata_presave.php
/dbtech/usertag/hooks/blog_textdata_presave.php
/dbtech/usertag/hooks/postdata_presave.php

Remove

, friend

 

[oloman]

I am doing some tests

 

[oloman]

Well, when I post @RUN, it posts run
and after refresh I get the bb code
MENTION=20901 run mention

In admincp, I can't save option, i get white page.

 

[oloman]

and usertag.php?do=list&action=tags&t=315550 give me a database error, but I don't know what error it is.
And tag lists stay empty

 

[Fillip H.]

It looks like this mod is incompatible with vBulletin 3.6, sorry

I would strongly recommend you upgrade to at least vBulletin 3.8, although the 4.1.x branch is a lot better developed and more feature-rich than 3.8 and certainly 3.6

 

[oloman]

All right, I wil think about it, but I am afraid that users would be lost with a new VB.
Thanks for your help anyway