Photo Organizer

This is the bug tracker for Photo Organizer.
Tasklist

FS#323 - Search function does not work with PostgreSQL 8.30

Attached to Project: Photo Organizer
Opened by Bruno Delalleau (realnerd) - Tuesday, 12 February 2008, 16:39 GMT-4
Last edited by Solomon Peachy (pizza) - Saturday, 26 July 2008, 08:54 GMT-4
Task Type Bug Report
Category Backend / Core → Database
Status Closed
Assigned To No-one
Operating System Linux
Severity Low
Priority Normal
Reported Version 2.35
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Search function no longer works since I upgraded from PostgreSQL 8.26 to 8.30.
This task depends upon

Closed by  Solomon Peachy (pizza)
Saturday, 26 July 2008, 08:54 GMT-4
Reason for closing:  Not a bug
Additional comments about closing:  I'm closing this for now; I plan on upgrading one of my test installations to use PG 8.3.x soon-ish, and I'll fix the bugs that crop up.
Comment by Solomon Peachy (pizza) - Tuesday, 12 February 2008, 17:16 GMT-4
What searches fail? (basic/folder/user/advanced?)

What's the actual error message? (see your httpd error_log)
Comment by Bruno Delalleau (realnerd) - Wednesday, 13 February 2008, 14:02 GMT-4
It should be a problem on my PostgreSQL 8.30 installation: when I use phpPgadmin to access po_db, the find function of phpPgadmin is not working, in spite of table of key-words being OK with keywords presents.

Sorry for the noise! Please remove this Bug Report which is only due to my ignorance...
Comment by Solomon Peachy (pizza) - Wednesday, 13 February 2008, 14:24 GMT-4
Was this a new installation on PSQL 8.3.0, or was it an installation that was upgraded from an older version of PSQL?

I don't have any PSQL 8.3.0 systems to play with right now, but it would be good to know the root cause of this problem, just in case there's something legitimately wrong with PO.
Comment by Bruno Delalleau (realnerd) - Wednesday, 13 February 2008, 15:22 GMT-4
This was an entirely new installation of PGSQL 8.3.0, compiled by me from the source.

I use Debian etch with linux 2.6.24, php5, apache2. Compilation was fine with GNUmake, and installation without problem.

I went back to PGSQL 8.2.6 and everything is fine again :o)

There is something in PGSQL 8.3.0 that is not working. I am now on the PGSQL mailing list and will ask. I will let you know when I find.

Loading...