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 -~----------~----~----~----~------~----~------~--~---
