Installation Unsuccessful – Syntax error in regular expression

  • Resolved roryferguson

    (@roryferguson)


    1 year, 6 months ago

    I created a full package from my production website to localhost

    Installation Unsuccessfully! – [“Query error (3688) Syntax error in regular expression on line 1, character 14.\r\n\r\nOriginal Query:\r\n\r\n UPDATE wp_postmeta SET meta_value = replace(meta_value, ‘https:\/\/www.hidden.co.uk’ , ‘http:\/\/localhost’ ) WHERE meta_value LIKE ‘%https:\/\/www.hidden.co.uk%’ AND meta_value NOT REGEXP ‘^[ao]:[0-9].*}$’; “]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support mialewp

    (@mialewp)

    Hi there,

    Thanks for reaching out. Could you please give us a full file log? And which PHP version and mysql you are using, please?
    Looking forward to hearing back from you.

    Best regards,
    Mia

    Thread Starter roryferguson

    (@roryferguson)

    ==== SYSTEM STATS ====

Wordpress Version: 6.2.2

PHP Version: 8.2.5

MySQL Version: 8.0.32

Website Name: hidden

Theme: My Child Theme

Wordpress URL: https://www.hidden.co.uk

Site URL: https://www.hidden.co.uk

Multisite: no

PHP Extensions: ["Core","date","libxml","openssl","pcre","zlib","bz2","ctype","curl","dom","fileinfo","filter","hash","iconv","json","SPL","session","standard","mysqlnd","PDO","pdo_mysql","pdo_pgsql","pgsql","Phar","posix","random","readline","Reflection","mysqli","SimpleXML","sockets","tokenizer","xml","xmlreader","xmlwriter","zip","cgi-fcgi","Zend OPcache"]

Server Info: Apache

WP Memory Limit: 40M

WP Admin Memory Limit: 256M

PHP Memory Limit: 128M

Max Execution Time: 30

Open BaseDir:

Wordpress Plugins: {"all-in-one-wp-security-and-firewall\/wp-security.php":{"Name":"All In One WP Security","PluginURI":"https:\/\/www.remarpro.com\/plugins\/all-in-one-wp-security-and-firewall\/","Version":"5.1.8","Description":"All round best WordPress security plugin!","Author":"All In One WP Security & Firewall Team","AuthorURI":"https:\/\/aiosplugin.com\/","TextDomain":"all-in-one-wp-security-and-firewall","DomainPath":"\/languages","Network":true,"RequiresWP":"5.0","RequiresPHP":"5.6","UpdateURI":"https:\/\/www.remarpro.com\/plugins\/all-in-one-wp-security-and-firewall\/","Title":"All In One WP Security","AuthorName":"All In One WP Security & Firewall Team"},"fastdup\/fastdup.php":{"Name":"FastDup","PluginURI":"https:\/\/ninjateam.gitbook.io\/fastdup\/","Version":"2.1.4","Description":"WordPress Fastest Duplicator and Migration","Author":"Ninja Team","AuthorURI":"https:\/\/ninjateam.org\/","TextDomain":"njt-fastdup","DomainPath":"\/languages","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"FastDup","AuthorName":"Ninja Team"},"pods\/init.php":{"Name":"Pods - Custom Content Types and Fields","PluginURI":"https:\/\/pods.io\/","Version":"2.9.13","Description":"Pods is a framework for creating, managing, and deploying customized content types and fields","Author":"Pods Framework Team","AuthorURI":"https:\/\/pods.io\/about\/","TextDomain":"pods","DomainPath":"","Network":false,"RequiresWP":"5.7","RequiresPHP":"5.6","UpdateURI":"","Title":"Pods - Custom Content Types and Fields","AuthorName":"Pods Framework Team"},"s3-uploads\/s3-uploads.php":{"Name":"S3 Uploads","PluginURI":"","Version":"3.0.3","Description":"Store uploads in S3","Author":"Human Made Limited","AuthorURI":"https:\/\/hmn.md","TextDomain":"s3-uploads","DomainPath":"","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"S3 Uploads","AuthorName":"Human Made Limited"},"wp-fastest-cache\/wpFastestCache.php":{"Name":"WP Fastest Cache","PluginURI":"http:\/\/www.remarpro.com\/plugins\/wp-fastest-cache\/","Version":"1.1.5","Description":"The simplest and fastest WP Cache system","Author":"Emre Vona","AuthorURI":"https:\/\/www.wpfastestcache.com\/","TextDomain":"wp-fastest-cache","DomainPath":"\/languages\/","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"WP Fastest Cache","AuthorName":"Emre Vona"},"wpforms-lite\/wpforms.php":{"Name":"WPForms Lite","PluginURI":"https:\/\/wpforms.com","Version":"1.8.1.2","Description":"Beginner friendly WordPress contact form plugin. Use our Drag & Drop form builder to create your WordPress forms.","Author":"WPForms","AuthorURI":"https:\/\/wpforms.com","TextDomain":"wpforms-lite","DomainPath":"assets\/languages","Network":false,"RequiresWP":"5.2","RequiresPHP":"5.6","UpdateURI":"","Title":"WPForms Lite","AuthorName":"WPForms"},"wp-mail-smtp\/wp_mail_smtp.php":{"Name":"WP Mail SMTP","PluginURI":"https:\/\/wpmailsmtp.com\/","Version":"3.8.0","Description":"Reconfigures the <code>wp_mail()<\/code> function to use Gmail\/Mailgun\/SendGrid\/SMTP instead of the default <code>mail()<\/code> and creates an options page to manage the settings.","Author":"WP Mail SMTP","AuthorURI":"https:\/\/wpmailsmtp.com\/","TextDomain":"wp-mail-smtp","DomainPath":"\/assets\/languages","Network":false,"RequiresWP":"5.2","RequiresPHP":"7.2","UpdateURI":"","Title":"WP Mail SMTP","AuthorName":"WP Mail SMTP"},"google-sitemap-generator\/sitemap.php":{"Name":"XML Sitemap Generator for Google","PluginURI":"https:\/\/auctollo.com\/","Version":"4.1.11","Description":"This plugin improves SEO using sitemaps for best indexation by search engines like Google, Bing, Yahoo and others.","Author":"Auctollo","AuthorURI":"https:\/\/auctollo.com\/","TextDomain":"sitemap","DomainPath":"\/lang","Network":false,"RequiresWP":"","RequiresPHP":"","UpdateURI":"","Title":"XML Sitemap Generator for Google","AuthorName":"Auctollo"}}

Wordpress Active Plugins: {"0":"all-in-one-wp-security-and-firewall\/wp-security.php","1":"fastdup\/fastdup.php","2":"google-sitemap-generator\/sitemap.php","3":"pods\/init.php","4":"s3-uploads\/s3-uploads.php","6":"wp-fastest-cache\/wpFastestCache.php","7":"wp-mail-smtp\/wp_mail_smtp.php","8":"wpforms-lite\/wpforms.php"}

==== SYSTEM STATS ====

2023-05-25 09:47:22 [INFO] //========PACKAGE: START========//

2023-05-25 09:47:22 [INFO] Create Package: ID: 6

2023-05-25 09:47:22 [INFO] Package Data : {

"id": 6,

"name": "package",

"hash": 1685004442,

"name_hash": "package_1685004442",

"status": 10,

"scan_file": null,

"site_url": "https:\/\/www.hidden.co.uk",

"template_id": "full_site",

"filter_exts": null,

"filter_files": null,

"filter_dirs": null,

"filter_tables": null,

"store_path": "\/app\/wp-app\/wp-content\/njt-fastdup\/packages",

"store_url": "https:\/\/www.hidden.co.uk\/wp-content\/njt-fastdup\/packages\/",

"store_path_temp": "\/app\/wp-app\/wp-content\/njt-fastdup\/tmp",

"Archive": {

"is_filter": 0,

"export_onlydb": false,

"filter_exts": [],

"filter_dirs": [

"\/app\/wp-app\/wp-content\/njt-fastdup"

],

"filter_files": [],

"read_checks": [],

"recursive_links": [],

"addon_sites": [],

"file": "package_1685004442_archive.zip",

"sql_path": null,

"zip_archive": null,

"zip_path": null,

"compress_dir": "\/app\/wp-app",

"unreadable_log": [],

"dir_exclude_log": [],

"recursive_links_log": [],

"exts_exclude_log": [],

"add_file_error_log": [],

"file_exclude_log": []

},

"Database": {

"is_filter": false,

"filter_tables": [],

"file": "package_1685004442_database.sql",

"prefix": "wp_"

},

"created": "2023-05-25 08:47:22",

"njt_fastdup_archive_name": "wp-content\/njt-fastdup",

"njt_fastdup_dir_plugin": "wp-content\/plugins"

}

2023-05-25 09:47:22 [INFO] //========SCAN PACKAGE JSON: START========//

2023-05-25 09:47:22 [INFO] //========SCAN PACKAGE JSON: DONE========//

2023-05-25 09:47:27 [INFO] //========DATABASE: START========//

2023-05-25 09:47:29 [INFO] //========DATABASE: DONE========//

2023-05-25 09:47:29 [INFO] //========ARCHIVE: START========//

2023-05-25 09:47:29 [INFO] File Path: /app/wp-app/wp-content/njt-fastdup/tmp/package_1685004442_database.sql

2023-05-25 09:47:29 [INFO] ZIP database: successfully

2023-05-25 09:47:29 [INFO] File Path: /app/wp-app/wp-content/njt-fastdup/tmp/package_1685004442_scan.json

2023-05-25 09:47:29 [INFO] ZIP scan_json: successfully

2023-05-25 09:47:29 [INFO] File Path: /app/wp-app/.htaccess

2023-05-25 09:47:29 [INFO] ZIP htaccess: successfully

2023-05-25 09:47:29 [INFO] File Path: /app/wp-app/wp-config.php

2023-05-25 09:47:29 [INFO] ZIP wp-config: successfully

2023-05-25 09:47:29 [INFO] File Path:

2023-05-25 09:47:29 [INFO] ZIP robots: Not Found

2023-05-25 09:47:29 [INFO] -----ZIP Source: Start-----

2023-05-25 09:47:29 [INFO] ---Directory Exclude Start---

2023-05-25 09:47:29 [INFO] Array

(

[0] => /app/wp-app/wp-content/njt-fastdup

)

2023-05-25 09:47:29 [INFO] ---Directory Exclude End---

2023-05-25 09:47:29 [INFO] -----ZIP Source: End-----

2023-05-25 09:47:35 [INFO] Zip Source Successfully

2023-05-25 09:47:35 [INFO] //========ARCHIVE: DONE========//

2023-05-25 09:47:35 [INFO] //========CLEAN UP: START========//

2023-05-25 09:47:35 [INFO] Move File /app/wp-app/wp-content/njt-fastdup/tmp/package_1685004442_scan.json To Packages Directory Successfully

2023-05-25 09:47:35 [INFO] Move File /app/wp-app/wp-content/njt-fastdup/tmp/package_1685004442_archive.zip To Packages Directory Successfully

2023-05-25 09:47:35 [INFO] Move File /app/wp-app/wp-content/njt-fastdup/tmp/package_1685004442_database.sql To Packages Directory Successfully

2023-05-25 09:47:35 [INFO] //========CLEAN UP: DONE========//

2023-05-25 09:47:35 [INFO] //========PACKAGE: DONE========//

2023-05-25 09:47:36 [INFO] Unschedule Package 6
    • This reply was modified 1 year, 6 months ago by roryferguson.

    Hi @roryferguson ,

    Thanks for your feedback!

    Please let me check with the dev and I will feed you back as soon as possible.

    Kind regards,
    Alina

    Hi @roryferguson ,

    Thanks for you patience!

    We have release a new fix for this issue, please update to the latest version and let us know if it works.

    Kind regards,
    Alina

    Thread Starter roryferguson

    (@roryferguson)

    Impressive turn around!

    • This reply was modified 1 year, 6 months ago by roryferguson.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Installation Unsuccessful – Syntax error in regular expression’ is closed to new replies.