A
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}
"}
[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}
"}
- MSAnsweredHello,
Please let me know your php and database version. SIM v4 required php 8.1+ and MySQL 8.
Thank you - AAnsweredim 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 - MSAnsweredHello,
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 - MSAnsweredHello,
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 - AAnsweredalright sure take your time
- Login to Reply