Relational Features Are Disabled

eliteel5

Member
Messages
36
Reaction score
1
Points
8
Good evening all

Hope all are in good health and moving forward

I have a problem which I'm hoping someone can assist me with
Im busy designing a database using phpMyAdmin as back-end for website
All going well save that of on creating referential links using the designer within phpMyAdmin where on attempting to create link I'm getting this error

"Relational Features are disabled "

Code this far for creating tables using mysql is as follows

Code:
CREATE TABLE IF NOT EXISTS clients
(
    Client_ID VARCHAR(50) NOT NULL PRIMARY KEY,
    Title VARCHAR(4),
    Name VARCHAR(25) ,
    Surname VARCHAR(25),
    Mobile VARCHAR(12),
    Email VARCHAR(40),
    PostCode VARCHAR(8),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);


CREATE TABLE IF NOT EXISTS ClientsWareHouse
(  Client_ID VARCHAR(50),
  WareHouse_ID VARCHAR(50) NOT NULL PRIMARY KEY,
  WareHouse_Name VARCHAR(50) ,
  ImageFolder VARCHAR(255),
  Description VARCHAR(100),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT fk_Clients
  FOREIGN KEY (Client_ID)
  REFERENCES clients(Client_ID)
  ON UPDATE CASCADE
  ON DELETE CASCADE

);

I'm sure I have all foreign keys enabled correctly for parent table being clients and child table being ClientsWareHouse

What could I be doing wrong

Thanking you all kindly for any light some could provide on this


Please see image clip below

Screenshot_20210427_222725.png


On my own personal server my code seems fine and relationship , a ok and as I would expect the relation to be created


https://drive.google.com/file/d/1vX2aSNWygHlm-0cNqZQJEhe9-6exrms7/view?usp=sharing

view
 
Last edited:

spacresx

Community Advocate
Community Support
Messages
2,182
Reaction score
195
Points
63
Im not certain,But its possible that some features are disabled by default
on free accounts and only enabled for premium accounts.
as your message "Relational Features are disabled " may suggest.
this is just a guess, but staff should be able to give you an answer.
 

eliteel5

Member
Messages
36
Reaction score
1
Points
8
Im not certain,But its possible that some features are disabled by default
on free accounts and only enabled for premium accounts.
as your message "Relational Features are disabled " may suggest.
this is just a guess, but staff should be able to give you an answer.

Thanking you for your reply

Question 2 :
Would this imply that if you were for example using relational links even though not displayed on the designer as suggested , although I could test this , but without testing that cascade delete and update wont be effective even if stipulated in MYSQL code when designing

Would I be correct in making that assumption

Thanking you

Mark
 

eliteel5

Member
Messages
36
Reaction score
1
Points
8
Im not certain,But its possible that some features are disabled by default
on free accounts and only enabled for premium accounts.
as your message "Relational Features are disabled " may suggest.
this is just a guess, but staff should be able to give you an answer.


Thanking you spacresx

They are disabled by the appearancef of this having just tested with data

Looks like upgrade account in order
 

spacresx

Community Advocate
Community Support
Messages
2,182
Reaction score
195
Points
63
just a thought,
you might want to check your code and make sure it is compatible with
your current mysql version that is on your account.
in case your code is different in any way.
 

eliteel5

Member
Messages
36
Reaction score
1
Points
8
Cheers for the info spacerex

I 'll go back and double check this

Not this is an issue I could always code this in and probably good practice for someone like myself at any rate to get me back into the swing of coding

My apologies for having to ask all these questions realising you have a lot on your hands and am appreciative of that fact knowing just how demanding this can be in your position

I'm just going through .htaccess which from the control panel appears to be set via the menu , " password protect directories "

On clicking, this then returns no directories listed and with a prompt at top of page , "find a directory to password protect "

From here I am lost

Could you advise or are there any instructions on how to do this anywhere on your site via cpanel or even manually

Thanking you for all your time and patience to date

I really appreciate your help and advice

Have a good day

Mark
 

eliteel5

Member
Messages
36
Reaction score
1
Points
8
Good news I have this working with relational links

Its the coding that was incorrect So you can do this from to create a design view and this will automatically put links in for you

Took me a while to figure out and yes 100% correct coding was incorrect I now have this working

Correct code as follows for others to reference to

Thanking you very much for you instructions to date

Very helpful :):):)

I'm leaving also a link for others to refer to in-case they experience same issues

This is as follows Screenshot_20210427_222725.png

mysql tutorial

Code:
CREATE TABLE eliteel5_business.Consumers (
    Client_ID varchar(100) NOT NULL,
    Title varchar(4) NULL,
    Name varchar(40) NULL,
    Surname varchar(40) NULL,
    Postcode varchar(12) NULL,
    IP varchar(15) NULL,
    PRIMARY KEY (`Client_ID`)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;

CREATE TABLE eliteel5_business.WhareHouse (
    Client_ID varchar(100) NOT NULL,
    WhareHouse_ID varchar(5) NOT NULL,
    WhareHouse_Name varchar(40) NULL,
    Description varchar(40) NULL,
    PRIMARY KEY (`WhareHouse_ID`),
    CONSTRAINT fk_clients
    FOREIGN KEY (`Client_ID`)
        REFERENCES Consumers(`Client_ID`)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;


Thanking you once again

Image attached for others to view

Have a brilliant day

Mark
 
Last edited:
Top