You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by Joe Lam <jo...@moni-media.net> on 2006/11/17 04:48:51 UTC

still getting 'isenabled' sql error with roller 3.0

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.


Re: still getting 'isenabled' sql error with roller 3.0

Posted by Dave <sn...@gmail.com>.
Hi Joe,

Comments below...


On 11/16/06, Joe Lam <jo...@moni-media.net> 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