Answers.Body: <p>Looks to be this issue: <a href="https://lab.civicrm.org/dev/core/issues/1037" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/issues/1037</a></p>
  
  <p>You could try applying <a href="https://github.com/civicrm/civicrm-core/pull/14508" rel="nofollow noreferrer">the PR</a> linked there - or wait since it has been merged so will be in a release soon. </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-07-03T07:56:01.997Z
Answers.LastActivityDate: 2019-07-03T07:56:01.997Z
Answers.UserDisplayName: Aidan
Body: <p>In sent Mailings, the 'mailing.viewUrl' is rendered into:
  <a href="https://terranova.tamera.org/civicrm/mailing/view?reset=1&amp;id=95c21fb7cc1b7aac" rel="nofollow noreferrer">https://terranova.tamera.org/civicrm/mailing/view?reset=1&amp;id=95c21fb7cc1b7aac</a></p>
  
  <p>and clicking it gives me this error: </p>
  
  <blockquote>
    <p>$Fatal Error Details = Array ( [message] => One of parameters (value: e05fa931f15dedbb) is not of the type Integer [code] => )</p>
  </blockquote>
  
  <p>With the following stack trace:</p>
  
  <blockquote>
    <p>$backTrace = #0 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(343): CRM_Core_Error::backtrace("backTrace", TRUE) #1 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Utils/Type.php(535): CRM_Core_Error::fatal("One of parameters (value: e05fa931f15dedbb) is not of the type Integer") #2 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1519): CRM_Utils_Type::validate("e05fa931f15dedbb", "Integer") #3 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1397): CRM_Core_DAO::composeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime_typ...", (Array:2), TRUE) #4 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/BAO/File.php(332): CRM_Core_DAO::executeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime_typ...", (Array:2)) #5 /home/tamera/www/www/sites/all/modules/civicrm/api/v3/Mailing.php(571): CRM_Core_BAO_File::getEntityFile("civicrm_mailing", "e05fa931f15dedbb") #6 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm_api3_mailing_preview((Array:3)) #7 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #8 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9)) #9 /home/tamera/www/www/sites/all/modules/civicrm/api/api.php(43): Civi\API\Kernel->runSafe("Mailing", "preview", (Array:3)) #10 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Mailing/Page/View.php(145): civicrm_api3("Mailing", "preview", (Array:3)) #11 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Mailing_Page_View->run((Array:3), NULL) #12 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:15)) #13 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3)) #14 /home/tamera/www/www/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3)) #15 /home/tamera/www/www/includes/menu.inc(527): civicrm_invoke("mailing", "view") #16 /home/tamera/www/www/index.php(21): menu_execute_active_handler() #17 {main}</p>
  </blockquote>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-02T11:26:46.987Z
Comments.Text: Forgot to mention - I'm running Civi 5.14.1 on Drupal
Comments.UserDisplayName: Elad
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-02T11:46:32.407Z
Comments.Text: Under `Administer > CiviMail Component Settings`, is `Hashed Mailing URL's` ticked?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-07-02T18:07:22.070Z
Comments.Text: Yes, Hashed Mailing URL's is ticked.
Comments.UserDisplayName: Elad
Tags: <civimail>
Title: Error (One of parameters is not of the type Integer) while clicking the 'mailing.viewUrl' in a sent mailing
ThreadText: # Error (One of parameters is not of the type Integer) while clicking the 'mailing.viewUrl' in a sent mailing
  
  (Asked by: username_0 on 2019-07-02)
  
  In sent Mailings, the 'mailing.viewUrl' is rendered into:
  <https://terranova.tamera.org/civicrm/mailing/view?reset=1&id=95c21fb7cc1b7aac>
  
  and clicking it gives me this error:
  
  > $Fatal Error Details = Array ( [message] => One of parameters (value: e05fa931f15dedbb) is not of the type Integer [code] => )
  
  With the following stack trace:
  
  > $backTrace = #0 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(343): CRM\_Core\_Error::backtrace("backTrace", TRUE) #1 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Utils/Type.php(535): CRM\_Core\_Error::fatal("One of parameters (value: e05fa931f15dedbb) is not of the type Integer") #2 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1519): CRM\_Utils\_Type::validate("e05fa931f15dedbb", "Integer") #3 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1397): CRM\_Core\_DAO::composeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime\_typ...", (Array:2), TRUE) #4 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/BAO/File.php(332): CRM\_Core\_DAO::executeQuery("\nSELECT CF.id as cfID,\n CF.uri as uri,\n CF.mime\_typ...", (Array:2)) #5 /home/tamera/www/www/sites/all/modules/civicrm/api/v3/Mailing.php(571): CRM\_Core\_BAO\_File::getEntityFile("civicrm\_mailing", "e05fa931f15dedbb") #6 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(101): civicrm\_api3\_mailing\_preview((Array:3)) #7 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(168): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #8 /home/tamera/www/www/sites/all/modules/civicrm/Civi/API/Kernel.php(99): Civi\API\Kernel->runRequest((Array:9)) #9 /home/tamera/www/www/sites/all/modules/civicrm/api/api.php(43): Civi\API\Kernel->runSafe("Mailing", "preview", (Array:3)) #10 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Mailing/Page/View.php(145): civicrm\_api3("Mailing", "preview", (Array:3)) #11 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM\_Mailing\_Page\_View->run((Array:3), NULL) #12 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM\_Core\_Invoke::runItem((Array:15)) #13 /home/tamera/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM\_Core\_Invoke::\_invoke((Array:3)) #14 /home/tamera/www/www/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM\_Core\_Invoke::invoke((Array:3)) #15 /home/tamera/www/www/includes/menu.inc(527): civicrm\_invoke("mailing", "view") #16 /home/tamera/www/www/index.php(21): menu\_execute\_active\_handler() #17 {main}
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_0**: Forgot to mention - I'm running Civi 5.14.1 on Drupal  
  > **username_1**: Under `Administer > CiviMail Component Settings`, is `Hashed Mailing URL's` ticked?  
  > **username_0**: Yes, Hashed Mailing URL's is ticked.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-07-03. Score: 2
  
  Looks to be this issue: <https://lab.civicrm.org/dev/core/issues/1037>
  
  You could try applying [the PR](https://github.com/civicrm/civicrm-core/pull/14508) linked there - or wait since it has been merged so will be in a release soon.
  
  
  ---
  
  