The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Can't use ALTER TABLE in SQL Tab (phpmyAdmin)

Discussion in 'Database Discussions' started by Silent Storm, Mar 4, 2013.

  1. Silent Storm

    Silent Storm Registered

    Joined:
    Mar 4, 2013
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello.

    This is pretty urgent, but I have created my tables in phpmyadmin, and when I go to edit them using this in the SQL tab:

    "ALTER TABLE topics ADD FOREIGN KEY(topic_cat) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE;"

    This error comes up:

    "#1005 - Can't create table (errno: 150)"

    Clicking on details takes me to a page about InnoDB, but my tables have been set up to use that...

    I have been stuck on this for a while and I don't know how to fix this.

    Here is a picture of my tables.

    http://i756.photobucket.com/albums/xx202/CrimsonEchoes/123_zps12e27cc8.png

    Can someone please help me?
     
    #1 Silent Storm, Mar 4, 2013
    Last edited: Mar 4, 2013
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    This isn't actually an issue with your cPanel.



    Interestingly enough, if you google the command just as you've posted it, you get lots of results with google.
     
Loading...

Share This Page