Habboon PlusEMU - PRODUCTION-201602082203-712976078

[Woiah]

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

 

[Woiah]

Alright if everything is 0 then check this:

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

 

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= '';

Didn't work! Uncompleted will all error

 

[JayC]

No. That's right.. Try this one:

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

 

[Woiah]

No. That's right.. Try this one:

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

 

[Altercationz]

Did you run the query i told you to? What's the error when importing my table?

 

[Woiah]

Did you run the query i told you to? What's the error when importing my table?

Yep i tried the query and it didnt be a single success!

i used this query

SET @@global.sql_mode= '';

 

[Altercationz]

Yep i tried the query and it didnt be a single success!

i used this query

SET @@global.sql_mode= '';

Did you import my furniture table?

 

[Woiah]

Did you import my furniture table?

Yep i did

 

[JayC]

SELECT * FROM `furniture` WHERE height_adjustable != 0 AND height_adjustable NOT LIKE '%,%'

This should return no results?

 

[CosmoPeak]

Check the furniture you've added recently. One of the values in height_adjustable is incorrect. Without editing the emulator, it may be difficult to track down.

@JayCustom - It seems like the query you're providing is not helping, it may be likely that the cell containing the error contains a comma.

 

[JayC]

Check the furniture you've added recently. One of the values in height_adjustable is incorrect. Without editing the emulator, it may be difficult to track down.

@JayCustom - It seems like the query you're providing is not helping, it may be likely that the cell containing the error contains a comma.

So I am currently looking into this for him and as far I coded this in php so I could do a more advanced test:

<?php
                                $getItems = mysql_query("SELECT `id`,`height_adjustable` FROM `furniture` WHERE `height_adjustable` != '0'");
                                while($Item = mysql_fetch_assoc($getItems)){
                                $arr = explode(',', $Item['height_adjustable']);
                                    foreach($arr as $thisitem){
                                        if(!is_double($thisitem) && !is_numeric($thisitem)){
                                            echo $Item['id'];
                                        }
                                    }
                                }
                              
                                ?>

Nothing is coming out of that saying it is not valid. Going to keep digging into this.
 
Update-
Gave him a whole new emulator and a whole new database clean and its till doesn't get past this error. I am unsure of what this issue is tbh. The 2nd error shown is an error generatoring gifts, I tried to turn all the interaction_type gift to default and still nothing there either.