Bug #638
PostgreSQL database creation / merge fails.
Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
Quassel Core
Target version:
-
Start date:
03/21/2009
Due date:
% Done:
0%
Estimated time:
Version:
0.4.0+
OS:
Linux
Description
Hi,
I got a fresh git clone running here.
Yet, the PostgreSQL backend doesn't work.
Regardless of whether I'm attempting to convert an SQLite database to PostgreSQL or try to initialize one, PostgreSQL query errors are reported:
2009-03-21 15:43:32 Error: Storage Schema is missing! 2009-03-21 15:43:32 Error: unhandled Error in QSqlQuery! 2009-03-21 15:43:32 Error: last Query: CREATE INDEX backlog_bufferid_idx ON backlog(bufferid, messageid DESC) 2009-03-21 15:43:32 Error: executed Query: 2009-03-21 15:43:32 Error: bound Values: 2009-03-21 15:43:32 Error: Error Number: -1 2009-03-21 15:43:32 Error: Error Message: ERROR: syntax error at or near "DESC" at character 66QPSQL: Unable to create query 2009-03-21 15:43:32 Error: Driver Message: QPSQL: Unable to create query 2009-03-21 15:43:32 Error: DB Message: ERROR: syntax error at or near "DESC" at character 66 2009-03-21 15:43:32 Error: Unable to setup Logging Backend! 2009-03-21 15:43:32 Error: Selected storage backend is not available: "PostgreSQL"
PostgreSQL version: 8.0.15
Distribution: Gentoo Hardened
I followed the howto on the wiki, permissions are set correctly. As you can see, connection and interaction to / with PostgreSQL is working fine.
History
#1 Updated by EgS almost 16 years ago
- Status changed from New to Rejected
Quassel requires Postgres Version 8.3.0+
I think we should put that into the wiki :)