|
|
 | | From: | Daniel Blavos | | Subject: | Error Help | | Date: | Thu, 20 Jan 2005 16:22:03 -0700 |
|
|
 | This is a multi-part message in MIME format.
------=_NextPart_000_0019_01C4FF0C.2D0A59C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I have been working on two errors that I continue to recieve. I am =
attempting to get DocMgr to work with Postgres and PHP4. Postgres is =
version 7.4.6, and PHP4 is version 4.3.10. I am able to access the =
test.php page and my apache server page like normal. When I try to =
access my /doc/ directory in my web browser, I recieve this error:
=20
Warning: pg_query(): Query failed: ERROR: relation "site_properties" =
does not exist in /var/www/doc/include/postgresql.inc.php on line 46
ERROR_SQL=3DSELECT * FROM site_properties ORDER BY sort_order
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL =
result resource in /var/www/doc/include/postgresql.inc.php on line 49
Error! No modules are configured in this system
I am absoutley stuck on what to do. All my variables and account =
permissions are set correctly, yet it still keeps giving me this error. =
Any ideas? =20
Thank you,
Daniel Blavos
------=_NextPart_000_0019_01C4FF0C.2D0A59C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
charset=3Diso-8859-1">
Hello, I have been working on two errors that =
I continue=20
to recieve. I am attempting to get DocMgr to work with Postgres =
and=20
PHP4. Postgres is version 7.4.6, and PHP4 is version 4.3.10. =
I am=20
able to access the test.php page and my apache server page like =
normal. =20
When I try to access my /doc/ directory in my web browser, I =
recieve this=20
error:
Warning: pg_query(): Query =
failed:=20
ERROR: relation "site_properties" does not exist in=20
/var/www/doc/include/postgresql.inc.php on line=20
46
ERROR_SQL=3DSELECT * FROM site_properties ORDER BY=20
sort_order
Warning: pg_numrows(): supplied argument is not a =
valid=20
PostgreSQL result resource in =
/var/www/doc/include/postgresql.inc.php on=20
line 49
Error! No modules are configured in this system I am absoutley stuck on =
what to=20
do. All my variables and account permissions are set correctly, =
yet it=20
still keeps giving me this error. Any ideas? Thank=20
you, Daniel=20
Blavos
------=_NextPart_000_0019_01C4FF0C.2D0A59C0--
|
|
| | From: | Jeff Eckermann | | Subject: | Re: Error Help | | Date: | Fri, 21 Jan 2005 06:57:11 -0800 (PST) |
|
|
| --- Daniel Blavos wrote:
> Hello,
>
> I have been working on two errors that I continue to
> recieve. I am attempting to get DocMgr to work with
> Postgres and PHP4. Postgres is version 7.4.6, and
> PHP4 is version 4.3.10. I am able to access the
> test.php page and my apache server page like normal.
> When I try to access my /doc/ directory in my web
> browser, I recieve this error:
>
>
> Warning: pg_query(): Query failed: ERROR: relation
> "site_properties" does not exist in
> /var/www/doc/include/postgresql.inc.php on line 46
'relation "site_properties" does not exist' looks like
a database error. Can you show us the table
definition? The output of "\d site_properties", using
psql, would be good. If you get a similar message (as
I suspect you will), the output of "\dt" will be
helpful.
Your problem appears to be related to case folding,
but it is difficult to be more specific without more
information.
> ERROR_SQL=SELECT * FROM site_properties ORDER BY
> sort_order
> Warning: pg_numrows(): supplied argument is not a
> valid PostgreSQL result resource in
> /var/www/doc/include/postgresql.inc.php on line 49
>
> Error! No modules are configured in this system
>
> I am absoutley stuck on what to do. All my
> variables and account permissions are set correctly,
> yet it still keeps giving me this error. Any ideas?
>
>
>
> Thank you,
>
> Daniel Blavos
__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
|
|
|
