Install Amelia Booking plugin : error 500

Elodie · August 31, 2021, 4:57pm

Hello,

I installed the Plugin Amelia Booking (Booking for Appointments and Events Calendar – Amelia – WordPress plugin | WordPress.org) but when I try to edit something it says “Request failed with status code 500” (for exemple in the settings). It is also really slow (the dashboard don’t load, just see the amelia logo loading).

My configuration : PHP/MySQL : 7.3.5 / 8.0.16, localwp webserver nginx, worpdress 5.8

Do you have any ideas ? I think I have a configuration problem with localwp (the plugin works fine with Wamp or an online website)

Thanks !

Elodie · September 3, 2021, 4:40pm

Up ! Could someone help me to debug my problem ?

there is no errors in website logs (php and nginx) and no errors in AppData\Roaming\Local\run\router\nginx\logs\error.log
I activate the localwp extension “Xdebug + VS Code” but don’t know what to do with that to be honnest. I just see call tracks when I load a page that craches in the wordpress backend.
I open a ticket on support Amelia : "Localwp error 500" (#2861931) / TMS-Plugins. He asks me some questions about localwp but I’m new, can you take a look ?

Where are the errors displayed ? What can I do to debug this ?

Thanks !

Elodie · September 7, 2021, 12:29pm

Hello,

Anyone to help me figure out the problem? Please Are you also reproducing the bug (the time to install a site and the Amelia Booking plugin Amelia – Events & Appointments Booking Calendar – WordPress plugin | WordPress.org, does the plugin crash from the backend?).

Before giving up Localwp… the tool is really nice but I need to install this plugin locally and I don’t understand how to find the error. thanks for your help

Geoffray · October 14, 2021, 7:56am

Hello,

I’ve got the same problem.

Thanks for your help

peterz82 · January 4, 2022, 6:33pm

Hi everybody,
any news on this one? I am experiencing exactly the same issues

Thanks for your help!

genyus · January 5, 2022, 12:26am

I span up a test site, installed the plugin and it works as expected. Try it in a clean site to be sure it’s not conflicting with another component?

itsjohnnyhatz · May 30, 2022, 1:03pm

Same issue here.
On a normal hosted site Amelia works fine.
I have also just tried XAMPP (thought I’d never have to go back!) and Amelia works fine there.

On Local however, any site, regardless of it being a clean install or not, Amelia just doesn’t work.
The dashboard just hangs on the logo, there is no way of entering the license key, and modifying any setting seems to throw this error: ‘Error - Request failed with status code 500’.

So, it seems that Local WP is the issue.

@ben.turner @austinwendt - can someone investigate? We cannot use Local for building Booking sites now for our clients!

And to further add to the frustration, no one from WP Engine has replied to this thread and to @Elodie’s questions regarding her debug activities!

Some input on this would be very much appreciated.

Thanks,
John

sambrockway · May 31, 2022, 4:59pm

Hello there - thank you so much for reaching out with your question!

Can you please share your Local configuration settings?

I just spun up a new site with the following settings & I haven’t been able to replicate the errors described:

PHP: 7.4.1
Web server: nginx
MySQL Version: 8.0.16
WordPress Version: 6.0

Feel free to share screenshots or a screen share video with what you are seeing.

Best,

Sam

itsjohnnyhatz · May 31, 2022, 5:52pm

Hi there @sambrockway.

Appreciate your reply.

Same setup here. I created a new site and tested again. Here’s the screen share on Loom.

In the site’s shell, I see this:

Setting Local environment variables...
----
WP-CLI: Warning: PHP Startup: Unable to load dynamic library 'php_imagick.dll' (tried: C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_imagick.dll (The specified module could not be found.), C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_php_imagick.dll.dll (The specified module could not be found.)) in Unknown on line 0
WP-CLI: WP-CLI 2.6.0
Composer: Warning: PHP Startup: Unable to load dynamic library 'php_imagick.dll' (tried: C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_imagick.dll (The specified module could not be found.), C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_php_imagick.dll.dll (The specified module could not be found.)) in Unknown on line 0
Composer: Warning: PHP Startup: Unable to load dynamic library 'php_imagick.dll' (tried: C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_imagick.dll (The specified module could not be found.), C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_php_imagick.dll.dll (The specified module could not be found.)) in Unknown on line 0
Composer: Composer version 2.1.5 2021-07-23 10:35:47
PHP: Warning: PHP Startup: Unable to load dynamic library 'php_imagick.dll' (tried: C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_imagick.dll (The specified module could not be found.), C:/Users/johnn/AppData/Local/Programs/Local/resources/extraResources/lightning-services/php-7.4.1+18/bin/win64/ext\php_php_imagick.dll.dll (The specified module could not be found.)) in Unknown on line 0
PHP: 7.4.1
MySQL: mysql  Ver 8.0.16 for Win64 on x86_64 (MySQL Community Server - GPL)
----
Loaded Shell for Local Site: test-amelia
----

The router logs shows this message:

2022/05/31 20:35:27 [warn] 13152#19132: *482 a client request body is buffered to a temporary file C:\Users\johnn\AppData\Roaming\Local\run\router\nginx/temp/client_body_temp/0000000001, client: ::1, server: testamelia.local, request: "POST /wp-admin/update.php?action=upload-plugin HTTP/1.1", host: "testamelia.local", referrer: "http://testamelia.local/wp-admin/plugin-install.php"

And the local-lighting.log file has this:

{"localVersion":"6.4.0+5927","osPlatform":"win32","osRelease":"10.0.19044","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2022-05-31T17:27:38.022Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:43.859697Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 14052","timestamp":"2022-05-31T17:28:45.489Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:43.861825Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T17:28:45.489Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:45.458511Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T17:28:45.490Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:45.489628Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10102  MySQL Community Server - GPL.","timestamp":"2022-05-31T17:28:45.490Z"}

Hope that helps further the investigation.

Regards,
John

austinwendt · May 31, 2022, 10:57pm

Hi John,

Is that your local-lightning.log file in its entirety? I don’t see anything in there that points to an issue. The site shell warnings shouldn’t be related either. Given that we can’t reproduce it, I’m assuming it is something specific to Windows (I’m on a Mac, and I assume Sam tested there too.) I can try this on my Parallels to see if I can get it to happen.

There might be more detail in the browser console - if you inspect the page, do you get more details on the 500 or the network/stack trace?

itsjohnnyhatz · June 1, 2022, 6:49am

Hi @austinwendt

It was the logs dated from yesterday when I carried out this test again. I barely used Local yesterday.

My logs in local-lightning.log go all the way back Oct 2021. Do you want the whole file?

Here’s all of of the logs from yesterday until now:

{"localVersion":"6.4.0+5927","osPlatform":"win32","osRelease":"10.0.19044","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2022-05-31T17:27:38.022Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:43.859697Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 14052","timestamp":"2022-05-31T17:28:45.489Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:43.861825Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T17:28:45.489Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:45.458511Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T17:28:45.490Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T17:28:45.489628Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10102  MySQL Community Server - GPL.","timestamp":"2022-05-31T17:28:45.490Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:35.173625Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 1668","timestamp":"2022-05-31T18:50:37.342Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:35.175401Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T18:50:37.343Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:36.178143Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2022-05-31T18:50:37.343Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:36.186102Z 0 [System] [MY-010232] [Server] Crash recovery finished.","timestamp":"2022-05-31T18:50:37.343Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:37.301552Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T18:50:37.344Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:50:37.343346Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10102  MySQL Community Server - GPL.","timestamp":"2022-05-31T18:50:37.344Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:50.359154Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 1712","timestamp":"2022-05-31T18:51:52.409Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:50.360958Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T18:51:52.409Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:51.238689Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2022-05-31T18:51:52.409Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:51.243590Z 0 [System] [MY-010232] [Server] Crash recovery finished.","timestamp":"2022-05-31T18:51:52.409Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:52.366878Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T18:51:52.410Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T18:51:52.409168Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10065  MySQL Community Server - GPL.","timestamp":"2022-05-31T18:51:52.410Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:10.701Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:10.701Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:10.762Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:10.763Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:10.818Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:10.819Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:32.840Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:32.841Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:32.893Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:32.893Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:32.939Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:32.939Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:36.631Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:36.632Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:36.678Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:36.679Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:36.737Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:36.737Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.358Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.358Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.405Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.406Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.471Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.472Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.568Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.568Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.621Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.621Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:24:59.682Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:24:59.683Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:00.968227Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 8460","timestamp":"2022-05-31T20:28:02.968Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:00.970509Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T20:28:02.968Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:01.797948Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2022-05-31T20:28:02.968Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:01.801707Z 0 [System] [MY-010232] [Server] Crash recovery finished.","timestamp":"2022-05-31T20:28:02.968Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:02.927150Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T20:28:02.969Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:28:02.968303Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10065  MySQL Community Server - GPL.","timestamp":"2022-05-31T20:28:02.969Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:17.822Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:17.822Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:17.866Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:17.866Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:17.909Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:17.909Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:46.169Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:46.170Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'mysqldump.exe' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:46.216Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:46.216Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"'--help' is not recognized as an internal or external command,","timestamp":"2022-05-31T20:28:46.262Z"}
{"thread":"main","class":"Process","process":"phpCgi","level":"warn","message":"operable program or batch file.","timestamp":"2022-05-31T20:28:46.262Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:34.467071Z 0 [System] [MY-010116] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.16) starting as process 12632","timestamp":"2022-05-31T20:42:36.432Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:34.469744Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2022-05-31T20:42:36.432Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:35.284465Z 0 [System] [MY-010229] [Server] Starting crash recovery...","timestamp":"2022-05-31T20:42:36.432Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:35.288323Z 0 [System] [MY-010232] [Server] Crash recovery finished.","timestamp":"2022-05-31T20:42:36.433Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:36.397079Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2022-05-31T20:42:36.433Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2022-05-31T20:42:36.433145Z 0 [System] [MY-010931] [Server] %%resourcesPath%%\\lightning-services\\mysql-8.0.16+6\\bin\\win64\\bin\\mysqld.exe: ready for connections. Version: '8.0.16'  socket: ''  port: 10065  MySQL Community Server - GPL.","timestamp":"2022-05-31T20:42:36.433Z"}
{"localVersion":"6.4.0+5927","osPlatform":"win32","osRelease":"10.0.19044","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2022-06-01T06:36:51.772Z"}
{"localVersion":"6.4.0+5927","osPlatform":"win32","osRelease":"10.0.19044","osArch":"ia32","windowsEdition":"Microsoft Windows 10 Pro","linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2022-06-01T06:40:43.146Z"}

Anything that might be telling - I see a few ‘Crash Recovery’ related logs…?

[Edit - missed your note on browser console]

There are these errors:

JQMIGRATE: Migrate is installed, version 3.3.2
admin-ajax.php:1          Failed to load resource: the server responded with a status of 500 (Internal Server Error)
amelia-booking-dashboard-b05063c034c1cba1fef7.js:1 getCurrentUser fail
admin-ajax.php:1          Failed to load resource: the server responded with a status of 500 (Internal Server Error)
amelia-booking-dashboard-b05063c034c1cba1fef7.js:1 Error: Request failed with status code 500
    at e.exports (amelia-booking.js?ver=4.6:1:135260)
    at e.exports (amelia-booking.js?ver=4.6:1:1005406)
    at XMLHttpRequest.f.<computed> (amelia-booking.js?ver=4.6:1:134274)

Let me know any other steps I could take.

Thanks for your help,
John

CBallard · August 10, 2022, 11:50am

Hi,

Did you get this resolved? I am having the same issue. Using WAMP for booking sites…

Cheers

secondreality · January 28, 2023, 4:22pm

Hi all,

as i ran into the same issue, i started to investigate further into this.
The issue is caused by using a non standard port for MySQL on LocalWP.

The Amelia Plugin API Calls try to connect to the the database using the standard port 3306.
Sadly, there is currently no easy way to set the port.

The classes (SLIM Framework) used by amelia does have a variable for the port, but it’s not read / taken into account during the initialisation process of connecting to the database.

This can be found in the script:
Infrastucture → ContainerConfig → container.php

Around these lines (73-89):

 if (!extension_loaded('pdo_mysql') || $mysqliEnabled) {
        return new \AmeliaBooking\Infrastructure\DB\MySQLi\Connection(
            $config('host'),
            $config('database'),
            $config('username'),
            $config('password'),
            $config('charset')
        );
    }

    return new \AmeliaBooking\Infrastructure\DB\PDO\Connection(
        $config('host'),
        $config('database'),
        $config('username'),
        $config('password'),
        $config('charset')
    );

Adding the Port you find in your localWP Database Config page, as last parameter, will solve this issue, as long as you don’t update the plugin.

 if (!extension_loaded('pdo_mysql') || $mysqliEnabled) {
        return new \AmeliaBooking\Infrastructure\DB\MySQLi\Connection(
            $config('host'),
            $config('database'),
            $config('username'),
            $config('password'),
            $config('charset'),
            10012 // Custom PORT 
        );
    }

    return new \AmeliaBooking\Infrastructure\DB\PDO\Connection(
        $config('host'),
        $config('database'),
        $config('username'),
        $config('password'),
        $config('charset'),
        10012 // Custom PORT 
    );

I would expect Amelia to fix this with a custom setting.

Regards
Frank

secondreality · January 29, 2023, 3:56pm

A working solution is to add the NON STANDARD Database Port to the wordpress config.

So instead of:


/** Database hostname */ 
define( 'DB_HOST', 'localhost' );

You can set the port as following:


/** Database hostname */ 
define( 'DB_HOST', 'localhost:10012' );

Where :10012 is the port used.
Hope this helps.

Regards
Frank

castria · October 8, 2023, 2:13pm

This solution worked for me.

system · October 10, 2023, 1:23pm

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Amelia WP Booking Plugin is not loading using Local Server Support windows-10	20	1907	February 8, 2024
Changing the database listening port Support	1	21	January 24, 2025
Install and updating plugins Support	6	1948	August 25, 2020
500 Internal Server Error nginx/1.16.0 Support	2	410	July 10, 2023
Server Error (500 error) Archived Support 500-error	4	433	June 3, 2023

Install Amelia Booking plugin : error 500

Related topics