nuBuilder Forum

Posted: **Thu Jan 09, 2020 7:59 pm**

Hi
I'm getting this error after save.

[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?

Posted: **Thu Jan 09, 2020 8:08 pm**

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.

Posted: **Thu Jan 09, 2020 10:20 pm**

It's only in one form.

Posted: **Fri Jan 10, 2020 4:22 am**

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?

Posted: **Sat Jan 11, 2020 10:36 am**

Kevin

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

Thanks again.
Johan

Posted: **Sat Jan 11, 2020 10:31 pm**

nuBuilder Forum

error after save

error after save

Re: error after save

Re: error after save

Re: error after save

Re: error after save

Re: error after save