MV 3.14 - Mysql 3.22.23b - Problem creating database - I WAS STUPID

["Russ" <russ@khouse.org>]

Sorry about this, I figured it out 10 minutes after sending the email.  My
problem was the link to Access, not minivend or mySQL.  It's now working
just great!

Russ

Hello,

I finally got on a Linux machine so I could increase performance and
implement cool features (such as mySQL).  I've got mySQL installed and
running, and 'minivend' is a user, and 'cb' is the name of the database
'minivend' has full control over.

I've been able to import my products, userdb, transactions, and a few other
databases (custom).  When I restart Minivend, the databases don't
automatically re-import.  Ultimately I dont want them to import all the
time, because I'll be directly updating the SQL Database (via an ODBC link
to M$ Access - very cool by the way).  But for now I'm trying to get my
database to import properly.  I have a field ('detail') that needs to be a
BLOB or a TEXT field so it can go to 65536 characters.

The 'detail' field imports under these conditions, however it seems to
truncate some leading characters.  I have no idea how it's deciding to do
that or how many, but my 'details' are only showing the second half!
Anybody do anything like this before or have an idea about this?

Catalog.cfg info pertinant to mySQL: (the xxxxxxxxxxxxx for user and
password just mean I'm not telling).

Database            products products.asc dbi:mysql:cb:localhost:3306
Database            products USER       xxxxxxxxxxxxx
Database            products PASS       xxxxxxxxxxxxx
Database            userdb userdb.asc dbi:mysql:cb:localhost:3306
Database            userdb USER xxxxxxxxxxxxx
Database            userdb PASS xxxxxxxxxxxxx
Database            transactions transactions.txt
dbi:mysql:cb:localhost:3306
Database            transactions USER   xxxxxxxxxxxxx
Database            transactions PASS   xxxxxxxxxxxxx
Database            affiliates affiliates.txt dbi:mysql:cb:localhost:3306
Database            affiliates USER     xxxxxxxxxxxxx
Database            affiliates PASS     xxxxxxxxxxxxx
Database            affiliatesdb affiliatesdb.asc
dbi:mysql:cb:localhost:3306
Database            affiliatesdb USER   xxxxxxxxxxxxx
Database            affiliatesdb PASS   xxxxxxxxxxxxx

# Change some data type definitions
Database             products COLUMN_DEF   "code=char(20) primary key"
#Database             products COLUMN_DEF   detail=char(255)
Database             products COLUMN_DEF   detail=text
Database             products COLUMN_DEF   comment=char(255)
Database             products COLUMN_DEF   price=float
Database             products COLUMN_DEF   retail=float
Database             products COLUMN_DEF   pages=smallint

Database             userdb COLUMN_DEF   "code=char(255) primary key"

Database             transactions COLUMN_DEF   "code=char(20) primary key"

Database             affiliates COLUMN_DEF   "code=char(20) primary key"

Database             affiliatesdb COLUMN_DEF   "username=char(255) primary
key"


I Have commented out the database lines for all these databases from when
they were in gdbm mode.

Russ 
<///><&#160;&#160; ><\\\>&#160;&#160;&#160; <///><&#160;&#160; ><\\\>
Do not speak evil of one another, bretheren. He who speaks evil of a
brother and judges his brother, speaks evil of the law and judges the
law. But if you judge the law, you are not a doer of the law but a
judge.&#160; There is one Lawgiver, who is able to save and to destroy. Who
are you to judge another?

James 4:11-12