Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
habari-dev
Home
+ new post
About this group
Join this group
installing on postgresql?
Options
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
   9 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
mikelietz  
View profile  
 More options Dec 3 2011, 11:20 pm
From: mikelietz <cod...@gmail.com>
Date: Sat, 3 Dec 2011 20:20:08 -0800 (PST)
Local: Sat, Dec 3 2011 11:20 pm
Subject: installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author
I can't seem to get Habari 0.8, or master, to install on postgresql. I
get errors in my server log about classes/logentry:101 and 195, and
the installer just reloads.

Is anybody else able to install on pgsql?


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Bryce Campbell  
View profile  
 More options Dec 3 2011, 11:21 pm
From: Bryce Campbell <tonyhawk2...@gmail.com>
Date: Sat, 3 Dec 2011 20:21:59 -0800
Local: Sat, Dec 3 2011 11:21 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

Sorry, I use MySQL on all my servers.
On Dec 3, 2011 8:20 PM, "mikelietz" <cod...@gmail.com> wrote:


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Nacos  
View profile  
 More options Dec 6 2011, 12:33 pm
From: Michael Nacos <m.na...@gmail.com>
Date: Tue, 6 Dec 2011 17:33:15 +0000
Local: Tues, Dec 6 2011 12:33 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

I've managed to install previous version of habari on postgresql, I'll have
a look.

On 4 December 2011 04:20, mikelietz <cod...@gmail.com> wrote:

> I can't seem to get Habari 0.8, or master, to install on postgresql. I
> get errors in my server log about classes/logentry:101 and 195, and
> the installer just reloads.

> Is anybody else able to install on pgsql?

> --
> To post to this group, send email to habari-dev@googlegroups.com
> To unsubscribe from this group, send email to
> habari-dev-unsubscribe@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/habari-dev

--
Want to sign up for websites without giving your email? Ask me for a leemail
.me invite.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Nacos  
View profile  
 More options Dec 11 2011, 6:30 pm
From: Michael Nacos <m.na...@gmail.com>
Date: Sun, 11 Dec 2011 23:30:46 +0000
Local: Sun, Dec 11 2011 6:30 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

I've used the recommended zipfile from here:
http://habariproject.org/dist/habari_makaanga.zip and it installs fine.
What kind of errors did you get?

M.

On 6 December 2011 17:33, Michael Nacos <m.na...@gmail.com> wrote:

--
Want to sign up for websites without giving your email? Ask me for a leemail
.me invite.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Bishop  
View profile  
 More options Dec 11 2011, 7:44 pm
From: Michael Bishop <mi...@miklb.com>
Date: Sun, 11 Dec 2011 19:44:57 -0500
Local: Sun, Dec 11 2011 7:44 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

Might be using the latest dev build, rather than that version, which is
basically .7.x

~miklb


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael C. Harris  
View profile  
 More options Dec 11 2011, 7:48 pm
From: "Michael C. Harris" <mich...@twofishcreative.com>
Date: Mon, 12 Dec 2011 11:48:28 +1100
Local: Sun, Dec 11 2011 7:48 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author
On 12 December 2011 11:44, Michael Bishop <mi...@miklb.com> wrote:

> On Sun, Dec 11, 2011 at 6:30 PM, Michael Nacos <m.na...@gmail.com> wrote:>>>> I've used the recommended zipfile from here:>> http://habariproject.org/dist/habari_makaanga.zip and it installs fine.>> What kind of errors did you get?>
> Might be using the latest dev build, rather than that version, which is
> basically .7.x

The makaanga _should_ be the right version, but something seems to
have gone awry with the script that makes it. I'll look into that
later, but in the meantime, could you try
http://habariproject.org/dist/habari_head.zip ?

--
Michael C. Harris, School of CS&IT, RMIT University
http://twofishcreative.com/michael/blog
IRC: michaeltwofish #habari


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael Nacos  
View profile  
 More options Dec 11 2011, 7:53 pm
From: Michael Nacos <m.na...@gmail.com>
Date: Mon, 12 Dec 2011 00:53:05 +0000
Local: Sun, Dec 11 2011 7:53 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

michaeltwofish kindly pointed out smthg's wrong with this zipfile, so I
tried installing again using the same setup and a new zipfile from HEAD.
This time got:

*ERROR:  duplicate key value violates unique constraint
"testblog__log_types_module_key"*

which stops installation in its tracks. Removing the UNIQUE constraint
allows the installation to proceed just fine.

diff --git a/system/schema/pgsql/schema.sql b/system/schema/pgsql/schema.sql
index c4a128e..9d55cad 100644
--- a/system/schema/pgsql/schema.sql
+++ b/system/schema/pgsql/schema.sql
@@ -143,8 +143,7 @@ CREATE TABLE {$prefix}log_types (
   id INTEGER NOT NULL DEFAULT nextval('{$prefix}log_types_pkey_seq'),
   module VARCHAR(100) NOT NULL,
   type VARCHAR(100) NOT NULL,
-  PRIMARY KEY (id),
-  UNIQUE (module,type)
+  PRIMARY KEY (id)
 );

looking at the actual data in the db gives:

testblog=> SELECT * FROM testblog__log_types;
 id |   module   |      type
----+------------+----------------
  1 | *habari*     | *content
*  2 | habari     | theme
  3 | habari     | default
  4 | habari     | user
  5 | habari     | authentication
  6 | *habari*     | *content*
  7 | habari     | comment
  8 | habari     | default
  9 | habari     | plugin
 10 | HabariSilo | plugin
 11 | Pingback   | Pingback
(11 rows)

so it's clear the {habari, content} combination gets registered twice,
which violates the constraint.

This is actually good news. Install went fine and my postgres + habari 8
dummy blog seens fully functional, all you need to do is find out why
{habari, content} is emitted twice.

cheers,

Michael

On 11 December 2011 23:30, Michael Nacos <m.na...@gmail.com> wrote:

--
Want to sign up for websites without giving your email? Ask me for a leemail
.me invite.

 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Andy C  
View profile  
 More options Dec 20 2011, 8:32 am
From: Andy C <andyc...@gmail.com>
Date: Tue, 20 Dec 2011 05:32:12 -0800 (PST)
Local: Tues, Dec 20 2011 8:32 am
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

You have just broken the referential integrity of your database.

Odd things may happen when code is presented with 2 records for 'habari -
content' when only 1 is expected.

Not today, not tomorrow but when you are least expecting it.

I would remove second 'habari - content' record and reinstate the unique
primary key on (module, type).

Obviously, the installer/upgrade should skip any attempts to re-insert
pre-existing meta data and just add new records.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Michael C. Harris  
View profile  
 More options Dec 20 2011, 5:08 pm
From: "Michael C. Harris" <mich...@twofishcreative.com>
Date: Wed, 21 Dec 2011 09:08:14 +1100
Local: Tues, Dec 20 2011 5:08 pm
Subject: Re: [habari-dev] installing on postgresql?
Print | Individual message | Show original | Report this message | Find messages by this author

The fix was to register types earlier, thus preventing a default being
registered, which was causing the duplicate.

https://github.com/habari/system/commit/589f61220c0e35eff77020ac1a4cd...

On Wednesday, 21 December 2011, Andy C <andyc...@gmail.com> wrote:
> You have just broken the referential integrity of your database.

> Odd things may happen when code is presented with 2 records for 'habari -

content' when only 1 is expected.

> Not today, not tomorrow but when you are least expecting it.

> I would remove second 'habari - content' record and reinstate the unique

primary key on (module, type).

> Obviously, the installer/upgrade should skip any attempts to re-insert

pre-existing meta data and just add new records.

> --
> To post to this group, send email to habari-dev@googlegroups.com
> To unsubscribe from this group, send email to

habari-dev-unsubscribe@googlegroups.com
> For more options, visit this group at

http://groups.google.com/group/habari-dev

--
Michael C. Harris
http://twofishcreative.com/michael/blog
IRC: michaeltwofish #habari


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2012 Google