Trying to edit the grid but show unkonwn coloumn

QuestionsTrying to edit the grid but show unkonwn coloumn
Bhavesh Garg asked 4 years ago

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

5 Answers
Abu Ghufran answered 4 years ago

Hello,

Please email me sample database sql dump to regenerate case.
You can email me at [email protected]

Bhavesh Garg answered 4 years ago

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.

Abu Ghufran answered 4 years ago

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.

Abu Ghufran answered 4 years ago

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.

Bhavesh Garg answered 4 years ago

Thanks for the help. Is there anyway to bypass it?

Your Answer

0 + 17 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?