MariaDB Issue
-
Hi, Duplicator is my favourite plugin and I am using it since 2012. Since then I havent got any issue and even cloned very complex website with it but now I am using latest XAMPP with MariaDB on my local environment. My Live server has MYSQL 5.5 and when I use installer.php I am getting numerous errors about database server. I’d done some research and found that its an incompatibility issue between MYSQL and MARIADB. Can you help how to fix? Thanks.
-
It may be possible, it just depends on what the incompatibility issues are what kind of errors are you seeing?
I have sorted out the issue. Its the new version of duplicator who check the compatibility of servers before installing anything. Not good ??
If your referring to the “Test Connection” button version compatibility check that is basically just a notice. There is no new code in the latest version that prevents or stops the SQL scripts from running. If your getting errors thrown from the SQL then that would have probably happened in previous version of the plugin as well…
Hope that helps!
I’m now getting warnings when using Duplicator to install a package from a server running with MariaDB 10.0.23 (from Rackspace cloud sites, yuck):
Version: This Server: [5.5.42] — Package Server: [10.0.23]Everything runs fine, but localhost/mysite I get :
The localhost page isn’t workinglocalhost is currently unable to handle this request.
HTTP ERROR 500Never had this problem before…
Hey Ben,
Do you see any SQL ERROR notices in the installer-log.txt file?
I don’t think so.
Line 56 says “ERRORS FOUND: 0”
Line 220 says “ERRORS: 0 ”Hey Ben,
OK that is good! As long as you have data in the new database tables your db shouldn’t be the issue. This might be related to Apache or possibly PHP. Can you or possibly your host check the PHP error logs, there may be a clue being logged there?
Here’s what’s in my error files:
apache_error.log
[Sat Jul 02 11:04:39 2016] [notice] Digest: generating secret for digest authentication …
[Sat Jul 02 11:04:39 2016] [notice] Digest: done
[Sat Jul 02 11:04:39 2016] [notice] FastCGI: process manager initialized (pid 14120)
[Sat Jul 02 11:04:39 2016] [notice] Apache/2.2.29 (Unix) mod_wsgi/3.5 Python/2.7.10 PHP/7.0.0 mod_ssl/2.2.29 OpenSSL/0.9.8zg DAV/2 mod_fastcgi/2.4.6 mod_perl/2.0.9 Perl/v5.22.0 configured — resuming normal operations
[Sat Jul 02 11:04:46 2016] [error] [client ::1] File does not exist: /Applications/MAMP/htdocs/docs-assets, referer: https://localhost:8888/MAMP/?language=English
[Sat Jul 02 11:04:54 2016] [notice] caught SIGTERM, shutting down
[Sat Jul 02 11:05:00 2016] [notice] Digest: generating secret for digest authentication …
[Sat Jul 02 11:05:00 2016] [notice] Digest: done
[Sat Jul 02 11:05:00 2016] [notice] FastCGI: process manager initialized (pid 14168)
[Sat Jul 02 11:05:00 2016] [notice] Apache/2.2.29 (Unix) mod_wsgi/3.5 Python/2.7.10 PHP/7.0.0 mod_ssl/2.2.29 OpenSSL/0.9.8zg DAV/2 mod_fastcgi/2.4.6 mod_perl/2.0.9 Perl/v5.22.0 configured — resuming normal operations
[Sat Jul 02 11:05:11 2016] [error] [client ::1] File does not exist: /Applications/MAMP/htdocs/docs-assets, referer: https://localhost/MAMP/?language=English
[Sat Jul 02 11:06:09 2016] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/.DS_Store
[Sat Jul 02 11:22:05 2016] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/bendunkle/.DS_Store
[Sat Jul 02 11:24:49 2016] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/localsite/.DS_Store
[Sat Jul 02 11:24:49 2016] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/localsite/.htaccess
[Sat Jul 02 11:24:49 2016] [error] [client ::1] client denied by server configuration: /Applications/MAMP/htdocs/localsite/.htaccess.origmysql_error_log.err
160702 11:04:36 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
160702 11:04:37 [Warning] Setting lower_case_table_names=2 because file system for /Applications/MAMP/db/mysql/ is case insensitive
160702 11:04:37 [Note] Plugin ‘FEDERATED’ is disabled.
160702 11:04:37 InnoDB: The InnoDB memory heap is disabled
160702 11:04:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160702 11:04:37 InnoDB: Compressed tables use zlib 1.2.3
160702 11:04:37 InnoDB: Initializing buffer pool, size = 128.0M
160702 11:04:37 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
160702 11:04:37 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait…
160702 11:04:37 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait…
160702 11:04:37 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait…
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
160702 11:04:37 InnoDB: Waiting for the background threads to start
160702 11:04:38 InnoDB: 5.5.42 started; log sequence number 0
160702 11:04:38 [Note] Server hostname (bind-address): ‘0.0.0.0’; port: 8889
160702 11:04:38 [Note] – ‘0.0.0.0’ resolves to ‘0.0.0.0’;
160702 11:04:38 [Note] Server socket created on IP: ‘0.0.0.0’.
160702 11:04:38 [Note] Event Scheduler: Loaded 0 events
160702 11:04:38 [Note] /Applications/MAMP/Library/bin/mysqld: ready for connections.
Version: ‘5.5.42’ socket: ‘/Applications/MAMP/tmp/mysql/mysql.sock’ port: 8889 Source distributionphp_error.log
[02-Jul-2016 17:08:27 Europe/Berlin] PHP Fatal error: Uncaught Error: Call to undefined function wp() in /Applications/MAMP/htdocs/localsite/wp-blog-header.php:16
Stack trace:
#0 /Applications/MAMP/htdocs/localsite/index.php(17): require()
#1 {main}
thrown in /Applications/MAMP/htdocs/localsite/wp-blog-header.php on line 16
[02-Jul-2016 17:11:07 Europe/Berlin] PHP Fatal error: Uncaught Error: Call to undefined function wp() in /Applications/MAMP/htdocs/localsite/wp-blog-header.php:16
Stack trace:
#0 /Applications/MAMP/htdocs/localsite/index.php(17): require()
#1 {main}
thrown in /Applications/MAMP/htdocs/localsite/wp-blog-header.php on line 16
[02-Jul-2016 17:11:11 Europe/Berlin] PHP Fatal error: Uncaught Error: Call to undefined function nocache_headers() in /Applications/MAMP/htdocs/localsite/wp-admin/admin.php:33
Stack trace:
#0 /Applications/MAMP/htdocs/localsite/wp-admin/options-permalink.php(10): require_once()
#1 {main}
thrown in /Applications/MAMP/htdocs/localsite/wp-admin/admin.php on line 33
[02-Jul-2016 17:31:45 Europe/Berlin] PHP Fatal error: Uncaught Error: Call to undefined function wp() in /Applications/MAMP/htdocs/localsite/wp-blog-header.php:16
Stack trace:
#0 /Applications/MAMP/htdocs/localsite/index.php(17): require()
#1 {main}
thrown in /Applications/MAMP/htdocs/localsite/wp-blog-header.php on line 16`The only thing that stands out to me is:
[02-Jul-2016 17:08:27 Europe/Berlin] PHP Fatal error: Uncaught Error: Call to undefined function wp() in /Applications/MAMP/htdocs/localsite/wp-blog-header.php:16
Which means either the file isn’t physically there or you have your permissions setup in such a way that PHP is not able to process all your files…
- The topic ‘MariaDB Issue’ is closed to new replies.