Unable to use "values defined by table" on a foreign key
VFront is a dynamic front-end for MySQL, PostgreSQL and SQLite DBs.
Status: Beta
Brought to you by:
marciuz
Menu
▾
▴
#30 Unable to use "values defined by table" on a foreign key
Hi,
I try 0.99.2 on Mac yosemite and 0.99.3 on ubuntu 14.04 with firefox and I'm unable to use the input type "values defined by table" on foreign key. On mac I obtain the correct from view with the correct list for this key but no grid view and with ubuntu 0.99.3 I obtain an error message :
Filesystem write error for JSON file
My SQL is "SELECT id,name FROM author" for the table.
If I delete this option and let a integer from the foreign key, it's work fine.
It seems to be a misconfiguration of filesystem permission, not a bug.
Please check if the files folder and subfolders are writable from the apache user (if you are using Apache). Or check directly on admin/vfront.info.php script the situation of the folders...
It was the case for the ubuntu machine, now all the subfolders are writable and I have the 2 machines (mac and ubuntu) with the same probleme. The input "Values defines by table" work fine in a form view but my grid view is empty without any error message. If I let the integer for the foreign key I obtain a grid view.