| Author |
Message |
CLermen
Nuke Cadet
Joined: Feb 27, 2003
Posts: 5
Location: Brasil
|
 Posted:
Thu Feb 27, 2003 4:28 am |
  |
Hi
I just installed PHPNuke in my server with PostgreSQL and I get the following errors in the database:
Warning: pg_exec() query failed: ERROR: parser: parse error at or near "=" in /home/ncg_temp/webdir/includes/sql_layer.php on line 212
Warning: pg_result_error(): supplied resource is not a valid PostgreSQL result resource in /home/ncg_temp/webdir/includes/sql_layer.php on line 214
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /home/ncg_temp/webdir/includes/sql_layer.php on line 267
Anyone can give me an idea of what is going wrong? What should I do to fix this problem ?
Thanks in advance. |
|
|
   |
|
Zhen-Xjell
Nuke Cops Founder
Joined: Nov 14, 2002
Posts: 5939
|
| Posted:
Thu Feb 27, 2003 8:04 am |
|
Turn on debug mode please. |
_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki] |
|
  |
|
CLermen
Nuke Cadet
Joined: Feb 27, 2003
Posts: 5
Location: Brasil
|
| Posted:
Thu Feb 27, 2003 10:41 am |
|
|
|
|
Zhen-Xjell
Nuke Cops Founder
Joined: Nov 14, 2002
Posts: 5939
|
| Posted:
Thu Feb 27, 2003 11:40 am |
|
Hi, this is documented in some threads around here. One in particular I can think of is the announcement forum. |
_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki] |
|
|
|
CLermen
Nuke Cadet
Joined: Feb 27, 2003
Posts: 5
Location: Brasil
|
| Posted:
Thu Feb 27, 2003 12:19 pm |
|
Thanks
I turned on the debug mode and I could see that the error is in the query passed to the PostgreSQL server:
SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where position='r' AND active='1' ORDER BY weight ASC
Warning: pg_exec() query failed: ERROR: parser: parse error at or near "=" in /home/ncg_temp/webdir/includes/sql_layer.php on line 213
It seems that the problem is in the field "position", but I can´t figure out where really is the problem.
Thanks again |
|
|
|
|
chatserv
General
Joined: Jan 12, 2003
Posts: 3128
Location: Puerto Rico
|
| Posted:
Thu Feb 27, 2003 12:24 pm |
|
If you are running nuke 6.5 then your database tables have not yet been updated as position is a field of nuke 6.0 |
_________________
Feed a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
ScriptHeaven | NukeResources |
|
|
|
CLermen
Nuke Cadet
Joined: Feb 27, 2003
Posts: 5
Location: Brasil
|
| Posted:
Thu Feb 27, 2003 12:43 pm |
|
I,m running nuke 6.0 with PostgreSQL 7.1.
Should I change to nuke 6.5 or this is a PostgreSQL specific problem ?
I ran that query using phpPgAdmin and the same error was returned.
When I removed the clause "position = 'l'" from the query, it worked fine.
Thanks again |
|
|
|
|
|
|
