Hi!

I want to buy this plugin for a project but when I try it I cannot create a service for my category. Whenever I try to create a service I get an HTTP 500 error from the server. 

I'm using WP 5.3.2 with PHP 7.4 with apache in a Docker environment.

Here is the content of the error:

{
    "message": "Slim Application Error",
    "error": [
        {
            "type": "Error",
            "code": 0,
            "message": "Call to a member function getMessage() on bool",
            "file": "/var/www/html/wp-content/plugins/ameliabooking/src/Infrastructure/Repository/Bookable/Service/ServiceRepository.php",
            "line": 197,
            "trace": [
                "#0 /var/www/html/wp-content/plugins/ameliabooking/src/Application/Commands/Bookable/Service/AddServiceCommandHandler.php(81): AmeliaBooking\Infrastructure\Repository\Bookable\Service\ServiceRepository->add(Object(AmeliaBooking\Domain\Entity\Bookable\Service\Service))",
                "#1 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/Handler/CommandHandlerMiddleware.php(71): AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommandHandler->handle(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand))",
                "#2 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/CommandBus.php(62): League\Tactician\Handler\CommandHandlerMiddleware->execute(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand), Object(Closure))",
                "#3 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/Plugins/LockingMiddleware.php(36): League\Tactician\CommandBus->League\Tactician\{closure}(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand))",
                "#4 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/Plugins/LockingMiddleware.php(66): League\Tactician\Plugins\LockingMiddleware->League\Tactician\Plugins\{closure}()",
                "#5 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/Plugins/LockingMiddleware.php(45): League\Tactician\Plugins\LockingMiddleware->executeQueuedJobs()",
                "#6 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/CommandBus.php(62): League\Tactician\Plugins\LockingMiddleware->execute(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand), Object(Closure))",
                "#7 /var/www/html/wp-content/plugins/ameliabooking/vendor/league/tactician/src/CommandBus.php(42): League\Tactician\CommandBus->League\Tactician\{closure}(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand))",
                "#8 /var/www/html/wp-content/plugins/ameliabooking/src/Application/Controller/Controller.php(107): League\Tactician\CommandBus->handle(Object(AmeliaBooking\Application\Commands\Bookable\Service\AddServiceCommand))",
                "#9 [internal function]: AmeliaBooking\Application\Controller\Controller->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response), Array)",
                "#10 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(41): call_user_func(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array)",
                "#11 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/Route.php(356): Slim\Handlers\Strategies\RequestResponse->__invoke(Array, Object(Slim\Http\Request), Object(Slim\Http\Response), Array)",
                "#12 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\Route->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#13 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/Route.php(334): Slim\Route->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#14 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/App.php(515): Slim\Route->run(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#15 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/MiddlewareAwareTrait.php(117): Slim\App->__invoke(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#16 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/App.php(405): Slim\App->callMiddlewareStack(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#17 /var/www/html/wp-content/plugins/ameliabooking/vendor/slim/slim/Slim/App.php(313): Slim\App->process(Object(Slim\Http\Request), Object(Slim\Http\Response))",
                "#18 /var/www/html/wp-content/plugins/ameliabooking/ameliabooking.php(155): Slim\App->run()",
                "#19 /var/www/html/wp-includes/class-wp-hook.php(288): AmeliaBooking\Plugin::wpAmeliaApiCall('')",
                "#20 /var/www/html/wp-includes/class-wp-hook.php(312): WP_Hook->apply_filters('', Array)",
                "#21 /var/www/html/wp-includes/plugin.php(478): WP_Hook->do_action(Array)",
                "#22 /var/www/html/wp-admin/admin-ajax.php(175): do_action('wp_ajax_wpameli...')",
                "#23 {main}"
            ]
        }
    ]
}

Hi Isidora,

Thanks for your answer. Yes I'm trying the lite version. I just tried on a pristine WP installation on our staging environment but it worked... This environment doesn't use Docker. 

It seems that only my local environment which runs on Docker has the problem. Do you want the docker-compose.yml file in order to reproduce it on your end?

Thanks for your help.

Alright. But I cannot upload it through the form. It won't let met. Where should I send you the database export?

Hi Isidora,

Sure no big deal I figured your support was only during weekdays. I'll send that to you.

Best regards,

I just sent it your way.

I have Version 1.0.13 which I think is the latest version.

Hi Isidora,

Thank you for the code. I just replaced the file "ServiceRepository.php" that you gave me and I have new error now on the POST request :  /wp-admin/admin-ajax.php?action=wpamelia_api&call=/services. The response I get is : { message: "Unable to add data in AmeliaBooking\Infrastructure\Repository\Bookable\Service\ServiceRepository" }. The service I tried to add is not created.

Here is the data I tried to send with that request through the backoffice form : 

{"id":0,"categoryId":1,"color":"#1788FB","description":"","duration":3600,"providers":[1],"extras":[],"maxCapacity":1,"minCapacity":1,"name":"Test","pictureFullPath":"","pictureThumbPath":"","price":10,"status":"visible","timeAfter":"","timeBefore":"","bringingAnyone":true,"show":true,"applyGlobally":false,"gallery":[],"aggregatedPrice":true,"settings":{"general":{"minimumTimeRequirementPriorToCanceling":null,"redirectUrlAfterAppointment":null},"payments":{"onSite":true,"wc":{"productId":""},"payPal":{"enabled":false},"stripe":{"enabled":false}}},"position":0}

I enabled wp_debug_log feature and here is a warning which matches the time of my request : 

[24-Mar-2020 09:16:06 UTC] PHP Warning:  mysqli_stmt::bind_param(): Undefined fieldtype a (parameter 19) in /var/www/html/wp-content/plugins/ameliabooking/src/Infrastructure/DB/MySQLi/Statement.php on line 102

Let me know if I can provide more information.

Hi Isidora,

Thanks for your message. Sorry for my delayed response I had other matter to attend to as well. I'm going to try your premium version and see how it goes. Should I submit another ticket in your ticket system if I have the same problem?

Best regards,

Jonas Pauthier.

Hi!

I just installed your plugin after my purchase and my problem is gone. Thank you very much for your help. You can close the issue now. I don't know how I can do it myself.

Have a great day.

Best regards,

Jonas.