Receive code 500 when adding lineup (but lineup added)

[garybuhrmaster]

While testing some code to add/delete lineups, it may be that I have exceeded the number of allowed changes, but rather than returning an error (expected) it appears the the BIGINT UNSIGNED value of -1 causes difficulty (changedRemaining = -1? for an unsigned value?). Interestingly the lineup does get added.

Not the most important thing in the world, but server errors are never good....

HTTP response code: 500

HTTP Error message:

`Slim Application Error The application could not run because of the following error:

Details

Type: PDOException Code: 22003 Message: SQLSTATE[22003]: Numeric value out of range: 1690 BIGINT UNSIGNED value is out of range in \'(API20141201.user.changesRemaining - 1)\' File: /var/www/html/functions/func.20141201.php Line: 1313 Trace

0 /var/www/html/functions/func.20141201.php(1313): PDOStatement->execute(Array)

1 /var/www/html/functions/func.20141201.php(1976): heUpdateCounter(\'1417\')

2 /var/www/html/index.php(336): addLineupToUserAccount(\'1417\', \'USA-DITV-DEFAUL...\', 255)

3 [internal function]: {closure}(\'USA-DITV-DEFAUL...\')

4 /var/www/html/vendor/slim/slim/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)

5 /var/www/html/vendor/slim/slim/Slim/Slim.php(1357): Slim\Route->dispatch()

6 /var/www/html/vendor/slim/slim/Slim/Middleware/Flash.php(85): Slim\Slim->call()

7 /var/www/html/vendor/slim/slim/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()

8 /var/www/html/vendor/slim/slim/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride->call()

9 /var/www/html/vendor/slim/slim/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions->call()

10 /var/www/html/index.php(1011): Slim\Slim->run()

11 {main}`

[rkulagowski]

Weird - I thought I had already handled that, so I'm wondering where my code is letting it wrap around to negative. I'll investigate.

[garybuhrmaster]

Thanks. And sorry. No real hurry.

I think I was easily able to reproduce it. I was apparently getting it a few times, but as the return was 500 (server error) and my code auto-retries for server errors (and a number of other retryable errors such as timeouts), after the retry I was getting a "Add failed, duplicate" because while I was getting the 500, it was adding. I was pulling (what little remaining) hair out at first wondering what was going on (so I had to add in the debugging code to notice what seemed like the improbable).

Again, no hurry, and thanks for looking into it.