MariaDB / MySQL; Foreign key checks error

[Joshhh]

Currently got an issue importing an SQL however I'm currently getting an issue that I've not really come up against before;

You must be registered for see images attach

I have googled this a few times and I've seen things being posted for running a query like this;

SET GLOBAL foreign_key_checks=ON;

OR

SET SESSION foreign_key_checks=ON;

(Depending on Session or Globally)

But I have no idea what I'm doing at this stage as it's the same error over and over again..

Any help?

I'd appreciate it, thanks if so.

 

[Adil]

have you tried using OFF?

When it's set to 1 it re-validates all FK constraints, you may have an issue in your data which is causing the problem. Try and set it to OFF.

 

[Joshhh]

have you tried using OFF?

When it's set to 1 it re-validates all FK constraints, you may have an issue in your data which is causing the issue. Try and set it to OFF.

That seemed to work, thanks!

It was just a simple solution of just changing it from ON to OFF.