SQL Bad Grammar on Import
Posted: Tue Sep 02, 2008 7:42 pm
Hi,
I receive the following error when attempting to import 25k addresses into Openemm via a CSV file.
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TEMPORARY TABLE cust_1_exist1_tmp13_tbl AS (SELECT customer_id FROM cust_1_tmp13_tbl WHERE datasource_id=0)]; nested exception is java.sql.SQLException: Table 'openemm.cust_1_tmp13_tbl' doesn't exist
The openemm user (agnitas) has all permissions required from within mysql to create temporary tables.
The environment is Centos 5.2, Openemm 5.5.0, MySQL 5.0.45 - This is a fresh install with no previous database upgrade.
Thoughts?
Thanks,
Bcadmin
I receive the following error when attempting to import 25k addresses into Openemm via a CSV file.
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [CREATE TEMPORARY TABLE cust_1_exist1_tmp13_tbl AS (SELECT customer_id FROM cust_1_tmp13_tbl WHERE datasource_id=0)]; nested exception is java.sql.SQLException: Table 'openemm.cust_1_tmp13_tbl' doesn't exist
The openemm user (agnitas) has all permissions required from within mysql to create temporary tables.
The environment is Centos 5.2, Openemm 5.5.0, MySQL 5.0.45 - This is a fresh install with no previous database upgrade.
Thoughts?
Thanks,
Bcadmin