FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » pg_query error line 96 of index.php?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
pg_query error line 96 of index.php? [message #31268] Thu, 13 April 2006 19:36 Go to next message
itrebal is currently offline  itrebal   United States
Messages: 1
Registered: April 2006
Location: Florida
Karma: 0
Junior Member
Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input at character 36 in /home/shrinks/public_html/FUDforum2/index.php on line 96

That is hte error I get when I first install it using postgresql. I am entirely unsure how to resolve it, and what caused it.
Re: pg_query error line 96 of index.php? [message #31275 is a reply to message #31268] Fri, 14 April 2006 20:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Can you access the forum's admin control panel, by going to
http://your_forum_url/admin/ ? If you can, check the query log and see what query failed?

If you cannot access the admin control panel look inside the forum's errors/ directory in there you'll find sql_errors file


FUDforum Core Developer
Re: pg_query error line 96 of index.php? [message #34310 is a reply to message #31268] Thu, 19 October 2006 06:25 Go to previous messageGo to next message
redbaron is currently offline  redbaron   Russian Federation
Messages: 3
Registered: October 2006
Location: Kazan
Karma: 0
Junior Member
I've exact the same problem.

in sql_errors I've:

ERROR:  syntax error at end of input at character 36<br />
Query: SELECT id FROM fud26_ses WHERE oid=<br />
_GET: array (
  't' =&gt; 'login',
  'adm' =&gt; '1',
)<br />


In PostgreSQL log file:
ERROR:  42601: syntax error at end of input at character 36
WHERE:       yyerror, scan.l:762
STATEMENT:  SELECT id FROM fud26_ses WHERE oid=


It seems like there is symbol to start new line after "oid=".

My env:
Postgresql 8.1.4
FUDForum 2.7.6 (zlib)
PHP 5.1.6

[Updated on: Thu, 19 October 2006 06:25]

Report message to a moderator

Re: pg_query error line 96 of index.php? [message #34312 is a reply to message #34310] Fri, 20 October 2006 01:01 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Do you have OID support enabled?

FUDforum Core Developer
Re: pg_query error line 96 of index.php? [message #34318 is a reply to message #34312] Fri, 20 October 2006 06:10 Go to previous messageGo to next message
redbaron is currently offline  redbaron   Russian Federation
Messages: 3
Registered: October 2006
Location: Kazan
Karma: 0
Junior Member
Ilia wrote on Thu, 19 October 2006 21:01

Do you have OID support enabled?

What is OID and where I should enable support of it?
Re: pg_query error line 96 of index.php? [message #34319 is a reply to message #31268] Fri, 20 October 2006 06:17 Go to previous message
redbaron is currently offline  redbaron   Russian Federation
Messages: 3
Registered: October 2006
Location: Kazan
Karma: 0
Junior Member
Ok, I've found solution. thx!

http://fudforum.org/forum/index.php?t=msg&th=6205&start=0&
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: MAILLIST
Next Topic: error after install GLOBALS.php
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 08:11:03 GMT 2024

Total time taken to generate the page: 0.02225 seconds