Get a DB Error.....


Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
user.userid,
username,
usergroupid,
membergroupids,
displaygroupid,
infractiongroupids,
user.dbtech_usertag_excluded AS excluded,
relationid,
userlist.type,
friend,
dbtech_usertag_settings,
email,
languageid,
options,
adminoptions
, mention.dateline
FROM user AS user
LEFT JOIN userlist AS userlist ON (userlist.userid = user.userid AND userlist.relationid = '1443441')
LEFT JOIN dbtech_usertag_mention AS mention ON(mention.mentionedid = user.userid AND mention.postid = 'post' AND mention.type = ?)
WHERE user.userid = 9931;

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 '?)
WHERE user.userid = 9931' at line 20
Error Number : 1064

This should be resolved if you re-download and re-upload the product :)


Fillip

Tried the copy/paste username thing and still didn't work. I tried using the mention tag instead of @ and it replaced it with an @ sign with no name.

Is it possible for the user to turn off email notification for just themselves?

Is there a problem with names that start with a number?

ie. @68plymouth383 doesn't seem to work, but @bluefury361 does.

So I take it this is unsupported ?

The [MENTION] tag takes a user ID, not user name.

This can be done in the Pro version, via the UserCP.

Could you please re-post this as a bug @ our site, so I can track this issue properly? Thanks :)

Providing support @ vBulletin.org is much, much more difficult than @ our site. For that reason, we let all our vB.org users know in the first post of every thread that we offer priority support @ our site.


Fillip

great hack thank you

Even the userid didn't work. Maybe it's the username that is bugged or it cant handle 3 character usernames?

If your minimum username length setting has been increased from 3, then it won't work with usernames below that limit.

Fillip