UBB.Developers Forums UBB.threads 7 Development How Do I? Question for Cardoe..

Hey..

I'm trying to use php + postgres version of the forum and I keep getting this error message:


Parse error: parse error in /home/httpd/html/maxima/forum/postgres.inc.php on line 25

Fatal error: Cannot instantiate non-existent class: sql in /home/httpd/html/maxima/forum/main.inc.php on line 43


Do you have any idea what is causing that?

------------------------------------------------
Jeremy 'PeelBoy' Amberg

I figured out the problem..

on line 25 of postgres.inc.php the $connect var is messed up.

there needs to be a dot after "user="

it should be "user=" . $config.......

------------------------------------------------
Jeremy 'PeelBoy' Amberg

I get bunches of errors when I try to run createtables with postgres.....

Warning: PostgreSQL query failed: ERROR: Relation 'w3t_users' does not exist
in postgres.inc.php on line 59

Seeya! ERROR: Relation 'w3t_users' does not exist

Warning: Supplied argument is not a valid PostgreSQL result resource in postgres.inc.php on line 74

Warning: PostgreSQL query failed: ERROR: Relation 'w3t_users' does not exist
in postgres.inc.php</b> on line 59

Seeya! ERROR: Relation 'w3t_users' does not exist

etc...

I guess I should try the Perl version to create the tables and then use PHP after that..

------------------------------------------------
Jeremy 'PeelBoy' Amberg

I don't think that would help at this point. There is a problem with the postgres.inc file and some of the basic sql commands. I haven't been able to get this working so I haven't been able to debug the postgres support as of yet.

-------------------
Scream
WWWThreads Developer

You're right.. I just made the tables with the perl version..... still no luck..

ugh =(



------------------------------------------------
Jeremy 'PeelBoy' Amberg

Just curious.

Are you looking into it?

Any idea when it might be fixed?

I'm really looking forward to putting a new forum up soon, but
I don't want to use mySQL at all. I just want one db server running
and mySQL is far to weak for my needs.

------------------------------------------------
Jeremy 'PeelBoy' Amberg

I've tried to work on it, but I don't know enough about Postgres to get the library working properly.

-------------------
Scream
WWWThreads Developer

Here's one..

in adduser

around line 219 or so..

VALUES ( '$seq', ...............

should be

VALUES ( $seq,

don't put the single quotes around the sequence....


Also.. for who's online.. using REPLACE isn't going to work I don't think.. You might have to do a select to see if the row exists in the db and then do an insert or update depending on if the row exists or not.

------------------------------------------------
Jeremy 'PeelBoy' Amberg

and another..

in postgres.inc.php (or whatever)

around line 74 in the fetch_array method..

change:

$this->row = pg_fetch......

to:

if ( pg_numrows($sth) > 0 )
{
$this->row = pg_fetch.....
}
else
{
$this->row = "";
}

That will keep it from spitting out error messages if no rows were returned.

------------------------------------------------
Jeremy 'PeelBoy' Amberg

blah.. never mind.. god this is frustrating.

------------------------------------------------
Jeremy 'PeelBoy' Amberg

Edited by PeelBoy on 12/22/00 11:49 AM (server time).