Bugs item #910826, was opened at 2004-03-06 08:23 Message generated for change (Settings changed) made by vietj You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=910826&group_id=22866
Category: Nukes Group: None >Status: Closed >Resolution: Invalid Priority: 4 Submitted By: Dave Gould (davrgould) Assigned to: Nobody/Anonymous (nobody) Summary: Sections Module mysql setup.xml error update Initial Comment: OS: W2kSrv JDK: 1.4.2_03 [EMAIL PROTECTED]:3306] ERROR 1064: 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 'IDENTITY, pn_secname VARCHAR(40) DEFAULT '' NOT NULL, pn_image [EMAIL PROTECTED]:3306] ERROR 1064: 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 'IDENTITY, pn_secid INTEGER DEFAULT 0, pn_title VARCHAR(256) NOT The March 5th CVS snapshot for the Sections Module mysql setup.xml file contains a few errors. IDENTITY was used instead of AUTO_INCREMENT,and an accompanying set PRIMARY KEY was needed for the AUTO_INCREMENT column. Also several fields were set to a lenth of 256 but mySQL only does 255. I have a file here that includes these changes. ---------------------------------------------------------------------- Comment By: Dave Gould (davrgould) Date: 2004-03-25 03:29 Message: Logged In: YES user_id=343730 OS: W2kSrv JDK: 1.4.2_03 [EMAIL PROTECTED]:3306] ERROR 1064: 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 'IDENTITY, pn_secname VARCHAR(40) DEFAULT '' NOT NULL, pn_image [EMAIL PROTECTED]:3306] ERROR 1064: 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 'IDENTITY, pn_secid INTEGER DEFAULT 0, pn_title VARCHAR(256) NOT The March 5th CVS snapshot for the Sections Module mysql setup.xml file contains a few errors. IDENTITY was used instead of AUTO_INCREMENT,and an accompanying set PRIMARY KEY was needed for the AUTO_INCREMENT column. Also several fields were set to a lenth of 256 but mySQL only does 255. new version of section setup.xml that has section instead of m_section to replace ..\sections\src\resources\mysql\setup.xml ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=910826&group_id=22866 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
