Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Bricolage: users

[Bricolage-General] bug in upgrade program

 

 

Bricolage users RSS feed   Index | Next | Previous | View Threaded


michael at insulin-pumpers

Mar 21, 2002, 3:54 PM

Post #1 of 3 (728 views)
Permalink
[Bricolage-General] bug in upgrade program

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 [at] Insulin-Pumpers

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


michael at insulin-pumpers

Mar 21, 2002, 3:53 PM

Post #2 of 3 (689 views)
Permalink
[Bricolage-General] bug in upgrade program [In reply to]

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 [at] Insulin-Pumpers

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


david at kineticode

Mar 22, 2002, 9:42 AM

Post #3 of 3 (682 views)
Permalink
Re: [Bricolage-General] bug in upgrade program [In reply to]

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 [at] kineticode ICQ: 15726394
Yahoo!: dew7e
Jabber: Theory [at] jabber
Kineticode. Setting knowledge in motion.[sm]

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

Bricolage users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.