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?
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
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?
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.
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
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:
Here is the debug after the form is submitted:
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.
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
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
This topic is locked and no more replies can be posted.
