SQL error in nuRUNQuery when saving

Questions related to customising nuBuilder Forte with Javascript or PHP.

SQL error in nuRUNQuery when saving

Postby Wael » Wed Aug 14, 2019 5:26 pm

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] :



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


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


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

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

Think's for your help
Posts: 1
Joined: Wed Aug 14, 2019 5:13 pm

Return to Custom Code