1.7.3: quests do not update, everything else works fine

Data Accuracy issues

1.7.3: quests do not update, everything else works fine

Postby Fangorn » Sun Feb 25, 2007 7:41 pm

Hi all,

My roster works great except for one little things: the quests do not seem to update. See my character's quest page:
http://wow.clan-blackstar.org/Content/w ... ion=quests

It lists only one quest here (without a name). The update log is as follows:

Code: Select all
---
Updating Character [Larissia]
About to update player
Updating Equipment . . . . . . . . . . . . . . . . .
Updating Inventory : Bag5 : Bag4 : Bag0 : Bag1 : Bag2 : Bag3
Updating Bank : Bag5 : Bag4 : Bag0 : Bag1 : Bag2 : Bag3
Updating Mailbox: 11 Messages
Updating Skills . . . . . . . . . . . . . . . . . . .
Updating Professions : Cooking : First Aid : Alchemy
Updating Spellbook : Restoration : Balance : General : Feral Combat
Updating Talents : Balance : Restoration : Feral Combat
Updating Reputation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
---> Updating Quests: 22 <--- this is correct
Updating Buffs: 1



But... No quests in the roster.

I deleted my lua file and tried again with a fresh one, same result. When I try to update my profile manually I get the following error:

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


This error is repeated 21 times.


Next thing I tried was to empty my roster_quests table and see if it worked better... It didn't: I get the same errors and I have one line inserted in the table that reads as follows:

Code: Select all
---
member_id: 52
quest_name:
quest_index: 6
quest_level: 60
quest_tag: Group
is_complete: 0
zone: Blasted Lands


Note the NULL quest_name field. This quest entry corresponds to quest "You Are Rakh'likh, Demon" from the LUA file...

This is the first quest listed in the file, and the update error message is repeated 21 times so it looks like:
1/ The quest isn't inserted properly (missing quest name)
2/ Each subsequent quest insert attempt fails because the primary index is based on member_id, quest_name


I'm not sure what to try next :/ Do others have the same issue?

I am attaching my LUA file.

Thanks,


- Jeff
Attachments
characterprofiler.lua
(301.76 KiB) Downloaded 157 times
Last edited by Fangorn on Sun Feb 25, 2007 7:51 pm, edited 6 times in total.
ImageImageImage
User avatar
Fangorn
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Mon Jul 24, 2006 4:26 am
Location: Ashburn, Virginia, USA

1.7.3: quests do not update, everything else works fine

Postby Fangorn » Sun Feb 25, 2007 7:55 pm

Note for self: read forums before posting :p

http://www.wowroster.net/Forums/viewtopic/t=2699.html
ImageImageImage
User avatar
Fangorn
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Mon Jul 24, 2006 4:26 am
Location: Ashburn, Virginia, USA


Return to Data Accuracy

Who is online

Users browsing this forum: No registered users and 0 guests

cron