WEB keep getting an mysql syntax error

Discussion in 'OT Technology' started by blinger, Apr 22, 2009.

  1. blinger

    blinger Guest

    but I can't find it :o

    db file...

     
    Last edited by a moderator: Apr 22, 2009
  2. biawokauns

    biawokauns New Member

    Joined:
    Sep 18, 2001
    Messages:
    19,893
    Likes Received:
    0
    Location:
    Republic of Kalifornia
    Code:
    CREATE TABLE `count_updates` ( `day` tinyint( 3 ) NOT NULL default '0',
    `week` tinyint( 3 ) NOT NULL default '0',
    `month` tinyint( 3 ) NOT NULL default '0'[b][SIZE="6"],[/SIZE][/b])
    
    extra ,
     
  3. Krakerjak

    Krakerjak Active Member

    Joined:
    Jul 7, 2003
    Messages:
    8,288
    Likes Received:
    0
    Location:
    Edmonton eh
    why is this thread asking me to log into wamuew.com cpanel?
     
  4. tryfuhl

    tryfuhl New Member

    Joined:
    Oct 4, 2003
    Messages:
    75,450
    Likes Received:
    0
    Location:
    MD/DC Metro
  5. brds

    brds OT Supporter

    Joined:
    Jun 26, 2006
    Messages:
    17,650
    Likes Received:
    15
    Location:
    Atlanta
    this
     
  6. retorq

    retorq What up bitch??

    Joined:
    Dec 14, 2006
    Messages:
    6,061
    Likes Received:
    0
    Location:
    Mohave Desert
    Can I get the username and password to view this thread properly?? :big grin:
     
  7. SLED

    SLED build an idiot proof device and someone else will

    Joined:
    Sep 20, 2001
    Messages:
    28,118
    Likes Received:
    0
    Location:
    AZ, like a bauce!
    lol @ phantom login
     
  8. blinger

    blinger Guest

    fixed this still getting an error tho..


    CREATE TABLE `count_updates` ( `day` tinyint( 3 ) NOT NULL default '0',
    `week` tinyint( 3 ) NOT NULL default '0',
    `month` tinyint( 3 ) NOT NULL default '0'
    )--
    -- Dumping data for table `count_updates`
    --
    LOCK TABLES `count_updates` WRITE ;

    MySQL said:
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCK TABLES `count_updates` WRITE' at line 8
     
  9. CrazyInteg

    CrazyInteg Honda-Acura.net OG

    Joined:
    Dec 30, 2000
    Messages:
    12,206
    Likes Received:
    3
    Location:
    Omaha
    missing semi colon?

    create table ( );
     
  10. brds

    brds OT Supporter

    Joined:
    Jun 26, 2006
    Messages:
    17,650
    Likes Received:
    15
    Location:
    Atlanta
    Try replacing the ` marks with a '
     

Share This Page