search

vahidhedayati / grails-wschat-plugin

Grails websocket chat Plugin provides a multi-chat room add-on to an existing grails based site. provides: Private Messaging/WebRTC/Offline PM + room booking/reservations. Websocket TicTactoe. Add Live Chat to your Grails application
http://grails.org/plugin/wschat
Apache License 2.0
22 stars 10 forks source link

db config for this plugin? #8

Closed jcinquegrana closed 8 years ago

jcinquegrana commented 9 years ago

Sorry I'm an amateur. What did i do wrong? get these results and my users cant log into chat room. I suspect I must change the default persistence in the datasource.groovy, but couldn't find docs on that. Looked at videos too.

Running Grails application Error | 2015-08-13 16:35:48,817 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_block_list drop constraint FK_9mr7kcajd5s9kssgjfkbtt9g8 if exists Error | 2015-08-13 16:35:48,818 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_BLOCK_LIST" not found; SQL statement: alter table chat_block_list drop constraint FK_9mr7kcajd5s9kssgjfkbtt9g8 if exists [42102-176] Error | 2015-08-13 16:35:48,819 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_booking_invites drop constraint FK_c41fedy0sbd7ajnlrokhptddw if exists Error | 2015-08-13 16:35:48,819 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_BOOKING_INVITES" not found; SQL statement: alter table chat_booking_invites drop constraint FK_c41fedy0sbd7ajnlrokhptddw if exists [42102-176] Error | 2015-08-13 16:35:48,819 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_customer_booking drop constraint FK_s68rfd701egw2g96ykfj8p8if if exists Error | 2015-08-13 16:35:48,819 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_CUSTOMER_BOOKING" not found; SQL statement: alter table chat_customer_booking drop constraint FK_s68rfd701egw2g96ykfj8p8if if exists [42102-176] Error | 2015-08-13 16:35:48,819 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_friend_list drop constraint FK_d19nsbacgga45i4427nmgl23v if exists Error | 2015-08-13 16:35:48,820 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_FRIEND_LIST" not found; SQL statement: alter table chat_friend_list drop constraint FK_d19nsbacgga45i4427nmgl23v if exists [42102-176] Error | 2015-08-13 16:35:48,820 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_message drop constraint FK_g8rjdj81flqqu1w9077u6sbj0 if exists Error | 2015-08-13 16:35:48,820 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_MESSAGE" not found; SQL statement: alter table chat_message drop constraint FK_g8rjdj81flqqu1w9077u6sbj0 if exists [42102-176] Error | 2015-08-13 16:35:48,820 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_user drop constraint FK_i99bvxvgtx7d1ocgbqjt9wrlv if exists Error | 2015-08-13 16:35:48,820 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_USER" not found; SQL statement: alter table chat_user drop constraint FK_i99bvxvgtx7d1ocgbqjt9wrlv if exists [42102-176] Error | 2015-08-13 16:35:48,821 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_user drop constraint FK_5owi4i4i3cegtbeevkt2ua2ty if exists Error | 2015-08-13 16:35:48,821 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_USER" not found; SQL statement: alter table chat_user drop constraint FK_5owi4i4i3cegtbeevkt2ua2ty if exists [42102-176] Error | 2015-08-13 16:35:48,821 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_user drop constraint FK_fuw7fq86933dkg2rcx4dylrii if exists Error | 2015-08-13 16:35:48,821 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_USER" not found; SQL statement: alter table chat_user drop constraint FK_fuw7fq86933dkg2rcx4dylrii if exists [42102-176] Error | 2015-08-13 16:35:48,821 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_user_pics drop constraint FK_gfncij0kudcsfmgax6t9rhc0t if exists Error | 2015-08-13 16:35:48,822 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_USER_PICS" not found; SQL statement: alter table chat_user_pics drop constraint FK_gfncij0kudcsfmgax6t9rhc0t if exists [42102-176] Error | 2015-08-13 16:35:48,822 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table chat_user_profile drop constraint FK_tjq957gketyppaj3m9jo0cy67 if exists Error | 2015-08-13 16:35:48,822 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "CHAT_USER_PROFILE" not found; SQL statement: alter table chat_user_profile drop constraint FK_tjq957gketyppaj3m9jo0cy67 if exists [42102-176] Error | 2015-08-13 16:35:48,822 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table off_line_message drop constraint FK_kwf7yp5m3d9l6evalx4nndtdb if exists Error | 2015-08-13 16:35:48,822 [localhost-startStop-1] ERROR hbm2ddl.SchemaExport - Table "OFF_LINE_MESSAGE" not found; SQL statement: alter table off_line_message drop constraint FK_kwf7yp5m3d9l6evalx4nndtdb if exists [42102-176] |Server running. Browse to http://localhost:8080/chat

vahidhedayati commented 9 years ago

Looks like tables are not being created. https://github.com/vahidhedayati/testwschat/blob/master/grails-app/conf/DataSource.groovy#L33

what's dbCreate set to? Try as above if anything either create a new app and just call plugin in your build configuration or just clone above project I think it uses 2.4.4

vahidhedayati commented 8 years ago

Please re-create if there is any issues this is ancient and must be resolved by now