SQL Error in nuRunQuery
Posted: Tue Jan 28, 2020 12:20 am
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)
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)