Bugs item #910826, was opened at 2004-03-06 02:23 Message generated for change (Comment added) made by davrgould You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=910826&group_id=22866
Category: Nukes Group: None Status: Open >Resolution: Out of Date >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-24 21: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 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
