Did a CHECK TABLE in phpMyAdmin - errors - any explanation?

[Guest chantesse]

cc 3.09 - I was investigating why deleting some products was failing and why stock adjustments seemed to first work, then the previous stock level seemed to reappear. Also some mysterious negative stock issues.

So I did a Did a CHECK TABLE on all tables and got things like this (have 3 sets of tales with 3 prefixes):

Problems with indexes of table `re_CubeCart_iso_countries`

More than one INDEX key was created for column `id`

Problems with indexes of table `re_CubeCart_order_inv`

PRIMARY and INDEX keys should not both be set for column `id`

Problems with indexes of table `ts_CubeCart_iso_countries`

More than one INDEX key was created for column `id`

Problems with indexes of table `ts_CubeCart_order_inv`

PRIMARY and INDEX keys should not both be set for column `id`

Problems with indexes of table `ws_CubeCart_iso_countries`

More than one INDEX key was created for column `id`

Problems with indexes of table `ws_CubeCart_order_inv`

PRIMARY and INDEX keys should not both be set for column `id`

...anyone seen this sort of thing in the Cubecart database?

I am thinking of doing a REPAIR TABLE on all but hesitating just now...

[Guest chantesse]

Just found that abalone posted the same error on Cubecart 3.x but by accident in the cc 2.x forum on Jan 29 this year.

So I'm pasting it here - looks as though he traced the code that creates the index error message. Can anyone comment?

Hi,

CC v. 3.0.(6,7,8)

Path : /install/bd/

File : schema.inc.php

Table : CubeCart_iso_countries

Line : 731

and

Table : CubeCart_order_inv

Line : 1006

Table : CubeCart_iso_countries :

CODE$db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_iso_countries` (

`id` int(11) NOT NULL auto_increment,

`iso` char(2) NOT NULL default '',

`printable_name` varchar(80) NOT NULL default '',

`iso3` char(3) default NULL,

`numcode` smallint(6) default NULL,

PRIMARY KEY (`iso`),

KEY `id` (`id`),

KEY `id_2` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=242;");

More than one INDEX key was created for column "id".

Table : CubeCart_order_inv

CODE$db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_order_inv` (

`productId` int(11) NOT NULL default '0',

`productCode` varchar(255) NOT NULL default '',

`name` varchar(225) NOT NULL default '',

`quantity` int(32) NOT NULL default '0',

`price` decimal(30,2) NOT NULL default '0.00',

`cart_order_id` varchar(30) NOT NULL default '',

`id` int(32) NOT NULL auto_increment,

`product_options` text NOT NULL,

`digital` int(1) NOT NULL default '0',

`stockUpdated` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=1;");

PRIMARY and INDEX keys should not both be set for column "id", not?

[convict]

You are right about indexes however mysterious negative stock issues is an another issue.

[Guest]

Just found that abalone posted the same error on Cubecart 3.x but by accident in the cc 2.x forum on Jan 29 this year.

So I'm pasting it here - looks as though he traced the code that creates the index error message. Can anyone comment?

Hi,

CC v. 3.0.(6,7,8)

Path : /install/bd/

File : schema.inc.php

Table : CubeCart_iso_countries

Line : 731

and

Table : CubeCart_order_inv

Line : 1006

Table : CubeCart_iso_countries :

CODE$db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_iso_countries` (

`id` int(11) NOT NULL auto_increment,

`iso` char(2) NOT NULL default '',

`printable_name` varchar(80) NOT NULL default '',

`iso3` char(3) default NULL,

`numcode` smallint(6) default NULL,

PRIMARY KEY (`iso`),

KEY `id` (`id`),

KEY `id_2` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=242;");

More than one INDEX key was created for column "id".

Table : CubeCart_order_inv

CODE$db->misc("CREATE TABLE `".$_POST['dbprefix']."CubeCart_order_inv` (

`productId` int(11) NOT NULL default '0',

`productCode` varchar(255) NOT NULL default '',

`name` varchar(225) NOT NULL default '',

`quantity` int(32) NOT NULL default '0',

`price` decimal(30,2) NOT NULL default '0.00',

`cart_order_id` varchar(30) NOT NULL default '',

`id` int(32) NOT NULL auto_increment,

`product_options` text NOT NULL,

`digital` int(1) NOT NULL default '0',

`stockUpdated` int(11) NOT NULL default '0',

PRIMARY KEY (`id`),

KEY `id` (`id`)

) TYPE=MyISAM AUTO_INCREMENT=1;");

PRIMARY and INDEX keys should not both be set for column "id", not?

Did anyone find a way to fix this? I'm getting this same message on 2 of my tables "PRIMARY and INDEX keys should not both be set for column "id"". My CC 3.0.14 quit accepting new products or new customers. When I looked in mysql using phpadmin I could see that each time I tried to ad a customer or product, the ID was being set to 0. If the ID is 0 then the product doesn't show up and I just get a blank page when I try to edit. Customers are getting an error that says it's a dublicate in the database. How do I fix this? I even tried to to install a brand new CC 3.0.17 into a different directory and I'm getting the exact same thing.

Help.