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 <[email protected]> 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?
>
> M.
>
>
> On 6 December 2011 17:33, Michael Nacos <[email protected]> wrote:
>
>> I've managed to install previous version of habari on postgresql, I'll
>> have a look.
>>
>>
>> On 4 December 2011 04:20, mikelietz <[email protected]> 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 [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-dev
>>
>>
>>
>>
>> --
>> Want to sign up for websites without giving your email? Ask me for a
>> leemail.me invite.
>>
>
>
>
> --
> Want to sign up for websites without giving your email? Ask me for a
> leemail.me invite.
>
--
Want to sign up for websites without giving your email? Ask me for a leemail
.me invite.
--
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-dev
