What is the data type of the primary key of the table? Sounds like it is too
low and you have reached the maximum incremental value.
Jeremy Burns
Class Outfit
Tel: +44 (0) 208 123 3822
Mob: +44 (0) 7973 481949
Skype: jeremy_burns
http://www.classoutfit.com
On 25 Aug 2011, at 10:22, abhimanyu bv
Why have a primary key which does not auto increment? Your query
shows why this is a very bad idea as your trying to insert a record
and have not included a primary key value so the database has tried to
create one for you that already exists (probably '0').
And why prefix your prinary key with t
heya...
Am Thursday, den 25.08.2011, 16:24 +0530 schrieb abhimanyu bv:
> the primary key field is deal_id. it is not an auto-increment
> field.while saving, i am giving a value to deal_id and there are no
> ids with the same in that table.it doesnt have any dependencies.
please provide us with
the primary key field is deal_id. it is not an auto-increment field.while
saving, i am giving a value to deal_id and there are no ids with the same
in that table.it doesnt have any dependencies.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the n
hi Abhi...
Am Thursday, den 25.08.2011, 02:22 -0700 schrieb abhimanyu bv:
> i developed a page to save deals into database.till yesterday it was
> working fine.now its not working, an error is coming like SQL Error:
> 1062: Duplicate entry '' for key 'PRIMARY'. and query it showng is
> Query: IN
hi all,
i developed a page to save deals into database.till yesterday it was
working fine.now its not working, an error is coming like SQL Error:
1062: Duplicate entry '' for key 'PRIMARY'. and query it showng is
Query: INSERT INTO `deals` (`no_of_coupons`, `deal_type_id`,
`disabled`, `modified`,