MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

Re: Minivend with Mysql



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



Search for: Match: Format: Sort by: