Update from 3.0.8 to 3.1.1 crashed

gnulf

I want to update to the version 3.1.1. While updating the process stops. The progress bar shows somethings like "installation finished"but switched to red-color. I wait some minutes but nothing happens. If I reload the page, I see only a blank page. This concerns the admin-interface and the website.

I update like it was described in the release note:

disable the extensions
ignore the extension-updates
update the main-part

Has someone an idea what I can do?
Are there some logfiles I can view?

My screenshot:
https://ibb.co/Cz9HYR2

sampoyigi

Can you also share your System > System Logs?

gnulf

sampoyigi
Yes, of course, but … I ve no access to the admin interface. Is access to the logfile from comandline? I ve searched the filesystem but cant find any.

ryanmitchell

gnulf either storage/logs/laravel.log or your main php log

gnulf

Thank you for the hint 🙂

The /storage/logs/system.log (there is no lavarel.log …?) is empty.

Tasty runs at a webhosting account so there is no php-log-file - but: I was able to activate the php output 🙂

PHP says:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ti_themes.updated_at' in 'field list' (SQL: updateti_themessetstatus= 0,ti_themes.updated_at= 2021-10-23 07:25:10 wherecodenot in (demo, m-test, m-test-hf6, m-test, m-test, tastyigniter-orange, tastyigniter-orange-b1v))

And access-log says:
500 POST /admin/updates HTTP/1.0 https://my-restaurant.com/admin/updates (...)

sampoyigi

gnulf It appears the update did not complete. To update your database, run ‘php artisan igniter:up’.

gnulf

sampoyigi Ok, I did this - but I ve still some errors (see below). Have you some more hints for me?

What I ve done:
System-> Extension: deactivate all the extensions.
In System -> Update: ignore all the extensions.
Then run update. It crashes like described above.

Then run the command php artisan igniter:up - it seems to be ok:

Migrating application and extensions...
Migration table already exists
Migrating: 2021_07_20_000300_add_uuid_column_to_failed_jobs_table
Migrated:  2021_07_20_000300_add_uuid_column_to_failed_jobs_table (34.52ms)
Migrating: 2021_07_20_172212_create_job_batches_table
Migrated:  2021_07_20_172212_create_job_batches_table (42.40ms)
Migrating: 2021_07_20_172321_create_cache_table
Migrated:  2021_07_20_172321_create_cache_table (24.92ms)
Migrating: 2021_09_06_010000_add_timestamps_to_tables
Migrated:  2021_09_06_010000_add_timestamps_to_tables (379.53ms)
Migrated app System
Migrating: 2021_09_03_010000_make_serialize_columns_json
Migrated:  2021_09_03_010000_make_serialize_columns_json (152.90ms)
Migrating: 2021_09_06_010000_add_timestamps_to_tables
Migrated:  2021_09_06_010000_add_timestamps_to_tables (1,018.80ms)
Migrated app Admin
Nothing to migrate.
Migrated app Main

I recalled the https://my-restaurant.com/admin and saw a new red dashboard-frame. (See image: https://ibb.co/0C3tWb2) But without any function. If I hit the select date the red frame disapeared and I saw only a non stopping loading-fire (https://ibb.co/Yht3HMZ).

Then I called System->Update and I saw a blank page with:
“Something went wrong and the page cannot be displayed”

In System->Logs I find some errors:

TypeError: Carbon\CarbonInterval::setLocalTranslator(): Argument #1 ($translator) must be of type Symfony\Component\Translation\TranslatorInterface, Carbon\Translator given, called
in /…/httpdocs/vendor/nesbot/carbon/src/Carbon/Traits/Difference.php on line 826 and defined in /…/httpdocs/vendor/nesbot/carbon/src/Carbon/Traits/Localization.php:154

Error: Class “Symfony\Component\Debug\Exception\FatalThrowableError” not found
in /…/httpdocs/app/system/traits/ViewMaker.php:233

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ti_themes.updated_at’
in ‘field list’ in /…/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82

sampoyigi

gnulf When update crashes do you have the error? Try php artisan igniter:update and share any errors

gnulf

sampoyigi Any ideas / hints about the errors? (Errors: see my posting above.)

gnulf

sampoyigi I have an new error.

php artisan igniter:update

raises

PHP Fatal error:  Declaration of Symfony\Component\Console\Input\ArrayInput::
hasParameterOption($values, bool $onlyParams = false) must be compatible with 
Symfony\Component\Console\Input\InputInterface::hasParameterOption($values, 
$onlyParams = false) in /doc-root/vendor/symfony/console/Input/ArrayInput.php 
on line 56

Have you got any idea / tip?

My steps:

deactivate extensions (system-> extensions)
ignore update of the extensions (system -> update)
remove doc-root/vendor
composer update

php artisan igniter:up
output:

Migrating application and extensions...
Migration table already exists
Nothing to migrate.
Migrated app System
Nothing to migrate.
Migrated app Admin
Nothing to migrate.
Migrated app Main

php artisan igniter:update
output:

Updating TastyIgniter...
Downloading application files
Extracting application files
 
PHP Fatal error:  Declaration of Symfony\Component\Console\Input
\ArrayInput::hasParameterOption($values, bool $onlyParams = false) must be 
compatible with Symfony\Component\Console\Input\InputInterface::
hasParameterOption($values, $onlyParams = false) in /doc-root/vendor/
symfony/console/Input/ArrayInput.php on line 56
 
In ArrayInput.php line 56:
Declaration of Symfony\Component\Console\Input\ArrayInput::
hasParameterOption($values, bool $onlyParams = false)   
must be compatible with Symfony\Component\Console\Input\InputInterface::
hasParameterOption($values, $onlyParams = false)

gnulf

Yes, I ve the errors 😉 I wrote them into the posting above …
Here again:

TypeError: Carbon\CarbonInterval::setLocalTranslator(): Argument #1 ($translator) must 
be of type Symfony\Component\Translation\TranslatorInterface, Carbon\Translator given, 
called in /…/httpdocs/vendor/nesbot/carbon/src/Carbon/Traits/Difference.php on line 826 
and defined in /…/httpdocs/vendor/nesbot/carbon/src/Carbon/Traits/Localization.php:154

Error: Class “Symfony\Component\Debug\Exception\FatalThrowableError” not found
in /…/httpdocs/app/system/traits/ViewMaker.php:233

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 
‘ti_themes.updated_at’ in ‘field list’ in /…/httpdocs/vendor/doctrine/dbal/lib/Doctrine/
DBAL/Driver/PDOConnection.php:82

Do you need the StackTrace?

sampoyigi

Follow the steps here

https://forum.tastyigniter.com/d/2620-tastyigniter-v310-released/6

sampoyigi

gnulf You should also delete the API extension folder extensions/igniter/api before running igniter:update

gnulf

sampoyigi Oh, I have not any api folder at this place 🙁

ls /doc-root/extensions/igniter/
shows me:

cart  
coupons 
demo 
frontend  
local  
pages  
payregister  
reservation  
user

sampoyigi

At this stage, your best bet is to backup your files and database and do a fresh install.

gnulf

sampoyigi Ok, and how should I merge old database (mysql-dump) and old files with all the new tables and files? Which files I have to restore? The /config/database.php and probably the other configs of course, I assume the /assets-folder - but what else?

sampoyigi

For the fresh install, download the latest release from github, open the .env file and update the APP and DB values from your old config/app.php and config/database.php config files, then run composer update and php artisan igniter:up to update your database. That should get you back up and running, after which you can install your extensions.

gnulf

sampoyigi Ok, I’ll try it. Thank you very much! 🙂

gnulf

sampoyigi A question: is it equal if I download the zip-file from github or if I run composer create-project tastyigniter/tastyigniter . ?

gnulf

sampoyigi Now, I tried this, but I get more errors:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ti_job_batches' 
already exists (SQL: create table `ti_job_batches` (`id` varchar(128) not null, 
`name` varchar(128) not null, `total_jobs` int not null, `pending_jobs` int not null, 
`failed_jobs` int not null, `failed_job_ids` text not null, `options` mediumtext null, 
`cancelled_at` int null, `created_at` int not null, `finished_at` int null) default 
character set utf8mb4 collate 'utf8mb4_unicode_ci')

Steps that I do:

download and unzip developer.zip from github
move all files from TastyIgniter-develop to doc-root
copied example.env to .env
edit .env and insert values from old config/app.php and config/database.php
run composer update (->all fine)
run php artisan:up

I see the following output:

Migrating application and extensions...
Migration table already exists
Migrating: 2021_07_20_000300_add_uuid_column_to_failed_jobs_table
Migrated:  2021_07_20_000300_add_uuid_column_to_failed_jobs_table (245.50ms)
Migrating: 2021_07_20_172212_create_job_batches_table

In Connection.php line 703:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ti_job_batches' already exists (SQL: create table `ti_job_batches` (`id` varchar(128) not null, `name` varchar(128) not null, `total_jobs` int not null, `pending_jobs` int not null, `failed_jobs` int not null, `failed_job_ids` text not null, `options` mediumtext null, `cancelled_at` int null, `created_at` int not null, `finished_at` int null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

In Exception.php line 18:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ti_job_batches' already exists

In PDOStatement.php line 117:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'ti_job_batches' already exists

sampoyigi

gnulf Running composer create-project tastyigniter/tastyigniter . is same as downloading the zip from github and running composer install/update