We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Help: Data too long for column 'ip' at row 1

    • 9995
    • 1,613 Posts
    fourroses666 Reply #1, 9 years, 7 months ago
    I can't edit pages etc. Can't do anything, keep seeing a message :S
    When logging in the manager I see:

    « Execution of a query to the database failed - Data too long for column 'ip' at row 1 »
SQL > REPLACE INTO `xxx_xxx`.`modx_active_users` (internalKey, username, lasthit, action, id, ip)


    See attached images.

    Anyone knows whats going on?


    This question has been answered by fourroses666. See the first response.

      Evolution user, I like the back-end speed and simplicity smiley
      • 9995
      • 1,613 Posts
      fourroses666 Reply #2, 9 years, 7 months ago
      When I look at phpmyadmin in table `modx_active_users` on a other host/website I see a IP address, but on this site/host I see a long encripted? address like: 2001:970:3fa4:1:2313:7a67:b333:d0bc
        Evolution user, I like the back-end speed and simplicity smiley
      • discuss.answer
        • 9995
        • 1,613 Posts
        fourroses666 Reply #3, 9 years, 7 months ago
        Oké, after changing the IP table from varchar(50) to varchar(75) the site works again smiley
          Evolution user, I like the back-end speed and simplicity smiley