[mv] [MV4] mySQL

["Joel Vandal" <jvandal@9bit.qc.ca>]

******    message to minivend-users from "Joel Vandal" <jvandal@9bit.qc.ca>     ******

When I try to use SQL for my products file with MV404, I get the following
error (dont have this problem with MV3.14-5)... Any idea for solve this ?

In my catalog.cfg, I have:

Database products products.txt dbi:mysql:test:host:port (hide host/port :P)
Datapase products column_def "code=char=20 primary key"
Database products USER ****
Database products PASS ****

In my error.log, I have:

- - - [19/April/2000:11:52:39 -0400] cyberentrepot - bad table creation
statement:
> create table products (
> code char(20) primary key,
> product char(128),
> manufacturer char(128),
> sku char(128),
> cpu char(128),
> media char(128),
> qte char(128),
> price char(128),
> poid char(128),
> status char(128),
> cat char(128),
> cat1 char(128),
> cat2 char(128),
> cat3 char(128),
> desc char(128),
> base char(128),
> prixsug char(128)
> )
>
>
> Error: You have an error in your SQL syntax near 'desc char(128),
> base char(128),
> prixsug char(128)
> )
> ' at line 16


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list