• Resolved patrickschababerle

    (@patrickschababerle)


    Hello,

    first of all thanks for the really useful plugin. If we can get it to work, it can really save us time. But there’s also the catch – we’re currently struggling with an error in the plugin that we haven’t been able to localize yet. The following error message appears during the import:

    Importing products…
    [ERROR] Error:SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: ‘0000-00-00 00:00:00’

    Briefly about the systems…

    Source:

    – PrestaShop (1.6.1.23)

    Target:

    – WordPress (5.8.3)
    – WooCommerce (6.1.1)
    – FG PrestaShop to WooCommerce (4.24.0)

    Maybe you can help us out quickly, otherwise we’ll have to look for an alternative to your great plugin.

    Thanks a lot and warm greetings
    Patrick

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Kerfred

    (@kerfred)

    This error is not due directly to our plugin. It is due to a setting on your MySQL server. Here is the explanation and the solutions: https://stackoverflow.com/questions/22806870/incorrect-datetime-value-database-error-number-1292

    Thread Starter patrickschababerle

    (@patrickschababerle)

    Thank you in advance for the hint! I’ve looked into this and tried various solutions – unfortunately without success.

    Next, I exported the table from the Live DB and imported it into a second, temporary one. There I have set all ‘000-00-00’ datetimes and timestamps to ‘1970-01-01’ or NULL if possible. Surprisingly, I still get this error message, which makes me believe that the problem must be somewhere else.

    Is there another potential source of error?

    Plugin Author Kerfred

    (@kerfred)

    Are you sure you get the exact same message if you don’t have 0000-00-00 00:00:00 anymore?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘SQL Error: Incorrect DATETIME value’ is closed to new replies.