[ic] New catelogue with MySQL problems

Dave Barr dave.barr@cricinfo.com
Tue, 3 Oct 2000 12:11:38 +0100


>Dear All
>
>Been playing withn interchange with a view to a production roll out.
>
>I made a cat yesterday with Mysql support - Interchange made the DB -
>but upon restart gives the following in the logs:
>
>- - - [03/October/2000:07:44:17 +0000] - - Config 'fooshop' at server
>startup
>- - - [03/October/2000:07:44:17 +0000] - - Using MySQL,
>DSN=dbi:mysql:fooshop.
>- - - [03/October/2000:07:44:18 +0000] - - fooshop config error: Table
>'fooshop.orderline' doesn't exist
>- - - [03/October/2000:07:44:18 +0000] - - fooshop: config error.
>Skipping.
>
>I looked through the docs and cannot find any info - this may sound,
>lame but do I need to create that table ?

-----

Hi Greg,

I had exactly the same thing happen when I created a new shop with 
the same name as an older one after I had "dropped" that older shops 
SQL database (mysqladmin)... you could have a different scenario but 
I fixed it by giving the new catalog a new unique name (talk about 
being lame  :-)

Dave
-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dave Barr        eCommerce Technical Manager      CricInfo Ltd
www.cricinfo.com   dave.barr@cricinfo.com    Tel: 01249 700748
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~