Re: Minivend with Mysql

[Brian Korsund <brian@hb-designs.com>]

THANK YOU! hehe

thanks Dan I dont have a clue why I cant use the names different, but I will be able to
figure it out from here I hope.

I started out with an existing database structure, and I shoulda done it with a test
database with a table named products, and fields code, price, and description.

If anyone else is having a problem like this Try making a database table called products
and have at least those 3 fields inside

Code, Description, Price.


Thanks again Dan you are the greatest ;-)

Dan Busarow wrote:

> ******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******
>
> On Tue, 20 Jul 1999, Brian Korsund wrote:
> > my Database Directive looks this way
> >
> >
> > database    awhealth    Items.sql    dbi:mysql:awhealth:awhealth.com:3306
> > database    awhealth    USER        username
> > database    awhealth    PASS        password
> >
> > As far as I know this is the correct way to do it?
>
> You'll save yourself some effort with in page searches and such by
> naming the table products.  Isn't required but I'd suggest
>
> Database    products    products.asc    dbi:mysql:awhealth:awhealth.com:3306
>
> until your more comfortable with MV
>
> > It starts the server with these directives, but gives an iternal server error when I
> > use the
> > [sql html][sql]
> > inside a page for testing
> > the error.log contains this
> >
> > ivic-dyn55.ivic.net HIKuYoiL:ivic.net - [18/July/1999:08:39:51 -0700] health
> > /cgi-bin/health/index1 Hammered session lock LOCK_HIKuYoiL:ivic.net left by PID
> > 21581
> > ivic-dyn55.ivic.net HIKuYoiL:ivic.net - [18/July/1999:08:39:51 -0700] health
> > /cgi-bin/health/index1 Runtime error: Can't locate object method "html_query" via
> > package "Vend::Table::GDBM" at /client/home/awhealth/mvend/lib/Vend/Data.pm line
> > 414.
> > >
> >
> > Its looking in Vend:Table:GDBM? the method is in Vend:Table:DBI
>
> Do you have DBI and DBD::mysql installed?  Does DBI::DBD work from
> a standard perl script?
>
> 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