Auto Increment (auto-increment) Field validation Due to Underscore Character in Primary Key

It was a strange issue, but if there is underscore "_" character in your primary key, it will cause the validation to fail when edit or add new records.

It may be a phpGrid limitation. For now don't use underscore in table or column names. Sorry for the inconvenience. 


Datagrid Edit

  1. Constant value in create/edit form
  2. Display column in grid but hide when edit
  3. inline editing limited to single cell
  4. Get value from a specific cell from selected row
  5. phpGrid insert error - Need to hide primary key during edit
  6. Unable to edit
  7. Use arrow key to navigate a grid
  8. WYSIWYG doesn't work
  9. Editable Datagrid with Add Only Ability
  10. Change edit properties without modifying the source code
  11. Auto Increment (auto-increment) Field validation Due to Underscore Character in Primary Key
  12. CRUD (Create, Remove, Update, Delete) Not Working
  13. Dropdown Concatenation
  14. How to preserve a value of NULL as on update as it is being set to 0
  15. Cannot save or edit records. How to debug?
  16. Show a column as link based on value of another column
  17. Verify uniqueness of a new value entered when edited or added through phpGrid before saving
  18. Soft-delete record by flagging a value (Flag for delete)
  19. Must fill every fields to save, or nothing gets saved!
  20. Displaying TIMESTAMP Fields in an Editable Grid
  21. Datetime Format
  22. Create edit type "select" options manually from SQL query
  23. Datetime in datepicker
  24. Access local array data source
  25. How to Obtain Entire Datagrid Data as an Array?
  26. Center Add/Edit Form
  27. Save stored value in PHP Session when inserting
  28. Save Local Data Array Back to Server via Ajax
  29. How to set the "select" col_edittype be readonly?
  30. Dynamic dropdown based on cell value in a row.
  31. How to Increase Size of Multiple Select in Edit Form
  32. Save Data in Calculated/Virtual Column to Database
  33. Sorting columns with Key-Value pairs when edit type is "select"
  34. Sorting columns with Key-Value pairs when edit type is "select"
  35. Week start on Monday
  36. How to grab the table rows in a grid
  37. How to view Sql generated during CRUD?
  38. How to show remaining characters in a field on the edit form?
  39. Use Inner Join
  40. Custom button in action column
  41. Edit Grid of a JOIN or a complex query
  42. How do I make lookup fields (id fields referencing to other table) make dropdown from other table?
  43. Capture time stamp on submit
  44. Sample code to save local array back to database with custom edit script
  45. How to Create a Confirm Dialog Box Before Submit a Change?

Feedback and Knowledge Base