[ic] ic database problem

[Wojtek]

Stefan Hornburg wrote:
> 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 ?


I did not set up the administration (I am building my own site - not 
using the foundation demo). Is there a quick way to set it up?

Thanks,
Wojtek