[ic] ic database problem

[Wojtek]

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?

Thanks in advance,
Wojtek