Information won't save to DB

classic 23 Aug, 2010

Hi Guys,
I have a form setup that is already running a custom php code section "after email", since no email is actually sent, that runs an auth.net transaction and redirects the person who made the purchase to a custom redirect page (an article I created in Joomla).

I now, additionally, want the form to save the users information to a database table. I have setup everything following the instructionial PDF file. I have created a table, connected to it, all fields are selected, have setup the auto increment and primary key, etc. (I also have this setup to work "after email".

When I go to run a test, the form still operates just fun, but when I check the table, no data is saving. I set Joomla to debug mode and it doesn't even appear to be running the save to database code (yes I do have this activated under the form settings).

Here is the debug:

•Profile Information•
Application afterLoad: 0.001 seconds, 0.23 MB
Application afterInitialise: 0.221 seconds, 2.15 MB
Application afterRoute: 0.241 seconds, 2.55 MB
Application afterDispatch: 0.465 seconds, 4.84 MB
Application afterRender: 0.679 seconds, 6.76 MB
•Memory Usage•
7177832
•15 queries logged•

   1.
      SELECT *
        FROM jos_session
        WHERE session_id = '6c2a6aaac1b50b959db8f258e369a8d9'
   2.
      DELETE
        FROM jos_session
        WHERE ( time < '1282589643' )
   3.
      SELECT *
        FROM jos_session
        WHERE session_id = '6c2a6aaac1b50b959db8f258e369a8d9'
   4.
      UPDATE `jos_session`
        SET `time`='1282590543',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:20;s:19:\"session.timer.start\";i:1282587418;s:18:\"session.timer.last\";i:1282590466;s:17:\"session.timer.now\";i:1282590542;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 (.NET CLR 3.5.30729)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{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:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:96:\"/homepages/27/d104848708/htdocs/dimestore/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"45800c49fdc0187770b908c48c0f2237\";}__eb81adcc4edfeccb1ba0f16dfe1a737f|a:2:{s:19:\"chrono_verification\";s:32:\"70740fe24bf12d44323f50170732d04b\";s:21:\"cfreturnurl_orderform\";s:36:\"http://127.0.0.1/\";}'
        WHERE session_id='6c2a6aaac1b50b959db8f258e369a8d9'
   5.
      SELECT *
        FROM jos_components
        WHERE parent = 0
   6.
      SELECT folder AS type, element AS name, params
        FROM jos_plugins
        WHERE published >= 1
        AND access <= 0
        ORDER BY ordering
   7.
      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
   8.
      SELECT template
        FROM jos_templates_menu
        WHERE client_id = 0
        AND (menuid = 0 OR menuid = 3)
        ORDER BY menuid DESC
        LIMIT 0, 1
   9.
      SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
        FROM jos_content AS a
        LEFT JOIN jos_categories AS cc
        ON cc.id = a.catid
        LEFT JOIN jos_sections AS s
        ON s.id = cc.section
        AND s.scope = "content"
        LEFT JOIN jos_users AS u
        ON u.id = a.created_by
        LEFT JOIN jos_groups AS g
        ON a.access = g.id
        WHERE a.id = 3
        AND (  ( a.created_by = 0 )    OR  ( a.state = 1
        AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-08-23 19:09:03' )
        AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-08-23 19:09:03' )   )    OR  ( a.state = -1 )  )
  10.
      UPDATE jos_content
        SET hits = ( hits + 1 )
        WHERE id='3'
  11.
      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 = 3 OR mm.menuid = 0 )
        ORDER BY position, ordering
  12.
      SELECT *
        FROM `jos_chrono_contact`
        WHERE `name` = 'orderform'
  13.
      SELECT *
        FROM `jos_chrono_contact`
        WHERE `id` = '2'
  14.
      SELECT *
        FROM `jos_chrono_contact_plugins`
        WHERE `form_id` = '2'
        AND event IN ('ONLOAD','ONLOADONSUBMIT')
        AND `name` = 'cf_Authorize_dotnet'
  15.
      SELECT *
        FROM `jos_components`
        WHERE `option` = 'com_chronocontact'
        AND parent='0'
        AND admin_menu_link='option=com_chronocontact'

•Language Files Loaded•

    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.ini 1
    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.plg_system_debug.ini 1
    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.com_content.ini 1
    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.plg_content_pagebreak.ini 1
    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.tpl_immigration_english_success.ini
    * /homepages/27/d104848708/htdocs/dimestore/language/en-GB/en-GB.mod_chronocontact.ini 

•Untranslated Strings Diagnostic•

•None•

•Untranslated Strings Designer•

•None•

Forums

Information won't save to DB