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

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
Wael
 
Posts: 1
Joined: Wed Aug 14, 2019 5:13 pm

Return to Custom Code