search

Spuds / SMF-Member-Awards

Member Awards for SMF 2.0
Other
8 stars 8 forks source link

Database Issue. #43

Closed SychO9 closed 6 years ago

SychO9 commented 8 years ago

Greetings, For some reason whenever I delete an Award this appears when viewing topics :/ How can I fix this knowing that I made no changes to the mod.

Thanks in Advance.

Duplicate entry '1-3' for key 'id_member_id_award'
File: /home/****/****/****/***.**.**/htdocs/forum/Sources/AwardsManage.php
Line: 350
Spuds commented 8 years ago

Do you have access to phpmyadmin on your install ?

The message indicates that the member id 1, which is probably the admin? has an award 3 already auto assigned and its trying to add it again ... The auto assign code should prevent that so I don't really know why its doing it, certainly a bug.

If you have access to phpmyadmin, open the table awards_members and sort on member_id col ... see if user '1' has any award_id 3 row, and if so delete those rows.

SychO9 commented 8 years ago

i keep deleting that row and every time i refresh my awards page in my profile it fills back o.O

SychO9 commented 8 years ago

same issue appears every time adding an auto assign award and then removing it, it just stays in the database cause the error to show.

Spuds commented 8 years ago

Just for user with an id of 1 ?

SychO9 commented 8 years ago

well since i am testing the mod in a separate forum which has one member only which is me, then yes