Aamir asked 10 years ago
Hi Abu,
Thanks for such a great tool.
I am using free version and planning to have a commercial one soon.
I have 17 columns in my database table [ mysql ]. When I try to update a record whether from inline editing or other method, grid updates only 11 columns and does not save 5 columns. I have checked these
1. Columns names are not Reserve Words
2. Grid is posting all the fields correctly i.e.
date=2013-06-11&unit_name=4&supervisor=4&docket_number=4&sale_date=2013-06-14&credit_reference=4&cost_centre=4&goods_9=4&vat_9=444&gross_9=4&goods_23=4&vat_23=4&gross_23=4&goods_total=4&vat_total=4&gross_total=4&oper=edit&id=8
3. Grid is not showing any errors in Firebug
Can you please assist what may be the problems?
Best Regards,
Aamir
Abu Ghufran answered 10 years ago
Either query will execute OR fail. There is no possibility to run for 11 columns and not others.
Please recheck your database data. Share the grid code for review if not resolved. You can use pastebin.com and share it's link on forum.
Aamir answered 10 years ago
Thanks for your response. I have pasted the code here
http://pastebin.com/r6qBKKzp
Abu Ghufran answered 10 years ago
Amir,
Please check the jqgrid_dist.php for this line …
$Vac5c74b6 = "UPDATE {$this->table} $V74c9e6d4 WHERE $V2dab5f16 = '$Vb80bb774'";
You can print this variable to know what actually UPDATE is going to database. Rest code seems fine.
