Page Load Errors - Problems Debugging

[courtharris]

I have turned debug on, but I am continuing to get errors in the header of the page that loads to edit a record. I am using an existing database that was transferred from MS Access to mysql. Any ideas on where I can locate the exact error that is occurring?

I had to remove the exact URL due to forum restrictions on new users.


On line 3538 of file Table in function printStackTrace()
On line 479 of file Relationship in function absoluteFieldName(branch,array(tblBranches),Resource id #11)
On line 373 of file Relationship in function _normalizeColumns()
On line 105 of file Relationship in function _init(array(select ID,branch from tblBranches order by ID asc))
On line 1839 of file Table in function Dataface_Relationship(tblEmployees,Branch__valuelist,array(select ID,branch from tblBranches order by ID asc))
On line 200 of file ValuelistTool in function addRelationship(Branch__valuelist,array(select ID,branch from tblBranches order by ID asc))
On line 43 of file select in function asRelationship(Dataface_Table Object,Branch)
On line 393 of file FormTool in function buildWidget(Dataface_Record Object,array(BranchID,int(11),YES,,,,tblEmployees,array(BranchID,,tblEmployees.BranchID.label,tblEmployees.,Dataface_QuickForm Object,BranchID,)
On line 345 of file QuickForm in function buildWidget(Dataface_Record Object,array(BranchID,int(11),YES,,,,tblEmployees,array(BranchID,,tblEmployees.BranchID.label,tblEmployees.,Dataface_QuickForm Object,BranchID,,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 QuickForm in function _buildWidget(array(BranchID,int(11),YES,,,,tblEmployees,array(BranchID,,tblEmployees.BranchID.label,tblEmployees.,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 edit in function _build()
On line 1222 of file Application.php in function handle(array(array(Edit,?-table=tblEmployees&-action=edit&-cursor=0&-ski)
On line 1728 of file Application.php in function handleRequest()
On line 5 of file index.php in function display()
Block "custom_stylesheets2"
Block "head"
Block "body_atts">
Block "before_body"

[shannah]

I see a stack trace but not the error message the originated it. Perhaps turn off debug, and check your error log to see what the error is.

-Steve

[courtharris]

Found the error in the error.log - it looks like maybe something due to the data formatting?


[Wed Oct 19 17:56:53 2011] [error] [client 65.46.56.66] Notice: Valuelist sql query failed: select NameFirst,NameLast from tblEmployees where tblEmployees.ID = sbtEmployeeType.EmployeeID: Unknown column 'sbtEmployeeType.EmployeeID' in 'where clause'On line 75 of file /var/www/domains/web/public_html/xataface/Dataface/ValuelistTool. in function printStackTrace()\n<br>On line 28 of file /var/www/domains/web/public_html/xataface/Dataface/ValuelistTool. in function _loadValuelistsIniFile()\n<br>On line 94 of file /var/www/domains/web/public_html/xataface/Dataface/ValuelistTool.

[shannah]

Yes. You have a problem with that query. Fix the query, and you fix your error.