Mercury Emulator Bug

[ramahe]

Could not load Item #11 please verify that data is okay
System.FormatException: Input String was not in a correct format.
--
ItemManager.cs:line 57

height = Convert.ToDouble(dataRow["stack_height"]);

And after what I can see is a part of

if (dataRow["stack_height"].ToString().Contains(";"))   {
array = dataRow["stack_height"].ToString().Split(newchar[{';'});
height=Convert.ToDouble(array[0]); 
}
else
{
height = Convert.ToDouble(dataRow["stack_height"]);
}

Ive looked for fixes but none seem to contain an answer.
When i press a button to continue it goes to another item like #12 etc..

Ive looked into the SQL and there seem to be no ";" usen in the stack_height column, but i changed ; to . still no luck.

 

[LucasAbade]

This is because your column "stack_height" is not on the right format for that furniture, is it varchar(255)?

If yes, the furniture is not working or there is no acceptable value on the "stack_height" column, please check it.

 

[ramahe]

Its indeed in varchar(255) i even tried changing to varchar(11) as someone suggested but that didnt work so i dropped the table and re ran the SQL
Changed to double and did some tweaking in the emulator no luck at all.

its all back to normal now.

varchar(255)

 

[LucasAbade]

Its indeed in varchar(255) i even tried changing to varchar(11) as someone suggested but that didnt work so i dropped the table and re ran the SQL
Changed to double and did some tweaking in the emulator no luck at all.

its all back to normal now.

varchar(255)

This happens with ALL furnitures?
Sounds like a problem with a single furni with no value on "stack_height" column

 

[ramahe]

i happens first at #11 which is the first one with "." in it :

So it seems to happent o numers like 0.5, 1.1 etc but not 1, 2 and so on.

 

[LucasAbade]

i happens first at #11 which is the first one with "." in it :

So it seems to happent o numers like 0.5, 1.1 etc but not 1, 2 and so on.

Have you disabled strict mode on your mysql?

 

[ramahe]

I added
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

To the my.ini, no change at all



I also ran SET @@global.sql_mode= ''; in query

 

[LucasAbade]

I added
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

To the my.ini, no change at all



I also ran SET @@global.sql_mode= ''; in query

Do you have skype? PM me



RESOLVED.

 

[The General]

Do you have skype? PM me



RESOLVED.

Please keep it on the forums so others might use this thread as a reference in the future.