Jump to content
Holiday Closure, Support Availability Notice

IPS\Db\Exception::1264

SoloInter

By SoloInter

  • Status: Moved to Github

UPDATE ibf_forums_forums forums_forums SET topics=9796posts=-2last_post_data='{"1515877846.28136":{"last_poster_id":59605,"last_poster_name":"BONOB0","seo_last_name":"bonob0","last_post":null,"last_title":"Maillot Inter 2018\/2019, nouvelles indiscr\u00e9tions","seo_last_title":"maillot-inter-20182019-nouvelles-indiscr\u00e9tions","last_id":28136,"last_poster_anon":0,"last_post_snippet":"On dirait un maillot d\'entrainement celui ext\u00e9rieur ._.\n ","posts":14},"1515876881.28135":{"last_poster_id":59795,"last_poster_name":"Ockfuler","seo_last_name":"ockfuler","last_post":null,"last_title":"Ramires - Inter, un \u00e9clair de g\u00e9nie de Sabatini\u00a0!","seo_last_title":"ramires-inter-un-\u00e9clair-de-g\u00e9nie-de-sabatini\u00a0","last_id":28135,"last_poster_anon":0,"last_post_snippet":"Il directeur sportif des deux clubs , on parlera de roublardise si cela passe \u00e0 l\'UEFA.\u00a0\n \n\n\n\t\u00a0\n \n","posts":12},"1515856827.28141":{"last_poster_id":58793,"last_poster_name":"Rahim95","seo_last_name":"rahim95","last_post":null,"last_title":"Spalletti respire pour sa d\u00e9fense\u00a0: Lisandro Lopez arrive !","seo_last_title":"spalletti-respire-pour-sa-d\u00e9fense\u00a0-lisandro-lopez-arrive","last_id":28141,"last_poster_anon":0,"last_post_snippet":"Correa est un milieu de terrain\n \n","posts":5},"1515786038.28140":{"last_poster_id":59888,"last_poster_name":"Vic14","seo_last_name":"vic14","last_post":null,"last_title":"Sans Ligue des Champions, Icardi partira","seo_last_title":"sans-ligue-des-champions-icardi-partira","last_id":28140,"last_poster_anon":0,"last_post_snippet":"C\u2019est une supposition qui para\u00eet cr\u00e9dible mais tout cela reste une supposition\u00a0\n \n\n\n\tles gars du r\u00e9al ont beau se prendre pour irr\u00e9sistibles...c\u2019est pas le cas, comme c\u2019est le cas, pour aucun club\u00a0\n \n\n\n\til n\u2019y a pas si\u00a0longtemps, j\u2019ai entendu Icardi dire qu\u2019il songeait \u00e0 une carri\u00e8re \u00e0 la Zanetti\u00a0\n \n\n\n\tpour tout dire, j\u2019ai plus peur de la r\u00e9action ","posts":9},"1515757564.28123":{"last_poster_id":59860,"last_poster_name":"Maniaboy","seo_last_name":"maniaboy","last_post":null,"last_title":"Fum\u00e9e blanche pour Rafinha\u00a01","seo_last_title":"fum\u00e9e-blanche-pour-rafinha\u00a0","last_id":28123,"last_poster_anon":0,"last_post_snippet":"Ahah mais voyons cest pas comme si on allait le mettre titulaire roh. On pourrait croire que cest une oiseau de mauvaise augure \u00e0 vous entendre\u00a0\u00a0\n ","posts":19}}' WHERE id=?

Out of range value for column 'posts' at row 1

#0 /home/damien_prod/Internazionaleprod/public_html/system/Db/Db.php(1232): IPS\Db->preparedQuery()

#1 /home/damien_prod/Internazionaleprod/public_html/system/Patterns/ActiveRecord.php(544): IPS\Db->update()

#2 /home/damien_prod/Internazionaleprod/public_html/system/Node/Model.php(2821): IPS\Patterns\ActiveRecord->save()

#3 /home/damien_prod/Internazionaleprod/public_html/applications/forums/sources/Forum/Forum.php(657): IPS\Node\Model->save()

#4 /home/damien_prod/Internazionaleprod/public_html/system/Node/Model.php(1198): IPS\forums\Forum->_setLastComment()

#5 /home/damien_prod/Internazionaleprod/public_html/system/Content/Item.php(2468): IPS\Node\Model->setLastComment()

#6 /home/damien_prod/Internazionaleprod/public_html/applications/forums/sources/Topic/Topic.php(1029): IPS\Content\Item->delete()

#7 /home/damien_prod/Internazionaleprod/public_html/system/Node/Model.php(2963): IPS\forums\Topic->delete()

#8 /home/damien_prod/Internazionaleprod/public_html/applications/forums/sources/Forum/Forum.php(2029): IPS\Node\Model->massMoveorDelete()

#9 /home/damien_prod/Internazionaleprod/public_html/applications/core/extensions/core/Queue/DeleteOrMoveContent.php(95): IPS\forums\Forum->massMoveorDelete()

#10 /home/damien_prod/Internazionaleprod/public_html/system/Task/Task.php(111): IPS\core\extensions\core\Queue\DeleteOrMoveContent->run()

#11 /home/damien_prod/Internazionaleprod/public_html/applications/core/tasks/queue.php(49): IPS\Task::runQueue()

#12 /home/damien_prod/Internazionaleprod/public_html/system/Task/Task.php(444): IPS\core\tasks\queue->IPS\core\tasks\{closure}()

#13 /home/damien_prod/Internazionaleprod/public_html/applications/core/tasks/queue.php(44): IPS\Task->runUntilTimeout()

#14 /home/damien_prod/Internazionaleprod/public_html/system/Task/Task.php(343): IPS\core\tasks\queue->execute()

#15 /home/damien_prod/Internazionaleprod/public_html/system/Task/Task.php(306): IPS\Task->run()

#16 /home/damien_prod/Internazionaleprod/public_html/applications/core/interface/task/task.php(78): IPS\Task->runAndLog()

#17 {main}

The URL of page the error occurred on was Not available

    •

    User Feedback

    Recommended Comments

    Miss_B Veteran

    Miss_B

    Clients

    The following error that you are getting: "Out of range value for column 'posts' at row 1", indicates that the value for the aforementioned field is exceeding the length of its INT datatype. i.e. the value is larger than the maximum supported by the INT datatype.

    I'm mentioning this because this might not be a bug. What is the datatype and length set for the posts column in the forums_forums table at your database?

    SoloInter Mentor

    SoloInter

    Clients

    I don't know, I think it's mainly a problem due to the age of the content.

    We're talking about topics created 20 years ago that have been moved, archived, and unarchived. Many years and updates have passed between each step.

    Esther E. Experienced

    Esther E.

    Invision Community Team
    42 minutes ago, Miss_B said:

    The following error that you are getting: "Out of range value for column 'posts' at row 1", indicates that the value for the aforementioned field is exceeding the length of its INT datatype. i.e. the value is larger than the maximum supported by the INT datatype.

    I'm mentioning this because this might not be a bug. What is the datatype and length set for the posts column in the forums_forums table at your database?

    It's a bug.

    •
    Miss_B Veteran

    Miss_B

    Clients
    (edited)
    16 minutes ago, Esther E. said:

    It's a bug.

    Ah ok. Thank you for the clarification. The reason that I thought that it might be a bug is that sometime ago I performed an upgrade for someone and I got this same error, but for a different field and the filed in question had been altered pre upgrade. I thought that that might have been the case here too.

    Edited by Miss_B