tastyigniter / TastyIgniter

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

[Bug]: Upgrade from 3.0.8 to 3.5.4 fails with errno: 150 "Foreign key constraint is incorrectly formed" #1012

Closed roydeanjr closed 1 year ago

roydeanjr commented 2 years ago

What happened?

Existing database, new directory installed using command line instructions:

2022-09-06 02_25_11

What did you expect to happen?

Successful installation and upgraded database.

Version

3.5.x

What browser are you seeing the problem on?

Microsoft Edge

Relevant log output

[Tue Sep 06 03:50:07.596922 2022] [php7:notice] [pid 116179] [client 172.56.50.54:58780] PHP Fatal error:  Uncaught ErrorException: file_put_contents(/var/www/rdq/storage/framework/cache/data/85/e8/85e8fa5398ee5a9a51b9b343d8734f986c1eac78): failed to open stream: No such file or directory in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:187\nStack trace:\n#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()\n#1 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(187): file_put_contents()\n#2 /var/www/rdq/vendor/tastyigniter/flame/src/Filesystem/Filesystem.php(251): Illuminate\\Filesystem\\Filesystem->put()\n#3 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(77): Igniter\\Flame\\Filesystem\\Filesystem->put()\n#4 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(200): Illuminate\\Cache\\FileStore->put()\n#5 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(363): Illuminate\\Cache\\FileStore->forever()\n#6 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repos in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php on line 187
[Tue Sep 06 03:50:07.599791 2022] [php7:notice] [pid 116179] [client 172.56.50.54:58780] PHP Fatal error:  Uncaught ErrorException: file_put_contents(/var/www/rdq/storage/framework/cache/data/85/e8/85e8fa5398ee5a9a51b9b343d8734f986c1eac78): failed to open stream: No such file or directory in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:187\nStack trace:\n#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()\n#1 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(187): file_put_contents()\n#2 /var/www/rdq/vendor/tastyigniter/flame/src/Filesystem/Filesystem.php(251): Illuminate\\Filesystem\\Filesystem->put()\n#3 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(77): Igniter\\Flame\\Filesystem\\Filesystem->put()\n#4 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(200): Illuminate\\Cache\\FileStore->put()\n#5 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(363): Illuminate\\Cache\\FileStore->forever()\n#6 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repos in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php on line 187
[Tue Sep 06 03:50:15.224514 2022] [php7:notice] [pid 118558] [client 172.56.50.54:41927] PHP Fatal error:  Uncaught ErrorException: file_put_contents(/var/www/rdq/storage/framework/cache/data/85/e8/85e8fa5398ee5a9a51b9b343d8734f986c1eac78): failed to open stream: No such file or directory in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:187\nStack trace:\n#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()\n#1 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(187): file_put_contents()\n#2 /var/www/rdq/vendor/tastyigniter/flame/src/Filesystem/Filesystem.php(251): Illuminate\\Filesystem\\Filesystem->put()\n#3 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(77): Igniter\\Flame\\Filesystem\\Filesystem->put()\n#4 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(200): Illuminate\\Cache\\FileStore->put()\n#5 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(363): Illuminate\\Cache\\FileStore->forever()\n#6 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repos in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php on line 187
[Tue Sep 06 03:50:15.227237 2022] [php7:notice] [pid 118558] [client 172.56.50.54:41927] PHP Fatal error:  Uncaught ErrorException: file_put_contents(/var/www/rdq/storage/framework/cache/data/85/e8/85e8fa5398ee5a9a51b9b343d8734f986c1eac78): failed to open stream: No such file or directory in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:187\nStack trace:\n#0 [internal function]: Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError()\n#1 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php(187): file_put_contents()\n#2 /var/www/rdq/vendor/tastyigniter/flame/src/Filesystem/Filesystem.php(251): Illuminate\\Filesystem\\Filesystem->put()\n#3 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(77): Igniter\\Flame\\Filesystem\\Filesystem->put()\n#4 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/FileStore.php(200): Illuminate\\Cache\\FileStore->put()\n#5 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(363): Illuminate\\Cache\\FileStore->forever()\n#6 /var/www/rdq/vendor/laravel/framework/src/Illuminate/Cache/Repos in /var/www/rdq/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php on line 187
sampoyigi commented 1 year ago

This issue will be closed and archived in 3 days, as there has been no activity in the last 60 days. If this issue is still relevant or you would like to see it actioned, please respond and we will re-open this issue. If this issue is critical to your business, consider the Dedicated Support Service where a Service Level Agreement is offered.

roydeanjr commented 1 year ago

While I appreciate your work very much, I do wish I could get your application installed and working again. I have tried several times and even after 3.6 was released and I am still unable to install TI and get it running.

Would you please consider creating a video of a complete installation process from a virgin LINUX system all the way through a functioning TI installation using existing data (as an upgrade) as well as using no data, no theme, with demo data and with a theme. That simple video would go a long way in aleviating installation issues. Thank you.