Forums

Hello ,please help, i retrive data (id,username,name) from "users" table to my form, it works fine, but then i want to save the data (id,username,name) in another table but it doesnt work, the new table has the same colum name , here is the Debbuger:
​
​

Data Array

Array
(
    [cont] => lists
    [ccname] => Busqueda_Pacientes
    [act] => view
    [gcb] => 163
    [chronoform] => Baja_Inventario
    [event] => submit
    [option] => com_chronoconnectivity5
    [Itemid] => 
    [lang] => es
    [Consulta_Pacientes] => Array
        (
            [id] => 163
            [username] => hugo11
            [name] => Hugo Esquer
        )

    [Numero_Procedimiento] => 02
    [ID_Codigo_barras] => 123456789
    [Descripcion] => Paracetamol
    [Cantidad] => 1
    [button6] => Guardar
    [language] => es-ES
    [idp] => 36
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [1] => Array
        (
            [DB Save] => Array
                (
                    [Queries] => Array
                        (
                            [0] => INSERT INTO `k1nuf_chronoengine_chronoforms_datatable_Baja_Inventario` (`Numero_Procedimiento`, `ID_Codigo_barras`, `Descripcion`, `Cantidad`, `button6`, `user_id`, `uniq_id`, `created`) values ('02', '123456789', 'Paracetamol', '1', 'Guardar', '123', 'd28b7ba474be254ea0b907303e8011a29bb6e052', '2019-09-25 14:20:37');
                        )

                )

        )

)

Hi angelmorales,
​
The MySQL query looks OK - what exactly doesn't work?
​
Have you tried testing the query using PHPMyAdmin to see if you get a more helpful error message?
​
Bob

The data in the following text boxes saves in the table without problems : (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion)But (id,username,name) doesnt saves in the table (i TRY TO UPLOAD IMAGES, BUT AN ERROR HAPPENS: "ERROR SAVING THE ATTACHMENT FILE", i try with .jpg, .png, .pdf but it doesnt seems to work )
I retrive the id,username,name data from "users" table, using chronoconnectivity, and it work fine, the data shows on the form , next I capture data in the rest of the textboxes: (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion), then I submit, but when i check the table in the data base only the data in the : (Nuevo_Procedimiento,ID_Codigo_barras,Descripcion) textboxes has been saved, (id,username,name) don't.
The field names of the textboxes are like this:
Consulta_Pacientes[id]
Consulta_Pacientes[username]
Consulta_Pacientes[name]
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
​
The column name's in the table are like this:
idp
uniq_id
user_id
created
modified
id
username
name
Numero_Procedimiento
ID_Codigo_barras
Descripcion
Cantidad
button6
​
Sorry but the "Upload file option" doesnt work, i try to attach images but i didnt work
Thanks for your help!