Just to follow up for future posterity, this problem...."Failed to read auto-increment value from storage engine" is actually a MySQL bug as reported here: http://bugs.mysql.com/bug.php?id=36411
I rolled back from 5.1.28 to GA 5.0.67 and it works fine. Therefore, I don't recommend the 5.1.28 release until this problem is resolved. mraible wrote: > > On Mon, Oct 6, 2008 at 10:32 AM, md10024 <[EMAIL PROTECTED]> wrote: >> >> >> >> Ok, thanks for your response that is good to know. >> >> That leaves my original questions. In a fresh installation: >> >> why are these properties not found? ... ${appfuse.version}... > > This is an issue with Maven that's not caused by AppFuse. From the > QuickStart Guide: > > > >> The warnings you see when creating your project are expected. If you >> see BUILD SUCCESSFUL at the end, your project was created >> successfully. >> > >> >> And why does the SIgnup test fail with this error? ... ("Failed to read >> auto-increment value from storage engine") > > Don't know, maybe MySQL isn't setup correctly? You might try dropping > your database and trying again. > > Matt > >> >> Any clues? >> >> Mark >> >> >> >> Peter Schneider-Manzell wrote: >>> >>> Hi Mark! >>> >>> The negative IDs are not created by the DB, these are default values >>> inserted via dbunit during the maven test phase. >>> See sample-data.xml for these entries >>> >>> Bye, >>> >>> Peter >>> >>> 2008/10/6 md10024 <[EMAIL PROTECTED]> >>> >>>> >>>> >>>> Hi, >>>> I am getting started with Spring MVC Basic on a WinXP development >>>> platform. >>>> I'm new to Maven but have used Appfuse for several different projects. >>>> >>>> I have two issues/questions: >>>> >>>> When I run this command >>>> mvn archetype:create -DarchetypeGroupId=org.appfuse.archetypes >>>> -DarchetypeArtifactId=appfuse-basic-spring >>>> -DremoteRepositories=http://static.appfuse.org/releases >>>> -DarchetypeVersion=2.0.2<http://static.appfuse.org/releases-DarchetypeVersion=2.0.2>-DgroupId=com.mycompany.app >>>> -DartifactId=myproject >>>> >>>> first, I get a list of these warnings: >>>> >>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: >>>> refe >>>> rence : template = archetype-resources/pom.xml [line 50,column 26] : >>>> ${a >>>> ppfuse.version} is not a valid reference. >>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: >>>> refe >>>> rence : template = archetype-resources/pom.xml [line 52,column 34] : >>>> ${a >>>> mp.genericCore} is not a valid reference. >>>> [WARNING] org.apache.velocity.runtime.exception.ReferenceException: >>>> refe >>>> rence : template = archetype-resources/pom.xml [line 53,column 33] : >>>> ${a >>>> mp.fullSource} is not a valid reference. >>>> >>>> >>>> Am I missing something? >>>> >>>> >>>> Secondly, further down, I get this error: >>>> >>>> Signup: >>>> [INFO] [talledLocalContainer] [zoomWeb] WARN [http-8081-4] >>>> JDBCException >>>> Reporter.logExceptions(77) | SQL Error: 1467, SQLState: HY000 >>>> [INFO] [talledLocalContainer] [zoomWeb] ERROR [http-8081-4] >>>> JDBCExceptio >>>> nReporter.logExceptions(78) | Failed to read auto-increment value from >>>> s >>>> torage engine >>>> [INFO] >>>> ----------------------------------------------------------------- >>>> >>>> I'm running MySQL 5.1.28-rc-community (utf-8) and looking at my DB >>>> tables >>>> I >>>> see this in the app_user table: >>>> -2 false false Denver US 80210 CO false >>>> [EMAIL PROTECTED] >>>> -1 false false Denver US 80210 CO false >>>> [EMAIL PROTECTED] >>>> >>>> I'm not sure how these got created with negative value ID's. Note, I am >>>> able >>>> to reproduce this with the JSF archetype also. >>>> >>>> Any hints as to what is going on here would be much appreciated. >>>> >>>> Mark >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19831354.html >>>> Sent from the AppFuse - User mailing list archive at Nabble.com. >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>> >>> >> >> -- >> View this message in context: >> http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p19841441.html >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Failed-to-read-auto-increment-value-tp19831354s2369p20062318.html Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]