Problems with tags

[cykelmyggen]

I got this on one af the tags in the shoutbox:

*Boris omtalte kathrine i indlægget [post=]Nyt: Bruger tagging[/post]* @ 20:04

Translation *Boris mentioned kathrine in post [post=]Nyt: Bruger tagging[/post]* @ 20:04

It seems that tagged username dissapears in post?


Edit: Getting this DB error too:

Database error in vBulletin 3.8.4:

Invalid SQL:

                        SELECT
                                user.username,
                                user.usergroupid,
                                user.membergroupids,
                                user.infractiongroupid,
                                user.displaygroupid,
                                user.dbtech_vbshout_settings AS shoutsettings,
                                user.dbtech_vbshout_shoutstyle AS shoutstyle,
                                vbshout.*
                                , pmuser.username AS pmusername
                        FROM vbdbtech_vbshout_shout AS vbshout
                        LEFT JOIN vbuser AS user ON(user.userid = vbshout.userid)
                         LEFT JOIN vbuser AS pmuser ON(pmuser.userid = vbshout.id)
                        WHERE vbshout.instanceid IN(-1, 0, 1)
                                AND vbshout.userid NOT IN(
                                        SELECT ignoreuserid
                                        FROM vbdbtech_vbshout_ignorelist AS ignorelist
                                        WHERE userid = 2032
                                )
                                AND vbshout.forumid
IN(1,2,83,43,84,47,3,85,20,86,15,87,12,102,4,89,5,96,21,90,17,95,16,92,18,93,29,94,19,72,78,33,64,61,8,9,80,81,11,34,99,62,75,100,23,24,25,26,35,36,42,59,66,71,101,14,44,37,98,38,39,40,53,54,55,57,56,73,74,52,68,69,70,76,79,97,0)
                                AND vbshout.type IN() AND vbshout.chatroomid = 0 AND vbshout.userid NOT IN(
        SELECT userid
        FROM vbuser AS user
        WHERE dbtech_vbshout_silenced = 1
                AND userid != 2032
)AND vbshout.id = '2032'
                        ORDER BY dateline DESC, shoutid DESC
                        LIMIT 40;

MySQL Error   : You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ') AND
vbshout.chatroomid = 0 AND vbshout.userid NOT IN(
        SELECT userid
        FROM vbu' at line 21
Error Number  : 1064

Disabled for now

 

[Fillip H.]

You need vBShout v5.2.2 to make this work

Not sure if this will fix the other problem, but it'll fix the DB error I think.

 

[cykelmyggen]

Looks like this killed the DB errors, but username is still missing in post.
Edit: When editing post and deleting and writing the @Username; again it appears.

 

[Fillip H.]

That's really weird. Is the vanishing username something you can reproduce; ie it happens with every single Mention you try to make?

 

[cykelmyggen]

That's really weird. Is the vanishing username something you can reproduce; ie it happens with every single Mention you try to make?

Yes, and some users has confirmed this too. When editing the post, delieting the usertag and reentering this apparently it works fine.

I discovered that if I tag 2 different users in the same post one of them vanishes - like in the attached shot.

 

[Fillip H.]

Can you try downloading it again? You might have the initial version without the regexp fixes

 

[cykelmyggen]

Redownloaded, reupped, reimported productfile. Apparently no changes.

When I edit the post with the failed usertag it looks like this:

 

[Fillip H.]

I'm at a loss then

Would it be possible for me to get FTP access to your forum so I could try it out for myself?

 

[cykelmyggen]

PM sent
Plugin disabled for now

 

[Fillip H.]

I need it enabled for testing to work, let me know when It's reenabled and ill go look.

 

[cykelmyggen]

Reenabled now

 

[Fillip H.]

I just attempted to tag two users and it appears that if I had not interrupted the post output, it would have tagged them just fine.

Could you please provide me with the exact text you use to produce this problem?

 

[cykelmyggen]

Just tried to tag user at:
http://www.boggnasker.dk/vbforum/sk...videre-nu-google-street-view-4.html#post74063
Just showing as @:

 

[Fillip H.]

Seems like it works now, I'm not sure if it's your server or vBulletin 3.8.x, but the method I used for updating the message didn't work as intended (obviously )

I fixed it on your site and it'll also remain fixed in the upcoming v1.1.0, sorry for the trouble and thanks for your assistance

 

[cykelmyggen]

To me typing @username; still produces only the "@:"
http://www.boggnasker.dk/vbforum/sk...videre-nu-google-street-view-4.html#post74083

 

[Fillip H.]

Can you give me Admin perms with Can Admin Plugins? I want to see if there's a mod conflict here, because the message looks OK after my plugin is ran, and it works when you edit the post again...

 

[cykelmyggen]

Admin access granted

 

[Fillip H.]

Here's how the post looks in the database after it's bugged out:

@[ame]http://www.boggnasker.dk/vbforum/member.php?u=5[/ame]: Testing a  tag, getting closer...

Does this make any sense to you? Do you have an idea what the [ame] thing could mean?

 

[cykelmyggen]

AME is an automatic media embedder. You can throw in a link to almost any media and show it in your posts:

http://www.vbulletin.org/forum/showthread.php?t=202476

 

[Edrondol]

Ouch. This interferes with Ame (or visa versa)?

I have this hack, too.