I just tried to upload my charcterprofiler.lua, and got the following error (had to cut it abit, as the forum wouldn't allow me to past the entire message):

Code: Select all

1062: Duplicate entry '89-Beached Sea Turtle' for key 1
SQL:
INSERT INTO `roster_quests` SET `member_id` = '89', `quest_name` = 'Beached Sea Turtle', `quest_index` = '15', `quest_level` = '19', `zone` = 'Darkshore', `quest_tag` = '', `is_complete` = '1'
File: lib/dbal/mysql.php
Line: 202
Backtrace (most recent call last):

    * lib/functions.lib.php
          o Line: 240
          o Function Called: backtrace
    * lib/dbal/mysql.php
          o Line: 202
          o Function Called: die_quietly
          o Arguments:
                + 1062: Duplicate entry '89-Beached Sea Turtle' for key 1
                + Database Error
                + /usr/share/www-data/roster/lib/dbal/mysql.php
                + 202
                + INSERT INTO `roster_quests` SET `member_id` = '89', `quest_name` = 'Beached Sea Turtle', `quest_index` = '15', `quest_level` = '19', `zone` = 'Darkshore', `quest_tag` = '', `is_complete` = '1'
    * lib/update.lib.php
          o Line: 977
          o Function Called: query
          o Arguments:
                + INSERT INTO `roster_quests` SET `member_id` = '89', `quest_name` = 'Beached Sea Turtle', `quest_index` = '15', `quest_level` = '19', `zone` = 'Darkshore', `quest_tag` = '', `is_complete` = '1'
    * lib/update.lib.php
          o Line: 1411
          o Function Called: insert_quest
          o Arguments:
                + Array ( [member_id] => 89 [quest_name] => Beached Sea Turtle [quest_tag] => [quest_index] => 15 [quest_level] => 19 [zone] => Darkshore [is_complete] => 1 )

I'm guessing it is because my lvl 24 Shaman has 2-3 of the "Beached Sea Turtle" quests from Darkshore...

Yep, the table is key'ed on member_id, quest_name
I didn't know that you could have the same two or more quests with the same name

The "Beached Sea Turtle" quests are a bit special in that regard, as you can basically pick up 4-5 (perhaps even more) along the shores of Darkshore. There's also a few "Beached Sea Creature" I think.