But after I clicking Submit button to save a new added row or edited row, I check the result from phpMyAdmin or using SQL from command line. It is found that no row was added and the edited row has not been changed.
Please let me know how to make it work.
Please check out the FAQ .. q#1 for debugging purpose and let me know the json result.
Note: We only provide solution related to the product at http://www.phpgrid.org/download
I have having the same issues. I'm interested in purchasing but I am not able to get this to work. It displays data fine. Unable to perform any CRUD operations though.
Here is the error I received.
Oh and an FYI – Chrome will also let you view this – Tools –> Developer Tools
Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Release,Load,Shipper,ShipCity,ShState,PUDate,PUInfo,Consignee,ConsCity,ConsState' at line 1 – INSERT INTO tblSchedule (ID,Release,Load,Shipper,ShipCity,ShState,PUDate,PUInfo,Consignee,ConsCity,ConsState,DelDate,DelInfo,Carrier,BaseRate,FSC,Lumper,Detention,Total,OneidaLoad,Notes,Complete) VALUES ('3','987456431','','','','','','','','','','','','','','','','','','','','')
RELEASE is a keyword in mysql, so that might be causing issue.
Although fix is required in lib to use `release` instead of just keyword, but quick solution would be to rename field.
I'll add it in todos for coming build.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!