Mailing List Archive: [Bricolage-General] bug in upgrade program

[Bricolage-General] bug in upgrade program

Mar 21, 2002, 3:54 PM

Post #1 of 3 (1173 views)

Desperately trying to learn how to use bricolage.

Simple first step,

create story, get to the part where you click "save"

error
Unable to execute SQL statement

checking logs reveal:
Unable to execute SQL statement: DBD::Pg::st execute failed:
ERROR: audio_member:

checking the postgres permissions reveals that the following tables
do not have ANY access permission at all -- manually correcting

audio_member
seq_audio_member
seq_video_member
video_member

haven't looked at the 1.2.2 upgrade script in detail, but clearly the
permissions were not set.

BTW, still would like someone to PLEASE explain the function of
Pre and Post with respect to the document root or file system.

Michael
Michael@Insulin-Pumpers.org

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general

[Bricolage-General] bug in upgrade program [ In reply to ]

michael at insulin-pumpers

Mar 21, 2002, 3:53 PM

Post #2 of 3 (1134 views)

Permalink

Re: [Bricolage-General] bug in upgrade program [ In reply to ]

david at kineticode

Mar 22, 2002, 9:42 AM

Post #3 of 3 (1128 views)

Permalink

On Thu, 2002-03-21 at 15:53, Michael wrote:

> checking logs reveal:
> Unable to execute SQL statement: DBD::Pg::st execute failed:
> ERROR: audio_member:

> haven't looked at the 1.2.2 upgrade script in detail, but clearly the
> permissions were not set.

Yeah, you'll have to set those permissions yourself, I'm afraid. Just do
this in psql:

GRANT INSERT, UPDATE, SELECT, DELETE
ON audio_member, seq_audio_member, seq_video_member, video_member
TO MY_BRIC_USER

Be sure use your Bricolage PosgreSQL user name there.

> BTW, still would like someone to PLEASE explain the function of
> Pre and Post with respect to the document root or file system.

Just did.

HTH,

David

--
David Wheeler AIM: dwTheory
david@kineticode.com ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory@jabber.org
Kineticode. Setting knowledge in motion.[sm]

_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general