Habboon PlusEMU - PRODUCTION-201602082203-712976078

[Woiah]

I got this error on my Habboon PlusEMU!
What does it mean ?

 

[JayC]

It means that something in your item table is not a valid input.

 

[Woiah]

I downloaded the plusclean.sql.. But when i uploaded the sql to navicat it showed some errors doe..

Skickat från min SM-G930F via Tapatalk

 

[Woiah]

Do you have any good sql files

Skickat från min SM-G930F via Tapatalk

 

[Altercationz]

Turn off strict mode then run the database again.

SET @@global.sql_mode= '';

 

[Woiah]

Where can i do that?

Skickat från min SM-G930F via Tapatalk

 

[Altercationz]

Assuming you're using navicat, just run it as a query.

 

[Woiah]

Global.sql?

Skickat från min SM-G930F via Tapatalk

 

[Sledmore]

You've added a record to the furniture table incorrectly. Something isn't parsing properly, go to line 69 and paste it here.

 

[Woiah]

Will do when i get home

Skickat från min SM-G930F via Tapatalk
 

You've added a record to the furniture table incorrectly. Something isn't parsing properly, go to line 69 and paste it here.

INSERT INTO `achievements` VALUES ('113', 'ACH_FriendListSize', 'social', '14', '5', '15', '140', '0');
This is the line 69 in the sql file!

 

[Altercationz]

Line 69 from the emulator source please.

 

[Woiah]

Line 69 from the emulator source please.

this._gifts.Add(spriteID, new ItemData(id, spriteID, itemName, PublicName, type, width, length, height, allowStack, allowWalk, allowSit, allowRecycle, allowTrade, allowMarketplace, allowGift, allowInventoryStack, interactionType, cycleCount, vendingIDS, heightAdjustable, EffectId, WiredId, IsRare, ClothingId, ExtraRot));

 

[Altercationz]

Interesting, send me line 82 in ItemData.cs

 

[Woiah]

Interesting, send me line 82 in ItemData.cs

this.AdjustableHeights.Add(double.Parse(H));
 

this.AdjustableHeights.Add(double.Parse(H));

The thing is. If i change to another database.sql the emulator works.. So it must be something with the DB ? right ?

 

[Lame]

this.AdjustableHeights.Add(double.Parse(H));
 

The thing is. If i change to another database.sql the emulator works.. So it must be something with the DB ? right ?

Obviously.

 

[Woiah]

Obviously.

But idk the problem!

 

[JayC]

SELECT item_name,height_adjustable FROM `furniture` WHERE height_adjustable NOT LIKE "%,%,%"

Run this query and see what happens. Review all of the items if you find anything that is not 0 , change it to 0.

 

[Woiah]

SELECT item_name,height_adjustable FROM `furniture` WHERE height_adjustable NOT LIKE "%,%,%"

Run this query and see what happens. Review all of the items if you find anything that is not 0 , change it to 0.

Everything is 0

 

[Altercationz]

Alright, must be your furniture table then.
Here is my furniture table, import this into your database and let me know if it works.

You must be registered for see links

Also for that error, run the following query in your database like i said, it works for me when i get importing errors:

SET @@global.sql_mode= '';

 

[JayC]

Alright if everything is 0 then check this:

SELECT item_name,height_adjustable FROM `furniture` WHERE height_adjustable NOT LIKE "%,%,%" AND height_adjustable != 0