Upgrading from 3.0.8 to 3.1 fails , "Foreign key constraint is incorrectly formed

To be completed by the original poster:

CMS Version


Installation Method

WAMP installation, PHP 8.0

Operating System

Windows Server 2012 R2


I’m trying to upgrade my Xibo installation from 3.0.8 to 3.1, but during database migration process, I get the following error:

SQLSTATE[HY000]: General error: 1005 Can’t create table xibo.oauth_lentuser (errno: 150 “Foreign key constraint is incorrectly formed”)

Screenshot 2022-03-22 123324

Screenshot provided.

Do you know what could be the problem?

You can look at : 3.1.0-beta - Phinx Error Migration

i got a similar error (linux) with the phinx migration script. I use the solution in this post, but i got another problem. Hope this will work fine for you.

That worked!

Thank you very much for your help.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.