Hi Joe, Comments below...
On 11/16/06, Joe Lam <[EMAIL PROTECTED]> wrote:
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...
You've got your database setup correctly, that's not the problem. Turns out, this is a real bug in Roller 3.0. I reported it for you: http://opensource.atlassian.com/projects/roller/browse/ROL-1296 I'm not sure if there will be another 3.0 release, but this will definitely be fixed in 3.1. As a workaround, use SQL to set the disabled flag for users you want to disable. Thanks, - Dave
