Add Record Does Not Work
- Single Page
Posted 20 July 2012 - 21:06 PM
For example, I can click "Add Record" fill out the fields and press "Save" and the first time I do this everything works fine.
The second time I try to add a new record, it does not work. Nothing is added to the table. Any Ideas?
Also, firebug in firefox gives the following warning: Use of getAttributeNode() is deprecated. Use getAttribute() instead.
When I press "Save" I get the following errors from Firebug:
"NetworkError: 500 Internal Server Error - http://mysite/intern...results/insert"
SyntaxError: JSON.parse: unexpected character
Posted 20 July 2012 - 22:37 PM
Database error:
[color=#4F5155]Duplicate entry '2147483647' for key 'PRIMARY'[/color]
[color=#4F5155]INSERT INTO `tablename` (`myID`, `tNum`, `ItemNum`, `mbID`, `owner`, `Num`, `xRank`, `Rank`, `yPoints`, `Points`, `date`) VALUES ('2022', '2022', '2022', '2022', '2022', '2022', '2022', '2022', '2022', '2022', '')[/color]
[color=#4F5155]Next, I am setting the primary key using set_primary_key('id', 'tablename') but, that did not work.[/color]
Posted 20 July 2012 - 22:53 PM