[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: minivend and mysql
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Wed, 10 Feb 1999, Joe Arcuri wrote:
> I've setup minivend 3.11 with mysql-3.22.16a-gamma, the problem is,
> they both work great BUT, when I set the Database directive for
> products to use mysql, I get:
>
>
>
> - table products index failed: Column 'code' is used with UNIQUE or
> INDEX but is not defined as NOT NULL
>
> the products.sql file gets created with nothing in it. If I do NoImport
> products I get no products on the subsequent web page. What the hell...
> I'm new to SQL and minivend... has anyone come across this problem ????
Yes. It's normal for mysql. Create the table manually (using
code int not null primary key
for the first column.). MV will still populate it for you.
Dan
--
Dan Busarow 949 443 4172
Dana Point Communications, Inc. dan@dpcsys.com
Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
-
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
