R63B Create Rooms Button Doesn't Work (BcStorm)

[CosmoTrigger]

I'm not sure if this fix has been posted anywhere, but i've been looking forever for it.

Everything in the client works except for the create rooms button.

It lets me go to the homeroom, and everything like that, but it just won't let me create a room :/

I'm not sure what the problem is, here's a picture of the rooms table in the database :

And on another not so important note: this groups button does not work either:

I am using BCStorm EMU (Newest version, with the most updated swfs)

 

[KyleVonnie]

Found this fix on another forum, not sure if it will work. Tell us what happens.
*Credits to TimNL from RZ for this fix*

Open your PHP.ini and set

sql_mode = '';

save and restart IIS/Apache
Run this query then.

SET@@global.sql_mode ='';

*And restart your emulator *

​

​

 

[CosmoTrigger]

Nothing, The only thing it could be is the swfs, haha but it doesn't really make any sense, do you have a link to working r63b swfs?

 

[JakeA]

Have you by any chance added any new columns in rooms? Because I remember doing this on butterstorm and was unable to create rooms until I removed the column, make sure all columns have a default value

 

[Stevee]

Does it give you an error on the emulator? Try clicking and and go to your mySQL errors folder, I had a similar issue like this.

I fixed it by dumping the rooms table, and then re-uploading the SQL manually.

 

[cyberxwarez]

have same problem
error:

Error in query:
INSERT INTO rooms (roomtype,caption,owner,model_name) VALUES ('private',@caption,@username,@model)
MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'description' doesn't have a default value
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Database_Manager.Database.Session_Details.QueryAdapter.insertQuery()

 

[lepos]

Found this fix on another forum, not sure if it will work. Tell us what happens.
*Credits to TimNL from RZ for this fix*

Open your PHP.ini and set

sql_mode = '';

save and restart IIS/Apache
Run this query then.

SET@@global.sql_mode ='';

*And restart your emulator *

​

​

I was just about to post this - I had this problem on my hotel and that is what I did and it worked.

Actually I only ran the query.

SET@@global.sql_mode ='';

 

[KyleVonnie]

I was just about to post this - I had this problem on my hotel and that is what I did and it worked.

Actually I only ran the query.

SET@@global.sql_mode ='';

Weird thing is I just encountered the same error, lol. I used the SQL, works perfectly. Thanks

 

[Vinnie]

Fix this yourself or buy

You must be registered for see links

's PlusEmu License

 

[sk8er423]

Ya but were in the php.ini like what line do I add it to?

 

[Weasel]

Open up your php.ini and search for sql_mode.

 

[sk8er423]

Nope it couldnt find it

 

[EKerik]

If you have a backup when it was good, restore the room bit in your db. This happend to me after a few weeks...
An old version of the db worked for me. Don't know what is is exactly but i know it's in the rooms_ bit.

Btw; that fix never worked for me either.