CiviCRM Community Forums (archive)

incomplete urls like: "http://d45.demo.civicrm.org/civicrm/profile/create?" generate an error:

Sorry but we are not able to provide this at the moment.
One of parameters (value: ) is not of the type Integer

There are many examples of this - often generated by a bot (in this case google.)

It may seem inocuous but I'm struggling with a very real issue that only affects iphone / ios 8.x and civicrm registrations that also generates this (somewhat cryptic) error.

Parsing the logs to distinguish bot errors vs. real errors is quite tedious at best.  Is there a better way to handle these unexpected edge cases and possibly distinguish between bots vs. registration workflow errors???

Here is backtrace:

Jan 19 11:13:51  [info] $backTrace = #0 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(387): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Utils/Type.php(347): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
#2 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1183): CRM_Utils_Type::validate(NULL, "Integer")
#3 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1102): CRM_Core_DAO::composeQuery("\nSELECT module,is_reserved\n  FROM civicrm_uf_group\n  LEFT JOIN civicrm_uf_...", (Array:1), TRUE)
#4 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Profile/Form/Edit.php(125): CRM_Core_DAO::executeQuery("\nSELECT module,is_reserved\n  FROM civicrm_uf_group\n  LEFT JOIN civicrm_uf_...", (Array:1))
#5 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Form.php(436): CRM_Profile_Form_Edit->preProcess()
#6 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm()
#7 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Profile_Form_Edit), "display")
#8 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Profile_Form_Edit), "display")
#9 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php(356): HTML_QuickForm_Page->handle("display")
#10 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#11 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Profile/Page/Router.php(121): CRM_Utils_Wrapper->run("CRM_Profile_Form_Edit", "Create Profile", (Array:2))
#12 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(331): CRM_Profile_Page_Router->run((Array:3), NULL)
#13 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(75): CRM_Core_Invoke::runItem((Array:14))
#14 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#15 /home/xxxx/public_html/drupal/sites/all/modules/civicrm/drupal/civicrm.module(457): CRM_Core_Invoke::invoke((Array:3))
#16 [internal function](): civicrm_invoke("profile", "create")
#17 /home/xxxx/public_html/drupal/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#18 /home/xxxx/public_html/drupal/index.php(21): menu_execute_active_handler()
#19 {main}