[ic] ic database problem
mailinglists at lunetta.de
Mon Dec 13 09:50:21 EST 2004
Stefan Hornburg wrote:
> On Sun, 12 Dec 2004 22:05:06 -0500
> Wojtek <mailinglists at lunetta.de> wrote:
>>I want to only use my MySQL database for data storage, no text files
>>or anything. I use the following configuration directives:
>>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
> 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
Is there something else I can check?
Thanks in advance,
More information about the interchange-users