RE: [mv] Minivend3.14/MySQL Problem

[Cameron Prince <PRINCECB@novachem.com>]

******    message to minivend-users from Cameron Prince <PRINCECB@novachem.com>     ******

Although my MySQL experience is limited to MV4.03-4.04, I am guessing that
your tables are not defined properly in MySQL.

Also, you may have trouble not using a password for the database. This is
regardless of the "Uncomment if needed" statement above the SQL username and
password variables.

Look under your mvend directory for a mysql directory. This is where the
table definitions are in v4.04.

Here's a sample:


# MiniVend database definition
Database  products  products.txt __SQLDSN__
#ifdef SQLUSER
Database  products  USER         __SQLUSER__
#endif
#ifdef SQLPASS
Database  products  PASS         __SQLPASS__
#endif
Database  products  KEY          sku
Database  products  COLUMN_DEF   "sku=char(14) NOT NULL PRIMARY KEY"
Database  products  COLUMN_DEF   "description=VARCHAR(128) NOT NULL"
Database  products  COLUMN_DEF   "title=VARCHAR(128) DEFAULT '' NOT NULL,
index(title)"
Database  products  COLUMN_DEF   "artist=VARCHAR(128) DEFAULT '' NOT NULL,
index(artist)"
Database  products  COLUMN_DEF   "comment=TEXT"
Database  products  COLUMN_DEF   "display=VARCHAR(128)"
Database  products  COLUMN_DEF   "image=VARCHAR(64)"
Database  products  COLUMN_DEF   "price=DECIMAL(12,2) NOT NULL,
index(price)"
Database  products  COLUMN_DEF   "category=VARCHAR(64) NOT NULL,
index(category)"
Database  products  COLUMN_DEF   "nontaxable=CHAR(3)"
Database  products  COLUMN_DEF   "weight=VARCHAR(12) DEFAULT '0' NOT NULL"
Database  products  COLUMN_DEF   "size=VARCHAR(96)"
Database  products  COLUMN_DEF   "color=VARCHAR(96)"
Database  products  COLUMN_DEF   "related=text"
Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
Database  products  NUMERIC      price


You can verify that MiniVend creates the tables by logging into mysql as
follows:

>From the unix command line:

mysql -u root

(mysql -u root -p	if you have a password)

show databases;

use minivend314;

show tables;

select * from products;


You should see all the default products scroll by if minivend imported the
products.txt file properly.

I would recommend that you make each of your attempts with a newly created,
default catalog. In my experiences, a catalog can become trashed when
attempts to integrate with MySQL fail. 


Hope this helps,


Cameron



 -----Original Message-----
From: 	owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]  On Behalf Of OTR Comm
Sent:	Monday, April 24, 2000 2:32 PM
To:	MiniVend List
Subject:	[mv] Minivend3.14/MySQL Problem

******    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
-
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