NOw No Error,

MOd can close this thread.

John Adam
VIP member.

these are the two queries you have to execute

[code]
ALTER TABLE jcow_streams ADD dislikes INT NOT NULL ;
CREATE TABLE IF NOT EXISTS jcow_disliked (
id int(11) NOT NULL auto_increment,
uid int(11) NOT NULL,
stream_id int(11) NOT NULL,
PRIMARY KEY (id),
KEY uid (uid,stream_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[/code]

There was no table earlier.
I created table, with jcow_dislikes.

But than when I went to jcow_streams. the dislike id was not added.

I have added table "jcow_disliked" & "dislikes" field in jcow_streams. But Whenever some1 click "dislikes".
It gives following error :-
[cpde]
[SQL]
insert into jcow_disliked(uid,stream_id) values('48','3908')

[Error]
Duplicate entry '48' for key 'uid'
[/code]

[SQL]
insert into jcow_disliked(uid,stream_id) values('48','3908')

[Error]
Duplicate entry '48' for key 'uid'

Dislike option has been added, but i am getting above error when clicking on dislike option.

click on the sql tab in phpmyadmin and enter the code i gave you and click on the start button.

Problem Solved. Moderator can close this thread.