Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Duplicate entry '2147483647' for key 1

Duplicate entry '2147483647' for key 1

Thread began 9/08/2009 2:24 am by Suggs | Last modified 9/10/2009 9:39 am by Suggs | 5747 views | 5 replies

9/10/2009 1:29 amSuggs

Hi Jason,
Im not assigning a value to the ID column.
Ive attached the Insert Record Wizard listing in gif format for you to see.
Ive also attached a copy of the insert file for you as well.
The record insert file contains digital file pro image upload fields as well, however ive regenerated a new insert form using the Data Assist Wizard to test it with and its just writing the same ID numbers as before.

When you try to insert a product it appears in the database as ID 214xxxxx instead of the next number in sequence and instead of going to the detail page, it returns to the insert page along with this error message at the top of the screen:
Warning: Cannot modify header information - headers already sent by (output started at /home/barkerde/public_html/admin/productimport_Insert.php:142) in /home/barkerde/public_html/admin/productimport_Insert.php on line 169

Cheers

Paul

Attached Files

productimport_Insert.zip

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.