[mv] Minivend3.14/MySQL Problem

[OTR Comm <otrcomm@wildapache.net>]

******    message to minivend-users from OTR Comm <otrcomm@wildapache.net>     ******

Hey,

Okay, I give up!  What do I have to do to get MV3.14 working with MySQL?

First I created a test database in MySQL called minivend314.  For
testing, I do not require a username or password.

Then I commented out the references to products.asc in my catalog.cfg,
i.e.;

#Database            products     products.asc      TAB
#Database            products     INDEX             category

Then I uncommented the MySQL reference, i.e.;

Database            products products.asc dbi:mysql:minivend314

and changed one of the references like so,

Database            products COLUMN_DEF   code=char(20), code=NOT NULL

Now when I restart minivend I get:

...
...
...
Configuring catalog store...store config error: Table
'minivend.products' doesn't exist


store: error in configuration. Skipping.
store: config error. Skipping.
...

Notice that Minivend is referring to 'minivend.products', when I told it
to use minivend314.  So I dropped minivend314 from MySQL and created
minivend (mysqladmin create minivend) and I get the same error.

Does anyone know what is going on here?

I get the same error if I try to build the pricing table!

Also, where in the MV code are the tables created and I can look to see
how the tables are created initially?

Thanks,
Murrah Boswell
otrcomm at wildapache dot net
-
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