2. PHPRunner General questions
  3. [SOLVED]  Insert to another table issue
This topic is locked
[SOLVED]

 Insert to another table issue

 		12/31/2011 8:08:53 AM
PHPRunner General questions
A
 Athlon author

Because of the great help I get from this forum,I thought I would post this just in case other experience what I did as a newbie. I spent hours and could not figure why it was not doing as it should.
Trying to insert a new record into another table after new user created will not work on the normal user table (even though it updates) if you have dynamic enabled. You must put the code on the dynamic Admin_user table or you will get primary key duplicate error, even though the key is auto increment.. no idea why or how it can even do that error on a primary key on a new record.
Sure this is obvious to experienced users but it took me ages to discover this simple thing. Hope it helps others.
Sergey Kornilov admin 1/2/2012

Could you clarify what 'dynamic enabled' means?
A
 		Athlon author 1/2/2012

Sorry - Dynamic permissions.
Sergey Kornilov admin 1/2/2012

Not really sure how dynamic permissions are relevant here unless you trying to add a new record to one of tables that handle dynamic permissions (which you should not be doing directly).
I guess we need more info about your setup. Probably this is not related to dynamic permissions and there is something else that produces this issue.
If you need more help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.