nuBuilder Forum

Posted: **Wed Aug 14, 2019 9:56 am**

Hi,
I installed nuBuilder on Windows 10 wampserver 3.1.9, PHP 7.3.5, This is my first web-base.
I have a forum with a select SQL list

Code: Select all

SELECT etablissement.*
FROM etablissement
	JOIN droits_etablissement ON etablissement.etablissement_id=droits_etablissement.right_etb_etb_id
    JOIN droits_utilisateur ON droits_etablissement.right_etb_user_id= droits_utilisateur.droits_utilisateur_id
    JOIN zzzzsys_user ON droits_utilisateur.right_user_user_id=zzzzsys_user.zzzzsys_user_id

if I save my form without changing the Select list i got this error

Code: Select all

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

globeadmin

===PDO MESSAGE=== 

SQLSTATE[42000]: Syntax error or access violation: 1064 Erreur de syntaxe près de 'WHERE `statistiques_id` = '16'' à la ligne 1

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

UPDATE statistiques SET  WHERE `statistiques_id` = '16';

===BACK TRACE====

C:\wamp64\www\hebergement\nudata.php - line 348 (nuRunQuery)

C:\wamp64\www\hebergement\nuapi.php - line 52 (nuUpdateDatabase)

Think's for your help

nuBuilder Forum

SQL error in nuRUNQuery when saving

SQL error in nuRUNQuery when saving