Help with mysql error...

[modern-day-pirate]

okay, so ive been working on this PHP MMO for a while now, but whenever i try to register a new player, or add a news post, or post in the forum i get this message:

Incorrect integer value: '' for column 'id' at row 1

 

any ideas?

[Psycho]

Um, use a correct integer value?

 

Seriously though, you will need to post some code for us to be of any help. Most likely your query is screwed up. You should create your query as a variable so you can echo it to the page for debugging purposes.

[peranha]

I believe it is saying that you are not inserting an integer into an integer field in the database

[modern-day-pirate]

ok here's the bit of code for adding a new news post:

 

function addnews() {

   

    if (isset($_POST["submit"])) {

       

        extract($_POST);

        $errors = 0;

        $errorlist = "";

        if ($content == "") { $errors++; $errorlist .= "Content is required.<br />"; }

       

        if ($errors == 0) {

            $query = doquery("INSERT INTO {{table}} SET id='',postdate=NOW(),content='$content'", "news");

            admindisplay("News post added.","Add News");

        } else {

            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add News");

        }       

       

    }

[peranha]

you are setting id to nothing, it needs to have an integer in it.

[modern-day-pirate]

right....lol

 

but how can i set it to a value of one highr than the highest value in the table?

[peranha]

in your table, set the autoincrement for column id

[modern-day-pirate]

it's already set to auto_increment. thats why i dont understand

[peranha]

$query = doquery("INSERT INTO {{table}} postdate=NOW(),content='$content'", "news");

 

Than that will work, just dont mention it in the query.

[modern-day-pirate]

IT WORKED! thank you.