Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Out of range value for column 'shipId' at row 1 on characterModel #134

Closed
atkinsj opened this issue Apr 18, 2016 · 1 comment
Closed

Out of range value for column 'shipId' at row 1 on characterModel #134

atkinsj opened this issue Apr 18, 2016 · 1 comment
Assignees
Milestone

Comments

@atkinsj
Copy link

atkinsj commented Apr 18, 2016

PDOStatement: Out of range value for column 'shipId' at row 1 [app/lib/base.php:2015] Base->error(500,'PDOStatement: Out of range value for column 'shipId' at row 1'), [app/lib/DB/SQL/Mapper.php:471] DB\\SQL->exec('UPDATEcharacter_logSETupdated=?,constellationId=?,constellationName=?,regionId=?,regionName=?,shipTypeId=?,shipTypeName=?,shipId=?,shipName=?,stationId=?,stationName=? WHEREid=?',array(1=>array('2016-04-18 01:07:38',2),2=>array(redcated),3=>array('redcated',2),4=>array(redcated),5=>array('redcated',2),6=>array(11971,1),7=>array('Lachesis',2),8=>array(1020744982158,1),9=>array('redcated',2),10=>array(redcated),11=>array('redcated',2),12=>array(3,1))) [app/main/Model/CharacterModel.php:390] DB\\Cortex->save(), referer: http://pathfinder.dev/map [app/main/Controller/Api/map.php:659] Model\\CharacterModel->updateLog(array('suppressTimeoutErrors'=>true)), referer: http://pathfinder.dev/map

I'm not sure where the ID 1020744982159 is coming from for the ship.

@atkinsj atkinsj changed the title shipId on CharacterModel is behaving strangely Out of range value for column 'shipId' at row 1 on characterModel Apr 18, 2016
@atkinsj
Copy link
Author

atkinsj commented Apr 18, 2016

This field is currently set to DT_INT (8 bytes) but ShipID's can be bigint(20). Not sure how we never hit this before.

@exodus4d exodus4d added this to the v 1.0.0RC3 milestone Apr 24, 2016
@exodus4d exodus4d self-assigned this Apr 24, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants