What could be the reason for this vbulletin-mysql-problem ?

[Gerdoso]

I've recently installed some hacks ("Change Username via UserCP", "Custom Avatars as Files", "Country Flag Hack v2.0")
and experience a disturbing problem:


The following error in a mysql-statement occurs, when users enter their usercp or the PM's:

...privatemessage.fromuserid<> AND privatemessage.fromuserid<>669 ORDER BY...
(a number is missing after "fromuserid<>")

The reason for this:

For some users, the ignore-list-row of the user-table the entry looks like:
" 32 669 299"
instead of
"32 669 299"

There's a space at the beginning of the line !! And that causes the mysql-statement to fail...

So, which script adds this space at the beginning of the ignore-list-row and what could be the problem ?

[Admin]

Upgrade to version 2.2.2 and this (a bug) will go away.

[Scott MacVicar]

its pretty much whitespace that shouldn't be there

theres a text file which tells you all the changes in the files between 2.2.1 and 2.2.2.

[Gerdoso]

Thanks!