[ic] New catelogue with MySQL problems

Greg Cope gjjc@rubberplant.freeserve.co.uk
Tue, 03 Oct 2000 11:28:00 +0000


Dave Barr wrote:
> 
> >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  :-)

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 ?

Thanks for the prompt help -- appreciated.

Greg

> 
> Dave
> --
> 
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Dave Barr        eCommerce Technical Manager      CricInfo Ltd
> www.cricinfo.com   dave.barr@cricinfo.com    Tel: 01249 700748
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@www.minivend.com
> http://www.minivend.com/mailman/listinfo/interchange-users