[ic] "Bad key specification" @ IC startup

Doug Alcorn interchange-users@lists.akopia.com
Thu May 10 10:22:00 2001


--=-=-=

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.


--=-=-=
Content-Type: message/rfc822
Content-Disposition: inline

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.

-- Larry
  What do you call a
  drug ring in Dallas?
    -- a huddle --

--=-=-=



-- 
 (__) Doug Alcorn (mailto:doug@lathi.net http://www.lathi.net)
 oo / PGP 02B3 1E26 BCF2 9AAF 93F1  61D7 450C B264 3E63 D543
 |_/  If you're a capitalist and you have the best goods and they're
      free, you don't have to proselytize, you just have to wait. 

--=-=-=--