SQL Errors on Upload Since WOW 2.03 Patch

Requests, feedback, and general discussion about WoWRoster
DO NOT post topics about WoWRoster AddOns here!

SQL Errors on Upload Since WOW 2.03 Patch

Postby rkinley » Wed Jan 10, 2007 2:05 am

I am getting this error message now :

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

I am using Profiler's 2.04.

I have dropped the databases, deleted lua files and reinstalled, still getting error.

Any suggestions would be appreciated.
Last edited by rkinley on Wed Jan 10, 2007 2:07 am, edited 1 time in total.
rkinley
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Dec 09, 2006 5:08 am

Re: SQL Errors on Upload Since WOW 2.03 Patch

Postby baroern » Wed Jan 10, 2007 2:40 am

I am getting the same here.

Mail [A] could not be inserted
1062: Duplicate entry '47-0' for key 1
Mail [] could not be inserted
1062: Duplicate entry '47-0' for key 1
Mail [I] could not be inserted
1062: Duplicate entry '47-0' for key 1
Mail [2] could not be inserted
1062: Duplicate entry '47-0' for key 1
Mail [0] could not be inserted
1062: Duplicate entry '47-0' for key 1
Quest [] could not be inserted
1062: Duplicate entry '47-' for key 1

I am using both Profilers version 2.0.3

Also roster version 1.7.2
Last edited by baroern on Wed Jan 10, 2007 2:43 am, edited 2 times in total.
baroern
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Sun Dec 17, 2006 9:45 pm

Re: SQL Errors on Upload Since WOW 2.03 Patch

Postby Corbism » Wed Jan 10, 2007 2:44 am

Same (CP and GP 2.0.4 and Roster 1.7.2:

Quest [] could not be inserted
1062: Duplicate entry '223-' for key 1
Quest [] could not be inserted
1062: Duplicate entry '223-' for key 1
Quest [6] could not be inserted
1062: Duplicate entry '223-6' for key 1
Quest [] could not be inserted
1062: Duplicate entry '223-' for key 1
Quest [[] could not be inserted
1062: Duplicate entry '223-[' for key 1
Quest [] could not be inserted
1062: Duplicate entry '223-' for key 1
Quest [5] could not be inserted
1062: Duplicate entry '223-5' for key 1
Quest [D] could not be inserted
1062: Duplicate entry '223-D' for key 1
Last edited by Corbism on Wed Jan 10, 2007 2:45 am, edited 2 times in total.
User avatar
Corbism
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Fri Sep 29, 2006 10:48 pm
Location: Seattle, WA

SQL Errors on Upload Since WOW 2.03 Patch

Postby zanix » Wed Jan 10, 2007 3:11 am

Yeah, CP and GP are really messed up right now
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: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

SQL Errors on Upload Since WOW 2.03 Patch

Postby giselda » Wed Jan 10, 2007 4:55 am

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



Same problem here, when will be released an update for it?
Last edited by giselda on Wed Jan 10, 2007 5:03 am, edited 2 times in total.
giselda
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Dec 27, 2006 12:26 pm

SQL Errors on Upload Since WOW 2.03 Patch

Postby quarum » Wed Jan 10, 2007 6:25 am

I just downloaded the new CP and GP 2.0.4 and still get the error below - plus guild ranks are still not being shown

Quest [] could not be inserted
1062: Duplicate entry '366-' for key 1
User avatar
quarum
WR.net Apprentice
WR.net Apprentice
 
Posts: 42
Joined: Tue Dec 19, 2006 5:36 am
Location: Midwest

SQL Errors on Upload Since WOW 2.03 Patch

Postby Elethil » Wed Jan 10, 2007 10:03 am

I think the ranks in 1.7.2 are just turned off in the config.
User avatar
Elethil
WR.net Journeyman
WR.net Journeyman
 
Posts: 147
Joined: Wed Jul 05, 2006 10:28 pm

SQL Errors on Upload Since WOW 2.03 Patch

Postby Bondo » Wed Jan 10, 2007 10:29 am

i got the same problem CP and GP is not working from today :/
User avatar
Bondo
WR.net Apprentice
WR.net Apprentice
 
Posts: 17
Joined: Mon Jul 10, 2006 10:47 pm

Re: SQL Errors on Upload Since WOW 2.03 Patch

Postby hanna » Wed Jan 10, 2007 1:39 pm

Same Problem here
i use Roster v1.7.2
CharacterProfiler v2.0.4
GuildProfiler v2.0.4

Quest [] could not be inserted
1062: Duplicate entry '13-' for key 1
Mail [G] could not be inserted
1062: Duplicate entry '14-0' for key 1
Mail [] could not be inserted
1062: Duplicate entry '14-0' for key 1
Mail [I] could not be inserted
1062: Duplicate entry '14-0' for key 1
Mail [2] could not be inserted
1062: Duplicate entry '14-0' for key 1
hanna
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Mon Aug 21, 2006 9:33 am

SQL Errors on Upload Since WOW 2.03 Patch

Postby zanthorx » Wed Jan 10, 2007 1:48 pm

The problem is that Blizzard changed the format of saved variables files...
zanthorx
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Aug 03, 2006 10:04 pm

SQL Errors on Upload Since WOW 2.03 Patch

Postby hanna » Wed Jan 10, 2007 1:59 pm

i haved changed the luaparser.php like here http://www.wowroster.net/Forums/viewtopic/t=2289.html
but have still the same problem

an my next problem is
i have two accounts on one computer
and the chars on the second account can not invite
here came the following error message

Blafasel is not in the list of guild members so their data will not be inserted
hanna
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Mon Aug 21, 2006 9:33 am

Re: SQL Errors on Upload Since WOW 2.03 Patch

Postby Corbism » Wed Jan 10, 2007 11:02 pm

Any word on when they are might be able to fix CP so it uploads without these errors? Not many people seem to be complaining about it, so just unsure if it's a wide-scale problem.
Last edited by Corbism on Thu Jan 11, 2007 2:58 am, edited 1 time in total.
User avatar
Corbism
WR.net Apprentice
WR.net Apprentice
 
Posts: 51
Joined: Fri Sep 29, 2006 10:48 pm
Location: Seattle, WA

SQL Errors on Upload Since WOW 2.03 Patch

Postby Mathos » Thu Jan 11, 2007 2:52 am

Offcourse this will be fixed. But developement is not something to take lightly, especially since we all have jobs and a RL too....
User avatar
Mathos
Gimpy Developer
Gimpy Developer
 
Posts: 117
Joined: Wed Jul 05, 2006 11:00 am

SQL Errors on Upload Since WOW 2.03 Patch

Postby PleegWat » Thu Jan 11, 2007 5:07 am

The problem does not originate in CP. It is caused by blizzard's change of the way savedvariables are stored. An updated parser is available at http://www.wowroster.net/Forums/viewtopic/t=2289.html which should fix most errors.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

SQL Errors on Upload Since WOW 2.03 Patch

Postby panteradk » Thu Jan 11, 2007 9:56 am

Get the same as the others

And guildbank is not showing items probaly and not all items are uploadet to the guildbank.
panteradk
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Wed Dec 20, 2006 3:57 am

Next

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 1 guest

cron