I've also noticed this problem on the "1.1-r2905" version.
The table is not auto-created for Postgres.
I had to create the table myself:
I took the "create table" script from the error log and quoted the
"offset" column.

(But I'm not sure if this prevents errors in the future.)

Here is the error from the error.log:

2010-02-18 17:53:49,539 [Launcher:/openmeetings] ERROR
o.h.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table
flvrecording_meta_delta (flvrecording_meta_delta_id int8 not null,
flvrecording_metadata_id int8, time_stamp int4, delta_time int8,
last_time_stamp int8, delta_time_stamp int8, packet_time_stamp int4,
offset int8, start_time_stamp int4, missing_time int8, duration int4,
start_time timestamp, current_event_time timestamp, is_end_padding
bool, is_start_padding bool, debug_status varchar(255),
stream_creation_time int8, stream_creation_time_date timestamp,
wave_out_put_name varchar(255), data_length_packet int4,
received_audio_data_length int8, primary key
(flvrecording_meta_delta_id))
2010-02-18 17:53:49,540 [Launcher:/openmeetings] ERROR
o.h.tool.hbm2ddl.SchemaUpdate - ERROR: syntax error at or near
"offset"


On Jan 25, 10:29 am, Sebastian Wagner <[email protected]> wrote:
> okay thanks for the hint.
>
> Sebastian
>
> 2010/1/25 John Davis <[email protected]>
>
>
>
>
>
> > Potential problem with table flvrecording_meta_delta. Will not get
> > generated in Postgresql due to error, hangs application on startup.
>
> > The field in this table causes issues with Postgresql. I believe it is
> > an issue with the column name "offset" being used as a keyword in
> > Postgresql.
>
> >  I simply fixed the issue by renaming the column name the mapped name
> > can be left as is.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "OpenMeetings User" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected]<openmeetings-user%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/openmeetings-user?hl=en.
>
> --
> Sebastian 
> Wagnerhttp://www.webbase-design.dehttp://openmeetings.googlecode.comhttp://www.laszlo-forum.de
> [email protected]

-- 
You received this message because you are subscribed to the Google Groups 
"OpenMeetings User" group.
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/openmeetings-user?hl=en.

Reply via email to