Duplicate quest header

by **drianna** » Thu Apr 26, 2007 2:11 am

Hi
I have been using WowRoster without too many problems for the last few months when low and behold I notice an upload error on my last update:

Quest [] could not be inserted
1062: Duplicate entry '170-' for key 1

of which there must be approx 50 lines of the above with varying numbers.

I am using CP 2.06 and i have checked the sql table and I can see the quests there.

However when I go to the roster > character > quest - I only see 1 quest for any character.

Any ideas why this is happeneing

Thank You

by ds » Thu Apr 26, 2007 2:46 am

Look at this posted in the Official Bugs & Updates forum:
http://www.wowroster.net/Forums/viewtopic/t=2699.html

by **drianna** » Thu Apr 26, 2007 3:55 am

Worked a treat - thanks

by **zanix** » Thu Apr 26, 2007 7:56 am

Please remember to search before making a post

by **IsaacQuotien** » Thu May 17, 2007 4:29 am

would it be possible to add a .txt file to the .zip fix that says where to unzip that file.

I got the file through downloads with out looking in the forums....and simply put it in the base roster directory...which didnt help anything. there is a wowdb.php file in that directory too.

It wasnt until i stumbled upon it in the forums that i learned i was supposed to put it in the /lib directory.

thanks....and great job on this program btw.

cheers

by **Ohlo** » Mon Jun 11, 2007 9:51 pm

I did this and I'm still getting:

Quest [] could not be inserted
1062: Duplicate entry '36-' for key 1
Quest [] could not be inserted
1062: Duplicate entry '52-' for key 1

Error Log attached below

by **zanix** » Mon Jun 11, 2007 10:40 pm

Then you did overwrite lib/wowdb.php with the new file