Welcome to the nuBuilder Forums!

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

error after save

Questions related to using nuBuilder Forte.
Post Reply
johan
Posts: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

error after save

Unread post by johan »

Hi
I'm getting this error after save.


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 `zzzzsys_user_id` = '5d760b862083de1'' at line 1

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

UPDATE zzzzsys_user SET  WHERE `zzzzsys_user_id` = '5d760b862083de1';

===BACK TRACE====

/var/www/html/vrijwilligers/nudata.php - line 346 (nuRunQuery)

/var/www/html/vrijwilligers/nuapi.php - line 52 (nuUpdateDatabase)
I think my sql is correct. When I browse and open a form, everything is shown correct.
Any idea?
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: error after save

Unread post by kev1n »

johan wrote:Hi
I'm getting this error after save.
Does the error occur in just form one form or in any? Without more details it is probably difficult to say what goes wrong.
johan
Posts: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

Re: error after save

Unread post by johan »

It's only in one form.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: error after save

Unread post by kev1n »

Since the error occurs while saving the form, it has nothing to do with the Browse SQL? Is it possible to upload an SQL dump of your db containing just that form?
johan
Posts: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

Re: error after save

Unread post by johan »

Kevin

I've made a typing error. Now it's solved.

Thanks again.
Johan
admin
Site Admin
Posts: 2815
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: error after save

Unread post by admin »

.
Post Reply