Error message on save score in one game.

[Kim]

The following error came up when I tried to save a score on an IPB game -

Server Error
 
Mysqli statement execute error : Data truncated for column 'score' at row 1
 
    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in Arcade/Model/Session.php at line 11
    Arcade_Model_Session->saveSession() in Arcade/ControllerPublic/ArcadeUgly.php at line 231
    Arcade_ControllerPublic_ArcadeUgly->actionIpbSaveScore() in XenForo/FrontController.php at line 310
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /home/xxxxxx/public_html/xxxxxxx.com/index.php at line 13

The game is called Fairy Town and is a 32 game.

Just reporting it, not sure if there is anything you guys can do, or suggest.

It looks like it might be hacked, as the submit score is very different to the rest of the graphics, which might explain it!

 

[Kevin]

Kim, is that with all IPB games or just that one? If just that one, could you attach it so we can check it out (it'll then be removed as an attachment after we figure out what the problem is)?

I think a similar issues was reported before, just can't remember at the moment if it was resolved or not.

 

[Kim]

Just that one so far Kevin,

Here it is

 

[Kevin]

Short answer so far is that by the time it is trying to save the score the variable ("gscore") that holds the score value is blank. The error then is a result of trying to insert null as a score value.

Poking around I see the game on several IPB arcade type sites and the scores are working. Experimenting I see on those sites that the variable is not blank. It'll need to be looked at a bit further to see where the problem with the score is originating from.

 

[Kim]

Thanks for investigating Kevin

If you need any more games just let me know!