0
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}
"}
0
Hello,
Please let me know your php and database version. SIM v4 required php 8.1+ and MySQL 8.
Thank you
0
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
0
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
0
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
0
alright sure take your time
We use Cookies
We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.