Hi All!!! I have a problem with MEDIA LIBRARY on POSTGRESQL!

[sanata_vopilif]

I have fresh instalation of serendipity last version.

When I upload my images everything is ok, BUT media library allways say there is not images. In fact files are in /uploads (by default).

I can't imagine the reason, because datebase. pref_images content records of my images.

I need some help!

[garvinhicking]

Hi!

So you see the files in your "upload" directory, AND they are in your _images table, but you don'T see them when you click on "media database" in your table?

Did you enable imagemagick in yourinstallation, or GD? Are therefiles in your uploaddirectory like ".serendipityThumb"?

Regards,
Garvin

[sanata_vopilif]

on Postgresql images have a problems with listing... yes my images is in the upload directory.everything is ok but they didn't show up in admin panel.
The version is the same on my Mysql server and there I do not have this problem! Can you tell me some postgresql fix?

[garvinhicking]

Hi!

Can you compare the database tables?

Sadly I'm no postgreSQL user and have not yet heard of this problem. Could it be something because of missing auto-increment keys?

Regards,
Garvin

[sanata_vopilif]

Got files:

Array
(
[.empty] => 1
[kaun1.jpg] => 1
[kaun1.serendipityThumb.jpg] => 1
[kaun_media/491_b.jpg] => 1
[kaun_media/491_b.serendipityThumb.jpg] => 1
[kaun_media/kaun11.jpg] => 1
[kaun_media/kaun11.serendipityThumb.jpg] => 1
[kaun_media/bonesnat.jpg] => 1
[kaun_media/bonesnat.serendipityThumb.jpg] => 1
[kaun_media/kaun2.jpg] => 1
[kaun_media/kaun2.serendipityThumb.jpg] => 1
[kaun01.jpg] => 1
[kaun01.serendipityThumb.jpg] => 1
)

this is the debug of my problem 6 images and they are there!
So:) I check my $serendipity array and [last_image_hash] => 16cf28d3018e818ac9e8655bcd3d6bb5 and [current_image_hash] => 16cf28d3018e818ac9e8655bcd3d6bb5 hmm they are the same? I think there is a postgresql bug...and if I fix it I will return answare. Pls help me if you can!

[sanata_vopilif]

oks now I see:) it was a problem with sort query... they don't work very well on postgresql. Now I see my images on list but sorted by DPI. I work in 1251 cyrilic:)) not utf8 if this help you.

[garvinhicking]

Hi!

The sort order is defined by what you entered in the web interface for displaying the media database, so did you maybe choose the DPI column there?

Regards,
Garvin