FUDforum: FUDforum Installation Issues » Install went fine, posting gives SQL error

Home » FUDforum » FUDforum Installation Issues » Install went fine, posting gives SQL error

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

Install went fine, posting gives SQL error [message #8050]

Fri, 10 January 2003 05:56

billkatz

Messages: 2
Registered: January 2003

Karma: 0

Junior Member

When I try posting or reading a message, I get an error like:

() :
Query: SELECT fud23_msg.id FROM fud23_msg WHERE thread_id=1 AND fud23_msg.approved='Y' ORDER BY id ASC LIMIT 40,0
Server Version: PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
[Referring Page] http://www.hewlettdeathride.org/forum/index.php?t=thread&frm_id=2&r id=1&S=49551e8b7bc4570a9b1b1612736104af

I'm using the latest postgres and php, both built from
sources in the last couple weeks.

-Bill

Report message to a moderator

Re: Install went fine, posting gives SQL error [message #8063 is a reply to message #8050]

Fri, 10 January 2003 15:12

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

http://fud.prohost.org/forum/index.php?t=msg&goto=8060

Attached to this thread is an installer with fixes aimed at PostgreSQL.

The problem you are experiecing is due to PostgreSQL 7.3+ dropping support for LIMIT [n,[n]]

FUDforum Core Developer

Report message to a moderator

Re: Install went fine, posting gives SQL error [message #8085 is a reply to message #8063]

Sat, 11 January 2003 00:29

billkatz

Messages: 2
Registered: January 2003

Karma: 0

Junior Member

Thanks... The new code works fine on my ssytem with Postgres. For future reference, is there a way to patch the installation without wiping everything out?

-Bill

Report message to a moderator

Re: Install went fine, posting gives SQL error [message #8086 is a reply to message #8085]

Sat, 11 January 2003 00:39

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

You can use the upgrade script to upgrade across FUDforum versions.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Installation OK error when logging in as Admin
Next Topic:	Problem with install from phpBB2?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 06:25:23 GMT 2024

Total time taken to generate the page: 0.02821 seconds