[ic] ic database problem

[Stefan Hornburg]

On Mon, 13 Dec 2004 09:50:21 -0500
Wojtek <mailinglists at lunetta.de> wrote:

> Stefan Hornburg wrote:
> > On Sun, 12 Dec 2004 22:05:06 -0500
> > Wojtek <mailinglists at lunetta.de> wrote:
> > 
> > 
> >>Hi List:
> >>
> >>I want to only use my MySQL database for data storage, no text files 
> >>or anything. I use the following configuration directives:
> >>
> >>ProductFiles	products
> >>
> >>Variable SQLDSN dbi:mysql:demostore
> >>
> >>Require module DBI
> >>Require module DBD::mysql
> >>
> >>Message -i -n Using MySQL, DSN=__SQLDSN__...
> >>
> >>DatabaseDefault USER root
> >>DatabaseDefault PASS mypass
> >>
> >>Database	products	products.txt	__SQLDSN__
> >>
> >>
> >>I also have a products.sql file in my products directory. The problem 
> >>is that no data is showing. When I copy a products.txt file to the 
> >>products directory data shows up. But as I said I do not want to use 
> >>any additional text files. What is the problem here?
> > 
> > 
> > After the data is in there, set:
> > 
> > NoImport products
> > 
> > resp. 
> > 
> > NoImportExternal yes
> > 
> > in catalog.cfg.
> 
> Thanks for your advice. But it still does not work - no articles are 
> shown. I don't know what I am doing wrong. The table in the database 
> does exist and have all needed columns (sku, description, price).
> 
> I can connect to the database with the given user and passwort and 
> interchange seems also to be able to connect as there are no entires in 
> error.log.
> 
> Is there something else I can check?

Do you see the products from the Interchange administration ?

Bye
	Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team