[ic] "Bad key specification" @ IC startup

Ed LaFrance interchange-users@lists.akopia.com
Thu May 10 12:07:00 2001


At 10:21 AM 05/10/2001 -0400, you wrote:
>I've got a problem when making some changes to the products table.  My
>client wants to use the column name 'part' instead of 'sku' (along
>with some other column changes).  Previously he was using gdbm files.
>For various reasons I am switching him over to mysql.  On my local dev
>box I was able to do this without any problems.  I'm running IC 4.6.5
>and MySQL 3.23.36.  As far as I know, he's running MySQL 3.22.27 and
>IC 4.6.0.
>
>My products.mysql file looks mostly like this:
>
>Database  products  KEY          part
>Database  products  COLUMN_DEF   "part=char(30) NOT NULL PRIMARY KEY"
>Database  products  COLUMN_DEF   "category=VARCHAR(64) NOT NULL, 
>index(category)"
>Database  products  COLUMN_DEF   "description=VARCHAR(128) NOT NULL"
>...
>
>Attached is the error message that IC gives when starting up.
>
>Return-Path: <larry@pageprovider.com>
>Received: from mta6.snfc21.pbi.net (mta6.snfc21.pbi.net [206.13.28.240])
>         by velma.lathi.net (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id 
> HAA03234
>         for <doug@lathi.net>; Thu, 10 May 2001 07:56:06 -0400
>Received: from [63.205.136.162] by mta6.snfc21.pbi.net
>  (Sun Internet Mail Server sims.3.5.2000.01.05.12.18.p9)
>  with ESMTP id <0GD4001GLBWTYK@mta6.snfc21.pbi.net> for doug@lathi.net; Thu,
>  10 May 2001 04:58:05 -0700 (PDT)
>Date: Thu, 10 May 2001 04:58:55 -0700
>From: Larry Roma <larry@pageprovider.com>
>Subject: IC Config error
>To: Doug Alcorn <doug@lathi.net>
>Message-id: <B71FD08F.1E68%larry@pageprovider.com>
>User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>
>Hi Doug,
>
>I restarted IC this morning and here's the error I received:
>Configuring catalog wcc...Using MySQL, DSN=dbi:mysql:digitel.
>wcc config error: Bad key specification: part[
>   'sku',
>   'description',
>   'title',
>   'template_page',
>   'comment',
>   'display',
>   'image',
>   'price',
>   'wholesale',
>   'category',
>   'nontaxable',
>   'weight',
>   'size',
>   'color',
>   'gift_cert',
>   'related',
>   'featured',
>   'download',
>   'dl_type',
>   'dl_location',
>   'inactive'
>]
>{
>   'related' => 15,
>   'title' => 2,
>   'image' => 6,
>   'wholesale' => 8,
>   'description' => 1,
>   'dl_location' => 19,
>   'weight' => 11,
>   'nontaxable' => 10,
>   'featured' => 16,
>   'dl_type' => 18,
>   'inactive' => 20,
>   'sku' => '0',
>   'comment' => 4,
>   'price' => 7,
>   'display' => 5,
>   'gift_cert' => 14,
>   'download' => 17,
>   'template_page' => 3,
>   'size' => 12,
>   'category' => 9,
>   'color' => 13
>}
>
>wcc: error in configuration. Skipping.
>wcc: config error. Skipping.
>

Did you change the key column name in products.txt as well?

- Ed L.




New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================