Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

on install...2024_09_15_184830_add_xxx_vr_category ................................................................................................ 1.79ms FAIL #1636

Closed
nakedgoat opened this issue Nov 3, 2024 · 0 comments

Comments

@nakedgoat
Copy link

when installing , after compose install running php artisan nntmux:install

php artisan nntmux:install

Are you sure you want to install NNTmux? This will wipe your database!! (yes/no) [no]:

y

Migrating tables and seeding them with initial data

INFO Preparing database.

Creating migration table ............................................................................................................ 29.35ms DONE

INFO Loading stored database schemas.

database/schema/mariadb-schema.sql ....................................................................................................... 3s DONE

INFO Running migrations.

2024_03_30_095622_update_forum_category_colors ...................................................................................... 35.02ms DONE
2024_04_27_124202_create_media_infos_table .......................................................................................... 42.72ms DONE
2024_05_12_192646_add_uuid_column_to_failed_jobs_table .............................................................................. 98.75ms DONE
2024_05_25_122046_drop_stored_procedure .............................................................................................. 1.08ms DONE
2024_09_08_151127_create_grab_stats_table ........................................................................................... 13.76ms DONE
2024_09_08_151135_create_signup_stats_table ......................................................................................... 12.83ms DONE
2024_09_08_151158_create_role_stats_table ........................................................................................... 10.82ms DONE
2024_09_08_151214_create_download_stats_table ....................................................................................... 10.90ms DONE
2024_09_08_151223_create_release_stats_table ........................................................................................ 43.34ms DONE
2024_09_15_184830_add_xxx_vr_category ................................................................................................ 1.79ms FAIL

Illuminate\Database\QueryException

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (nntmux.categories, CONSTRAINT fk_root_categories_id FOREIGN KEY (root_categories_id) REFERENCES root_categories (id) ON DELETE CASCADE ON UPDATE CASCADE) (Connection: mariadb, SQL: insert into categories (id, title, root_categories_id, status, description, disablepreview, minsizetoformrelease, maxsizetoformrelease) values (6046, VR, 6000, 1, ?, 0, 0, 0))

at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825
821▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
822▕ );
823▕ }
824▕
➜ 825▕ throw new QueryException(
826▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
827▕ );
828▕ }
829▕ }

  +6 vendor frames 

7 database/migrations/2024_09_15_184830_add_xxx_vr_category.php:12
Illuminate\Database\Query\Builder::insert()
+34 vendor frames

42 app/Console/Commands/InstallNntmux.php:57
Illuminate\Console\Command::call()

Expected behavior
install should proceed as normal ...

Installation (please complete the following information):

  • OS: Ubuntu server clean install no wm. Version :
  • No LSB modules are available.
    Distributor ID: Ubuntu
    Description: Ubuntu 24.04.1 LTS
    Release: 24.04
    Codename: noble
  • PHP version : PHP 8.3.6 (cli) (built: Sep 30 2024 15:17:17) (NTS)
    Copyright (c) The PHP Group
    Zend Engine v4.3.6, Copyright (c) Zend Technologies
    with Zend OPcache v8.3.6, Copyright (c), by Zend Technologies
  • NNTmux version or commit [e.g. 1.0]

this was on master, did not run git fetch --all --tags --prune, or git checkout, just pulled master.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant