Xataface Forums

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.

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

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.

Can you provide a test case. E.g. The create table statement for the table in question, and the associated fields.ini file.