Bug #9575

Example trips over MySQL boolean/int

Details

Submitted	2006-12-07 21:07 UTC
From	perin at acm dot org
Assigned	arnaud
Status	Closed
Package	LiveUser
PHP Version	5.1.4
OS	XP
Roadmaps	(Not assigned)

Comments

[2006-12-07 21:07 UTC] perin at acm dot org

Description:
------------
MySQL rejects the booleans in example 5's demodata.xml that are expressed as Y or N. The problem vanished when I changed the values to 1 and 0.

I haven't looked at the other examples, but maybe the same problem is there, too?

Actual result:
--------------
Running the example demodata.php to populate example 5's database, I ran into this message from Apache:

[Last executed query: INSERT INTO liveuser_rights (right_id, area_id, right_define_name, has_implied) VALUES ('1', '1', 'MODIFYNEWS', 'N')]
[Native code: 1366]
[Native message: Incorrect integer value: 'N' for column 'has_implied' at row 1]