Duplicate key with 2.0.1

CharacterProfiler.lua file uploading issues

Duplicate key with 2.0.1

Postby Slipfoot » Wed Nov 26, 2008 1:30 pm

Hello y'all,

even with 2.0.1 I received a duplicate key error while trying to upload via the web interface.

1062: Duplicate entry '494-Blitzschnell' for key 1
SQL:
INSERT INTO `roster_20buffs` SET `member_id` = '494', `name` = 'Blitzschnell', `icon` = 'spell_nature_unrelentingstorm', `tooltip` = 'Blitzschnell\nBeweglichkeit um 120 und Angriffstempo geringfügig erhöht.\nNoch 2 Sekunden'
File: lib/dbal/mysql.php
Line: 234

I checked and identified as reason for this failing insert mongoose buffs being active on both onehand weapons which for the second one caused this error. Editing 'characterprofiler.lua' and deleting the second block makes no problems when uploading.

Now I'm not sure if this should be handled by CharacterProfiler while generating the upload file or has this to be fixed in WoWRoster's import routine?

thx for reading
Slipfoot
Slipfoot
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sun Mar 09, 2008 8:53 pm

Duplicate key with 2.0.1

Postby zanix » Wed Nov 26, 2008 1:48 pm

Never expected 2 buffs with the same name

Thanks
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Duplicate key with 2.0.1

Postby Derif » Fri Dec 05, 2008 10:41 am

If your looking for other examples (I imagine not, but I'll share), Boomkin and Tree's have the same issue.

{
["Name"] = "Tree of Life",
["Tooltip"] = "Tree of Life<br>Increases healing received by 6%.",
["Icon"] = "Ability_Druid_TreeofLife",
["Rank"] = "Passive",
}, -- [4]
{
["Name"] = "Tree of Life",
["Tooltip"] = "Tree of Life<br>Immune to Polymorph effects.",
["Icon"] = "Ability_Druid_TreeofLife",
["Rank"] = "Shapeshift",
}, -- [5]
Derif
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Nov 01, 2008 10:32 am


Return to Uploading

Who is online

Users browsing this forum: No registered users and 0 guests

cron