Forum

Thread tagged as: Problem

Assets thumbnails overlap / overflow

I just successfully updated my clients site to the latest Perch (2.5.4). However I noticed problems with the new assets section:

  1. Tall images overflows the grid causing thumbnails to overlap (looks like a mess).

  2. Wide images don't overflow the grid but are squished together on the width. Is this normal?

  3. The problem also exist when clicking one of the thumbnails to edit the details (title, tags etc). The image overflows its box causing the form fields below it (save in bucket, tags) to be partially covered by the image. This also happens with the wide images, where the link "Download original file" is covered.

Re-uploading the images actually seems to fix the problem (a properly sized and cropped thumbnail is generated?). However, I'd really like to not have to do that because there is a 7-10 pages of assets.

When I tested the update in on my local machine I only had the same problem appearing on a couple of images.

https://www.dropbox.com/s/4eapb0gdfpzad2o/assets1.png

https://www.dropbox.com/s/r21b5dv65j97gqb/assets2.png

https://www.dropbox.com/s/8qzr53jj9gsdxsd/assets3.png

Please help!

--

SUMMARY INFORMATION

Perch: 2.5.4, PHP: 5.3.28, MySQL: mysqlnd 5.0.8-dev - 20102224 - $Id: 731e5b87ba42146a687c29995d2dfd8b4e40b325 $, with PDO Server OS: Linux, cgi-fcgi Installed apps: content (2.5.4), assets (2.5.4), perch_events (1.9), perch_forms (1.7) App runtimes: <?php include(PERCH_PATH.'/core/apps/content/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_events/runtime.php'); include(PERCH_PATH.'/addons/apps/perch_forms/runtime.php'); ?> PERCH_LOGINPATH: /admin PERCH_PATH: /customers/2/f/e/eastwestsushi.com/httpd.www/admin PERCH_CORE: /customers/2/f/e/eastwestsushi.com/httpd.www/admin/core PERCH_RESFILEPATH: /customers/2/f/e/eastwestsushi.com/httpd.www/admin/resources Image manipulation: GD PHP limits: Max upload 96M, Max POST 96M, Memory: 128M, Total max file upload: 96M Resource folder writeable: Yes DOCUMENT_ROOT: /customers/2/f/e/eastwestsushi.com/httpd.www HTTP_HOST: www.eastwestsushi.com REQUEST_URI: /admin/core/settings/diagnostics/ SCRIPT_NAME: /admin/core/settings/diagnostics/index.php
Tim Kinali

Tim Kinali 0 points

  • 7 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

7 years ago

No that's not normal.

I can't tell if that is cached CSS (I had similar and that was the case, I just did a hard refresh) or if there is some other data issue. If you inspect the images do they have height and width tags stretching them to those sizes?
Tim Kinali

Tim Kinali 0 points

7 years ago

Rachel,

I tried cleaning the caches and also testing in other browsers (Mac Safari, Firefox, Chrome) which all exhibit the same thing.

There are no height or width tags or css on the problematic thumbs. All seem to display at 150px width (which makes some images squished) while the height displays in the img's natural size.

Ah I just discovered something. As I explained – reuploaded images (as well as some of the old ones!) displays correctly. When I inspect those, they actually do have width and height tags, making them scale and display correctly.

Any ideas?
Tim Kinali

Tim Kinali 0 points

7 years ago

Are you looking into this? What could be the reason that not all thumbnails have the width and height tag?
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

Which version did you update from?
Tim Kinali

Tim Kinali 0 points

7 years ago

I'm pretty sure it was the latest 2.4 release. (I have a backup of that perch core folder.)

I think I updated the events app after completing the Perch update. Would it have made any difference for my issue doing it the other way? (most images belong to events)
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

I wouldn't expect that to make a difference. If you load up the following URL in your site, you should get an almost empty page, but it will reindex your assets. Does it make a difference?

/perch/core/apps/assets/reindex/
Tim Kinali

Tim Kinali 0 points

7 years ago

Drew, unfortunately it didn't make a difference.
Tim Kinali

Tim Kinali 0 points

7 years ago

Drew McLellan said:

I wouldn't expect that to make a difference. If you load up the following URL in your site, you should get an almost empty page, but it will reindex your assets. Does it make a difference?

/perch/core/apps/assets/reindex/

  1. I should add that I didn't get an "almost empty" page but a completely empty page when I ran the reindex.

  2. I made a second attempt, this time enabling PERCH_DEBUG which displayed some SQL errors and missing properties. Output below:

DIAGNOSTICS:
SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r
WHERE u.roleID=r.roleID AND u.userEnabled='1' AND u.userID=1 AND u.userHash='2b753cab33e80e8514e5478ce3fdb209'
LIMIT 1
UPDATE perch2_users SET userHash='9d6342544b2c953e52f78702497a0a85' WHERE userID=1
SELECT p.privKey FROM perch2_user_privileges p
SELECT * FROM (SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=1 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID
SELECT * FROM perch2_resources ORDER BY resourceUpdated ASC
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='278'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/Events/ew10yreventwideweb-thumb@2x.jpg
ew10yreventwideweb-thumb@2x.jpg
Array

(

    [0] => w150h150@2x

    [1] => w150

    [2] => h150

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=14596, resourceCrop=0, resourceWidth=150, resourceHeight=55,5, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeight='150', resourceDensity='2' WHERE resourceID=278
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeigh' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='60'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/fah4842-h176@2x.jpg
fah4842-h176@2x.jpg
Array

(

    [0] => h176@2x

    [1] => 

    [2] => h176

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=20972, resourceCrop=0, resourceWidth=263,5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176', resourceDensity='2' WHERE resourceID=60
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176'' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='63'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/fah4884-h176@2x.jpg
fah4884-h176@2x.jpg
Array

(

    [0] => h176@2x

    [1] => 

    [2] => h176

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=39004, resourceCrop=0, resourceWidth=266,5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176', resourceDensity='2' WHERE resourceID=63
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176'' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='158'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/catering-h176@2x.jpg
catering-h176@2x.jpg
Array

(

    [0] => h176@2x

    [1] => 

    [2] => h176

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=39685, resourceCrop=0, resourceWidth=295,5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176', resourceDensity='2' WHERE resourceID=158
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176'' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='164'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/fah4892-h176@2x.jpg
fah4892-h176@2x.jpg
Array

(

    [0] => h176@2x

    [1] => 

    [2] => h176

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=55057, resourceCrop=0, resourceWidth=263,5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176', resourceDensity='2' WHERE resourceID=164
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=176, resourceMimeType='image/jpeg', resourceTargetHeight='176'' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='231'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/Events/1950-n-olthuis-thumb@2x.jpg
1950-n-olthuis-thumb@2x.jpg
Array

(

    [0] => w150h150@2x

    [1] => w150

    [2] => h150

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=18342, resourceCrop=0, resourceWidth=107,5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeight='150', resourceDensity='2' WHERE resourceID=231
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150',' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='235'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/Events/09-joanna-gorska-jerzy-skakun-driver-for-vera-film-poster-thumb@2x.jpg
09-joanna-gorska-jerzy-skakun-driver-for-vera-film-poster-thumb@2x.jpg
Array

(

    [0] => w150h150@2x

    [1] => w150

    [2] => h150

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=12785, resourceCrop=0, resourceWidth=107,5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeight='150', resourceDensity='2' WHERE resourceID=235
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150',' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='239'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/Events/3509696619afa38c1647o-thumb@2x.jpeg
3509696619afa38c1647o-thumb@2x.jpeg
Array

(

    [0] => w150h150@2x

    [1] => w150

    [2] => h150

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=13114, resourceCrop=0, resourceWidth=134,5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeight='150', resourceDensity='2' WHERE resourceID=239
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150',' at line 1
Looking up missing property resourceFileSize
SELECT resourceFileSize FROM perch2_resources WHERE resourceID='244'
Get image size: /Users/tim/Dropbox/Dev/East West/latest/admin/resources/Events/09-joanna-gorska-jerzy-skakun-driver-for-vera-film-poster-1-thumb@2x.jpg
09-joanna-gorska-jerzy-skakun-driver-for-vera-film-poster-1-thumb@2x.jpg
Array

(

    [0] => w150h150@2x

    [1] => w150

    [2] => h150

    [3] => 

    [4] => @2x

)


Yes
UPDATE perch2_resources SET resourceFileSize=12785, resourceCrop=0, resourceWidth=107,5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150', resourceTargetHeight='150', resourceDensity='2' WHERE resourceID=244
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '5, resourceHeight=150, resourceMimeType='image/jpeg', resourceTargetWidth='150',' at line 1
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=1
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=2
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=3
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=4
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=5
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=6
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=7
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=8
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=9
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=10
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=11
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=12
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=13
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=14
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=15
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=16
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=17
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=18
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=19
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=20
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=21
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=22
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=23
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=24
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=25
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=26
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=27
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=28
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=29
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=30
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=31
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=32
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=33
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=48
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=49
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=50
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=51
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=54
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=55
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=56
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=57
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=66
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=67
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=68
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=69
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=70
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=71
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=72
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=73
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=74
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=75
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=76
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=77
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=78
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=79
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=82
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=83
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=84
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=85
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=86
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=87
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=88
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=89
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=90
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=91
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=92
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=93
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=94
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=95
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=96
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=97
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=98
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=99
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=100
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=101
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=102
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=103
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=104
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=105
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=106
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=107
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=108
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=109
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=110
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=111
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=112
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=113
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=114
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=115
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=116
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=117
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=118
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=119
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=120
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=121
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=122
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=123
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=124
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=125
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=126
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=127
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=128
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=129
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=130
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=131
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=132
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=133
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=134
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=135
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=136
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=137
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=138
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=139
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=140
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=141
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=142
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=143
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=144
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=145
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=146
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=147
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=148
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=149
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=150
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=151
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=152
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=153
UPDATE perch2_resources SET resourceAWOL=1 WHERE resourceID=154
Queries: 271
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

What locale is your server set to?
Tim Kinali

Tim Kinali 0 points

7 years ago

Hi drew, It's Sv_se (Sweden)
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

Ok, I think that's the reason. I'll get this fixed in the next update.
Tim Kinali

Tim Kinali 0 points

7 years ago

Confirmed! I tested changing the locale on my dev site in config.php to en_GB and ran the reindex again. It worked. I then changed the locale back to sv_SE and everything is still fine.

I'm eager to fix this for my client, so do you think it's safe to do this on my client site too or could that potentially mess up the db?

About when do you think that this update will be released?
Drew McLellan

Drew McLellan 2638 points
Perch Support

7 years ago

It should be safe to do the same on your clients server. The fix will be in the next release.
Tim Kinali

Tim Kinali 0 points

7 years ago

Great. I did it now. I can confirm it's safe. Thanks for the support!
Urs Bräm

Urs Bräm 1 points

7 years ago

fab! I had the same issue and this thread solved it (I also had to switch the locale for reindexing)
Urs Bräm

Urs Bräm 1 points

7 years ago

launching a street party.