Hi fellow DP, I've got an error during installation x10mp3 script : the browser says: and i've choose a hosting my database in other place from my regular host. Can Anyone here give me a clue? Thanks.
It could be a number of things. What database vendor are you using? Postgres, MySql, Oracle, MS SQL? In general SQL it could be any of the following: Is the first value(I see it's blank) required? Is it a private key? Is it set as a NOT NULL constraint? Try adding a ; at the end of the query, might be a syntax error. Make sure that the table(in this case, suggest) that you are trying to INSERT INTO, exists in the database. The most obvious part that struck me was this part(highlighted): INSERT INTO suggest VALUES('','1 Giant Leap') I'm thinking that the '' shouldn't be blank, maybe there's a NOT NULL constraint on that column, meaning it's required to filled out before it INSERTs into the database. I don't really understand the error message it brings up so I can't really tell you, I can just bring up the possibilities of what caused the error. Could you tell us more about what type of database your using, or type of lanuage goes with it e.g. PHP, ASP, Java etc. Hope this helps