You have an error in your SQL syntax

[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)

[admin]

ARWEN,

This has been fixed now.


Steven

[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)

[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.

[kev1n]

Temporary fix: https://github.com/smalos/nuBuilder-Bug ... _Errors.md