Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10068

Invalid datetime format: 1292 Incorrect datetime value: '2011-03-27 02:47:26'

    XMLWordPrintable

    Details

      Description

      After run a seeder for create 75000 users, after several minutes (almost 7000 users inserts on table with any problem,my app get a exception below.

      [Illuminate\Database\QueryException]
        SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2008-03-30 02:56:12' for column 'created_at' at row 1 (S
        QL: insert into `users` (`type`, `name`, `email`, `nick`, `password`, `vat`, `address`, `zipcode`, `city`, `state`, `country`, `cr
        eated_at`, `updated_at`) values (customer, Adrian Santos, qpuig@live.com, rzavala12, y$Veqd2mkgRHtl6VKtYBV0yey77tVLo34.6THXqhtGRwg
        /Ea73/FhlK, 02058805Y, Plaça Abril, 85, 96º D, 44824, Vargas de San Pedro, 57431, San Roig, Huesca, ES, 2008-03-30 02:56:12, 2008-
        03-30 02:56:12))
      

      Datetime value it's correct and same for others 7000, 8000 users create with before INSERTS

      Try several options such:

      MariaDB [(none)]> select @@GLOBAL.sql_mode;
      +------------------------+
      | @@GLOBAL.sql_mode      |
      +------------------------+
      | NO_ENGINE_SUBSTITUTION |
      +------------------------+
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            abkrim Abdelakarim Mateos
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: