Page 1 of 1
Hi All!!! I have a problem with MEDIA LIBRARY on POSTGRESQL!
Posted: Wed Sep 05, 2007 10:32 am
by 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!
Re: Hi All!!! I have a problem with MEDIA LIBRARY
Posted: Wed Sep 05, 2007 1:00 pm
by 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
I instal serendipity on Postgresql!
Posted: Wed Sep 05, 2007 1:28 pm
by 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?
Re: I instal serendipity on Postgresql!
Posted: Thu Sep 06, 2007 10:43 am
by 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
:)
Posted: Mon Sep 10, 2007 9:50 am
by 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!
SORT Query:)
Posted: Mon Sep 10, 2007 10:20 am
by 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.
Re: SORT Query:)
Posted: Mon Sep 10, 2007 10:27 am
by 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