Relational Features Are Disabled

Discussion in 'Free Hosting' started by eliteel5, Apr 27, 2021.

  1. eliteel5

    eliteel5 New Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    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

    [​IMG]
     
    Last edited: Apr 27, 2021
  2. spacresx

    spacresx Active Member

    Messages:
    969
    Likes Received:
    70
    Trophy Points:
    28
    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.
     
  3. eliteel5

    eliteel5 New Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    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
     
  4. eliteel5

    eliteel5 New Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3

    Thanking you spacresx

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

    Looks like upgrade account in order
     
  5. spacresx

    spacresx Active Member

    Messages:
    969
    Likes Received:
    70
    Trophy Points:
    28
    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.
     
    • Like Like x 1
  6. eliteel5

    eliteel5 New Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    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
     
  7. eliteel5

    eliteel5 New Member

    Messages:
    27
    Likes Received:
    1
    Trophy Points:
    3
    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: Apr 29, 2021

Share This Page