Question: Server Error When I Install

Server Error When I Install

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] (Typ

A

ashraf

Asked

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} "}

  • MS

    Mian Saleem

    Answered

    Hello,

    Please let me know your php and database version. SIM v4 required php 8.1+ and MySQL 8.

    Thank you

  • A

    ashraf

    Answered

    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

  • MS

    Mian Saleem

    Answered

    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

  • MS

    Mian Saleem

    Answered

    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

  • A

    ashraf

    Answered

    alright sure take your time

  • Login to Reply