this is the log [2023-03-25 18:55:42] production.ERROR: PDO::exec(): Argument #1 ($statement) must be of type string, Illuminate\Database\Query\Expression given {“exception”:"[object] (TypeError(code: 0): PDO::exec(): Argument #1 ($statement) must be of type string, Illuminate\Database\Query\Expression given at /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Database/Connection.php:594) [stacktrace] #0 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Database/Connection.php(594): PDO->exec() #1 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\Database\Connection->Illuminate\Database\{closure}() #2 /home//domains/.net/public_html/watere/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\Database\Connection->runQueryCallback() #3 /home//domains/.net/public_html/watere/vendor/laravel/framework/src/Illuminate/Database/Connection.php(598): Illuminate\Database\Connection->run() #4 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\Database\Connection->unprepared() #5 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\Database\DatabaseManager->__call() #6 /home//domains/.net/public_html/fatere/vendor/tecdiary/installer/src/Install.php(310): Illuminate\Support\Facades\Facade::__callStatic() #7 /home//domains/.net/public_html/fatere/vendor/tecdiary/installer/src/Install.php(53): Tecdiary\Installer\Install::dbTransaction() #8 /home//domains/.net/public_html/ftere/vendor/tecdiary/installer/src/Http/Controllers/InstallController.php(76): Tecdiary\Installer\Install::createTables() #9 /home//domains/.net/public_html/fwtere/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Tecdiary\Installer\Http\Controllers\InstallController->save() #10 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\Routing\Controller->callAction() #11 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\Routing\ControllerDispatcher->dispatch() #12 /home//domains/schoole.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #13 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\Routing\Route->run() #14 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #15 /home//domains/.net/public_html/fatere/vendor/tecdiary/installer/src/Http/Middleware/CanInstall.php(15): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #16 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Tecdiary\Installer\Http\Middleware\CanInstall->handle() #17 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #18 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then() #19 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack() #20 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute() #21 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute() #22 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\Routing\Router->dispatch() #23 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #24 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #26 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #27 /home//domains/schoole.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #28 /home//domains/schoole.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #29 /home//domains/schoole.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #30 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #31 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #32 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #34 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #35 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle() #36 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #37 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle() #38 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\Pipeline\Pipeline->then() #40 /home//domains/.net/public_html/fatere/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #41 /home//domains/.net/public_html/fatere/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle() #42 {main} "}
- MSAnswered
Hello,
Please let me know your php and database version. SIM v4 required php 8.1+ and MySQL 8.
Thank you
- AAnswered
im using hostinger host php8.1 and MariaDB you should write your requirements before we purchase your script your requirements was written there V4 is re-written using Laravel and Vuejs and required PHP8+ & MySQL 5.7.8+ MariaDB Server cannot replicate from a MySQL 8.0 primary server, because MySQL 8.0 has a binary log format that is incompatible. so any suggestions that can help or what ? hope to get quick reply … Thanks
- MSAnswered
Hello,
The requirements are mentioned on the item pages.
You didn’t tell me the mariadb version? It’s not replication but the schema only. It should be fine with v10.2+
SIM v4 is developer using Laravel and it supports all the database engines that Laravel supports.
Please let me know your server details in private reply. I will try check.
Thank you
- MSAnswered
Hello,
I am so sorry. I was checking this and have found the cause on my end. I will fix this in a while and release the update today.
Thank you
- AAnswered
alright sure take your time
- Login to Reply