Question: Cannot Install Latest Version Of V0_12_0

Cannot Install Latest Version Of V0_12_0

Cannot install the latest version MPS 0.12.0 What we have tried 1. `composer install` everything is running well until on the install page, it's stuck. 2. Trying in Both Mac env and

PE

Pricellia Ellen

Asked

Cannot install the latest version MPS 0.12.0

What we have tried

  1. composer install everything is running well until on the install page, it’s stuck.
  2. Trying in Both Mac env and Windows Env
  3. Connect to either both docker db or server db MySQL
  4. Use PHP NTS CLI (php artisan …) or docker container
  5. Install Imagick successfully

Here is some detail from the logs and request response.

  1. Save returns 302 and install returns 200 but the response is blank (blank white page with header and body)
  2. The logs file
[2023-05-23 09:16:56] 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 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:594)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(594): PDO->exec(Object(Illuminate\\Database\\Query\\Expression))
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}(Object(Illuminate\\Database\\Query\\Expression), Array)
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(720): Illuminate\\Database\\Connection->runQueryCallback(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure))
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(598): Illuminate\\Database\\Connection->run(Object(Illuminate\\Database\\Query\\Expression), Array, Object(Closure))
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(469): Illuminate\\Database\\Connection->unprepared(Object(Illuminate\\Database\\Query\\Expression))
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(353): Illuminate\\Database\\DatabaseManager->__call('unprepared', Array)
#6 /var/www/html/packages/installer/src/Install.php(241): Illuminate\\Support\\Facades\\Facade::__callStatic('unprepared', Array)
#7 /var/www/html/packages/installer/src/Install.php(58): Tecdiary\\Installer\\Install::dbTransaction('/*!40103 SET @O...')
#8 /var/www/html/packages/installer/src/Http/Controllers/InstallController.php(76): Tecdiary\\Installer\\Install::createTables(Object(Illuminate\\Http\\Request), Array, 559)
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): Tecdiary\\Installer\\Http\\Controllers\\InstallController->save(Object(Illuminate\\Http\\Request))
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(43): Illuminate\\Routing\\Controller->callAction('save', Array)
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(260): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Tecdiary\\Installer\\Http\\Controllers\\InstallController), 'save')
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\\Routing\\Route->runController()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(798): Illuminate\\Routing\\Route->run()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))
#15 /var/www/html/packages/installer/src/Http/Middleware/CanInstall.php(15): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Tecdiary\\Installer\\Http\\Middleware\\CanInstall->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route))
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(200): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))
#24 /var/www/html/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\\DisableBrowserCache->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#26 /var/www/html/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(59): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Barryvdh\\Debugbar\\Middleware\\InjectDebugbar->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#38 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#39 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#41 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure))
#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))
#43 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(175): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))
#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(144): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))
#45 /var/www/html/public/index.php(59): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))
#46 {main}
"}

I think is there something wrong with the database seeder. Any ideas? Thanks, fellas!

Attachments
  • MS

    Mian Saleem

    Answered

    Hello,

    I am sorry for this.

    I found the Laravel 10 change the DB raw and installer uses that. I have fixed it.

    Please download the latest file and try again.

    Thank you

  • PE

    Pricellia Ellen

    Answered

    Do you have any change log? I mean we wanted to know the only file that changed. In the future, it would really help us rather than replace all the files in the project.

  • MS

    Mian Saleem

    Answered

    Hello,

    Change log only list the overview of changes. It doesn’t have the modified files list. You can view the change log from item page.

    Thank you

  • PE

    Pricellia Ellen

    Answered

    And how about the update strategy if you release the newest version? Replacing all files in the project directory? My concern is the downtime in the production server. Thank you

  • MS

    Mian Saleem

    Answered

    Hello,

    It wont take a minute to unzip a update, just few seconds. Of course you will be performing the update when the system is not being used and window of 15 minutes is enough to update and restore back in case of any problem.

    Thank you

  • PE

    Pricellia Ellen

    Answered

    Hi

    I see that you have an updated version, v0.12.2. In this scenario and based on your previous chat, did you mean by your scenario is unzipping the downloaded ZIP files from here and replacing all the files in the server instead of only updating the updated file?

    How do we know the only updated files? since we have customized the software to fit our requirements.

    We wanted to know what files changed so we can know what files were affected by our customization.

  • MS

    Mian Saleem

    Answered

    Hello,

    Yes, that’s correct for manual updates.

    You can use git or any other svn system to know that. We don’t have such option to list the modified files.

    Thank you

  • PE

    Pricellia Ellen

    Answered

    Hi

    For the database update, Does it included on the change log? How do we know if we required to upgrade or run database seeder? Thank you

  • PE

    Pricellia Ellen

    Answered

    Hi, I cannot install the demo data. The button for Import Demo Data not working. I have checked the developer console, no request has been made. Is there anything wrong? I use version 0.12.2

    Can I get the SQL or insert statements?

  • MS

    Mian Saleem

    Answered

    Hello,

    As I told you before the change log is only for the feature list. Running command won’t do any harm if there is no migration or your database is up to date.

    I will check the demo data for installer. You can import the storage/app/demo.sql

    Thank you

  • Login to Reply
We use cookies, by continuing to browse the site you are agreeing to our use of cookies. Read more