search

tastyigniter / TastyIgniter

:fire: Powerful, yet easy to use, open-source online ordering, table reservation and management system for restaurants
https://tastyigniter.com
MIT License
3.03k stars 988 forks source link

Wizard: Downloaded files from server are corrupt, check setup.log #832

Closed darksylinc closed 3 years ago

darksylinc commented 3 years ago

Expected behavior: Wizard install completes successfully

Actual behavior: Wizard install fails with Downloaded files from server are corrupt, check setup.log

Reproduce steps: Just follow the steps in https://tastyigniter.com/docs/master/installation

Version: Latest I guess? Downloaded from https://codeload.github.com/tastyigniter/setup/zip/master

Additional Information: I tried yesterday and I was getting another type of error (download was correct, but had MySql errors during the migration phase), so I'm 99.99% this is isn't my fault.

I repeated the process twice to make sure it wasn't a 1 in a million TCP error.

setup.log.zip

ryanmitchell commented 3 years ago

This should be resolved as per: https://forum.tastyigniter.com/d/2560-recent-upgrade-and-install-issue Can you confirm?

darksylinc commented 3 years ago

OK I can confirm this error is resolved, thanks; but now I'm getting the original error I wanted to report; I'm attaching the log. setup.log.zip

I can change the ticket's title to a more generic 'Errors while installing via Wizard' or open a new one.

The error is in the last few lines. I chose to start using:

[2021/07/30 04:11:44] => Foundation setup: finishInstall
[2021/07/30 04:11:49] => Handler error (onInstall): SQLSTATE[HY000]: General error: 1364 Field 'name' doesn't have a default value (SQL: insert into `ti_pages` (`content`, `date_added`, `date_updated`, `language_id`, `meta_description`, `meta_keywords`, `permalink_slug`, `status`, `title`) values (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2021-07-30 16:11:49, 2021-07-30 16:11:49, 1, , , about-us, 1, About Us), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2021-07-30 16:11:49, 2021-07-30 16:11:49, 1, , , policy, 1, Policy), (Lorem ipsum dolor sit amet, consectetur adipiscing elit., 2021-07-30 16:11:49, 2021-07-30 16:11:49, 1, , , terms-and-conditions, 1, Terms and Conditions))
[2021/07/30 04:11:49] => Trace log:
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(629): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(464): Illuminate\Database\Connection->run()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(416): Illuminate\Database\Connection->statement()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2661): Illuminate\Database\Connection->insert()
#4 /var/www/html/extensions/igniter/pages/database/migrations/2018_06_28_000300_create_pages_table.php(83): Illuminate\Database\Query\Builder->insert()
#5 /var/www/html/extensions/igniter/pages/database/migrations/2018_06_28_000300_create_pages_table.php(35): Igniter\Pages\Database\Migrations\CreatePagesTable->seedPages()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(392): Igniter\Pages\Database\Migrations\CreatePagesTable->up()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(200): Illuminate\Database\Migrations\Migrator->runMigration()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(165): Illuminate\Database\Migrations\Migrator->runUp()
#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(110): Illuminate\Database\Migrations\Migrator->runPending()
#11 /var/www/html/vendor/tastyigniter/flame/src/Database/Migrations/Migrator.php(14): Illuminate\Database\Migrations\Migrator->run()
#12 /var/www/html/app/system/classes/UpdateManager.php(239): Igniter\Flame\Database\Migrations\Migrator->run()
#13 /var/www/html/app/system/classes/ExtensionManager.php(759): System\Classes\UpdateManager->migrateExtension()
#14 /var/www/html/setup/classes/SetupController.php(569): System\Classes\ExtensionManager->installExtension()
#15 /var/www/html/setup/classes/SetupController.php(257): SetupController->completeInstall()
#16 /var/www/html/setup/classes/SetupController.php(284): SetupController->onInstall()
#17 /var/www/html/setup/classes/SetupController.php(47): SetupController->execPostHandler()
#18 /var/www/html/setup/bootstrap.php(63): SetupController->__construct()
#19 /var/www/html/setup.php(1): include_once('/var/www/html/s...')
#20 {main}

After that the installer seems to be stuck forever. StuckForever

darksylinc commented 3 years ago

If I choose Install with a pre-built theme: NO (fresh no theme or extensions) then installation completes but there is no admin folder:

00 02

matias@matias:/var/www/html$ ll
total 388
drwxr-xr-x 12 www-data www-data   4096 Jul 30 16:20 ./
drwxr-xr-x  3 root     root       4096 Jul 30 16:10 ../
-rw-r--r--  1 www-data www-data    367 Jul 28 12:30 .editorconfig
-rw-r--r--  1 www-data www-data    779 Jul 30 16:19 .env
-rw-r--r--  1 www-data www-data     72 Jul 28 12:30 .gitignore
-rw-r--r--  1 www-data www-data   1523 Jul 30 16:19 .htaccess
-rw-r--r--  1 www-data www-data   1098 Jul 30 16:19 LICENSE.txt
-rw-r--r--  1 www-data www-data   4264 Jul 30 16:19 README.md
drwxr-xr-x  5 www-data www-data   4096 Jul 30 16:11 app/
-rw-r--r--  1 www-data www-data   1654 Jul 30 16:19 artisan
drwxr-xr-x  4 www-data www-data   4096 Jul 30 16:11 assets/
-rw-r--r--  1 www-data www-data    779 Jul 30 16:11 backup.env
drwxr-xr-x  2 www-data www-data   4096 Jul 30 16:11 bootstrap/
-rw-r--r--  1 www-data www-data   1397 Jul 30 16:19 composer.json
-rw-r--r--  1 www-data www-data 280135 Jul 30 16:19 composer.lock
drwxr-xr-x  2 www-data www-data   4096 Jul 30 16:11 config/
drwxr-xr-x  3 www-data www-data   4096 Jul 30 16:11 extensions/
-rw-r--r--  1 www-data www-data   1793 Jul 30 16:19 index.php
-rw-r--r--  1 www-data www-data    716 Jul 30 16:19 phpunit.dusk.xml
-rw-r--r--  1 www-data www-data   1054 Jul 30 16:19 phpunit.xml
-rw-r--r--  1 www-data www-data     31 Jul 30 16:19 robots.txt
-rw-r--r--  1 www-data www-data    557 Jul 30 16:19 server.php
drwxr-xr-x  6 www-data www-data   4096 Jul 30 16:20 setup/
-rw-r--r--  1 www-data www-data   2240 Jul 28 12:30 setup.php
drwxr-xr-x  7 www-data www-data   4096 Jul 30 16:11 storage/
drwxr-xr-x  5 www-data www-data   4096 Jul 30 16:11 tests/
drwxr-xr-x  4 www-data www-data   4096 Jul 30 16:11 themes/
drwxr-xr-x 35 www-data www-data   4096 Jul 30 16:11 vendor/

Full file list of /var/www/html (via find . > list.txt): full_file_list.txt.zip

Setup.log of "successful" installation: setup2.log.zip

darksylinc commented 3 years ago 
mysql> show columns from ti_pages;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| page_id          | int          | NO   | PRI | NULL    | auto_increment |
| language_id      | int          | NO   |     | NULL    |                |
| name             | varchar(128) | NO   |     | NULL    |                |
| title            | varchar(128) | NO   |     | NULL    |                |
| heading          | varchar(128) | YES  |     | NULL    |                |
| content          | text         | NO   |     | NULL    |                |
| meta_description | varchar(128) | YES  |     | NULL    |                |
| meta_keywords    | varchar(128) | YES  |     | NULL    |                |
| layout_id        | int          | YES  |     | NULL    |                |
| navigation       | text         | YES  |     | NULL    |                |
| date_added       | datetime     | NO   |     | NULL    |                |
| date_updated     | datetime     | NO   |     | NULL    |                |
| status           | tinyint(1)   | NO   |     | NULL    |                |
| permalink_slug   | varchar(128) | YES  |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+
14 rows in set (0.00 sec)
sampoyigi commented 3 years ago

Apply the fix here if you haven't already https://github.com/tastyigniter/TastyIgniter/commit/474c6a0526023d04dd7aa990049c7ddbdecd8143

The admin pages not showing is related to your htaccess. Read the docs post-installation steps on making the appropriate changes to your htaccess file https://tastyigniter.com/docs/master/installation#post-installation-steps

darksylinc commented 3 years ago

Hi! Thanks!

I'll try your changes

The admin pages not showing is related to your htaccess. Read the docs post-installation steps on making the appropriate changes to your htaccess file

I did follow those steps but I guess I made a mistake enabling per folder htaccess. I'll check it again. Thanks!

Could this issue be added to the FAQ? e.g.

Q: Why accessing example.com/admin after installation gives me a 404? A: On Apache your htaccess file is not configured correctly. Please see the post-installation steps