• Resolved hobbyfr3ak

    (@hobbyfr3ak)


    Hello,
    I have often created and restored backups with Duplicator (free). However, I am now consistently receiving the following error message:

    "Processing Data Replacement 39.48%
    failed processing data replacement: Data too long for column 'referer' at row 1,
    wait 5 seconds and retry.
    second attempt
    Please Wait..."

    In detail:

    EXCEPTION ERROR:  Data too long for column 'referer' at row 1
    FILE:/var/www/html/dup-installer/classes/class.engine.php[411]
    TRACE:
    #0 /var/www/html/dup-installer/classes/class.engine.php(411): mysqli_fetch_assoc(Object(mysqli_result))
    #1 /var/www/html/dup-installer/classes/class.engine.php(327): DUPX_UpdateEngine::evaluatePagedRows(Array)
    #2 /var/www/html/dup-installer/classes/chunk/class.chunk.s3.manager.php(59): DUPX_UpdateEngine::evaluateTableRows('wp_rcb_consent', 1)
    #3 /var/www/html/dup-installer/classes/chunk/class.chunkingmanager.php(98): DUPX_chunkS3Manager->action('search_replace_...', Array)
    #4 /var/www/html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php(101): DUPX_ChunkingManager->start()
    #5 /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php(221): DUPX_S3_Funcs->updateWebsite()
    #6 /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php(95): DUPX_Ctrl_ajax::actions('webupdate')
    #7 /var/www/html/dup-installer/main.installer.php(60): DUPX_Ctrl_ajax::controller()
    #8 {main}

    AJAX ACTION [webupdate] FAIL, MESSAGE: Data too long for column 'referer' at row 1
    -------------------------

    LOG-TIME[/var/www/html/dup-installer/src/Core/Bootstrap.php:71] RESET TIME

    -------------------------
    AJAX ACTION [webupdate] START
    CHUNK ACTION: CURRENT [search_replace][wp_rcb_consent][1]
    DB QUERY [ERROR][/var/www/html/dup-installer/classes/database/class.db.php:645] MSG: Data too long for column 'referer' at row 1
    SQL: UPDATE
    wp_rcb_consent SET referer = "https://test.xxx.de/traefik-2-wildcard-lets-encrypt-zertifikate-verwenden/?utm_campaign=Traefik%20Monthly%20Journal&utm_medium=email&_hsmi=214787773&_hsenc=p2ANqtz--3ZgWcq86McGkDv6qvBh-yQDT-oRcCf5oqwWjcDY11DlX39l40uNDwyolY_bjgOptexY6K5bHRTVN7-aa5_WIXwXUn", pure_referer = "https://test.xxx.de/traefik-2-wildcard-lets-encrypt-zertifikate-verwenden/", url_imprint = "https://test.xxx.de/impressum/", url_privacy_policy = "https://test.go
    TRACE[1] CLASS___: DUPX_DB::mysqli_query FILE: /var/www/html/dup-installer/classes/class.engine.php[595]
    TRACE[2] CLASS___: DUPX_UpdateEngine::evaluateRow FILE: /var/www/html/dup-installer/classes/class.engine.php[412]
    TRACE[3] CLASS___: DUPX_UpdateEngine::evaluatePagedRows FILE: /var/www/html/dup-installer/classes/class.engine.php[327]
    TRACE[4] CLASS___: DUPX_UpdateEngine::evaluateTableRows FILE: /var/www/html/dup-installer/classes/chunk/class.chunk.s3.manager.php[59]
    TRACE[5] CLASS___: DUPX_chunkS3Manager->action FILE: /var/www/html/dup-installer/classes/chunk/class.chunkingmanager.php[98]
    TRACE[6] CLASS___: DUPX_ChunkingManager->start FILE: /var/www/html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php[101]
    TRACE[7] CLASS___: DUPX_S3_Funcs->updateWebsite FILE: /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php[221]
    TRACE[8] CLASS___: DUPX_Ctrl_ajax::actions FILE: /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php[95]
    TRACE[9] CLASS___: DUPX_Ctrl_ajax::controller FILE: /var/www/html/dup-installer/main.installer.php[60]


    EXCEPTION ERROR: Data too long for column 'referer' at row 1
    FILE:/var/www/html/dup-installer/classes/class.engine.php[411]
    TRACE:
    #0 /var/www/html/dup-installer/classes/class.engine.php(411): mysqli_fetch_assoc(Object(mysqli_result))
    #1 /var/www/html/dup-installer/classes/class.engine.php(327): DUPX_UpdateEngine::evaluatePagedRows(Array)
    #2 /var/www/html/dup-installer/classes/chunk/class.chunk.s3.manager.php(59): DUPX_UpdateEngine::evaluateTableRows('wp_rcb_consent', 1)
    #3 /var/www/html/dup-installer/classes/chunk/class.chunkingmanager.php(98): DUPX_chunkS3Manager->action('search_replace_...', Array)
    #4 /var/www/html/dup-installer/ctrls/classes/class.ctrl.s3.funcs.php(101): DUPX_ChunkingManager->start()
    #5 /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php(221): DUPX_S3_Funcs->updateWebsite()
    #6 /var/www/html/dup-installer/ctrls/classes/class.ctrl.ajax.php(95): DUPX_Ctrl_ajax::actions('webupdate')
    #7 /var/www/html/dup-installer/main.installer.php(60): DUPX_Ctrl_ajax::controller()
    #8 {main}

    AJAX ACTION [webupdate] FAIL, MESSAGE: Data too long for column 'referer' at row 1

    Server details:

    SERVER DETAILS
    Try CDN Request: No
    Web Server: Apache/2.4.59 (Debian)
    PHP Version: 8.2.19
    PHP SAPI: apache2handler
    PHP ZIP Archive: Is Installed
    PHP max_execution_time: 0
    PHP memory_limit: 4294967296
    Error Log Path: /dup-installer/php_error__[HASH].log

    PACKAGE BUILD DETAILS
    Plugin Version: 1.5.10.2
    WordPress Version: 6.5.5
    PHP Version: 8.2.19
    Database Version: 5.7.44
    Operating System: Linux

    I am working with Docker, and the original website has exactly the same Docker Compose file as the test website. So all versions are completely identical (database/web server).

    Could you please tell me what I can do?

    Thank you.

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

    (@mohammedeisa)

    Hello @hobbyfr3ak,

    Thanks for reaching out to us.

    Although we are already communicating though the Duplicator Pro support, I’m willing to provide you with the answer here as a reference for others who might encounter the same problem.

    I understand that you are not able to install your backup and got the following error:

    Data too long for column ‘referer’ at row 1
    SQL: UPDATE TABLE SET COULMN = “…..

    This error needs to be fixed to make sure that the installation went successfully:

    To fix this error, before you run the installation, you need to change the column?COULMN type to LONGTEXT. You can find this column in the?TABLE
    table.

    Alternatively, you can change the column type during the installation as follows:

    • Run the installation
    • Switch to the advanced mode in step 1 by clicking the Advanced button on the top right of the installer screen.
    • Proceed until step 2
    • Open your destination website database using PHPMyadmin
    • Change the?COULMN column type to LONGTEXT in?TABLE table
      If you can’t change the column type to LONGTEXT, please try increasing the column length
    • Continue the installation

    Please replace the COULMN and TABLE in the previous fix with the real column and table names in the query that causes the issue.

    Please let me know if this resolves your issue.

    Thanks

    Thread Starter hobbyfr3ak

    (@hobbyfr3ak)

    Thank you very much for the quick reply.

    I am in step 2 and can now select what I want to import:
    https://www.directupload.eu/file/d/8654/wjenl428_png.htm


    At the same time I looked at PHPmyadmin and the database is still completely empty:
    https://www.directupload.eu/file/d/8654/aalbw7ix_png.htm

    How should I change the attributes now?

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi?@hobbyfr3ak,

    Please try the following:

    • Start the backup restoration
    • Let it fail
    • Change the type of the column
    • Restart the backup restoration

    Please let me know if this works.

    Thanks!

    Plugin Support mohammedeisa

    (@mohammedeisa)

    Hi @hobbyfr3ak,

    I’m closing this support topic for inactivity. Please don’t hesitate to contact us in a Support Topic if you need any help with Duplicator.

    Thanks! 

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.