Using MySQL for products db

["PDS-MICS" <mark@ProgressiveDesignSolu.com>]

******    message to minivend-users from "PDS-MICS" <mark@ProgressiveDesignSolu.com>     ******

Hi All

I am trying to use minivend connected to a Mysql database. I have created
the products table in a database and have imported some records into it from
a tab delimited file. Minivend starts with out errors but when I am trying
to search against MySQL using the sql option for mv_searchtype I get the
"Sorry, we are still under construction!" form. I can execute a search
against the products.asc file using the glimpse option for mv_searchtype and
return the data from the MySQL table but I can not search against the MySQL
table. I have included part of my catalog.cfg file. Are there other areas
that need to be configured to use MySQL for searching?

Thanks
Mark

Database   products products.asc dbi:mysql:minivend:localhost:3306
Database   products  USER          mark
Database   products  PASS          password
NoImport   products
Database   products  COLUMN_DEF    code=char(20)
Database   products  COLUMN_DEF    description=char(50)
Database   products  COLUMN_DEF    manufacturer=char(50)
Database   products  COLUMN_DEF    team=char(50)
Database   products  COLUMN_DEF    extended_description=char(240)
Database   products  COLUMN_DEF    class=char(50)
Database   products  COLUMN_DEF    image=char(50)
Database   products  COLUMN_DEF    price=float
Database   products  COLUMN_DEF    category=char(25)
Database   products  COLUMN_DEF    nontaxable=char(5)
Database   products  COLUMN_DEF    weight=integer
Database   products  COLUMN_DEF    size=char(240)
Database   products  COLUMN_DEF    color=char(240)
Database   products  NUMERIC       price, weight



-
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