Mailing List Archive: Interchange: users

No key 'sku' found for function='insert' table='products'

Index | Next | Previous | View Threaded

tom at readyink

Nov 16, 2009, 5:19 PM

Post #1 of 3 (792 views)
Permalink

No key 'sku' found for function='insert' table='products'

Any idea why I would get this error on a 4.7 system when inserting/updating
products through admin interface? The table does have a key 'sku' and the
dbconf file is normal and unchanged.

Thank you,
tom friedel

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

gert at 3edge

Nov 16, 2009, 10:24 PM

Post #2 of 3 (714 views)
Permalink

Re: No key 'sku' found for function='insert' table='products' [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup [mailto:interchange-
> users-bounces [at] icdevgroup] On Behalf Of Tom Friedel
> Sent: Tuesday, November 17, 2009 3:19 AM
> To: interchange-users [at] icdevgroup
> Subject: [ic] No key 'sku' found for function='insert' table='products'
>
>
> Any idea why I would get this error on a 4.7 system when
> inserting/updating
> products through admin interface? The table does have a key 'sku' and
> the
> dbconf file is normal and unchanged.

- You experience this with every table, or only with the products table?
- products is GDBM/Mysql/Postgres DB table?
- It worked before and stopped working recently?
- Did any updated/upgrades lately?

CU,

Gert

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

racke at linuxia

Nov 17, 2009, 5:40 AM

Post #3 of 3 (711 views)
Permalink

Re: No key 'sku' found for function='insert' table='products' [In reply to]

Tom Friedel wrote:
>
> Any idea why I would get this error on a 4.7 system when
> inserting/updating products through admin interface? The table does
> have a key 'sku' and the dbconf file is normal and unchanged.

This message has nothing to do with your database setup or configuration.

It stems from Vend::Data::update_data (should be similar even back in 4.7):

elsif ( ! @{$data{$prikey}}) {
if($autonumber) {
@{$data{$prikey}} = map { '' } @{ $data{$fields[1]} };
}
else {
logError("No key '%s' found for function='%s' table='%s'",
$prikey, $function, $CGI::values{mv_data_table},
);
return undef;
}
}

So it looks like you don't provide a SKU for the product.

Regards
Racke

--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads