[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] re: new to minivend...several problems
****** message to minivend-users from Dan Busarow <dan@dpcsys.com> ******
On Wed, 12 Jan 2000, Jeffrey J. Libman wrote:
> > On Wed, 12 Jan 2000, Jeffrey J. Libman wrote:
> > > i have installed minivend version 3.14-4 on my web server. i am running
> > > freeBSD 3.3-stable, apache1.3 with mysql and perl 5.005_03.
> > >
> > > i created the "simple" catalog, then changed its configuration to use
> > > mysql table for all except the freight calculation tables.
> > >
> > > i encountered the following problems:
> > >
> > > . minivend did not create the tables...i had to create them myself.
Oh yeah. Mysql requires key fields to have a not null property and
minivend doesn't add this in the create statement. I believe I saw
a post recently where someone had gotten around this by changing "code"
to a char instead of an int. Try searching the archives for not null
> > > . minivend did not populate (import the flat file data)...i had to do this
> > > manually.
> >
> > The user minivend probably does not have create or insert privs on the
> > mysql database. Add a user record to the mysql database "mysql". See
> > the security section of the mysql handbook.
>
> the minivend user has both create and insert privileges on the minivend
> database in mysql. i did a 'grant all privileges on minivend.* to
> minivend', and i looked at the data...only grant pivilege is set to 'N'.
Since the minivend user has permissions I don't know what might be wrong
other than having NoImport products in your catalog.cfg. I just took a look
and it's commented out in the simple/catalog.cfg so you would have had
to uncomment it.
I do use NoImport so I can't help beyond that but I can say that
MV will populate a table for you, that's why I always define NoImport :)
Kind of ugly to loose a table cause you decide to edit products.asc.
Thank g-d for backups and NoImport.
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
