nuBuilder Forum

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)

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)

Code: Select all

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

Code: Select all

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

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)

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)

Code: Select all

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