Forums

Hi Guys,
Interesting one here. Basically I am saving form data to an external database and table. There are a total of two records in the table, both of which were created through the form. For some reason, when a new form data is entered and submitted, rather than add a record to the table, it just overwrites and then updates the second record in the table with the new information.

Any ideas?

Hi Classic,

The Jooomla database code updates a record if it finds a matching primary key, otherwise it creates a new record. I'd add some debug code (or use site debug) to see what query is being created.

Bob

Thanks for the response.

I think what happened is that after I had created the table and connected it to the form, I added a column titled "id" which auto increments and is set as the primary key. There is no form field for this id column.

How should I go about setting this up to where, I guess, the form field needs to submit a hidden field containing this id... but it still auto-increment?

Okay, if I remove the two entries that were already existing in the table, and this the table is now empty with no records -- the form stops adding a new record every form submission altogether.

So, if there is a record in the table, it just updates the last existing record, overwriting what was there previously, BUT, if I totally remove all records and try to submit the form -- it goes through fine without any errors, but when I look at the table, a new record was not submitted into the table.

Hi classic ,

I think that it is now time to turn on Site Debug briefly and look at the exact queries being generated and see what can be deduced from them.

Bob

Here is the debug when the form loads:

27 Queries Logged

   1. SELECT `data`
        FROM `jml17_session`
        WHERE `session_id` = '6eeb88d2d0cef97ff1e0fe425eb22bee'
   2. DELETE
        FROM `jml17_session`
        WHERE `time` < 1328804755
   3. SELECT folder AS type, element AS name, params
        FROM jml17_extensions
        WHERE enabled >= 1
        AND type ='plugin'
        AND state >= 0
        AND access IN (1,1)
        ORDER BY ordering
   4. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_languages'
   5. SELECT setting,value
        FROM jml17_jfbconnect_config
   6. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
        FROM jml17_menu AS m
        LEFT JOIN jml17_extensions AS e
        ON m.component_id = e.extension_id
        WHERE m.published = 1
        AND m.parent_id > 0
        AND m.client_id = 0
        AND m.access IN (1,1)
        ORDER BY m.lft
   7. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_rokcandy'
   8. SELECT *
        FROM jml17_rokcandy
        WHERE published=1
   9. SELECT id, home, template, s.params
        FROM jml17_template_styles as s
        LEFT JOIN jml17_extensions as e
        ON e.element=s.template
        AND e.type='template'
        AND e.client_id=s.client_id
        WHERE s.client_id = 0
        AND e.enabled = 1
  10. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_content'
  11. SELECT *
        FROM jml17_languages
        WHERE published=1
        ORDER BY ordering ASC
  12. SELECT b.rules
        FROM jml17_assets AS a
        LEFT JOIN jml17_assets AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
        WHERE a.name = 'com_content'
        ORDER BY b.lft
  13. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_users'
  14. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
        FROM jml17_content AS a
        LEFT JOIN jml17_categories AS c
        on c.id = a.catid
        LEFT JOIN jml17_users AS u
        on u.id = a.created_by
        LEFT JOIN jml17_contact_details AS contact
        on contact.user_id = a.created_by
        LEFT JOIN jml17_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN jml17_content_rating AS v
        ON a.id = v.content_id
        LEFT
        OUTER JOIN (SELECT cat.id as id
        FROM jml17_categories AS cat JOIN jml17_categories AS parent
        ON cat.lft BETWEEN parent.lft
        AND parent.rgt
        WHERE parent.extension = 'com_content'
        AND parent.published <= 0
        GROUP BY cat.id) AS badcats
        ON badcats.id = c.id
        WHERE a.id = 2
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-09 16:40:56')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 16:40:56')
        AND (a.state = 1 OR a.state =2)
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
        FROM jml17_categories as c
        LEFT JOIN jml17_categories AS s
        ON (s.lft <= c.lft
        AND s.rgt >= c.rgt) OR (s.lft > c.lft
        AND s.rgt < c.rgt)
        LEFT JOIN (SELECT cat.id as id
        FROM jml17_categories AS cat JOIN jml17_categories AS parent
        ON cat.lft BETWEEN parent.lft
        AND parent.rgt
        WHERE parent.extension = 'com_content'
        AND parent.published != 1
        GROUP BY cat.id) AS badcats
        ON badcats.id = c.id
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.access IN (1,1)
        AND c.published = 1
        AND s.id=2
        AND badcats.id is null
        GROUP BY c.id
        ORDER BY c.lft
  16. SELECT *
        FROM `jml17_chronoforms`
        WHERE `name` = 'CardholderRegistration'
        AND `published` = '1'
  17. SELECT *
        FROM `jml17_chronoform_actions`
        WHERE `chronoform_id` = '2'
        ORDER BY `
        order`
  18. SELECT *
        FROM `jml17_extensions`
        WHERE `element` = 'com_chronoforms'
        AND `type` = 'component'
  19. UPDATE jml17_content
        SET hits = hits + 1
        WHERE id = 2
  20. SELECT j_user_id
        FROM jml17_jfbconnect_user_map
        WHERE fb_user_id=''
  21. SELECT id, home, template, params
        FROM jml17_template_styles
        WHERE client_id = 0
  22. SELECT id, home, template, params
        FROM jml17_template_styles
        WHERE client_id = 0
  23. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
        FROM jml17_modules AS m
        LEFT JOIN jml17_modules_menu AS mm
        ON mm.moduleid = m.id
        LEFT JOIN jml17_extensions AS e
        ON e.element = m.module
        AND e.client_id = m.client_id
        WHERE m.published = 1
        AND e.enabled = 1
        AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-02-09 16:40:56')
        AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-02-09 16:40:56')
        AND m.access IN (1,1)
        AND m.client_id = 0
        AND (mm.menuid = 118 OR mm.menuid <= 0)
        ORDER BY m.position, m.ordering
  24. SELECT ts.template
        FROM jml17_template_styles AS ts
        INNER JOIN jml17_menu AS m
        ON ts.id=m.template_style_id
        WHERE m.id = 118
        AND m.template_style_id != 0
  25. SELECT template
        FROM jml17_template_styles
        WHERE home = 1
        AND client_id = 0
  26. SELECT j_user_id
        FROM jml17_jfbconnect_user_map
        WHERE fb_user_id=''
  27. UPDATE `jml17_session`
        SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1328805597;s:18:\"session.timer.last\";i:1328805597;s:17:\"session.timer.now\";i:1328805655;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.26) Gecko/20120128 Firefox/3.6.26\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7eff460622a6d426016a1b83e3b7ce53\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:1:{s:19:\"chrono_verification\";s:32:\"a8a5558a0ea7bc6f01c1e84e98ef226a\";}', `time` = 1328805656
        WHERE `session_id` = '6eeb88d2d0cef97ff1e0fe425eb22bee'

22 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

   1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jml17_extensions
   2. 2 × SELECT id, home, template, params FROM jml17_template_styles
   3. 2 × SELECT j_user_id FROM jml17_jfbconnect_user_map
   4. 1 × SELECT * FROM `jml17_extensions`
   5. 1 × SELECT * FROM `jml17_chronoform_actions`
   6. 1 × SELECT * FROM `jml17_chronoforms`
   7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jml17_modules AS m LEFT JOIN jml17_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jml17_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
   8. 1 × SELECT template FROM jml17_template_styles
   9. 1 × SELECT ts.template FROM jml17_template_styles AS ts INNER JOIN jml17_menu AS m ON ts.id=m.template_style_id
  10. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jml17_categories as c LEFT JOIN jml17_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jml17_categories AS cat JOIN jml17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  11. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jml17_content AS a LEFT JOIN jml17_categories AS c on c.id = a.catid LEFT JOIN jml17_users AS u on u.id = a.created_by LEFT JOIN jml17_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml17_categories as parent ON parent.id = c.parent_id LEFT JOIN jml17_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml17_categories AS cat JOIN jml17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  12. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jml17_menu AS m LEFT JOIN jml17_extensions AS e ON m.component_id = e.extension_id
  13. 1 × SELECT setting,value FROM jml17_jfbconnect_confi
  14. 1 × SELECT folder AS type, element AS name, params FROM jml17_extensions
  15. 1 × SELECT * FROM jml17_rokcandy
  16. 1 × SELECT id, home, template, s.params FROM jml17_template_styles as s LEFT JOIN jml17_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  17. 1 × SELECT b.rules FROM jml17_assets AS a LEFT JOIN jml17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  18. 1 × SELECT * FROM jml17_languages
  19. 1 × SELECT `data` FROM `jml17_session`

OTHER Tables:

   1. 1 × UPDATE `jml17_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1328805597;s:18:\"session.timer.last\";i:1328805597;s:17:\"session.timer.now\";i:1328805655;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.26) Gecko/20120128 Firefox/3.6.26\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7eff460622a6d426016a1b83e3b7ce53\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:1:{s:19:\"chrono_verification\";s:32:\"a8a5558a0ea7bc6f01c1e84e98ef226a\";}', `time` = 1328805656
   2. 1 × UPDATE jml17_content SET hits = hits + 1
   3. 1 × DELETE FROM `jml17_session`

Here is the debug after the form is submitted:

37 Queries Logged

   1. SELECT `data`
        FROM `jml17_session`
        WHERE `session_id` = '6eeb88d2d0cef97ff1e0fe425eb22bee'
   2. DELETE
        FROM `jml17_session`
        WHERE `time` < 1328804977
   3. SELECT folder AS type, element AS name, params
        FROM jml17_extensions
        WHERE enabled >= 1
        AND type ='plugin'
        AND state >= 0
        AND access IN (1,1)
        ORDER BY ordering
   4. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_languages'
   5. SELECT setting,value
        FROM jml17_jfbconnect_config
   6. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
        FROM jml17_menu AS m
        LEFT JOIN jml17_extensions AS e
        ON m.component_id = e.extension_id
        WHERE m.published = 1
        AND m.parent_id > 0
        AND m.client_id = 0
        AND m.access IN (1,1)
        ORDER BY m.lft
   7. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_rokcandy'
   8. SELECT *
        FROM jml17_rokcandy
        WHERE published=1
   9. SELECT id, home, template, s.params
        FROM jml17_template_styles as s
        LEFT JOIN jml17_extensions as e
        ON e.element=s.template
        AND e.type='template'
        AND e.client_id=s.client_id
        WHERE s.client_id = 0
        AND e.enabled = 1
  10. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_content'
  11. SELECT *
        FROM jml17_languages
        WHERE published=1
        ORDER BY ordering ASC
  12. SELECT b.rules
        FROM jml17_assets AS a
        LEFT JOIN jml17_assets AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
        WHERE a.name = 'com_content'
        ORDER BY b.lft
  13. SELECT extension_id AS "id", element AS "option", params, enabled
        FROM jml17_extensions
        WHERE `type` = 'component'
        AND `element` = 'com_users'
  14. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
        FROM jml17_content AS a
        LEFT JOIN jml17_categories AS c
        on c.id = a.catid
        LEFT JOIN jml17_users AS u
        on u.id = a.created_by
        LEFT JOIN jml17_contact_details AS contact
        on contact.user_id = a.created_by
        LEFT JOIN jml17_categories as parent
        ON parent.id = c.parent_id
        LEFT JOIN jml17_content_rating AS v
        ON a.id = v.content_id
        LEFT
        OUTER JOIN (SELECT cat.id as id
        FROM jml17_categories AS cat JOIN jml17_categories AS parent
        ON cat.lft BETWEEN parent.lft
        AND parent.rgt
        WHERE parent.extension = 'com_content'
        AND parent.published <= 0
        GROUP BY cat.id) AS badcats
        ON badcats.id = c.id
        WHERE a.id = 2
        AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-09 16:44:37')
        AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-09 16:44:37')
        AND (a.state = 1 OR a.state =2)
  15. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
        FROM jml17_categories as c
        LEFT JOIN jml17_categories AS s
        ON (s.lft <= c.lft
        AND s.rgt >= c.rgt) OR (s.lft > c.lft
        AND s.rgt < c.rgt)
        LEFT JOIN (SELECT cat.id as id
        FROM jml17_categories AS cat JOIN jml17_categories AS parent
        ON cat.lft BETWEEN parent.lft
        AND parent.rgt
        WHERE parent.extension = 'com_content'
        AND parent.published != 1
        GROUP BY cat.id) AS badcats
        ON badcats.id = c.id
        WHERE (c.extension='com_content' OR c.extension='system')
        AND c.access IN (1,1)
        AND c.published = 1
        AND s.id=2
        AND badcats.id is null
        GROUP BY c.id
        ORDER BY c.lft
  16. SELECT *
        FROM `jml17_chronoforms`
        WHERE `name` = 'CardholderRegistration'
        AND `published` = '1'
  17. SELECT *
        FROM `jml17_chronoform_actions`
        WHERE `chronoform_id` = '2'
        ORDER BY `
        order`
  18. SHOW FULL COLUMNS
        FROM `jml17_users`
  19. SELECT `id`, `title`
        FROM `jml17_usergroups`
        WHERE `id` = 2
  20. SELECT id
        FROM jml17_users
        WHERE username = '423564987'
        AND id != 0
  21. SELECT id
        FROM jml17_users
        WHERE email = 'tomson@asdfasdf.com'
        AND id != 0
  22. SELECT id
        FROM jml17_users
        WHERE username = ''
  23. SELECT b.rules
        FROM jml17_assets AS a
        LEFT JOIN jml17_assets AS b
        ON b.lft <= a.lft
        AND b.rgt >= a.rgt
        WHERE a.id = 1
        ORDER BY b.lft
  24. SELECT parent.id, parent.lft, parent.rgt
        FROM jml17_usergroups AS parent
        ORDER BY parent.lft
  25. INSERT INTO `jml17_users` (`id`,`name`,`username`,`email`,`password`,`usertype`,`sendEmail`,`registerDate`,`params`)
        VALUES ('0','tom','423564987','tomson@asdfasdf.com','e02f44f799576111d0002fafd59dea28:WTOQusjBQfh2ainWJiajCkfSTXucfOEB','deprecated','0','2012-02-09 16:44:37','{}')
  26. DELETE
        FROM `jml17_user_usergroup_map`
        WHERE `user_id` = 128
  27. INSERT INTO `jml17_user_usergroup_map` (`user_id`, `group_id`)
        VALUES (128, 2)
  28. SELECT *
        FROM `jml17_extensions`
        WHERE `element` = 'com_chronoforms'
        AND `type` = 'component'
  29. UPDATE jml17_content
        SET hits = hits + 1
        WHERE id = 2
  30. SELECT j_user_id
        FROM jml17_jfbconnect_user_map
        WHERE fb_user_id=''
  31. SELECT id, home, template, params
        FROM jml17_template_styles
        WHERE client_id = 0
  32. SELECT id, home, template, params
        FROM jml17_template_styles
        WHERE client_id = 0
  33. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
        FROM jml17_modules AS m
        LEFT JOIN jml17_modules_menu AS mm
        ON mm.moduleid = m.id
        LEFT JOIN jml17_extensions AS e
        ON e.element = m.module
        AND e.client_id = m.client_id
        WHERE m.published = 1
        AND e.enabled = 1
        AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-02-09 16:44:38')
        AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-02-09 16:44:38')
        AND m.access IN (1,1)
        AND m.client_id = 0
        AND (mm.menuid = 118 OR mm.menuid <= 0)
        ORDER BY m.position, m.ordering
  34. SELECT ts.template
        FROM jml17_template_styles AS ts
        INNER JOIN jml17_menu AS m
        ON ts.id=m.template_style_id
        WHERE m.id = 118
        AND m.template_style_id != 0
  35. SELECT template
        FROM jml17_template_styles
        WHERE home = 1
        AND client_id = 0
  36. SELECT j_user_id
        FROM jml17_jfbconnect_user_map
        WHERE fb_user_id=''
  37. UPDATE `jml17_session`
        SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1328805597;s:18:\"session.timer.last\";i:1328805655;s:17:\"session.timer.now\";i:1328805877;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.26) Gecko/20120128 Firefox/3.6.26\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7eff460622a6d426016a1b83e3b7ce53\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:0:{}', `time` = 1328805878
        WHERE `session_id` = '6eeb88d2d0cef97ff1e0fe425eb22bee'

29 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

   1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jml17_extensions
   2. 3 × SELECT id FROM jml17_users
   3. 2 × SELECT b.rules FROM jml17_assets AS a LEFT JOIN jml17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
   4. 2 × SELECT j_user_id FROM jml17_jfbconnect_user_map
   5. 2 × SELECT id, home, template, params FROM jml17_template_styles
   6. 1 × SELECT template FROM jml17_template_styles
   7. 1 × SELECT `id`, `title` FROM `jml17_usergroups`
   8. 1 × SELECT parent.id, parent.lft, parent.rgt FROM jml17_usergroups AS parent
   9. 1 × SELECT ts.template FROM jml17_template_styles AS ts INNER JOIN jml17_menu AS m ON ts.id=m.template_style_id
  10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jml17_modules AS m LEFT JOIN jml17_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jml17_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
  11. 1 × SELECT * FROM `jml17_extensions`
  12. 1 × SELECT * FROM `jml17_chronoform_actions`
  13. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jml17_categories as c LEFT JOIN jml17_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM jml17_categories AS cat JOIN jml17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  14. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jml17_menu AS m LEFT JOIN jml17_extensions AS e ON m.component_id = e.extension_id
  15. 1 × SELECT setting,value FROM jml17_jfbconnect_confi
  16. 1 × SELECT folder AS type, element AS name, params FROM jml17_extensions
  17. 1 × SELECT * FROM jml17_rokcandy
  18. 1 × SELECT id, home, template, s.params FROM jml17_template_styles as s LEFT JOIN jml17_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
  19. 1 × SELECT `data` FROM `jml17_session`
  20. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jml17_content AS a LEFT JOIN jml17_categories AS c on c.id = a.catid LEFT JOIN jml17_users AS u on u.id = a.created_by LEFT JOIN jml17_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml17_categories as parent ON parent.id = c.parent_id LEFT JOIN jml17_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml17_categories AS cat JOIN jml17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  21. 1 × SELECT * FROM jml17_languages
  22. 1 × SELECT * FROM `jml17_chronoforms`

OTHER Tables:

   1. 1 × UPDATE jml17_content SET hits = hits + 1
   2. 1 × UPDATE `jml17_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1328805597;s:18:\"session.timer.last\";i:1328805655;s:17:\"session.timer.now\";i:1328805877;s:22:\"session.client.browser\";s:90:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.26) Gecko/20120128 Firefox/3.6.26\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7eff460622a6d426016a1b83e3b7ce53\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:0:{}', `time` = 1328805878
   3. 1 × INSERT INTO `jml17_user_usergroup_map` (`user_id`, `group_id`) VALUES (128, 2
   4. 1 × DELETE FROM `jml17_user_usergroup_map`
   5. 1 × SHOW FULL COLUMNS FROM `jml17_users
   6. 1 × INSERT INTO `jml17_users` (`id`,`name`,`username`,`email`,`password`,`usertype`,`sendEmail`,`registerDate`,`params`) VALUES ('0','tom','423564987','tomson@asdfasdf.com','e02f44f799576111d0002fafd59dea28:WTOQusjBQfh2ainWJiajCkfSTXucfOEB','deprecated','0','2012-02-09 16:44:37','{}'
   7. 1 × DELETE FROM `jml17_session`

Basically the form does three things... registers them into Joomla, Adds them to the external database we have setup, and then it also submits a few of the fields over to an external processor to verify their membership number and activate it.

The Joomla registration appears to be working just fine and I was told so was the external activation that is submitted using cURL (If I remember how we set it up correctly). The external database was also working, but now it has stopped.

Could a component or something be causing an issue with the steps of this process. I noticed alot of references to JFBConnect in that debug scripting.

Hi classic,

Bother - I don't see any evidence of an INSERT or UPDATE to your external table :-( Maybe Joomla! doesn't log those queries.

I'm not sure where is best to go from here. I'd probably set up a very simple form to explore writing to the external database. Echoing out the queries might give some clues about what is happening.

Bob

Not a problem and thanks a bunch as always. I'll play around with it and see what I can find. If I come across anything or get it working I will post back.