The form browse/edit not save data in the table

Questions related to using nuBuilder Forte.

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

Unread postby jaimeandres3 » Thu Jul 29, 2021 11:34 pm

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)
jaimeandres3
 
Posts: 16
Joined: Thu Jul 22, 2021 11:40 pm
nuBuilder Version: 4.5

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

Unread postby kev1n » Thu Jul 29, 2021 11:37 pm

It seems that an object with id Matricula is still on the form.
kev1n
nuBuilder Team
 
Posts: 2013
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

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

Unread postby jaimeandres3 » Fri Jul 30, 2021 12:00 am

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
Attachments
PantallazoerroresNuBuilder.png
PantallazoerroresNuBuilder.png (20.93 KiB) Viewed 216 times
jaimeandres3
 
Posts: 16
Joined: Thu Jul 22, 2021 11:40 pm
nuBuilder Version: 4.5

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

Unread postby kev1n » Fri Jul 30, 2021 12:20 am

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.
kev1n
nuBuilder Team
 
Posts: 2013
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

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

Unread postby jaimeandres3 » Sat Jul 31, 2021 11:45 am

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.
jaimeandres3
 
Posts: 16
Joined: Thu Jul 22, 2021 11:40 pm
nuBuilder Version: 4.5

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

Unread postby kev1n » Thu Aug 05, 2021 5:15 am

Cause found: Saving does not work in preview mode.
kev1n
nuBuilder Team
 
Posts: 2013
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

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

Unread postby jaimeandres3 » Thu Aug 05, 2021 11:14 am

kev1n wrote:Cause found: Saving does not work in preview mode.

Thanks you
jaimeandres3
 
Posts: 16
Joined: Thu Jul 22, 2021 11:40 pm
nuBuilder Version: 4.5

Previous

Return to General

Who is online

Users browsing this forum: No registered users and 23 guests