Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-15896

Upgrade to 4.5.5 causes contact photos to be unviewable

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 4.5.5
    • Fix Version/s: 4.5.7
    • Component/s: Core CiviCRM
    • Labels:
      None
    • Documentation Required?:
      User and Admin Doc

      Description

      After migrating, contact images do not show. Went from 4.4.6 to 4.5.5 When new ones are uploaded, they do not show. Existing contact images do not show. However, all other fields can be updated and save properly.

      Steps to reproduce:

      1. Open Test Org. Click Edit.

      2. Scroll Down to Upload an Image. The existing image is broken.

      3. Try uploading an image. Save. The Org saves.

      4. The image in upper right corner of Test Org page is broken. The url, if opened in a new browser tab, is like the pattern Derek described.

      It is possible to update other fields. I can add text and if I save, it is there. The image field, however, always shows a broken image.

      Errors thrown in Log

      #1
      $backTrace = #0 /var/www/html/sites/all/modules/civicrm/CRM/Core/Error.php(866): CRM_Core_Error::backtrace("backTrace", TRUE) #1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error)) #2 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error)) #3 /var/www/html/sites/all/modules/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: syntax error", 2, 16, (Array:2), "\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #4 /var/www/html/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error>DB_Error(2, 16, (Array:2), "\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #5 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR>raiseError(NULL, 2, NULL, NULL, "\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...", "DB_Error", TRUE) #6 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(899): DB_common>raiseError(2, NULL, NULL, NULL, "1064 ** You have an error in your SQL syntax; check the manual that correspon...") #7 /var/www/html/sites/all/modules/civicrm/packages/DB/mysql.php(328): DB_mysql>mysqlRaiseError() #8 /var/www/html/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #9 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #10 /var/www/html/sites/all/modules/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #11 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #12 /var/www/html/sites/all/modules/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...", TRUE) #13 /var/www/html/sites/all/modules/civicrm/CRM/Core/BAO/ActionSchedule.php(1317): CRM_Core_DAO::executeQuery("\n, MAX(reminder.action_date_time) as latest_log_time\nFROM \n\nINNER JOIN \...") #14 /var/www/html/sites/all/modules/civicrm/CRM/Core/BAO/ActionSchedule.php(1381): CRM_Core_BAO_ActionSchedule::buildRecipientContacts(3, "20150130184501", (Array:2)) #15 /var/www/html/sites/all/modules/civicrm/api/v3/Job.php(188): CRM_Core_BAO_ActionSchedule::processQueue(NULL, (Array:2)) #16 /var/www/html/sites/all/modules/civicrm/Civi/API/Provider/MagicFunctionProvider.php(86): civicrm_api3_job_send_reminder((Array:1)) #17 /var/www/html/sites/all/modules/civicrm/Civi/API/Kernel.php(95): Civi\API\Provider\MagicFunctionProvider->invoke((Array:9)) #18 /var/www/html/sites/all/modules/civicrm/api/api.php(25): Civi\API\Kernel->run("Job", "send_reminder", (Array:1), NULL) #19 /var/www/html/sites/all/modules/civicrm/CRM/Core/JobManager.php(145): civicrm_api("Job", "send_reminder", (Array:1)) #20 /var/www/html/sites/all/modules/civicrm/CRM/Core/JobManager.php(94): CRM_Core_JobManager->executeJob(Object(CRM_Core_ScheduledJob)) #21 /var/www/html/sites/all/modules/civicrm/bin/cron.php(42): CRM_Core_JobManager->execute() #22

      {main}

      #2
      Notice: Undefined index: HTTP_USER_AGENT in CRM_Utils_System::download() (line 837 of /var/www/html/sites/all/modules/civicrm/CRM/Utils/System.php).

      Noticed that in the past some issues with .htaccess file in files/civicrm/custom could be culprit. Check .htaccess file. It shows:

      <Files "*">
      Order allow,deny
      Allow from all
      </Files>

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                atif.shaikh Atif Shaikh
                Reporter:
                Bryan King Bryan King
              • Votes:
                1 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: