[ic] "Bad key specification" @ IC startup

[Doug Alcorn <doug@lathi.net>]

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.

---

• To: Doug Alcorn <doug@lathi.net>
• Subject: IC Config error
• From: Larry Roma <larry@pageprovider.com>
• Date: Thu, 10 May 2001 04:58:55 -0700
• User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022

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.