[ic] New catelogue with MySQL problems

[Dave Barr]

>  > >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 ?


>  > 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  :-)



>Hum ... I missed out the bit about creating a shop and then deleteing
>it.
>
>This sounds like a kludge - but a help non the less.
>
>Any any ideas why the recreation of a shop should cause this ?

---

Actually no I don't... :(

But I figured after that that it wasn't a good idea to drop any SQL 
databases (I was trying to flush my system of *any* old files before 
upgrading to 4.5.6 latest CVS's). Have you ever created a shop on 
that particular machine with the name fooshop before?

Dave
-- 

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