Hi all,

I'm still getting the 'isenabled' sql error with roller 3.0 when trying to
disable an user in admin setting.

Data truncation: Column set to default value; NULL supplied to NOT NULL
column 'isenabled' at row 1

mysql version is 5.0.24
j/connector is located at Tomcat
5.0\common\lib\mysql-connector-java-3.1.13-bin.jar
roller version is 3.0 the new release one

type of isenabled in mysql is:
tinyint(1), not null, default value is 1

in hiberanate.cfg.xml
commented <property
name="dialect">org.hibernate.dialect.MySQLDialect</property>
and using this one <property
name="dialect">org.hibernate.dialect.MySQL5Dialect</property>

after searching the forum, seems this should be old issue with data type as
'bit' . but the data type in my table is already tinyint(1). anyone can
help? please...

thank you very much

Joe


-- 
View this message in context: 
http://www.nabble.com/still-getting-%27isenabled%27-sql-error-with-roller-3.0-tf2649352s12275.html#a7393419
Sent from the Roller - User mailing list archive at Nabble.com.

Reply via email to