You have an error in your SQL syntax

Questions related to using nuBuilder Forte.

You have an error in your SQL syntax

Postby ARWEN » Sat Jan 18, 2020 7:56 pm

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)




Attachments
nurrunqueryy sql error.PNG
nurrunqueryy sql error.PNG (45.81 KiB) Viewed 125 times
ARWEN
 
Posts: 61
Joined: Thu Nov 01, 2018 2:31 pm

Re: You have an error in your SQL syntax

Postby admin » Mon Jan 20, 2020 7:48 am

ARWEN,

This has been fixed now.


Steven
admin
Site Admin
 
Posts: 3211
Joined: Mon Jun 15, 2009 9:53 am

Re: You have an error in your SQL syntax

Postby ARWEN » Mon Jan 20, 2020 2:14 pm

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)
ARWEN
 
Posts: 61
Joined: Thu Nov 01, 2018 2:31 pm

Re: You have an error in your SQL syntax

Postby kev1n » Mon Jan 20, 2020 4:17 pm

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
 
Posts: 471
Joined: Mon Oct 15, 2018 2:13 am

Re: You have an error in your SQL syntax

Postby kev1n » Thu Jan 23, 2020 9:12 am

kev1n
 
Posts: 471
Joined: Mon Oct 15, 2018 2:13 am


Return to General