Lex, please download the latest version 1.6.2
You will see that in the hibernate.cfg.xml there is a new dialect: <property name="dialect">org.openmeetings.app.hibernate.utils.MySQL5MyISAMDialect</property> That is only available starting with OpenMeetings 1.6.2 Sebastian 2011/3/10 Lex Later <[email protected]> > Hi everyone, > I'm tryng to install Openmeetings in a VM with Windows7, MySQL 5.5.8, > JRE6 (path JAVA_HOME ok) but after I think 10 try I have every time > the same problem. > I hope this piece of error log can be useful. > ----------------------- > 2011-03-10 16:54:53,195 [Launcher:/openmeetings] ERROR > o.h.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table > appointmentremindertyps (typ_id bigint not null, name varchar(255), > user_id bigint, starttime datetime, updatetime datetime, deleted > varchar(255), comment_field varchar(255), primary key (typ_id)) > type=MyISAM > 2011-03-10 16:54:53,205 [Launcher:/openmeetings] ERROR > o.h.tool.hbm2ddl.SchemaUpdate - You have an error in your SQL syntax; > check the manual that corresponds to your MySQL server version for the > right syntax to use near 'type=MyISAM' at line 1 > 2011-03-10 16:54:53,205 [Launcher:/openmeetings] ERROR > o.h.tool.hbm2ddl.SchemaUpdate - Unsuccessful: create table > appointments (appointment_id bigint not null, user_id bigint, > appointmentname varchar(255), location varchar(255), > appointment_starttime datetime, appointment_endtime datetime, > description varchar(255), category_id bigint, remind_id bigint, > starttime datetime, updatetime datetime, deleted varchar(255), > comment_field varchar(255), isweekly bit, ismonthly bit, isyearly bit, > isdaily bit, room_id bigint, icalId varchar(255), language_id bigint, > is_password_protected bit, password varchar(255), is_connected_event > bit, primary key (appointment_id)) type=MyISAM > [...] > ----------------------- > > This my hibernate conf file > --------------------- > <hibernate-configuration> > > <!-- a SessionFactory instance listed as /jndi/name --> > <session-factory> > > <!-- User / Password --> > <property name="connection.username">root</property> > <property name="connection.password"></property> > > <!-- Database Settings --> > <property > name="connection.driver_class">com.mysql.jdbc.Driver</ > property> > <!-- for performance reasons changed to MyISAM from > org.hibernate.dialect.MySQLInnoDBDialect --> > <property > name="dialect">org.hibernate.dialect.MySQLMyISAMDialect</ > property> > <property > name="connection.url">jdbc:mysql://localhost/openmeetings? > > autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8</ > property> > [...] > --------------------- > > Username and password (blank) are tested and working > the installation process appears to connect successfully to the > database since it can create a new one called OpenMeetings > (createDatabaseIfNotExist=true) but no tables are created.... damn... > what is the problem? :( > > -- > You received this message because you are subscribed to the Google Groups > "OpenMeetings developers" 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-dev?hl=en. > > -- Sebastian Wagner http://www.webbase-design.de http://openmeetings.googlecode.com http://www.wagner-sebastian.com [email protected] -- You received this message because you are subscribed to the Google Groups "OpenMeetings developers" 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-dev?hl=en.
