Broadleaf Commerce Discussion Forums

Hi,

When we are switching the database from HSQL to Mysql, some of the tables are not created when we started the demo app. We are using mysql 5.6 and the mysql driver version is 5.1.26.

For most of the tables we are getting the SQL syntax error. Any ideas, how to resolve this?

This is the error i am getting.

[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKC1988C96B78C9977' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_MEDIA_MAP drop constraint FKEB4AECF96E4720E0
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKEB4AECF96E4720E0' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_MEDIA_MAP drop constraint FKEB4AECF9D93D857F
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKEB4AECF9D93D857F' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF drop constraint FK7B61DC0BB0C16A73
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK7B61DC0BB0C16A73' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_SKU_OPTION_VALUE_XREF drop constraint FK7B61DC0BB78C9977
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK7B61DC0BB78C9977' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_STATE drop constraint FK8F94A1EBA46E16CF
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK8F94A1EBA46E16CF' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_STATIC_ASSET drop constraint FK9875FB05F9C4A5B
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK9875FB05F9C4A5B' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_STATIC_ASSET drop constraint FK9875FB05579FE59D
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK9875FB05579FE59D' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF drop constraint FK125F58033615A91A
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK125F58033615A91A' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAR_CRIT_OFFER_XREF drop constraint FK125F5803D5F3FAF4
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FK125F5803D5F3FAF4' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAX_DETAIL drop constraint FKEABE4A4B3E2FC4F9
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKEABE4A4B3E2FC4F9' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table BLC_TAX_DETAIL drop constraint FKEABE4A4BC50D449
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKEABE4A4BC50D449' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table SANDBOX_ITEM_ACTION drop constraint FKB270D74AFE239304
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKB270D74AFE239304' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: alter table SANDBOX_ITEM_ACTION drop constraint FKB270D74A9797A024
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'constraint FKB270D74A9797A024' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADDITIONAL_OFFER_INFO if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADDRESS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_MODULE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_PASSWORD_TOKEN if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_PERMISSION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_PERMISSION_ENTITY if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_ROLE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_ROLE_PERMISSION_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_SECTION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_SEC_PERM_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_USER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_USER_PERMISSION_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_USER_ROLE_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ADMIN_USER_SANDBOX if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_AMOUNT_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ASSET_DESC_MAP if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_BUNDLE_ORDER_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_BUND_ITEM_FEE_PRICE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CANDIDATE_FG_OFFER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CANDIDATE_ITEM_OFFER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CANDIDATE_ORDER_OFFER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATALOG if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY_ATTRIBUTE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY_IMAGE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY_MEDIA_MAP if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY_PRODUCT_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CATEGORY_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CAT_SEARCH_FACET_EXCL_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CAT_SEARCH_FACET_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CHALLENGE_QUESTION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CODE_TYPES if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_COUNTRY if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CURRENCY if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_ADDRESS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_ATTRIBUTE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_OFFER_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_PASSWORD_TOKEN if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_PAYMENT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_PAYMENT_FIELDS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_PHONE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_CUSTOMER_ROLE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_DATA_DRVN_ENUM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_DATA_DRVN_ENUM_VAL if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_DISCRETE_ORDER_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_DISC_ITEM_FEE_PRICE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_DYN_DISCRETE_ORDER_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_EMAIL_TRACKING if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_EMAIL_TRACKING_CLICKS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_EMAIL_TRACKING_OPENS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FG_ADJUSTMENT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FG_FEE_TAX_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FG_FG_TAX_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FG_ITEM_TAX_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FIELD if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FIELD_SEARCH_TYPES if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FLD_DEF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FLD_ENUM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FLD_ENUM_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FLD_GROUP if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_GROUP if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_GROUP_FEE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_GROUP_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_OPTION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_OPTION_FIXED if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_OPT_BANDED_PRC if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_OPT_BANDED_WGT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_PRICE_BAND if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_FULFILLMENT_WEIGHT_BAND if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_GIFTWRAP_ORDER_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ID_GENERATION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_IMG_STATIC_ASSET if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ITEM_OFFER_QUALIFIER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_LOCALE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_MEDIA if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_MODULE_CONFIGURATION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_AUDIT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_CODE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_INFO if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_INFO_FIELDS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_ITEM_CRITERIA if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_RULE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_OFFER_RULE_MAP if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ADJUSTMENT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ATTRIBUTE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM_ADD_ATTR if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM_ADJUSTMENT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM_ATTRIBUTE if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM_DTL_ADJ if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_ITEM_PRICE_DTL if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_MULTISHIP_OPTION if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_OFFER_CODE_XREF if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_PAYMENT if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_ORDER_PAYMENT_DETAILS if exists
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:52 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_FLD if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_FLD_MAP if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_ITEM_CRITERIA if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_RULE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_RULE_MAP if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAGE_TMPLT if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAYINFO_ADDITIONAL_FIELDS if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAYMENT_ADDITIONAL_FIELDS if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAYMENT_LOG if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PAYMENT_RESPONSE_ITEM if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PERSONAL_MESSAGE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PGTMPLT_FLDGRP_XREF if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PHONE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT_ATTRIBUTE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT_BUNDLE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT_CROSS_SALE if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT_FEATURED if exists
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - 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 'if exists' at line 1
[artifact:mvn] [ERROR] 21:05:53 SchemaExport - HHH000389: Unsuccessful: drop table BLC_PRODUCT_OPTION if exists

Can you open a bug for this on https://github.com/BroadleafCommerce/Br ... rce/issues.

I had this same problem, got past it by updating core/src/main/resources/runtime-properties/common-shared.properties:

replace:

with:


Reference: http://forum.broadleafcommerce.org/viewtopic.php?f=14&t=1723
More details: http://forum.broadleafcommerce.org/viewtopic.php?f=20&t=2157

Even after doing by the book and made the changes, still getting same error

The MySql coding is little complicated , Its important to know about it concepts before implementing. To know about this coding view WebEminence

I just don't understand why the syntax
drop table if exists XXX;
now be generated wrongly by Hibernate as
drop table XXX if exists;
Is there any way we could update the Hibernate please? I just want to try...