Matthias Umbach schrieb: > Hello everyone, > > after successfully installing SWAMP I am not able to start any workflows due > to the following error (using SWAP1.5.1 on a WinXP machine with Tomcat5.5.17 > and MySQL5.0.22-community-nt): > > "Unable to doInsert in Dbnodes: org.apache.torque.TorqueException: > com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for > column 'activity' at row 1" > > By manually changing the data type of the 'activity'-field in the > 'dbnodes'-table from "bit(1)" to "tinyint(1)" I could solve this error. > Obviously the error shows up with any other field set to "bit(1)" but > manually changing each data type seems not to be an applicable workaround. > > Did anyone encounter the same problem? Is this an incompatibility between > the MySQL and Torque installations so that I should better use older program > versions? > > Any suggestions are greatly appreciated! > Matthias Umbach
Hi, it seems to be an incompatibility between torque and your mysql server. I never encountered this problem, but it seems the "BIT" definition changed its meaning since mysql 5.0.3. Although it's working fine here with mysql 5.0.18. I changed the database definitions from BIT to TINYINT(1) in subversion, will be included in the next release. Greetings -- Thomas Schmidt (tschmidt [at] suse.de) SUSE Linux Products GmbH :: Research & Development :: Internal Tools "Zurück zu den Schatten!" - Gandalf, "HdR 1" ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ swamp-devel mailing list swamp-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/swamp-devel http://swamp.sf.net
