|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
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
UBB.threads Developer
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
You're right.. I just made the tables with the perl version..... still no luck..
ugh =(
------------------------------------------------ Jeremy 'PeelBoy' Amberg
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: May 1999
Posts: 3,039
Guru
|
Guru
Joined: May 1999
Posts: 3,039 |
I've tried to work on it, but I don't know enough about Postgres to get the library working properly.
------------------- Scream WWWThreads Developer
UBB.threads Developer
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
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
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
|
Joined: Feb 2000
Posts: 128
Member
|
Member
Joined: Feb 2000
Posts: 128 |
blah.. never mind.. god this is frustrating. ------------------------------------------------ Jeremy 'PeelBoy' Amberg Edited by PeelBoy on 12/22/00 11:49 AM (server time).
------------------------------------------------ Jeremy 'PeelBoy' Amberg
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 417
Joined: November 2001
|
|
Forums63
Topics37,574
Posts293,926
Members13,850
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|