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

[Dan Mostert <dan@delhitel.com>]

Dirk wrote:

> 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.

I've imported a text file into mySQL, and that seems to have worked right, 'cause I can
see all the data in SQL.  Those are the same changes that I made to my catalog.cfg.
However, this is a new catalog, and I've never even had it fired up with the standard
MiniVend way, so maybe I'm asking too much to jump to mySQL.  Perhaps I should try to
get it running with MiniVend's database first?  The interesting thing that I noticed
after my post is that nothing in that particular database is working correctly.  In a
recent post by someone, they mentioned that you should be able to go to
http://server/cgi-bin/catalog/ord/basket.html for example, but my server does the
standard Internal Server Error which turns out to be a Premature End of Script in
error_log.

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

I'll keep that in mind, but at this rate, I think it'll be a while before I have to
worry about search.

Thanks for speedy replies...  I'm supposed to have a demo site up for our client this
week...

Dan