Peter Moh asked 11 years ago
I download phpGrid lite for testing.
It is vrey good to display data from databse.
It seems phpGrid has many build in functions to allow add new record and edit a selected record.
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.
Abu Ghufran answered 11 years ago
Hello,
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
Ben Walter answered 11 years ago
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','','','','','','','','','','','','','','','','','','','','')
Abu Ghufran answered 11 years ago
Hello,
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.
Ben Walter answered 11 years ago
Ah ha! I changed Release to ReleaseNo and still had no luck. But your suggestion got me thinking – so I changed Load to LoadNo and now it works.
Thank you!
