mysql update error

[twoodcc]

i am trying to add a new column to my database, and using php have a page that updates that new column.

basically what i have is as follows:

"update data set likes = likes+1 where id = '$id'"

and that gives me an error.

but if i run the same command, except on another column, it works. any ideas on what is going on?

 

[Cabbit]

i am trying to add a new column to my database, and using php have a page that updates that new column.

basically what i have is as follows:

"update data set likes = likes+1 where id = '$id'"

and that gives me an error.

but if i run the same command, except on another column, it works. any ideas on what is going on?

If you post the sql error it would be easier to debug.

 

[twoodcc]

If you post the sql error it would be easier to debug.

well all it says is you have an error in your mysql syntax near "likes = likes +1 where id = '12'"

but if i change likes to another field then it works. it just doesn't work with the new column that i added to the database that already has data in it. i made the column a bigint size 15.

 

[firestarter]

It's probably taken the value 'null' since it's a new column - and complaining 'cos you can't add 1 to null.

Why not update every likes value to 0 before you set out?

Any reason you chose bigint? Any reason you chose not to use 'not null'?

 

[twoodcc]

It's probably taken the value 'null' since it's a new column - and complaining 'cos you can't add 1 to null.

Why not update every likes value to 0 before you set out?

Any reason you chose bigint? Any reason you chose not to use 'not null'?

well when i first added the column, i put the default 0, and it didn't work. i then deleted it and added it again, without making the default 0, same result. i even put in a 1 for a few records, and the same thing happens.

this is really bothering me that it doesn't work

 

[firestarter]

well when i first added the column, i put the default 0, and it didn't work. i then deleted it and added it again, without making the default 0, same result. i even put in a 1 for a few records, and the same thing happens.

this is really bothering me that it doesn't work

What do you get when you select likes from your table with Id='12'?

 

[twoodcc]

What do you get when you select likes from your table with Id='12'?

i get 0. and i get 1 for the one that i inserted 1 directly into the database.

 

[firestarter]

That's strange.

How are you testing this... with code, or with an interactive tool?

Just wondering if it's really null, but your test code interprets that as 1.

I can't think of any other good reasons why the update would fail. You haven't put some sort of index on 'like' have you?

 

[twoodcc]

That's strange.

How are you testing this... with code, or with an interactive tool?

Just wondering if it's really null, but your test code interprets that as 1.

I can't think of any other good reasons why the update would fail. You haven't put some sort of index on 'like' have you?

yeah i can't figure it out either. i kept looking at my code over and over, and don't see why it's failing.

i'm using php for this. basically, i'm using GET with a link. you click the link, it pulls in the info from the database, and updates the 'like' field based on the 'id' from the link.

i do not have an index on like.

 

[designguy79]

i am trying to add a new column to my database, and using php have a page that updates that new column.

basically what i have is as follows:

"update data set likes = likes+1 where id = '$id'"

and that gives me an error.

but if i run the same command, except on another column, it works. any ideas on what is going on?

Maybe "likes" is a reserved name? Try escaping that, so something like

update data set `likes`=`likes`+1 where id = '$id'

HTH

 

[twoodcc]

Maybe "likes" is a reserved name? Try escaping that, so something like

update data set `likes`=`likes`+1 where id = '$id'

HTH

that was it! thanks! now where is that on my keyboard?