Bug #9418

Initialization for example 5 wrong

Details

Submitted	2006-11-22 18:27 UTC
From	7sios8402 at sneakemail dot com
Assigned	arnaud
Status	Closed
Package	LiveUser
PHP Version	Irrelevant
OS	Windows 2003
Roadmaps	(Not assigned)

Comments

[2006-11-22 18:27 UTC] 7sios8402 at sneakemail dot com

Description:
------------
MDB2_Schema doesn't seem to be overly smart about handling initization data.

As such, the init values for the is_active columns for the liveuser_users tables is not handled properly.

The 'Y' in:
<field>
<name>is_active</name>
<value>Y</value>
</field>

leads to this query "INSERT INTO liveuser_users (auth_user_id, handle, passwd, owner_user_id, owner_group_id, lastlogin, is_active) VALUES ('29214857b12575501c5c731353c7217e', 'johndoe', '
6579e96f76baa00787a28653876c6127', '2003', '0', '0000-00-00 00:00:00', 'Y')"

As boolean is mapped to TINYINT(1), at least, in MySQL 4.1.
The 'Y' can not be handled by this datatype and is coerced to zero.

I.e., the user becomes inactive.

Expected result:
----------------
Default users for example 5 should be set as active.

Actual result:
--------------
Default users for example 5 are set as not active.