nuBuilder Forum

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)

It seems that an object with id Matricula is still on the form.

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

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 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.

Cause found: Saving does not work in preview mode.

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

Thanks you