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

Home » FUDforum Development » Bug Reports » upgrading 2.6.2->2.6.3 error (PostgresSQL)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
upgrading 2.6.2->2.6.3 error (PostgresSQL) [message #18354] Tue, 18 May 2004 20:45 Go to next message
Sebastian_T is currently offline  Sebastian_T   Poland
Messages: 33
Registered: January 2004
Location: Warsaw, Poland
Karma: 0
Member
When upgrading, such error occured:


Warning: pg_query(): Query failed: ERROR: syntax error at or near "LIMIT" at character 73 . in /usr/local/apache/htdocs/forum.blizniaki.net/upgrade.php on line 549
PostgreSQL Error: ERROR: syntax error at or near "LIMIT" at character 73
Query: DELETE FROM fud23_thread_notify WHERE user_id='2' AND thread_id='1696' LIMIT 1


I think it's bad formulated query for postgres... (my admin says so, as I'm just user and owner of our forum Wink )


Sebastian
Re: upgrading 2.6.2->2.6.3 error (PostgresSQL) [message #18358 is a reply to message #18354] Tue, 18 May 2004 21:51 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
Your admin is correct in his analysis is correct, here is an updated upgrade script that hopefuly should address this problem.
http://bb.prohost.org/upgrade.php.bz2


FUDforum Core Developer
Odp: Re: upgrading 2.6.2->2.6.3 error (PostgresSQL) [message #18378 is a reply to message #18358] Wed, 19 May 2004 20:09 Go to previous message
Sebastian_T is currently offline  Sebastian_T   Germany
Messages: 33
Registered: January 2004
Location: Warsaw, Poland
Karma: 0
Member
thanks again Smile

Sebastian
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: "mark all unread forum messages read" - error
Next Topic: smart notification (yes/no)
Goto Forum:
  

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

Current Time: Sat Nov 09 17:27:40 GMT 2024

Total time taken to generate the page: 0.03337 seconds