Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Insert page returns error 'Duplicate entry '0' for key 'PRIMARY''

View all replies to this thread

Insert page returns error 'Duplicate entry '0' for key 'PRIMARY''

Thread began 10/24/2011 7:49 am by CheopisIV | Last modified 2/23/2012 6:47 am by CheopisIV | 9550 views | 16 replies

10/24/2011 7:49 amCheopisIVBeta Tester

Insert page returns error 'Duplicate entry '0' for key 'PRIMARY''

Hello, I'm using Security Assist to develop a multi-tiered user system, and it's been a huge time saver and flawless until today (Great plugin!!).

I've added some different viewable fields for user levels and also added some spry validation to make sure data is entered correctly. Today, I'm testing the Insert User function and keep getting this error;

Duplicate entry '0' for key 'PRIMARY'

so my script isn't checking and advancing the User ID any more. I haven't edited the main script so I don't know where it's been broken or what caused it. I'll attach the file I'm using if anyone can assist me with it.

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.