Table 'user' field 'option'
 

Hello,
I have a simple question: in my database, table 'user', there's a field called 'option', with different values, but I don't understand the useful of this field.
A developper made an alternative page to create new user directly to vbulletin database. As a result, all new users have "15" in option field and they are like "coppa users" (as I can see in my control panel). So he decided to put "3159" (like most of the other users) and now, they can login to the forum, send PM, but for me, I can't send them a PM. I have error sql:

Database error in vBulletin 3.6.8:

Invalid SQL:
INSERT INTO pm (pmtextid, userid) VALUES (480583, );

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 ')' at line 1
Error Number : 1064
Date : Wednesday, June 4th 2008 @ 06:04:53 PM
Script : http://...........
Referrer : http://...........
IP Address : ..:..:..:..
Username : LemarkXxX
Classname : vb_database

Sorry for my poor english, and I hope all of this is understandable.
If there anybody who can find me a solution ?
Thanks in advance...

Disable all your modifications. Try then.

Tell your developer to use the DataManagers instead of directly inserting new users into the user table.

Inserting them manually will lead to many problems unless you know exactly what you are doing (a new user need rows in more tables then only the user table).

The option field is a bitfield used to store multiple boolean values into a single column.

Thanks for your answer, but what do you mean by "the DataManagers" ? Sorry for the question... :-)

See this article for examples: Add new Users (automatically)

Thanks a lot for your answer...