FUDforum: Bug Reports » upgrading 2.6.2->2.6.3 error (PostgresSQL)

Home » FUDforum Development » Bug Reports » upgrading 2.6.2->2.6.3 error (PostgresSQL)

Show: Today's Messages :: Polls :: Message Navigator

upgrading 2.6.2->2.6.3 error (PostgresSQL) [message #18354]

Tue, 18 May 2004 20:45

Sebastian_T

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

Report message to a moderator

Re: upgrading 2.6.2->2.6.3 error (PostgresSQL) [message #18358 is a reply to message #18354]

Tue, 18 May 2004 21:51

Ilia

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

Report message to a moderator