Page 1 of 1

You have an error in your SQL syntax

Posted: Sat Jan 18, 2020 11:26 am
by ARWEN
I Installed the latest nuBuilder from sourceforge and just seen that there are hundreds of error message in the debug window.
Deleted all and they keep coming back.

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE 1' at line 2

===SQL=========== 

SELECT 
WHERE 1

===BACK TRACE====

C:\xampp\htdocs\nuBuilder\nuform.php - line 350 (nuRunQuery)

C:\xampp\htdocs\nuBuilder\nuform.php - line 331 (nuBrowseTotals)

C:\xampp\htdocs\nuBuilder\nuapi.php - line 42 (nuGetFormObject)





Re: You have an error in your SQL syntax

Posted: Sun Jan 19, 2020 11:18 pm
by admin
ARWEN,

This has been fixed now.


Steven

Re: You have an error in your SQL syntax

Posted: Mon Jan 20, 2020 5:44 am
by ARWEN
The error still appears after updating. (open objects form for instance)

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nuBuilder4).___nu15e252f1129acb___' doesn't exist

===SQL=========== 

SELECT SUM(sob_all_type) AS total_0,SUM(sob_input_type) AS total_1,SUM(sob_all_id) AS total_2,SUM(zzzzsys_form_id) AS total_3,SUM(sob_all_label) AS total_4,SUM(sfo_description) AS total_5,SUM(syt_title) AS total_6
 FROM zzzzsys_object JOIN ___nu15e252f1129acb___ ON zzzzsys_object_id = theid JOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id JOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id
 WHERE 1

===BACK TRACE====

C:\xampp\htdocs\nuBuilder/nuform.php - line 356 (nuRunQuery)

C:\xampp\htdocs\nuBuilder/nuform.php - line 335 (nuBrowseTotals)

C:\xampp\htdocs\nuBuilder/nuapi.php - line 41 (nuGetFormObject)

Re: You have an error in your SQL syntax

Posted: Mon Jan 20, 2020 7:47 am
by kev1n
Guys, the error occurs with forms that use a temporary table. At the time the SQL is executed in nuRunQuery(), the temporary table no longer exists.

Re: You have an error in your SQL syntax

Posted: Thu Jan 23, 2020 12:42 am
by kev1n