Status
Not open for further replies.

cykelmyggen

Customer
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?
tagged_username_dissapears.jpg

Edit: Getting this DB error too:
Code:
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
 
Last edited:
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.
 
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.
 
Last edited:
That's really weird. Is the vanishing username something you can reproduce; ie it happens with every single Mention you try to make?
 
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.
user_tagging _2.png
 
Last edited:
Can you try downloading it again? You might have the initial version without the regexp fixes :)
 
Redownloaded, reupped, reimported productfile. Apparently no changes.

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

edit_usertagging.png
 
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?
 
I need it enabled for testing to work, let me know when It's reenabled and ill go look. :)
 
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?
 
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 :p)

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 :D
 
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...
 
Here's how the post looks in the database after it's bugged out:
Code:
@[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?
 
Status
Not open for further replies.
Back
Top