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 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.
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.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?