Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

SQL error in nuRUNQuery when saving

Questions related to customising nuBuilder Forte with JavaScript or PHP.
Wael
Posts: 1
Joined: Wed Aug 14, 2019 9:43 am

SQL error in nuRUNQuery when saving

Unread post by Wael »

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
Post Reply