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.

cant create tables in phpmyadmin

Discussion in 'Database Discussions' started by eger, May 31, 2003.

  1. eger

    eger Well-Known Member

    Joined:
    Feb 28, 2003
    Messages:
    128
    Likes Received:
    0
    Trophy Points:
    16
    i'm having trouble creating and saving tables in phpmyadmin.

    PHP Version 4.3.1
    MySQL Version 4.0.12
    cPanel Version 6.4.2-EDGE
    cPanel Build 46

    when i click save the next window gives the generic IE Action Cancelled message. If i click back and try again after about 20 times it works and phpmyadmin says i have an error in my query (which i do not belive i do). Anyone else witha similar problem? i've already tried restarting the cpanel services and updated and even rebooted the server. Thanks!

    cPanel.net Support Ticket Number:
     
  2. noppid

    noppid Member

    Joined:
    May 30, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    It only take a subbtle syntax error to mess up a query. Sometimes it's hard to see a little error in our own code. Maybe if you posted the query one of us could make a suggestion.

    One other thing, did you end the query with the DB type?

    Code:
    CREATE TABLE `comp_stats` (
     `userid` int(10) unsigned NOT NULL,
      `wins` int(10) unsigned NOT NULL default '0',
     `losses` int(10) unsigned NOT NULL default '0',
      `ties` int(10) unsigned NOT NULL default '0',
       `battles` int(10) unsigned NOT NULL default '0',
     PRIMARY KEY  (`userid`)
    ) [color=red]TYPE=MyISAM[/color]  
    
    cPanel.net Support Ticket Number:

    cPanel.net Support Ticket Number:
     
  3. eger

    eger Well-Known Member

    Joined:
    Feb 28, 2003
    Messages:
    128
    Likes Received:
    0
    Trophy Points:
    16
    i was able to create it when i created the table with just 1 field, and then added fields to the table 1 by 1. the table ended up the exact same as i tried to create when i did multiple fields so i dont understand.

    cPanel.net Support Ticket Number:
     
  4. noppid

    noppid Member

    Joined:
    May 30, 2003
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Post the query you are using, someone may see what's up. Second opinions always help.

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page