Whats wrong with this query?

Discussion in 'Databases' started by maney, Nov 18, 2006.

  1. #1
    I'm installing a phpld mod and it gave me this query to put in phpmyadmin isn't having any of it. I'm using sql5, any ideas what the problem is?

    NSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_THREE_WAY', '0');
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('THREE_WAY_LINK_URL', 'http://www.third-site.com/');
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('THREE_WAY_LINK_TITLE', 'Third-Site');
    Code (markup):

     
    maney, Nov 18, 2006 IP
  2. fatmagoo

    fatmagoo Peon

    Messages:
    62
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Assuming the fact that the first "INSERT" is missing an "I" is a copy/paste error, what exactly is the error message?
     
    fatmagoo, Nov 18, 2006 IP
  3. Wyla

    Wyla Well-Known Member

    Messages:
    924
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #3
    Also, if your database is already popluated, export some rows and copy their form, changing the values as needed.
     
    Wyla, Nov 18, 2006 IP
  4. daboss

    daboss Guest

    Messages:
    2,249
    Likes Received:
    151
    Best Answers:
    0
    Trophy Points:
    0
    #4
    try this - remove the ` characters.

    i.e. change this
    INSERT INTO `PLD_CONFIG` (`ID`, `VALUE`) VALUES ('ENABLE_THREE_WAY', '0');
    Code (markup):
    to this

    INSERT INTO PLD_CONFIG (ID, VALUE) VALUES ('ENABLE_THREE_WAY', '0');
    Code (markup):
     
    daboss, Nov 18, 2006 IP
  5. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #5
    PLD_CONFIG is the default configuration table, if you are using other prefix than "PLD_" you should change it in your query to adjust it accordingly.

    Also I hope you are not missing the "i" as fatmagoo has mentioned ;)
     
    max pain, Nov 19, 2006 IP
    jaree likes this.
  6. maney

    maney Active Member

    Messages:
    1,130
    Likes Received:
    36
    Best Answers:
    0
    Trophy Points:
    90
    #6
    Managed to get it working by doing each query line seperatly :)
     
    maney, Nov 19, 2006 IP