PostgreSQL support?
8 views
Skip to first unread message
E. Naeher
Sep 4, 2008, 2:06:45 PM9/4/08
to habari-users
Hello,
Has anyone successfully gotten Habari going using Postgres?
I'm using Habari 0.5, Postgres 8.3.3. After clicking 'Install' on the
installer page, I get:
Warning: PDOStatement::execute() [pdostatement.execute]:
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column
"id" violates not-null constraint in system/classes/
databaseconnection.php line 261
In the Postgres logs:
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:44 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:44 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:44 CDT FATAL: password authentication failed for
user "habari"
2008-09-04 13:51:44 CDT FATAL: password authentication failed for
user "habari"
2008-09-04 13:51:48 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:48 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:49 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:49 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__posts_pkey" for table "habari__posts"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__posts_slug_key" for table "habari__posts"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__postinfo_pkey" for table
"habari__postinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__posttype_pkey" for table
"habari__posttype"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__poststatus_pkey" for table
"habari__poststatus"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__options_pkey" for table
"habari__options"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__users_pkey" for table "habari__users"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__users_username_key" for table "habari__users"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__userinfo_pkey" for table
"habari__userinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__tags_pkey" for table "habari__tags"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__tags_tag_slug_key" for table "habari__tags"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__tag2post_pkey" for table
"habari__tag2post"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__comments_pkey" for table
"habari__comments"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__commentinfo_pkey" for table
"habari__commentinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__rewrite_rules_pkey" for table
"habari__rewrite_rules"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__crontab_pkey" for table
"habari__crontab"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__log_pkey" for table "habari__log"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__log_types_pkey" for table
"habari__log_types"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__log_types_module_key" for table
"habari__log_types"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__groups_pkey" for table "habari__groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__groups_name_key" for table "habari__groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__permissions_pkey" for table
"habari__permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__permissions_name_key" for table
"habari__permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__users_groups_pkey" for table
"habari__users_groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__users_groups_user_id_key" for table
"habari__users_groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__groups_permissions_pkey" for table
"habari__groups_permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__groups_permissions_group_id_key" for table
"habari__groups_permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__sessions_pkey" for table
"habari__sessions"
2008-09-04 13:51:49 CDT ERROR: null value in column "id" violates not-
null constraint
2008-09-04 13:51:49 CDT STATEMENT: INSERT INTO habari__tags (id,
tag_text, tag_slug) VALUES (NULL, $1, $2)
2008-09-04 13:51:49 CDT ERROR: current transaction is aborted,
commands ignored until end of transaction block
Any suggestions will be gratefully received.
--Eli
Has anyone successfully gotten Habari going using Postgres?
I'm using Habari 0.5, Postgres 8.3.3. After clicking 'Install' on the
installer page, I get:
Warning: PDOStatement::execute() [pdostatement.execute]:
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column
"id" violates not-null constraint in system/classes/
databaseconnection.php line 261
In the Postgres logs:
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:43 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:43 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:44 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:44 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:44 CDT FATAL: password authentication failed for
user "habari"
2008-09-04 13:51:44 CDT FATAL: password authentication failed for
user "habari"
2008-09-04 13:51:48 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:48 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:49 CDT ERROR: relation "habari__options" does not
exist
2008-09-04 13:51:49 CDT STATEMENT: SELECT name, value, type FROM
habari__options
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__posts_pkey" for table "habari__posts"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__posts_slug_key" for table "habari__posts"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__postinfo_pkey" for table
"habari__postinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__posttype_pkey" for table
"habari__posttype"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__poststatus_pkey" for table
"habari__poststatus"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__options_pkey" for table
"habari__options"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__users_pkey" for table "habari__users"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__users_username_key" for table "habari__users"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__userinfo_pkey" for table
"habari__userinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__tags_pkey" for table "habari__tags"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__tags_tag_slug_key" for table "habari__tags"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__tag2post_pkey" for table
"habari__tag2post"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__comments_pkey" for table
"habari__comments"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__commentinfo_pkey" for table
"habari__commentinfo"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__rewrite_rules_pkey" for table
"habari__rewrite_rules"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__crontab_pkey" for table
"habari__crontab"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__log_pkey" for table "habari__log"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__log_types_pkey" for table
"habari__log_types"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__log_types_module_key" for table
"habari__log_types"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__groups_pkey" for table "habari__groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__groups_name_key" for table "habari__groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__permissions_pkey" for table
"habari__permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__permissions_name_key" for table
"habari__permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__users_groups_pkey" for table
"habari__users_groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__users_groups_user_id_key" for table
"habari__users_groups"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__groups_permissions_pkey" for table
"habari__groups_permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / UNIQUE will create
implicit index "habari__groups_permissions_group_id_key" for table
"habari__groups_permissions"
2008-09-04 13:51:49 CDT NOTICE: CREATE TABLE / PRIMARY KEY will
create implicit index "habari__sessions_pkey" for table
"habari__sessions"
2008-09-04 13:51:49 CDT ERROR: null value in column "id" violates not-
null constraint
2008-09-04 13:51:49 CDT STATEMENT: INSERT INTO habari__tags (id,
tag_text, tag_slug) VALUES (NULL, $1, $2)
2008-09-04 13:51:49 CDT ERROR: current transaction is aborted,
commands ignored until end of transaction block
Any suggestions will be gratefully received.
--Eli
Connway
Sep 17, 2008, 6:43:55 AM9/17/08
to habari-users
I am attempting to use PostgresSQL with Habari as well and am getting
the same error. I don't want to have to install another SQL database
manager if I don't have to.
the same error. I don't want to have to install another SQL database
manager if I don't have to.
Matt Read
Sep 17, 2008, 10:25:29 AM9/17/08
to habari...@googlegroups.com
On Wed, Sep 17, 2008 at 6:43 AM, Connway <nicholas...@gmail.com> wrote:
>
> I am attempting to use PostgresSQL with Habari as well and am getting
> the same error. I don't want to have to install another SQL database
> manager if I don't have to.
>
> I am attempting to use PostgresSQL with Habari as well and am getting
> the same error. I don't want to have to install another SQL database
> manager if I don't have to.
> On Sep 4, 11:06 am, "E. Naeher" <enae...@gmail.com> wrote:
>> I'm using Habari 0.5, Postgres 8.3.3. After clicking 'Install' on the
>> installer page, I get:
Postgre support in 0.5 is not that good. The latest SVN has much
better support for Postgre. SVN is quite stable right now.
--
Matt Read
http://mattread.com
Connway
Sep 17, 2008, 4:16:38 PM9/17/08
to habari-users
Downloaded the SVN version, worked like a charm. Thank you very much!
On Sep 17, 7:25 am, "Matt Read" <matt.r.r...@gmail.com> wrote:
On Sep 17, 7:25 am, "Matt Read" <matt.r.r...@gmail.com> wrote:
Reply all
Reply to author
Forward
0 new messages