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
#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
- supplements
-
CRM-15897 Contact ImagesUnviewable - Issue Persisting through 4.5.5
- Done/Fixed