actually, the line you added to the upgrade script does not work with mysql. this is the same problem i had when attempting to alter the datetime column to allow for null values, there is no database independent manner for doing that.
[EMAIL PROTECTED]:/app/blogs/dev ] /app/mysql/bin/mysql -u roller -proller roller_dev < /export/home/workspace/roller_bsc/roller-1.3/build/roller/WEB-INF/dbscripts/mysql/120-to-130-migration.sql ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'not null' at line 1 we are going to have to do that in a database independent fashion. is it time we drop the "-raw" sql scripts and simply maintain different scripts for each db? -- Allen On Tue, 2005-11-01 at 08:19, Dave Johnson wrote: > I fixed that problem (ROL-869), did a new build and uploaded to my > space (~snoopdave) on people.apache.org just a couple of minutes ago. > > - Dave > > > On Nov 1, 2005, at 12:38 AM, Henri Yandell wrote: > > I hit an error when I tried to run an update on the Website->Settings > > page. I changed the editor, hit save and got a Hibernate error of: > > > > ========================================================= > > net.sf.hibernate.JDBCException: Could not execute JDBC batch update > > Caused by: Batch entry 0 update website set name='Mr Testy\'s Weblog', > > description='Mr Testy\'s Weblog', > > userid='ff808081074a49d901074a4ac8770006', defaultpageid=null, > > weblogdayid='dummy', enablebloggerapi='t', > > bloggercatid='ff808081074a49d901074a4ac8840009', > > defaultcatid='ff808081074a49d901074a4ac8840009', > > editorpage='editor-dhtml.jsp', ignorewords='', allowcomments='t', > > emailcomments='f', emailfromaddress='', editortheme='sotto', > > locale='en_US', timezone='US/Eastern', defaultplugins='', > > isenabled='t' where id='ff808081074a49d901074a4ac8830008' was aborted. > > at org.postgresql.jdbc2.Statement.executeBatch(Statement.java:201) > > at > > org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStat > > ement.java:294) > > at > > net.sf.hibernate.impl.BatchingBatcher.doExecuteBatch(BatchingBatcher.ja > > va:54) > > ========================================================= > > > > The only odd thing about the data on the page is that the default page > > select box has nothing in it. Thus the null in defaultpageid. This is > > a not-null in the database, so I'm guessing this is the problem. > > > > > > > > > ---- > > > > I was able to modify the user settings (Website->User) without > > entering a password. > > > > The right-to-left plugin didn't switch my text to be right to left, > > but that could be because that's not what it does :) > > > > ---- > > > > Otherwise things looked to be good. Just the one error that seems to > > be a problem. > > > > Hen > > >
