okay thanks for the hint I will rename the column name. http://code.google.com/p/openmeetings/issues/detail?id=1151
Sebastian 2010/2/18 Alexander Prudnikov <[email protected]>: > 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. > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://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.
