Re: [mv] Flypages from MySQL (2nd post...please help!!)

[Dirk <dp@letras.de>]

Dan Mostert wrote:

> ******    message to minivend-users from Dan Mostert <dan@delhitel.com>     ******
>
> Hello,
>     I have been working with MiniVend for a little while now, and I have
>
> a *very* limited proficiency with it.  I've got it working with the flat
>
> files that MiniVend works with "out of the box," but I'm wondering what
> the procedures are to get it to work with MySQL.
>     I have changed my catalog.cfg to all of the SQL statements that are
> required, and now MiniVend doesn't whine when it starts up, so I assume
> that all is well in the catalog.cfg.  I'm wondering what changes I need
> to make to the flypage.html to have it work with SQL, if any.  I've
> looked through the documentation and the mail archives, and I haven't
> seen any specific references to the need to make changes to flypage, but
>
> it isn't working for me, either.  On one of my catalogs (flat file
> database), I can just go to http://<server>/cgi-bin/<catalog>/<item
> number> and the appropriate page will come up, but if I do that to the
> SQL catalog, I get an Internal Server Error, and the error_log only
> lists Premature end of script headers.
>     The other question that I have is can I use spaces in the product
> code?  I'm guessing not, but I'd like some input.
>
>     Thanks so much,
>         Dan
>
> P.S.:  I know whoever answers this will want to see code, but rather
> than waste bandwith posting stuff that turns out to be irrelevant, let
> me know exactly what you need to see, and I'll be glad to post it.
>
> -
> 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

First I imported the original  text-database into MySQL.

What did you change in your cfg-file? I only needed to change two lines and to
comment out other ones.
Instead of this
#Database            products     products.asc      TAB
#Database            products     INDEX             category
I have now this
Database products products.asc dbi:mysql:zapf:localhost:3306
Database products USER root
Database products INDEX category.

zapf is the name of my database, so change it to yours. This database should include
a TABLE products.

In the code you always need to change the searchtype (from Glimpse/Text to sql ) and
maybe the search itself.
That should work.

Dirk
begin:vcard 
n:Pahl;Dirk
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:dp@letras.de
note:------
x-mozilla-cpt:;-18272
fn:Dirk Pahl
end:vcard