[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
mySQL for beginers
Hello!
Is there any HOW-TO for mySQL . I'm new in SQL and there is't to much info
in documentation.
My problem is that I can't export data from products.asc to mySQL DB.
If I change catalog.cfg like this :
===========================================
Database pricing pricing.asc TAB
Database transactions transactions.txt TAB
Database userdb userdb.asc TAB
Database country country.asc TAB
Database locale locale.asc TAB
Database Ground Ground.csv CSV
Database 2ndDayAir 2ndDayAir.csv CSV
Database NextDayAir NextDayAir.csv CSV
Database products products.asc
dbi:mysql:minivend:my.sqlserver.host:1234
Database products COLUMN_DEF code=char(20), nontaxable=char(4)
Database products COLUMN_DEF price=char(20)
Database products COLUMN_DEF title=char(64)
Database products USER somethin
Database products PASS somethin
===========================================
It generates an error :
Configuring catalog simple...simple config error: Undefined subroutine
&Vend::Table::DBI::create called at /www/mvend/lib/Vend/Table/Import.pm line
160, <IN> chunk 1.
simple: error in configuration. Skipping.
simple: config error. Skipping.
I'm comfused... please help.
zyzia
