DATABASE ERROR: database error write

  • Resolved bigbankclub

    (@bigbankclub)


    3 years, 1 month ago

    I am starting to get this error, and it has only happened in the last while.

    I have used this plugin for years and this is the 1st for such an error.

    What’s the fix?

    DATABASE ERROR: database error write

    DATABASE ERROR: ‘You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WARNING: Forcing protocol to TCP due to option specification. Please explic…’ at line 3′
    [SQL=/* DUPLICATOR-LITE (MYSQL-DUMP BUILD MODE) MYSQL SCRIPT CREATED ON : 2023-02-25 11:02:51 */

    WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol.
    …]

    DATABASE ERROR: ‘Variable ‘time_zone’ can’t be set to the value of ‘NULL”
    [SQL=/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;…]

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support mohammedeisa

    (@mohammedeisa)

    3 years, 1 month ago

    Hi @bigbankclub ,

    The error states that there is something wrong with your database.
    So, this is either an error in the original database, and this can’t be fixed from our side.
    Or, there is something went wrong with the exported package.

    Can you try to import the database manually to check if it works without Duplicator?

    If you need to check the exported package, please upload (not copy/paste) the package build log file to an uploading platform like Google Drive and share the file link here with me. 

    For instructions please see:

        – How do I read the package build log?
        – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-trouble-005-q

    Looking forward to your reply!

    Thread Starter bigbankclub

    (@bigbankclub)

    3 years, 1 month ago

    Thank you for the reply. I took it 1 step back and I saw this notice. I am copying to the same server and have 100’s of installs — they have the same type of error, I tested the 1st 25 and this show:

    STATUS
    This server’s database does not support the source site’s character set [utf8], so the installer is going to use default character [utf8mb3].

    DETAILS
    Settings used in the current installation
    DB_CHARSET = utf8mb3
    DB_COLLATE = utf8mb3_general_ci

    —

    So when installing WordPress, by default the system is setting to utf8 ?

    Plugin Support mohammedeisa

    (@mohammedeisa)

    3 years, 1 month ago

    Hi @bigbankclub ,

    Duplicator by default sets the Charset to utf8mb4 and the collation to utf8mb4_0900_ai_ci.

    Please try the following if you need to change these settings:
    – Click Advanced in Step 1 of the installer
    – In Step 2, Click Charset & Collation
    – Choose the values you prefer for the Charset and Collation fields

    About this error:
    This server’s database does not support the source site’s character set [utf8], so the installer is going to use default character [utf8mb3].

    I think you could contact your hosting to check this issue before you try the installation.

    I hope this helps.
    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘DATABASE ERROR: database error write’ is closed to new replies.