postgresql patch how to get it working

[Anonymous]

Hi,
I downloaded and unpacked the postgresql patch esn made
and I get a diff file that i can use to patch the files

only.. I dont know what files to patch.. is their any instruction manual? (howto, readme)
this is the diff file I have: pixelpost_pgsql_v0.2.diff
the OS is Gnu/Linux and commandline is available :)
this is the output (the www dir is the directory pixelpost is located in)

[root@memphis photolog]# ls
__MACOSX pixelpost_pgsql_v0.2.diff www
[root@memphis photolog]# patch < pixelpost_pgsql_v0.2.diff
can't find file to patch at input line 4
Perhaps you should have used the -p or --strip option?
The text leading up to this was:
--------------------------
|diff -ur www.orig/addons/calendar.php www/addons/calendar.php
|--- www.orig/addons/calendar.php Tue Nov 16 01:18:34 2004
|+++ www/addons/calendar.php Sat Nov 27 23:03:54 2004
--------------------------
File to patch:


thanks in advance
kayjay

[ESN]

Please read the ReadMe.txt thats in the bz2

Step 1
unzip pixelpost_1.3.zip
tar xjf pixelpost_pgsql_v0.2.bz2
cp pixelpost_pgsql_v0.2.dif pixelpost_1.3


Step 2
cd pixelpost_1.3
patch < pixelpost_pgsql_v0.2.diff


Step 3
You'r done ;)

[Anonymous]

and that's what I did ...but it didnt work..
see what I posted

I always read the txt...

[Anonymous]

Ok I managed to patch the files I think but Im getting these errors after I enhanced pixelpost.php in admin/:


Warning: pg_query(): Query failed: ERROR: relation "pixelpost_config" does not exist in /home/www/weblog/pixelpost/admin/index.php on line 51

Warning: Cannot modify header information - headers already sent by (output started at /home/www/weblog/pixelpost/admin/index.php:51) in /home/www/weblog/pixelpost/admin/index.php on line 55

[ESN]

This looks like you have not exec the admin/install.php (You have not setup the DB)

1º edit the admin/pixelpost.php
2º browse www.url.com/admin/install.php
3º www.url.com/admin/

if this is not you problem msg me back ;)

[Anonymous]

I managed to get in run properly just by redownloading the zip file from this site and to patch it again and for some reason.. it works.

The only problem I have now is that it doesnt create thumbs. This has to do with the gd lib.
It is installed but gd_info() doesnt work with this version of php. (Call to undefined function: gd_info() in /home/www/weblog/pixelpost/gd_test.php )
But that has to do with the other topic. and not with the db.

I've seen some kind of hack for it. hope that will work.
Thanks for all your trouble.