SQL View provokes fatal error on edit/ Set readonly?
Posted: Wed Feb 01, 2012 11:32 pm
My DB has one view (SQL: CREATE VIEW...) composed of several joins (and self-joins). I can easily access this view as a list, browse the details or search it. As soon as I click on "edit" or "new record", xataface spits (see end of post). It isn't necessary that this view is editable, removing all buttons and links to edit functions would be good for me. How can I do this?
Thank you for your help.
Regards, Adrian.
More Infos:
- there are just ini Files, no delegate classes
- there are SQL queries in valuelists.ini
- the view is defined as
The error it throws, when clicking on "edit" in "detail" or "new record" in "list", is:
Thank you for your help.
Regards, Adrian.
More Infos:
- there are just ini Files, no delegate classes
- there are SQL queries in valuelists.ini
- the view is defined as
- Code: Select all
CREATE OR REPLACE VIEW established_link AS
SELECT startp.*, endp.device_id AS end_device_id, endp.name AS end_name,
startloc.building_id, endloc.building_id AS end_building_id,
startdev.location_id, enddev.location_id AS end_location_id,
startdev.device_type_id, enddev.device_type_id AS end_device_type_id
FROM port AS startp INNER JOIN port AS endp
ON startp.link_id = endp.link_id AND startp.id <> endp.id
LEFT JOIN switch_pp AS startdev
ON startp.device_id = startdev.id
LEFT JOIN switch_pp AS enddev
ON endp.device_id = enddev.id
LEFT JOIN location AS startloc
ON startdev.location_id = startloc.id
LEFT JOIN location AS endloc
ON enddev.location_id = endloc.id;
The error it throws, when clicking on "edit" in "detail" or "new record" in "list", is:
- Code: Select all
Fatal error: [html_quickform_error: message="unregistered element" code=-5 mode=return level=notice prefix="QuickForm Error: " info="Element 'tex' does not exist in HTML_QuickForm::_loadElement()"]On line 404 of file /usr/local/share/xataface-1.3rc6/Dataface/FormTool.php in function printStackTrace()
On line 345 of file /usr/local/share/xataface-1.3rc6/Dataface/QuickForm.php in function buildWidget(Dataface_Record Object,array(description,varchar(100),YES,,,,established_link,array(Beschreibung,,established_link.descript,Dataface_QuickForm Object,description,1,array(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,)
On line 486 of file /usr/local/share/xataface-1.3rc6/Dataface/QuickForm.php in function _buildWidget(array(description,varchar(100),YES,,,,established_link,array(Beschreibung,,established_link.descript,array(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,)
On line 53 of file /usr/local/share/xataface-1.3rc6/a in /usr/local/share/xataface-1.3rc6/Dataface/FormTool.php on line 404