ERROR 1145 (42S02) at the end of instalation of WordPress Multisite on Win10

Keywords: WordPress Multisite - Installers - How to - Services (Apache, MariaDB, MySQL…)

Description:
Hello,
I was installing on my new computer (with Windows 10) Bitnami WordPress Multisite installation and at the end of it I got this error:

Error running F:\Bitnami\wordpressmultisite-5.8.1-0\mariadb\bin\mysql.exe --user=root --host=127.0.0.1 --port=3306 --database=bitnami_wordpress “–password=****” -e “UPDATE wp_sitemeta SET meta_value = ‘40960’ WHERE meta_key = ‘fileupload_maxk’”: ERROR 1145 (42S02) at line 1: Table ‘bitnami_wordpress.wp_sitemeta’ doesn’t exist

What should I do?

Hi @lukasz.konarski,

Which WordPress Multisite version is it? Can you check the installation log for any errors? It can be found in the user temp folder (just type %temp% in the file explorer). It’s called something like “installbuilder_*.log”.

Regards,
Michiel

I’m using “wordpressmultisite-5.8.1-0” I have found log in “apache2” folder “error.log” I will list it below:

[Wed Sep 29 23:05:06.926793 2021] [ssl:warn] [pid 6740:tid 632] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:07.033806 2021] [ssl:warn] [pid 6740:tid 632] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:07.080848 2021] [mpm_winnt:notice] [pid 6740:tid 632] AH00455: Apache/2.4.48 (Win64) OpenSSL/1.1.1l PHP/7.4.23 configured – resuming normal operations
[Wed Sep 29 23:05:07.080848 2021] [mpm_winnt:notice] [pid 6740:tid 632] AH00456: Apache Lounge VC15 Server built: Aug 26 2021 11:15:15
[Wed Sep 29 23:05:07.080848 2021] [core:notice] [pid 6740:tid 632] AH00094: Command line: ‘F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\bin\httpd.exe -d F:/Bitnami/wordpressmultisite-5.8.1-0/apache2 -f F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\conf\httpd.conf’
[Wed Sep 29 23:05:07.094397 2021] [mpm_winnt:notice] [pid 6740:tid 632] AH00418: Parent: Created child process 3656
[Wed Sep 29 23:05:07.433381 2021] [ssl:warn] [pid 3656:tid 584] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:07.488411 2021] [ssl:warn] [pid 3656:tid 584] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:07.506428 2021] [mpm_winnt:notice] [pid 3656:tid 584] AH00354: Child: Starting 64 worker threads.
[Wed Sep 29 23:05:14.086148 2021] [mpm_winnt:notice] [pid 6740:tid 632] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Wed Sep 29 23:05:16.099606 2021] [mpm_winnt:notice] [pid 3656:tid 584] AH00364: Child: All worker threads have exited.
[Wed Sep 29 23:05:16.124324 2021] [mpm_winnt:notice] [pid 6740:tid 632] AH00430: Parent: Child process 3656 exited successfully.
[Wed Sep 29 23:05:17.966047 2021] [ssl:warn] [pid 14288:tid 648] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:18.022090 2021] [ssl:warn] [pid 14288:tid 648] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:18.047113 2021] [mpm_winnt:notice] [pid 14288:tid 648] AH00455: Apache/2.4.48 (Win64) OpenSSL/1.1.1l PHP/7.4.23 configured – resuming normal operations
[Wed Sep 29 23:05:18.047113 2021] [mpm_winnt:notice] [pid 14288:tid 648] AH00456: Apache Lounge VC15 Server built: Aug 26 2021 11:15:15
[Wed Sep 29 23:05:18.047113 2021] [core:notice] [pid 14288:tid 648] AH00094: Command line: ‘F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\bin\httpd.exe -d F:/Bitnami/wordpressmultisite-5.8.1-0/apache2 -f F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\conf\httpd.conf’
[Wed Sep 29 23:05:18.061125 2021] [mpm_winnt:notice] [pid 14288:tid 648] AH00418: Parent: Created child process 6316
[Wed Sep 29 23:05:18.411211 2021] [ssl:warn] [pid 6316:tid 564] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:18.465260 2021] [ssl:warn] [pid 6316:tid 564] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:18.484277 2021] [mpm_winnt:notice] [pid 6316:tid 564] AH00354: Child: Starting 64 worker threads.
[Wed Sep 29 23:05:35.447989 2021] [mpm_winnt:notice] [pid 14288:tid 648] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Wed Sep 29 23:05:37.464099 2021] [mpm_winnt:notice] [pid 6316:tid 564] AH00364: Child: All worker threads have exited.
[Wed Sep 29 23:05:37.492567 2021] [mpm_winnt:notice] [pid 14288:tid 648] AH00430: Parent: Child process 6316 exited successfully.
[Wed Sep 29 23:05:39.320958 2021] [ssl:warn] [pid 3732:tid 648] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:39.390005 2021] [ssl:warn] [pid 3732:tid 648] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:39.406020 2021] [mpm_winnt:notice] [pid 3732:tid 648] AH00455: Apache/2.4.48 (Win64) OpenSSL/1.1.1l PHP/7.4.23 configured – resuming normal operations
[Wed Sep 29 23:05:39.406020 2021] [mpm_winnt:notice] [pid 3732:tid 648] AH00456: Apache Lounge VC15 Server built: Aug 26 2021 11:15:15
[Wed Sep 29 23:05:39.407021 2021] [core:notice] [pid 3732:tid 648] AH00094: Command line: ‘F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\bin\httpd.exe -d F:/Bitnami/wordpressmultisite-5.8.1-0/apache2 -f F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\conf\httpd.conf’
[Wed Sep 29 23:05:39.421033 2021] [mpm_winnt:notice] [pid 3732:tid 648] AH00418: Parent: Created child process 1400
[Wed Sep 29 23:05:39.789342 2021] [ssl:warn] [pid 1400:tid 568] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:39.854674 2021] [ssl:warn] [pid 1400:tid 568] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:39.873692 2021] [mpm_winnt:notice] [pid 1400:tid 568] AH00354: Child: Starting 64 worker threads.
[Wed Sep 29 23:05:52.019377 2021] [mpm_winnt:notice] [pid 3732:tid 648] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Wed Sep 29 23:05:54.040492 2021] [mpm_winnt:notice] [pid 1400:tid 568] AH00364: Child: All worker threads have exited.
[Wed Sep 29 23:05:54.065679 2021] [mpm_winnt:notice] [pid 3732:tid 648] AH00430: Parent: Child process 1400 exited successfully.
[Wed Sep 29 23:05:55.900195 2021] [ssl:warn] [pid 14464:tid 656] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:55.963170 2021] [ssl:warn] [pid 14464:tid 656] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:55.980186 2021] [mpm_winnt:notice] [pid 14464:tid 656] AH00455: Apache/2.4.48 (Win64) OpenSSL/1.1.1l PHP/7.4.23 configured – resuming normal operations
[Wed Sep 29 23:05:55.980186 2021] [mpm_winnt:notice] [pid 14464:tid 656] AH00456: Apache Lounge VC15 Server built: Aug 26 2021 11:15:15
[Wed Sep 29 23:05:55.980186 2021] [core:notice] [pid 14464:tid 656] AH00094: Command line: ‘F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\bin\httpd.exe -d F:/Bitnami/wordpressmultisite-5.8.1-0/apache2 -f F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\conf\httpd.conf’
[Wed Sep 29 23:05:55.996200 2021] [mpm_winnt:notice] [pid 14464:tid 656] AH00418: Parent: Created child process 6460
[Wed Sep 29 23:05:56.455545 2021] [ssl:warn] [pid 6460:tid 572] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:56.521588 2021] [ssl:warn] [pid 6460:tid 572] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:05:56.540605 2021] [mpm_winnt:notice] [pid 6460:tid 572] AH00354: Child: Starting 64 worker threads.
[Wed Sep 29 23:09:13.991851 2021] [mpm_winnt:notice] [pid 14464:tid 656] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Wed Sep 29 23:09:16.014616 2021] [mpm_winnt:notice] [pid 6460:tid 572] AH00364: Child: All worker threads have exited.
[Wed Sep 29 23:09:16.040631 2021] [mpm_winnt:notice] [pid 14464:tid 656] AH00430: Parent: Child process 6460 exited successfully.
[Wed Sep 29 23:09:18.013086 2021] [ssl:warn] [pid 13212:tid 676] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:09:18.088156 2021] [ssl:warn] [pid 13212:tid 676] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:09:18.113178 2021] [mpm_winnt:notice] [pid 13212:tid 676] AH00455: Apache/2.4.48 (Win64) OpenSSL/1.1.1l PHP/7.4.23 configured – resuming normal operations
[Wed Sep 29 23:09:18.113178 2021] [mpm_winnt:notice] [pid 13212:tid 676] AH00456: Apache Lounge VC15 Server built: Aug 26 2021 11:15:15
[Wed Sep 29 23:09:18.113178 2021] [core:notice] [pid 13212:tid 676] AH00094: Command line: ‘F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\bin\httpd.exe -d F:/Bitnami/wordpressmultisite-5.8.1-0/apache2 -f F:\Bitnami\wordpressmultisite-5.8.1-0\apache2\conf\httpd.conf’
[Wed Sep 29 23:09:18.133196 2021] [mpm_winnt:notice] [pid 13212:tid 676] AH00418: Parent: Created child process 5688
[Wed Sep 29 23:09:18.646662 2021] [ssl:warn] [pid 5688:tid 592] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:09:18.709720 2021] [ssl:warn] [pid 5688:tid 592] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name
[Wed Sep 29 23:09:18.730739 2021] [mpm_winnt:notice] [pid 5688:tid 592] AH00354: Child: Starting 64 worker threads.

Hi @lukasz.konarski,

The Apache log doesn’t show any errors. We have a Support Tool that will gather relevant information for us to analyze your configuration and logs. Could you please execute it on the machine where the stack is running by following the steps described in the guide below?

How to Run the Bitnami Support Tool in a cloud image or virtual machine

Please note that you need to paste the code ID that is shown at the end.

Regards,
Michiel

I have used bndiagnostic-0.9.13-windows.exe and I have got code:
12ebe14e-c66e-0392-4228-315229889b9c

Hi @lukasz.konarski,

Can you check for a file called properties.ini in the installation directory, and share the content here? Be careful not to share any private information like IP addresses.

Regards,
Michiel

Well only IP address is localhost so I will leave it as is:

[Banner]
disable_banner_file=F:\Bitnami\wordpressmultisite-5.8.1-0/apps/bitnami/banner/disable-banner
[MySQL]
mysql_port=3306
mysql_host=127.0.0.1
mysql_root_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/mariadb
mysql_binary_directory=F:/Bitnami/wordpressmultisite-5.8.1-0/mariadb/bin
mysql_data_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/mariadb/data
mysql_configuration_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/mariadb
mysql_arguments=-u root
mysql_unique_service_name=wordpressmultisiteMariaDB-2
mysql_version=10.4.21
mysql_database_type=mariadb
[General]
installdir=F:\Bitnami\wordpressmultisite-5.8.1-0
base_stack_name=Bitnami WordPress Multisite Stack
base_stack_key=wordpressmultisite
base_stack_version=5.8.1-0
base_stack_platform=windows-x64
[Support]
installed_components=apache php mysql imagemagick wordpress
apache_logs=apache{,2}/logs/errorlog logs/error_log
apache_conf=apache{,2}/conf/{
.conf,bitnami/.conf} etc/httpd.conf apps//conf/ht*.conf
apache_acl=apache apache2
php_logs=php/var/log/php-fpm.log
php_conf=php/{php.ini,etc/php.ini} php/etc/bitnami/common.conf apps//conf/php-fpm/.conf
php_acl=php
mysql_logs=m{ysql,ariadb}/data/mysql{d,_error}.log var/mysql/.err
mysql_conf=m{ysql,ariadb}/{my.cnf,my.ini} etc/my.cnf
mysql_acl=mariadb mysql
imagemagick_conf=common/lib/ImageMagick-
/config-*/{log.xml,magic.xml,policy.xml,type.xml}
wordpress_priv=apps/wordpress/htdocs/wp-config.php
[Apache]
apache_server_port=80
apache_server_ssl_port=443
apache_root_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/apache2
apache_htdocs_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/apache2/htdocs
apache_domainname=DESKTOP-79NEULB
apache_configuration_directory=F:\Bitnami\wordpressmultisite-5.8.1-0/apache2/conf
apache_unique_service_name=wordpressmultisiteApache
apache_version=2.4.48
[PHP]
php_binary_directory=F:/Bitnami/wordpressmultisite-5.8.1-0/php
php_configuration_directory=F:/Bitnami/wordpressmultisite-5.8.1-0/php
php_extensions_directory=F:/Bitnami/wordpressmultisite-5.8.1-0/php/ext
php_version=7.4.23
[Imagemagick]
imagemagick_root_directory=F:\Bitnami\wordpressmultisite-5.8.1-0\imagemagick

Hi @lukasz.konarski,

Do you have multiple installations of WP multisite running? Could you check in the task manager for a service called wordpressmultisiteMariaDB*? Could you try to uninstall the application and check if the services are also removed?

Regards,
Michiel

ok, I had several versions of “wordpressmultisiteMariaDB”: 1. “wordpressmultisiteMariaDB”
2. “wordpressmultisiteMariaDB-1”
3. “wordpressmultisiteMariaDB-2”
3. “wordpressmultisiteMariaDB-3”
and “wordpressMariaDB”
after uninstalling the “wordpressmultisiteMariaDB-3” version was missing

Hi @lukasz.konarski,

Can you stop the remaining wordpressmultisiteMariaDB processes in task manager, and try to install again?

Regards,
Michiel

The other processes were stopped but I couldn’t delete them.
At the end of the reinstallation, I got the same error as at the beginning of this discussion.

Hi @lukasz.konarski,

Can you check if the table “bitnami_wordpress.wp_sitemeta” exists in MySQL?

use bitnami_wordpress;
show tables like "bitnami_wordpress.wp_sitemeta";

https://docs.bitnami.com/installer/apps/wordpress/get-started/connect-mysql/

Regards,
Michiel

Sorry I don’t know how to use it, whatever i Write I get information like “is not recognized as an internal or external command”.

Hi @lukasz.konarski,

Could you completely uninstall all WordPress Multisite installations and also check if any services are running afterwards, and stop them if necessary? Then restart the machine and install again? If it happens again, could you run the bndiagnostic tool again?

Regards,
Michiel