Forum


Table Manager Support

Table Manager Support
Forums
No se permite escribir sin estar logado. Por favor, login

Error message on creating a table from CSV 15.03.2014 16:05

An error has occurred.
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 ')' at line 1 SQL=CREATE TABLE IF NOT EXISTS `VerO_brevets` ( );
Return to Control Panel

This is the table I pasted:
RecNum;NumDeBrevet;Lieu;DateOctroi;Validite
1;123;Louvain;2014-03-15;2016-03-15

What I am doing wrong?

thanks

Re: Error message on creating a table from CSV 17.03.2014 09:25

Hello,

When using create table from CSV fill table name and column names is needed. You should write table name and column name on each field according to mysql rules: [0-9,a-z,A-Z$_] (basic Latin letters, digits 0-9, dollar, underscore)

In error written in your post seems that column names was not filled.

Regards,
Moonsoft Team
www.moonsoft.es
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect
FaLang translation system by Faboba

Lo que nuestros clientes opinan de nosotros