Trouble migrating from 7 to 8.1, couple of DB errors

rsolva

The upgrade went smoothly until the last step, when running the php flarum migrate. Below are the three errors I get, even after restoring the DB from backup and trying again. The redacted parts are the main DB name (i.e. flarum).

In Connection.php line 664: SQLSTATE[HY000]: General error: 1005 Can't create table redacted.#sql-1788df_1c3cb8d (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table dtcposts add constraint dtcposts_user_id_foreign foreign key (user_id) references dtcusers (id) on delete set null)

In PDOStatement.php line 119: SQLSTATE[HY000]: General error: 1005 Can't create table redacted.#sql-1788df_1c3cb8d (errno: 150 "Foreign key constraint is incorrectly formed")

In PDOStatement.php line 117: SQLSTATE[HY000]: General error: 1005 Can't create table redacted.#sql-1788df_1c3cb8d (errno: 150 "Foreign key constraint is incorrectly formed")

Anyone know how this can be fixed? I guess I might have to do some manual work in the DB to fix this, but I don't know what.

EDIT: I can add that I'm on a shared hosting server, running MariaDB (10.1.37-MariaDB-cll-lve) and phpMyAdmin also tells med that the Database client version: libmysql - 5.1.73

jordanjay29

rsolva Did you disable all extensions before upgrading?

Can you post the output of php flarum info?

rsolva

jordanjay29 As far as I know, I had no third-party extensions installed to begin with. Here is the output:
Flarum core 0.1.0-beta.8.1 PHP version: 7.2.14 Loaded extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, pcntl, readline, Reflection, SPL, session, standard, bcmath, bz2, calendar, ctype, curl, dom, enchant, mbstring, fileinfo, ftp, gd, gettext, gmp, iconv, imap, intl, json, ldap, exif, mysqlnd, odbc, PDO, pgsql, Phar, posix, pspell, shmop, SimpleXML, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlwriter, xsl, zip, mysqli, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, wddx, xmlreader, xmlrpc, i360, ionCube Loader +----------------------+-----------------+--------+ | Flarum Extensions | | | +----------------------+-----------------+--------+ | ID | Version | Commit | +----------------------+-----------------+--------+ | flarum-approval | v0.1.0-beta.8 | | | flarum-bbcode | v0.1.0-beta.8 | | | flarum-emoji | v0.1.0-beta.8 | | | flarum-flags | v0.1.0-beta.8.1 | | | flarum-likes | v0.1.0-beta.8.1 | | | flarum-lock | v0.1.0-beta.8 | | | flarum-markdown | v0.1.0-beta.8 | | | flarum-mentions | v0.1.0-beta.8.1 | | | flarum-sticky | v0.1.0-beta.8 | | | flarum-subscriptions | v0.1.0-beta.8 | | | flarum-suspend | v0.1.0-beta.8 | | | flarum-tags | v0.1.0-beta.8.2 | | +----------------------+-----------------+--------+ Base URL: https://darktable.club Installation path: /home/rubensol/darktable.club Debug mode: off

luceos

The issue here is the database prefix and most likely the database version;

flarum/core1730

If you want a dirty fix for now, install Flarum without the table prefix, that should help. Please let us know how that works out.

rsolva

luceos Thanks, I will try this!