2. PHPRunner General questions
  3. Duplicate Entry Error
This topic is locked

Duplicate Entry Error

 		8/29/2007 6:50:42 PM
PHPRunner General questions
H
 horsey_kim author

I am trying to network a huge number of websites I have to the same database. I am using php runner and just creating different projects for each site so that I can customize to look totally different. Yet they all use the same database. However I am now coming across duplication entry errors when I try to add data.
I am sure it is because each project wants to number starting from 1 and such. How do you get around this. I need it to auto inc the fields. Should the programs be looking to see what the last used number is in the database?
HELP
Kim
Update: Hey I tried removing the session default on the value that is primary and build and tried again. Still get the error and I placed a higher number than what is in the database to test it out. HUMMMM
Error is duplicate entry "2" for key1
A
 		alang 8/29/2007

Set up the database field to "Auto Inc" using database admin tool and then make sure you don't include this field on your edit/add pages in PHPRunner projects. When a record is added, the database will assign the next available number.
H
 		horsey_kim author 8/29/2007

Set up the database field to "Auto Inc" using database admin tool and then make sure you don't include this field on your edit/add pages in PHPRunner projects. When a record is added, the database will assign the next available number.


Well I did all that and still got the same error. So out of frustration I reloaded all the files instead of update files and it seems to cleared up. Thanks for your help Alan! Your great.