
Get up and running in minutes. Pay by the hour. Try opentaps In The Cloud with opentaps and the Amazon EC2 Cloud.

Get up and running in minutes. Pay by the hour. Try opentaps In The Cloud with opentaps and the Amazon EC2 Cloud.
Increase your sales with GetResponse email marketing with the opentaps GetResponse Email Marketing Integration Module.
Reach key IT decision makers and developers worldwide by advertising on this site. For details, please Contact Us.

New Relic RPM helps you monitor the performance of your opentaps or ofbiz Java application. Get a free month of New Relic Gold with promo code OT30PRO.
Watch developer and user training videos at shop.opentaps.org, all with our Satisfaction Guarantee.
hi,guys
After install opentaps .5 in Win7 32(I thought I did everything, including to change the character set in the configuration file of opentaps) and did "startofbiz.bat", seems everything is ok, but go to http://localhost:8080/opentaps, got errors "httP error 500", then checked the cosole.log, found the message as below(BTW, I use Navicat as mysql GUI tools and set the database of opentaps attri. )
2011-12-21 23:52:29,476 (main) [ DatabaseUtil.java:345:WARN ] Entity [AccommodationClass] has no table in the database
2011-12-21 23:52:29,507 (main) [ DatabaseUtil.java:353:ERROR] Could not create table [ACCOMMODATION_CLASS]: SQL Exception while executing the following:
CREATE TABLE ACCOMMODATION_CLASS (ACCOMMODATION_CLASS_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PARENT_CLASS_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci, DESCRIPTION VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_ACCOMMODATION_CLASS PRIMARY KEY (ACCOMMODATION_CLASS_ID)) TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
2011-12-21 23:52:29,507 (main) [ DatabaseUtil.java:345:WARN ] Entity [AccommodationMap] has no table in the database
2011-12-21 23:52:29,601 (main) [ DatabaseUtil.java:353:ERROR] Could not create table [ACCOMMODATION_MAP]: SQL Exception while executing the following:
CREATE TABLE ACCOMMODATION_MAP (ACCOMMODATION_MAP_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, ACCOMMODATION_CLASS_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci, FIXED_ASSET_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci, ACCOMMODATION_MAP_TYPE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci, NUMBER_OF_SPACES DECIMAL(20,0), LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_ACCOMMODATION_MAP PRIMARY KEY (ACCOMMODATION_MAP_ID)) TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
2011-12-21 23:52:29,601 (main) [ DatabaseUtil.java:345:WARN ] Entity [AccommodationMapType] has no table in the database
2011-12-21 23:52:29,601 (main) [ DatabaseUtil.java:353:ERROR] Could not create table [ACCOMMODATION_MAP_TYPE]: SQL Exception while executing the following:
CREATE TABLE ACCOMMODATION_MAP_TYPE (ACCOMMODATION_MAP_TYPE_ID VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, DESCRIPTION VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, LAST_UPDATED_STAMP DATETIME, LAST_UPDATED_TX_STAMP DATETIME, CREATED_STAMP DATETIME, CREATED_TX_STAMP DATETIME, CONSTRAINT PK_ACCOMMODATION_MAP_TYPE PRIMARY KEY (ACCOMMODATION_MAP_TYPE_ID)) TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci
Error was: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'TYPE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1
opentaps Open Source ERP + CRM is an Java J2EE web enabled open source Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) system. opentaps supports customer relationship management, sales force automation, sales opportunities management, customer support case management, sales opportunity management, order entry and order management, warehouse and inventory management, supply chain management, purchasing, material resources planning (MRP), manufacturing management, Accounts Receivable, Accounts Payable, General ledger, and financial reporting. opentaps offers the Apache OFBiz ecommerce system out-of-the-box and supports integration with the Magento e-commerce system, Amazon seller Central, ebay, and GoogleBase (froogle). opentaps is based on open source projects including Apache Tomcat, Apache Lucene, Apache Derby, JasperReports business intelligence, Pentaho BI suite, Spring framework, Hibernate, Funambol. Read more about why open source is the right solution for ERP.
Site designed by IntegratingWeb with Drupal
© 2011 Open Source Strategies Inc. Terms of Use

I faced the same problem before. The problem is caused by the new version of MySQL database. The old version of rhe create table SQL statement had a TYPE clause. The new version of MySQL changed that to be ENGINE clause. So the statement should CREATE TABLE ... ENGINE InnoDB ...
You need to modify a couple of java source codes framework/sql/src/org/ofbiz/sql/Relation.java and framework/entity/src/org/ofbiz/entity/jdbc/DatabaseUtil.java. Just replace the " TYPE " with " ENGINE ". Rebuild the app. It should work.
Hope it help
Alvin