PHP errors with Dynamic Valuelists

Archived from the Xataface Users forum.

psylem — Sun May 15, 2011 5:12 am

Hi I just downloaded and installed xataface and created my first Dynamic Valuelists. It has 28 entries and appears to be working perfectly, except on the form page I get the following PHP errors:

Code: Select all
On line 3538 of file /var/www/localhost/xataface/Dataface/Table.php in function printStackTrace() On line 479 of file /var/www/localhost/xataface/Dataface/Relationship.php in function absoluteFieldName(ID,array(building_types),Resource id #11) On line 373 of file /var/www/localhost/xataface/Dataface/Relationship.php in function _normalizeColumns() On line 105 of file /var/www/localhost/xataface/Dataface/Relationship.php in function _init(array(SELECT ID, name FROM building_types where name <> 'Unknown' ORDER BY id)) On line 1839 of file /var/www/localhost/xataface/Dataface/Table.php in function Dataface_Relationship(buildings,Types__valuelist,array(SELECT ID, name FROM building_types where name <> 'Unknown' ORDER BY id)) On line 200 of file /var/www/localhost/xataface/Dataface/ValuelistTool.php in function addRelationship(Types__valuelist,array(SELECT ID, name FROM building_types where name <> 'Unknown' ORDER BY id)) On line 43 of file /var/www/localhost/xataface/Dataface/FormTool/select.php in function asRelationship(Dataface_Table Object,Types) On line 393 of file /var/www/localhost/xataface/Dataface/FormTool.php in function buildWidget(Dataface_Record Object,array(type,int(11),NO,,,,buildings,array(Type,,buildings.type.label,buildings.type.description,,,,se,Dataface_QuickForm Object,type,) On line 345 of file /var/www/localhost/xataface/Dataface/QuickForm.php in function buildWidget(Dataface_Record Object,array(type,int(11),NO,,,,buildings,array(Type,,buildings.type.label,buildings.type.description,,,,se,Dataface_QuickForm Object,type,,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 /var/www/localhost/xataface/Dataface/QuickForm.php in function _buildWidget(array(type,int(11),NO,,,,buildings,array(Type,,buildings.type.label,buildings.type.description,,,,se,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 68 of file /var/www/localhost/xataface/actions/edit.php in function _build() On line 1214 of file /var/www/localhost/xataface/Dataface/Application.php in function handle(array(array(Edit,/localhost/apps/bym/index.php?-table=buildings&-action=edit&-cursor=0&-skip=0) On line 1714 of file /var/www/localhost/xataface/Dataface/Application.php in function handleRequest() On line 5 of file /var/www/localhost/apps/bym/index.php in function display()

(had to remove http thing from the code to allow me to post here)

The valuelist looks like this:

Code: Select all
[Types] __sql__ = "SELECT ID, name FROM building_types where name <> 'Unknown' ORDER BY id"

shannah — Sun May 15, 2011 12:30 pm

This should be fixed in the latest SVN:
You should just be able to update your Dataface/Table.php to the latest:
http://weblite.ca/svn/dataface/core/tru … /Table.php

-Steve