Re: Can't locate html_query...

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

Hello,

I think I was the one you refer to that had the same problem. I do not
completely understand minivend yet so I cant explain things well. There was
a solution, tho I dont know why it wasnt in the thread.

Here is what I did in my Catalog.cfg to get mine to work

    184 Database            products     Items.csv
dbi:mysql:awhealth:awhealth.com:3306
    185 Database            products     USER              joeuser
    186 Database            products     PASS              blah
    187 Database            products     COLUMN_DEF        "code=int(11)
primary
 key", ItemDescription=char(150)
    188 Database            products     COLUMN_DEF
SuggestedRetail=doubl
e(16), Price=Double
    189 Database            products     COLUMN_DEF        Brand=int,
Category=i
nt, Vendor=int
    190 Database            products     COLUMN_DEF        link=char(50)
    191 Database            products     NAME              code
ItemDescription SuggestedRetail Price Brand Category Vendor link

To use a table other then products I had to define my schema and I also had
to use
DescriptionField        ItemDescription

since my description field was different then the  default.


Hope this helps ;) As I said I am still new at this so I can only tell you
what I did, not why it works (yet)

Brian Korsund
-----Original Message-----
From: The Hermit Hacker <scrappy@hub.org>
To: Minivend-users@minivend.com <Minivend-users@minivend.com>
Date: Sunday, July 25, 1999 8:06 PM
Subject: Can't locate html_query...


>******    message to minivend-users from The Hermit Hacker
<scrappy@hub.org>     ******
>
>
>Hi...
>
> Just checked the archives, and saw the responses to the thread
>titled 'Minivend with MySQL', where someone else was seeing this problem,
>but nobody appears to have given an answer to fix this...
>
> I too just got hit by it:
>
>142.177.192.151 UqoyQYRm:142.177.192.151 - [25/July/1999:22:08:32 -0400]
hub_prod /hub_prod.cgi Runtime error: Can't locate object method
"html_query" via package "Vend::Table::DB_File" at
/home/projects/minivend/mvend/lib/Vend/Data.pm line 414.
>
> I'm using PostgreSQL instead of MySQL, since I need an RDBMS for other
>projects, but that's neither here nor there...
>
> My table is defined as:
>
>hardware=> \d hardware
>Table    = hardware
>+----------------------------------+----------------------------------+----
---+
>|              Field               |              Type                |
Length|
>+----------------------------------+----------------------------------+----
---+
>| code                             | text                             |
var |
>| description                      | text                             |
var |
>| avail                            | text                             |
var |
>| cost                             | text                             |
var |
>| price                            | text                             |
var |
>| supplier                         | text                             |
var |
>| date                             | datetime                         |
8 |
>+----------------------------------+----------------------------------+----
---+
>
> So I have the 'code, description and price' fields in place here, but the
>table name isn't product, which shouldn't matter...
>
> I have my catalog.cfg file defined as:
>
>Database        hardware hardware .asc
dbi:Pg:dbname=hardware;host=hub.org;port=5432
>Database        hardware NAME code,description,avail,cost,price,supplier
>
> And doing a 'restart' on minivend comes up clean...
>
> So, what is it that I, and others, appear to be overlooking?
>
> Oh, I do have DBI and DBD both installed on the system, as a few of the
sites
>we host use it extensively, so would know if that was broken very quickly..
>
>Marc G. Fournier                   ICQ#7615664               IRC Nick:
Scrappy
>Systems Administrator @ hub.org
>primary: scrappy@hub.org           secondary:
scrappy@{freebsd|postgresql}.org
>
>-
>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
>