| Ed Greenberg 2005-01-15, 8:56 pm |
| I have a table:
CREATE TABLE `classified_detail` (
`item_id` int(10) unsigned NOT NULL default '0',
`price_min` decimal(10,0) NOT NULL default '0',
`price_max` decimal(10,0) default NULL,
PRIMARY KEY (`item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
createTables defines it as:
[classified_detail]
item_id = 129
price_min = 129
price_max = 1
[classified_detail__keys]
item_id = K
When I do an insert:
$detail=DB_DataObjects::factory('classif
ied_detail');
$detail->item_id = 20;
$detail->insert();
I get:
DB Error: unknown errordb_error Object
(
[error_message_prefix] =>
[mode] => 16
[level] => 1024
[code] => -1
[message] => DB Error: unknown error
[userinfo] => CREATE TABLE classified_detail_seq (id INTEGER UNSIGNED
AUTO_INCREMENT NOT NULL, PRIMARY KEY(id))
[nativecode=1044 ** Access denied for user 'valleylists'@'localhost' to
database 'dev']
This table is supposed to have a manually set primary key.
I have other tables that ARE autoincrementing primary keys and those work
fine.
the __keys stanza for the autoincrementing keys are "item_id = N"
What is going on?
</edg>
|