nuDebug errors

[giorgio58]

Good morning,
I upgraded nuBuilder Forte to the latest version, downloaded from https://sourceforge.net/projects/nubuil ... t/download, but, in nuDebug, I see many errors that I didn't see before.

many

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====

/var/www/html/nuBuilder.new/nuform.php - line 350 (nuRunQuery)

/var/www/html/nuBuilder.new/nuform.php - line 331 (nuBrowseTotals)

/var/www/html/nuBuilder.new/nuapi.php - line 41 (nuGetFormObject)

and

Code: Select all

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

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'nubuilder4.___nu15e0f6215bd0b7___'

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

DROP TABLE ___nu15e0f6215bd0b7___

===BACK TRACE====

/var/www/html/nuBuilder.new/nucommon.php - line 943 (nuRunQuery)

/var/www/html/nuBuilder.new/nureportdesigner.php - line 29 (nuTTList)

and others where table names like 'nubuilder4 .___ nu15e0f6215bd0b7___' not present in the database are displayed.

With the previous version, no errors.

What can it depend on?

I also tried to perform a 'clean' installation, but the errors remain.

Use:
Debian buster,
Server version: Apache / 2.4.38 (Debian)
php 7.3.11-1 ~ deb10u1,
MariaDb Ver 15.1 Distrib 10.4.11-MariaDB

[admin]

giorgio58,

Delete them and see if they come back.


Steven

[giorgio58]

Yes, they reappear immediately.
The errors are generated at the entrance in any screen.

Screenshot_20200104_105012.png

[kev1n]

Looking at the error message, the error is caused by the nuBrowseTotals() function.

Quick fix: Edit nuform.php replace this code (line 331)

Code: Select all

$f->browse_totals		= nuBrowseTotals($f);

with this code:

Code: Select all

	if ($f->browse_sql !== null) {
		$f->browse_totals	= nuBrowseTotals($f);	
	}	

Log in again into nuBuilder and the error is gone!

[jtoonen]

Thanx keep debug empty!!

[giorgio58]

Okay, the first problem is solved.
There are still these errors not present in the previous version:

Code: Select all

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

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nubuilder4.___nu15e10a7abd10e0___' 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 ___nu15e10a7abd10e0___ 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 AND ( (CONVERT(sob_all_type USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(sob_input_type USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(sob_all_id USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(zzzzsys_form_id USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(sob_all_label USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(sfo_description USING utf8) LIKE  "%5b8bf058a4ecf0c%" OR CONVERT(syt_title USING utf8) LIKE  "%5b8bf058a4ecf0c%") )

===BACK TRACE====

/var/www/html/nuBuilder.new/nuform.php - line 353 (nuRunQuery)

/var/www/html/nuBuilder.new/nuform.php - line 333 (nuBrowseTotals)

/var/www/html/nuBuilder.new/nuapi.php - line 41 (nuGetFormObject)

and

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 '),(select anagra_denominazione from anagra where anagra_key = preventivi_id_mitt' at line 3

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

SELECT SUM(preventivi_data) AS total_0,SUM(preventivi_numero) AS total_1,SUM(preventivi_operatore) AS total_2,SUM((select anagra_denominazione from anagra where anagra_key = preventivi_id_richiedente)) AS total_3,SUM((select anagra_denominazione from anagra where anagra_key = preventivi_id_mittente)) AS total_4,SUM((select nazioni_denominazione from nazioni where nazioni_key = preventivi_id_nazione_destinazione)) AS total_5,SUM(preventivi_destinazione) AS total_6,SUM((select modo_spedizione_descrizione from modo_spedizione where modo_spedizione_key = preventivi_id_modo_spedizione)) AS total_7,SUM(REPLACE(REPLACE(preventivi_valuta,1,'USD'),0,'EUR')) AS total_8,SUM(preventivi_quotazione) AS total_9,SUM(preventivi_costo) AS total_10,SUM(preventivi_profitto) AS total_11,SUM(preventivi_utile) AS total_12,SUM(preventivi_fatturato) AS total_13
 from anagra
 where anagra_key = preventivi_id_richiedente),(select anagra_denominazione from anagra where anagra_key = preventivi_id_mittente),(select nazioni_denominazione from nazioni where nazioni_key = preventivi_id_nazione_destinazione),preventivi_destinazione,(select modo_spedizione_descrizione from modo_spedizione where modo_spedizione_key = preventivi_id_modo_spedizione),REPLACE(REPLACE(preventivi_valuta,1,'USD'),0,'EUR'),preventivi_quotazione,preventivi_costo,preventivi_profitto,preventivi_utile,preventivi_fatturato  FROM   preventivi  WHERE      (         (             ('#OperatoreFilter#' = 'true') AND             (preventivi_operatore = 'globeadmin' OR preventivi_operatore = 'globeadmin' OR preventivi_operatore IN (SELECT sus_login_name FROM zzzzsys_user WHERE zzzzsys_user_id = 'globeadmin'))         )         OR         ('#OperatoreFilter#' <> 'true')     )     AND     (         (             ('#FatturatoFilter#' = 'true') AND (preventivi_fatturato = 'false')         )         OR         ('#FatturatoFilter#' <> 'true')     ) 
 ORDER BY preventivi_data DESC, preventivi_numero DESC

===BACK TRACE====

/var/www/html/nuBuilder.new/nuform.php - line 353 (nuRunQuery)

/var/www/html/nuBuilder.new/nuform.php - line 333 (nuBrowseTotals)

/var/www/html/nuBuilder.new/nuapi.php - line 41 (nuGetFormObject)

[kev1n]

Try excluding the line:

Code: Select all

// $f->browse_totals      = nuBrowseTotals($f);

[giorgio58]

ok thanks, no more errors

[admin]

people,

That has now been removed.


Steven