Form Submission Errors
Archived from the Xataface Users forum.
muzafar — Wed Mar 28, 2012 11:38 pm
Greetings,
I am facing the following problem while submitting the form.
“[Thu Mar 29 10:25:00 2012] [error] [client 182.183.238.137] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Attempt to use array in query clause’ in /var/www/xata/Dataface/QueryBuilder.php:502\nStack trace:\n#0 /var/www/xata/Dataface/QueryBuilder.php(664): Dataface_QueryBuilder->_fieldWhereClause(Array, Array, true, ‘tbl_application’)\n#1 /var/www/xata/Dataface/QueryBuilder.php(258): Dataface_QueryBuilder->_where(Array)\n#2 /var/www/xata/Dataface/QueryTool.php(120): Dataface_QueryBuilder->select_num_rows()\n#3 /var/www/xata/Dataface/QueryTool.php(531): Dataface_QueryTool->Dataface_QueryTool(‘tbl_application’, Resource id #12, Array)\n#4 /var/www/xata/Dataface/Application.php(1389): Dataface_QueryTool::loadResult(‘tbl_application’, Resource id #12, Array)\n#5 /var/www/xata/Dataface/Application.php(1418): Dataface_Application->getResultSet()\n#6 /var/www/xata/Dataface/Application.php(1601): Dataface_Application->getRecord()\n#7 /var/www/xata/Dataface/Application.php(1620): Dataface_Application->getPermissions()\n#8 /var/www/xata/Dataface/ActionTool.php(236): Dataface_Application->ch in /var/www/xata/Dataface/QueryBuilder.php on line 502”
The form contains almost all the widgets including multi-select but it is not a grid enabled form. Does anybody face the same above problem? kindly lead me.
your help will be greatly appreciated.
shannah — Thu Mar 29, 2012 9:56 am
What version of Xataface, PHP, MySQL? What is the table def and associated fields.ini file configuration? Does this happen for all input or only some input?
-Steve
muzafar — Fri Mar 30, 2012 12:10 am
we are using the following versions.
xataface version 1.5
Php : 5.3.6
Mysql : 5.1.61
The error occurring in very rare cases for just few users while submitting the application. It happens only sometime, and it’s hard to point that it’s occurring by all input fields or some input.
shannah — Fri Mar 30, 2012 9:31 am
Can you provide a test case. E.g. The create table statement for the table in question, and the associated fields.ini file.