New connection: "Save Failed"

What are the reasons behind the "Save Failed" error?

I just installed CF5 and CC5 on a Joomla 2.5.28 site. I tried to create a new connection with only the basic info (only setting up the model and table column names), but when I click Apply or Save, I get an error that says "Save Failed" with no details as to why.

I usually use CC5 on Joomla 3, so is there a Joomla 2.5 quirk that I'm unaware of?

Hi megana,

Does the table - or any of the column names - have any spaces, dashes, or other special characters in them?

If you turn on Site Debugging temporarily you should be able to see the MySQL query that is being created and possibly any error message that goes with it.

Bob

Hi Bob,

Only underscores. The table name is acBr_bfsurvey_30results and the fields are: bfsurvey_39result_id, created_by, created_on, waist, weight, lose_weight, bmi, stress_level, activity_level, hours_sleep.

By Site Debugging, do you mean in Global Configuration? I set it to Maximum but still only get the uninformative "Save Failed" error when I try to create the connection. 😟

Hi Megana,

In the Site Global Configuration > Server tab there is a Debug Settings > Debug System. Please set this to Yes temporarily.

Bob

Hi Bob,

Aha, thanks!

Here is what it shows when I get the "Save Failed" error:

Joomla! Debug Console
Session
__default
session.client.browser ⇒ Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36
user
session.token ⇒ b01f8afd1eb8e3f6c14c7e2f352e45ed
__akeeba.srp
referrerid ⇒ 544B4BE906AE5
__wf
session.token ⇒ b33f91832af9c95d54bd57d8e2647c99
gcore
user
id ⇒ 561
name ⇒ Megan
username ⇒ Megan
email ⇒ megan@adcoagency.com
last_login ⇒ 2015-10-23 14:56:49
groups
0 ⇒ 8
inheritance
0 ⇒ 1
1 ⇒ 0
GCore\Admin\Extensions\Chronoconnectivity\Chronoconnectivity
Connection
Profile Information
Application 0.001 seconds (+0.001); 0.82 MB (+0.825) - afterLoad
Application 0.238 seconds (+0.237); 11.61 MB (+10.786) - afterInitialise
Application 0.253 seconds (+0.015); 12.05 MB (+0.435) - afterRoute
Application 0.639 seconds (+0.386); 15.83 MB (+3.783) - afterDispatch
Application 0.644 seconds (+0.005); 16.07 MB (+0.246) - beforeRenderModule mod_version (Joomla Version)
Application 0.648 seconds (+0.004); 16.10 MB (+0.030) - afterRenderModule mod_version (Joomla Version)
Application 0.648 seconds (+0.000); 16.10 MB (-0.003) - beforeRenderModule mod_submenu (Admin Submenu)
Application 0.652 seconds (+0.004); 16.14 MB (+0.039) - afterRenderModule mod_submenu (Admin Submenu)
Application 0.652 seconds (+0.000); 16.14 MB (-0.002) - beforeRenderModule mod_title (Title)
Application 0.655 seconds (+0.003); 16.14 MB (+0.005) - afterRenderModule mod_title (Title)
Application 0.655 seconds (+0.000); 16.14 MB (-0.001) - beforeRenderModule mod_toolbar (Toolbar)
Application 0.658 seconds (+0.003); 16.15 MB (+0.008) - afterRenderModule mod_toolbar (Toolbar)
Application 0.658 seconds (+0.000); 16.15 MB (-0.002) - beforeRenderModule mod_status (User Status)
Application 0.663 seconds (+0.005); 16.16 MB (+0.011) - afterRenderModule mod_status (User Status)
Application 0.663 seconds (+0.000); 16.16 MB (-0.003) - beforeRenderModule mod_menu (Admin Menu)
Application 0.861 seconds (+0.198); 17.19 MB (+1.031) - afterRenderModule mod_menu (Admin Menu)
Application 1.475 seconds (+0.614); 17.66 MB (+0.473) - afterRender
Memory Usage
18 MB (18,874,008 Bytes)
Database Queries
35 Queries Logged
SELECT `data` 
  FROM `acBr_session` 
  WHERE `session_id` = 'cc3407225470dd9c75844167a5ace182'
DELETE 
  FROM `acBr_session` 
  WHERE `time` < '1445868387'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params 
  FROM acBr_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,2,3) 
  ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_kunena'
SELECT `value` 
  FROM `acBr_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT `query` 
  FROM `acBr_admintools_wafexceptions` 
  WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_chronoconnectivity5') 
  AND (`view` IS NULL OR `view` = '') 
  GROUP BY `query` 
  ORDER BY `query` ASC
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_akeebasubs'
SELECT `enabled` 
  FROM `acBr_extensions` 
  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
SELECT * 
  FROM acBr_vm_affiliate_settings 
  WHERE `setting` = '1'
SELECT * 
  FROM settings 
  WHERE `id` = '17'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_k2'
SELECT * 
  FROM acBr_eb_configs
SELECT a.id, a.first_name, a.last_name, a.email, a.register_date, a.transaction_id, b.id as event_id, b.title AS event_title, b.event_date 
  FROM acBr_eb_registrants AS a 
  INNER JOIN acBr_eb_events AS b 
  ON a.event_id = b.id 
  WHERE a.published=1 
  AND a.is_reminder_sent = 0 
  AND b.enable_auto_reminder=1 
  AND (DATEDIFF(b.event_date, NOW()) <= b.remind_before_x_days) 
  AND (DATEDIFF(b.event_date, NOW()) >=0) 
  ORDER BY b.event_date, a.register_date 
  LIMIT 15
SELECT extension_id 
  FROM acBr_extensions 
  WHERE name="ebreminder" 
  AND `folder`="system"
UPDATE acBr_extensions 
  SET params='{\"last_run\":1445874327,\"number_registrants\":\"15\"}' 
  WHERE extension_id=10297
SHOW TABLES
SELECT file_id 
  from acBr_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2015-10-26 10:45:27'
SELECT file_id 
  from acBr_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2015-10-26 10:45:27'
SELECT * 
  FROM `acBr_admintools_ipautoban` 
  WHERE `ip` = '173.161.75.101'
SELECT `value` 
  FROM `acBr_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT * 
  FROM acBr_languages 
  WHERE published=1 
  ORDER BY ordering ASC
SELECT `params` 
  FROM acBr_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';
SELECT template, s.params 
  FROM acBr_template_styles as s 
  LEFT JOIN acBr_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 1 
  AND home = 1 
  ORDER BY home
SHOW TABLES
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_chronoconnectivity5'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_cbootstrap'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM acBr_modules AS m 
  LEFT JOIN acBr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN acBr_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 <= '2015-10-26 15:45:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-10-26 15:45:27') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT COUNT(*) 
  FROM acBr_messages 
  WHERE state = 0 
  AND user_id_to = 561
SELECT COUNT(session_id) 
  FROM acBr_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM acBr_session 
  WHERE guest = 0 
  AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM acBr_menu_types AS a 
  LEFT JOIN acBr_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN acBr_languages AS l 
  ON l.lang_code = language 
  WHERE (b.client_id = 0 OR b.client_id IS NULL) 
  GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM acBr_menu AS m 
  LEFT JOIN acBr_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1 
  ORDER BY m.lft
SHOW TABLES
UPDATE `acBr_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1445871173;s:18:\"session.timer.last\";i:1445874296;s:17:\"session.timer.now\";i:1445874327;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"561\";s:4:\"name\";s:5:\"Megan\";s:8:\"username\";s:5:\"Megan\";s:5:\"email\";s:20:\"megan@adcoagency.com\";s:8:\"password\";s:34:\"$P$DhrN.JqUzjCMtPUw1ygP/8/OmccsT31\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-07-27 06:50:19\";s:13:\"lastvisitDate\";s:19:\"2015-10-23 14:56:49\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:134:\"{\"wrightLogoAlt\":\"0\",\"update_cache_list\":1,\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:13:\"wrightLogoAlt\";s:1:\"0\";s:17:\"update_cache_list\";i:1;s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:3:\"gid\";i:1000;}s:13:\"session.token\";s:32:\"b01f8afd1eb8e3f6c14c7e2f352e45ed\";}__akeeba.srp|a:1:{s:7:\"skipsrp\";i:0;}referrerid|s:13:\"544B4BE906AE5\";__wf|a:1:{s:13:\"session.token\";s:32:\"b33f91832af9c95d54bd57d8e2647c99\";}gcore|a:4:{s:16:\"acos_permissions\";N;s:4:\"user\";a:9:{s:2:\"id\";s:3:\"561\";s:4:\"name\";s:5:\"Megan\";s:8:\"username\";s:5:\"Megan\";s:5:\"email\";s:20:\"megan@adcoagency.com\";s:10:\"last_login\";s:19:\"2015-10-23 14:56:49\";s:9:\"logged_in\";b:1;s:5:\"guest\";i:0;s:6:\"groups\";a:1:{i:0;s:1:\"8\";}s:11:\"inheritance\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"0\";}}s:60:\"GCore\\Admin\\Extensions\\Chronoconnectivity\\Chronoconnectivity\";a:1:{s:10:\"Connection\";a:1:{s:5:\"
  limit\";i:30;}}s:9:\"__FLASH__\";N;}' , `time` = '1445874328' 
  WHERE `session_id` = 'cc3407225470dd9c75844167a5ace182'
25 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM acBr_extensions
2 × SELECT file_id 
  from acBr_jdownloads_files
2 × SELECT `value` 
  FROM `acBr_admintools_storage`
2 × SELECT COUNT(session_id) 
  FROM acBr_session
1 × SELECT `params` 
  FROM acBr_extensions
1 × SELECT * 
  FROM acBr_languages
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM acBr_menu AS m 
  LEFT JOIN acBr_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT template, s.params 
  FROM acBr_template_styles as s 
  LEFT JOIN acBr_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM acBr_modules AS m 
  LEFT JOIN acBr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN acBr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM `acBr_admintools_ipautoban`
1 × SELECT COUNT(*) 
  FROM acBr_messages
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM acBr_menu_types AS a 
  LEFT JOIN acBr_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN acBr_languages AS l 
  ON l.lang_code = language
1 × SELECT extension_id 
  FROM acBr_extensions
1 × SELECT `enabled` 
  FROM `acBr_extensions`
1 × SELECT `query` 
  FROM `acBr_admintools_wafexceptions`
1 × SELECT folder AS type, element AS name, params 
  FROM acBr_extensions
1 × SELECT * 
  FROM acBr_vm_affiliate_settings
1 × SELECT * 
  FROM settings
1 × SELECT a.id, a.first_name, a.last_name, a.email, a.register_date, a.transaction_id, b.id as event_id, b.title AS event_title, b.event_date 
  FROM acBr_eb_registrants AS a 
  INNER JOIN acBr_eb_events AS b 
  ON a.event_id = b.id
1 × SELECT * 
  FROM acBr_eb_config
1 × SELECT `data` 
  FROM `acBr_session`
OTHER Tables:
3 × SHOW TABLE
1 × UPDATE `acBr_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:26;s:19:\"session.timer.start\";i:1445871173;s:18:\"session.timer.last\";i:1445874296;s:17:\"session.timer.now\";i:1445874327;s:22:\"session.client.browser\";s:102:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"561\";s:4:\"name\";s:5:\"Megan\";s:8:\"username\";s:5:\"Megan\";s:5:\"email\";s:20:\"megan@adcoagency.com\";s:8:\"password\";s:34:\"$P$DhrN.JqUzjCMtPUw1ygP/8/OmccsT31\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-07-27 06:50:19\";s:13:\"lastvisitDate\";s:19:\"2015-10-23 14:56:49\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:134:\"{\"wrightLogoAlt\":\"0\",\"update_cache_list\":1,\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":8:{s:13:\"wrightLogoAlt\";s:1:\"0\";s:17:\"update_cache_list\";i:1;s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}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:3:\"gid\";i:1000;}s:13:\"session.token\";s:32:\"b01f8afd1eb8e3f6c14c7e2f352e45ed\";}__akeeba.srp|a:1:{s:7:\"skipsrp\";i:0;}referrerid|s:13:\"544B4BE906AE5\";__wf|a:1:{s:13:\"session.token\";s:32:\"b33f91832af9c95d54bd57d8e2647c99\";}gcore|a:4:{s:16:\"acos_permissions\";N;s:4:\"user\";a:9:{s:2:\"id\";s:3:\"561\";s:4:\"name\";s:5:\"Megan\";s:8:\"username\";s:5:\"Megan\";s:5:\"email\";s:20:\"megan@adcoagency.com\";s:10:\"last_login\";s:19:\"2015-10-23 14:56:49\";s:9:\"logged_in\";b:1;s:5:\"guest\";i:0;s:6:\"groups\";a:1:{i:0;s:1:\"8\";}s:11:\"inheritance\";a:2:{i:0;s:1:\"1\";i:1;s:1:\"0\";}}s:60:\"GCore\\Admin\\Extensions\\Chronoconnectivity\\Chronoconnectivity\";a:1:{s:10:\"Connection\";a:1:{s:5:\"
  limit\";i:30;}}s:9:\"__FLASH__\";N;}' , `time` = '1445874328'
1 × UPDATE acBr_extensions 
  SET params='{\"last_run\":1445874327,\"number_registrants\":\"15\"}'
1 × DELETE 
  FROM `acBr_session`

Hi Megana,

Thank you - that was what I was looking for Unfortunately though it isn't showing the error.

By all means PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

In case anyone else runs into this, the problem was that the ChronoConnectivity table in the database did not get created for some reason. Bob helped me add it manually.

Thanks Bob!