Skybird Groups & Rooms Issue

[Diddy]

Hello,


Im running skybird released by Johno, but i have come across 2 issues one of them i know how to fix the other i don't.
In the emu it says Error in Query Caught, when i check the MYSQLerror logs i come across these two issues;


Groups;

Error in query:
INSERT INTO groups (`name`, `desc`,`badge`,`owner_id`,`created`,`room_id`,`colour1`,`colour2`) VALUES(@[USER=7391]name[/USER], @desc, @badge, 2, UNIX_TIMESTAMP(), 75,'bd2121','ffffff')
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: 'bd2121' for column 'colour1' at row 1
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() in e:\Documents\Emulator [L]\Emulator [L]\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 164

Which i have no idea how to fix but i have the feeling its somthing similer to this issue,


Rooms;
This happens when a user moves furni, picks up furni, rotates furni & places furni.

Error in query:

UPDATE items SET user_id = 2, room_id='' WHERE id = 4334;UPDATE items SET user_id = 2, room_id='' WHERE id = 4333;UPDATE items SET user_id = 2, room_id='' WHERE id = 4332;UPDATE items SET user_id = 2, room_id='' WHERE id = 4331;UPDATE items SET user_id = 2, room_id='' WHERE id = 4335;UPDATE items SET user_id = 2, room_id='' WHERE id = 4337;UPDATE items SET user_id = 2, room_id='' WHERE id = 4336;UPDATE items SET user_id = 2, room_id='' WHERE id = 0
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in e:\Documents\Emulator [L]\Emulator [L]\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

Error in query: UPDATE items SET user_id = 33, room_id='' WHERE id = 5345
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: '' for column 'room_id' at row 1
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.ExecuteNonQuery()
at Database_Manager.Database.Session_Details.QueryAdapter.runQuery() in e:\Documents\Emulator [L]\Emulator [L]\Plus Emulator\DatabaseManager\Database_Manager\Database\Session_Details\QueryAdapter.cs:line 193

This one i researched and found this said by Sledmore,

Just CTRL + F for all results that come up for 'room_id='' WHERE' and change them to '`room_id` = '0' WHERE'.

But my problem is i don't know were to look for that.


Any help with both these issues would be greatful, thanks.
Josh

- - - Updated - - -

I searched all the files for 'room_id='' WHERE' and could find nothing.

[MentaL]

[feyestan]

Disable MySQL strict mode and the errors will go away I guess.

[Diddy]

Disable MySQL strict mode and the errors will go away I guess.

Iv'e Already done that.

[Diddy]

Bump need this sorted asap, ill be willing to pay if anyone can actually fix these.

[leenster]

Where is the source for your emu, i have a few minutes so i can take a look....

[Diddy]

Where is the source for your emu, i have a few minutes so i can take a look....

Its on my vps a private one given to me by Boom Would you like to tv?

[leenster]

I searched all the files for 'room_id='' WHERE' and could find nothing.

search for UPDATE ITEMS instead and you will find them


setting the room_id column to allow a null value in the database might also fix the problem but im not a 100% sure

[Diddy]

search for UPDATE ITEMS instead and you will find them


setting the room_id column to allow a null value in the database might also fix the problem but im not a 100% sure

Searched & nothing found
also think the table is already allowing null http://gyazo.com/85cff88ab94d01849fc53d0821647cec

[leenster]

Searched & nothing found
also think the table is already allowing null http://gyazo.com/85cff88ab94d01849fc53d0821647cec

make sure the default value for that field is set to NULL

[Diddy]

make sure the default value for that field is set to NULL

Where? :P

[The General]

for the field room_id in the items table.

[leenster]

Where? :P

we can do TV for a minute if you want

[Diddy]

we can do TV for a minute if you want

Yeah Sure Reply When Your Free Man.

[leenster]

backup your db and then try this..... (untested)

ALTER TABLE items CHANGE room_id room_id INT DEFAULT NULL;

[Diddy]

backup your db and then try this..... (untested)

ALTER TABLE items CHANGE room_id room_id INT DEFAULT NULL;

Did that, Still no change.

[duckietm]

I am having the same problem, but if i look in the DB Colour1 and Colour2 in groups are set to INT(11) this will not allow to insert 'bd2121'.

So we Changed it to VARCHAR(255) but that will not allow you to login anymore :

Bug duing user login: System.InvalidCastException: Specified cast is not valid.
   at Silverwave.HabboHotel.Groups.GroupManager.GetGroup(UInt32 GroupId)
   at Silverwave.HabboHotel.Rooms.RoomData.Fill(DataRow Row)
   at Silverwave.HabboHotel.Rooms.RoomManager.FetchRoomData(UInt32 RoomId, DataRow dRow)
   at Silverwave.HabboHotel.Users.UserDataManagement.UserDataFactory.GetUserData(String sessionTicket, String ip, Byte& errorCode)
   at Silverwave.HabboHotel.GameClients.GameClient.tryLogin(String AuthTicket) 

so there is where the error is The group.cs & groupmanager.cs have color1 & color2 set to INT wich do not allow the characters to be read :(

No how can we fix this .........