Welcome to the nuBuilder Forums!

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

The form browse/edit not save data in the table

Questions related to using nuBuilder Forte.
jaimeandres3
Posts: 16
Joined: Thu Jul 22, 2021 4:10 pm

Re: The form browse/edit not save data in the table

Unread post by jaimeandres3 »

kev1n wrote:Are there absolutely no errors in nuDebug Results (CTRL+SHIFT D) and Developer Console (F12)?
I have next problems:

[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'Matricula' specified twice

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

INSERT INTO alumnos (Matricula, `Matricula`, `Nombre`, `Direccion`, `Telefono`, `Nocarrera_1`) VALUES ('60f98007d5842b5', '5', 'jjj', 'vwer', '345667', '3454');

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\core\nudata.php - line 419 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\core\nuapi.php - line 71 (nuUpdateDatabase)

[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'Matricula' specified twice

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

INSERT INTO alumnos (Matricula, `Matricula`, `Nombre`, `Direccion`, `Telefono`, `Nocarrera_1`) VALUES ('60f96e14d9d0678', '6', 'sdvqe', 'efef', '33525', '3455');

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\core\nudata.php - line 419 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\core\nuapi.php - line 71 (nuUpdateDatabase)

[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42000]: Syntax error or access violation: 1110 Column 'Matricula' specified twice

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

INSERT INTO alumnos (Matricula, `Matricula`, `Nombre`, `Direccion`, `Telefono`, `Nocarrera_1`) VALUES ('60f96da1689276b', '3', 'swww', 'rtybg', '2345', '23456');

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\core\nudata.php - line 419 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\core\nuapi.php - line 71 (nuUpdateDatabase)

[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 'Matricula,Nombre,Direccion,Telefono,Nocarrera_1
FROM alumnos
WHERE 1 LIMIT 0...' at line 1

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

SELECT ,Matricula,Nombre,Direccion,Telefono,Nocarrera_1
FROM alumnos
WHERE 1 LIMIT 0, 20

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\core\nuform.php - line 1027 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\core\nuform.php - line 392 (nuBrowseRows)

C:\xampp\htdocs\nubuilder4\core\nuapi.php - line 61 (nuGetFormObject)

[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause'

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

Select * FROM `alumnos` WHERE `` = ?

===BACK TRACE====

C:\xampp\htdocs\nubuilder4\core\nuform.php - line 137 (nuRunQuery)

C:\xampp\htdocs\nubuilder4\core\nuapi.php - line 61 (nuGetFormObject)
kev1n
nuBuilder Team
Posts: 4305
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 446 times
Contact:

Re: The form browse/edit not save data in the table

Unread post by kev1n »

It seems that an object with id Matricula is still on the form.
jaimeandres3
Posts: 16
Joined: Thu Jul 22, 2021 4:10 pm

Re: The form browse/edit not save data in the table

Unread post by jaimeandres3 »

kev1n wrote:It seems that an object with id Matricula is still on the form.
I deleted all errors. I deleted forms and create new form browse/edit.
Not save data and not show none error.
Attachment print screen
You do not have the required permissions to view the files attached to this post.
kev1n
nuBuilder Team
Posts: 4305
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 446 times
Contact:

Re: The form browse/edit not save data in the table

Unread post by kev1n »

I really don't know what the reason could be.
Unless I somehow get direkt access to the database so I can look at it.
jaimeandres3
Posts: 16
Joined: Thu Jul 22, 2021 4:10 pm

Re: The form browse/edit not save data in the table

Unread post by jaimeandres3 »

kev1n wrote:I really don't know what the reason could be.
Unless I somehow get direkt access to the database so I can look at it.
if you want I can give you access by anydesk to my PC.
What time UTC -5 Bogotá, Lima Quito.
kev1n
nuBuilder Team
Posts: 4305
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 446 times
Contact:

Re: The form browse/edit not save data in the table

Unread post by kev1n »

Cause found: Saving does not work in preview mode.
jaimeandres3
Posts: 16
Joined: Thu Jul 22, 2021 4:10 pm

Re: The form browse/edit not save data in the table

Unread post by jaimeandres3 »

kev1n wrote:Cause found: Saving does not work in preview mode.
Thanks you
Post Reply