error after save

Questions related to using nuBuilder Forte.

error after save

Postby johan » Fri Jan 10, 2020 4:29 am

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?
johan
 
Posts: 306
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: error after save

Postby kev1n » Fri Jan 10, 2020 4:38 am

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.
kev1n
 
Posts: 841
Joined: Mon Oct 15, 2018 2:13 am

Re: error after save

Postby johan » Fri Jan 10, 2020 6:50 am

It's only in one form.
johan
 
Posts: 306
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: error after save

Postby kev1n » Fri Jan 10, 2020 12:52 pm

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?
kev1n
 
Posts: 841
Joined: Mon Oct 15, 2018 2:13 am

Re: error after save

Postby johan » Sat Jan 11, 2020 7:06 pm

Kevin

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

Thanks again.
Johan
johan
 
Posts: 306
Joined: Sun Feb 27, 2011 7:46 pm
Location: Belgium

Re: error after save

Postby admin » Sun Jan 12, 2020 7:01 am

.
admin
Site Admin
 
Posts: 3309
Joined: Mon Jun 15, 2009 9:53 am


Return to General