When I am trying to edit the grid using "db-table-grid.php", it shows an error: Couldn't execute query. Unknown column 'Sales_Doc__No' in 'field list' – UPDATE pod SET.
Please help
Hello,
Please email me sample database sql dump to regenerate case.
You can email me at [email protected]
Have mailed you the sql dump.Now can you please help me to sort out the problem. It's showing the same error when i try to add new data.
Your table field names contains ".", " ", "/" characters which are not allowed due to JS code mapping limitations.
Rename table field names, and use only _ sign as separator. It should work after that.
Currently it's not supported in php grid as this is variable name requirement by Javascript.
Another long solution could be to alias these fields ( characters replaced with _ ) and write your callback funtions on_insert / on_update where you replace them again to actual database name.
I've not verified second solution, and custom events need full version copy.