[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] "Bad key specification" @ IC startup
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
===============================================================
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
