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