MiniVend Akopia Services

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

Re: mySQL, minivend...



******    message to minivend-users from Dan Busarow <dan@dpcsys.com>     ******

On Thu, 20 May 1999, G. Tyler Koblasa wrote:
> We have installed a fairly large database and developed perl cgi script to
> perform searches and browsing of this data.  now when something is seen and
> ordered, a link to the minivend script, with the product's code is passed
> along...
> 
> All i need to accomplish now, is to have minivend pull from and utilize a
> new table created in the mysql DB, which contains the description, code,
> weight, and price... where is all this defined and how do i have the
> product in the mysql DB added to the shopping cart?

The catalog.cfg distributed with minivend has several examples of
Database config entries.  Find the mysql one and modify for your
system.

>                                               i was thinking i would
> have to add the queries for the desc, price, weight to the basket.html but
> that didnt seem right. ideas ??

Sounds like you are linking to the flypage.  If your new table uses
the same column names as the "standard" products.asc, code, description,
price, weight you won't need to change a thing.

> How does somone debug a minivend mysql connectivity error ? right now I am
> just getting: Requested Product Unavailable... as it is not finding the code..

Connectivity all boils down to a correct Database config entry and
proper installation of DBI::DBD

Easiest way to see what is happening on the SQL side is to turn on
debugging for mysqld and watch the log file.

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


Search for: Match: Format: Sort by: