Forums

Hi,

i have a form called prossug, and in the config it's linked to the table jos_chronoforms_prossug, which was created with chronoforms. i set database connection to yes but all data isn't saved in my database.

all field's can be NULL in my form AND in my database... how can i know which is the SQL statement that my form is sending to my DB?

can someone helpme please!!

Here you can download my form (attached)

Hi iAleX,

The form code looks OK - except that it is very big, 130 inputs.

I couldn't get ChronoForms to create a table - without changing the column types to something smaller than VARCHAR(255) so I haven't tested the DB Save.

You can see the DB query by setting Site | Global Confuguration | Debug to 'Yes' temporarily. All of the Joomla! DB queries are then shown at the bottom of the page.

Are you sure that all of the columns have been created in the database table?

Bob

hi, i set debug mode ON and there isn't any INSERT query when i do submit!!!

i attached my sql script (i modified my form's column type to varchar(3) - i don't modified chrono_contact columns... like cf_id and uid for example)

i can see some querys like:

SELECT * 
  FROM jos_session 
  WHERE session_id = '2a24db8250f02d77f6ed2986d1c53475'
DELETE 
  FROM jos_session 
  WHERE ( time < '1291056613' )
SELECT * 
  FROM jos_session 
  WHERE session_id = '2a24db8250f02d77f6ed2986d1c53475'

SELECT * 
  FROM jos_components 
  WHERE parent = 0
SELECT folder AS type, element AS name, params 
  FROM jos_plugins 
  WHERE published >= 1 
  AND access <= 0 
  ORDER BY ordering
SELECT m.*, c.`option` AS component 
  FROM jos_menu AS m 
  LEFT JOIN jos_components AS c 
  ON m.componentid = c.id 
  WHERE m.published = 1 
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `name` = 'prossug'
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `name` = 'prossug'
SELECT * 
  FROM `jos_chrono_contact_emails` 
  WHERE `formid` = '16' 
  ORDER BY emailid
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `id` = '16'
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `id` = '16'
SELECT * 
  FROM `jos_chrono_contact_plugins` 
  WHERE `form_id` = '16' 
  AND event IN ('ONSUBMIT','ONLOADONSUBMIT') 
  AND `name` = ''
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `id` = '16'
SELECT * 
  FROM `jos_chrono_contact_plugins` 
  WHERE `form_id` = '16' 
  AND event IN ('ONSUBMIT','ONLOADONSUBMIT') 
  AND `name` = ''
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `id` = '16'
SELECT * 
  FROM `jos_chrono_contact` 
  WHERE `id` = '16'
SELECT template 
  FROM jos_templates_menu 
  WHERE client_id = 0 
  AND (menuid = 0 OR menuid = 0) 
  ORDER BY menuid DESC 
  LIMIT 0, 1
SELECT id, title, module, position, content, showtitle, control, params 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  WHERE m.published = 1 
  AND m.access <= 0 
  AND m.client_id = 0 
  AND ( mm.menuid = 0 OR mm.menuid = 0 ) 
  ORDER BY position, ordering

Hi iAleX,

There's no sign of a DB Connection query there.

Please refresh the DB Connection next:

In the Form Editor click the DB Connection tab and set the Connection to 'No'. Click the 'Apply icon in the toolbar to save the form, open the DB Connection tab, set the Connection back to 'Yes' and re-save the form. This will refresh the copy of the table information that ChronoForms uses.

Bob