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):
Assuming the fact that the first "INSERT" is missing an "I" is a copy/paste error, what exactly is the error message?
Also, if your database is already popluated, export some rows and copy their form, changing the values as needed.
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):
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