[ic] MySQL Hell

Scott Goodman scott@searchbc.com
Thu, 24 Aug 2000 17:27:07 -0700


Hmmm. If the products exists in BOTH the products.txt and mysql table it works.
This is not quite what I expected!

Scott Goodman wrote:

> > When you ran /usr/local/minivend/bin/makecat to set up the Barry Demo, did
> >    you choose the option to use MySQL? Also, did you get confirmation from the
> >    makecat script that the Barry demo was succesfully imported into the MySQL
> >    db?
> >
> >
>
> Yes and yes.
>
> I did, however, delete the sample data from the mysql products table and
> insert my own. I didn't touch the products.txt, which is how I determined that
> I was getting the wrong data (it was coming from the old text file).
>
> I've messed around with installing a fresh demo and found that a) if I change
> something in the text file it doesn't change on the html page b) If I modify
> data in the SQL table it displays correctly on the html page c) If I INSERT a
> row into the SQL table it does NOT show up on the html page. d) If I remove
> products.txt altogether I get no results at all. I'm horribly confused.
>
> I also followed the following from the IC docs:
>
> <quote>
> Why do I even need an ASCII file?
>
> Interchange wants some source for column names initially. If you don't want to
> have one,
> just create a TABLENAME.sql file in the products directory. For example, if
> you have
> this:
>
> Database products products.txt dbi:mysql:test_minivend
>
>    then create a file products/products.sql. For
> Database pricing pricing.txt dbi:mysql:test_minivend
> create a file products/pricing.sql. Etc.
> </quote>
>
> This didn't work either.
>
> I've been at this one issue for hours now. Getting pretty frustrating!
> scott
>
> Houman Akhavan wrote:
>
> > Scott,
> >
> > When you ran /usr/local/minivend/bin/makecat to set up the Barry Demo, did
> > you choose the option to use MySQL? Also, did you get confirmation from the
> > makecat script that the Barry demo was succesfully imported into the MySQL
> > db?
> >
> > Houman A.
> >
> >
> > > Hi all,
> > >
> > > I'm having one heck of a time getting interchange to read data from my
> > > mysql database. I started with the stock "barry" demo, which seemed to
> > > work.  I then emptied the products table and loaded it up with my own
> > > data. My problem is that IC seems wants to read the data out of
> > > products.txt no matter what I do. I want nothing to do with the
> > > products.txt file as I manage the data from a different application. I
> > > tried removing products.txt and removing everything but the first row in
> > > products.txt. I've restarted IC. I've fiddled with the *.nysql files. Am
> > > I missing something here? Are the ascii text files somehow integral to
> > > how IC works?
> > >
> > > I'd love some help on this!
> > >
> > > Thanks
> > > Scott
> > >
> >
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users