[ic] MySQL Hell

[Scott Goodman]

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