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" <[EMAIL PROTECTED]> wrote: > 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 --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/habari-users -~----------~----~----~----~------~----~------~--~---
