Page 1 of 1

SQL Error in nuRunQuery

Posted: Tue Jan 28, 2020 12:20 am
by marc
Hi,

I see a lot of these messages in nuDebug Results. What does it mean?

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

globeadmin

===PDO MESSAGE===

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nuBuilder4.___nu15e2f6f6195151___' 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 ___nu15e2f6f6195151___ 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====

/home/html/nuBuilder4/nuform.php - line 356 (nuRunQuery)

/home/html/nuBuilder4/nuform.php - line 335 (nuBrowseTotals)

/home/html/nuBuilder4/nuapi.php - line 41 (nuGetFormObject)

Re: SQL Error in nuRunQuery

Posted: Tue Jan 28, 2020 9:51 pm
by admin
marc,

Remove them and see if they reappear.


Steven

Re: SQL Error in nuRunQuery

Posted: Tue Jan 28, 2020 10:02 pm
by kev1n
Hi,

This is a known "bug" & has been reported by other users as well:

https://github.com/smalos/nuBuilder4-Bu ... _Errors.md

Re: SQL Error in nuRunQuery

Posted: Thu Jan 30, 2020 10:42 pm
by admin
Now fixed.