Bugs with patch 2.0.3

Categorizes items in your guildbank(s)

Moderator: Mathos

Bugs with patch 2.0.3

Postby Mithan » Wed Jan 10, 2007 7:06 am

I am getting all sorts of bugs with the new patch and yes, I updated to CP 2.0.4

Might be faster to just look at this link for what I am getting:
http://www.wowhq.com/roster/addon.php?r ... =guildbank

but the error code is:

Notice: Undefined offset: 1 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 2 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 1 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 2 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 1 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 2 in /hsphere/local/home/mithan/wowhq.com/roster/addons/guildbank/gbank.php on line 247 Notice: Undefined offset: 1 in
Mithan
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Wed Jul 05, 2006 7:58 am

Bugs with patch 2.0.3

Postby zanix » Wed Jan 10, 2007 7:21 am

Patch 2.0.3 is messing with everything

Wait for a newer version of CP
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

Re: Bugs with patch 2.0.3

Postby Fistula » Wed Jan 10, 2007 1:09 pm

zanix wrote:Patch 2.0.3 is messing with everything

Wait for a newer version of CP


I hope CP doesn't stand for Character Profiler, cause an update is already out and I still get an error with the Categorized GB.

Fistula
Fistula
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Wed Jan 03, 2007 9:40 am

Bugs with patch 2.0.3

Postby Gholbine » Wed Jan 10, 2007 7:20 pm

I have upload 2.0.4 and after that i got alot of arrow

1. can add some quest

2. mess up the Guild bank
User avatar
Gholbine
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Sun Aug 27, 2006 8:12 am

Bugs with patch 2.0.3

Postby Dernes » Wed Jan 10, 2007 7:44 pm

http://www.wowroster.net/Forums/viewtopic/t=2289.html

That solved the problem for me. Just installed it, reuploaded all the data gathered with the latest CP and GP
User avatar
Dernes
WR.net Apprentice
WR.net Apprentice
 
Posts: 7
Joined: Mon Jul 10, 2006 10:20 pm
Location: Thunder Bluff

Re: Bugs with patch 2.0.3

Postby Fistula » Wed Jan 10, 2007 7:50 pm

Dernes wrote:http://www.wowroster.net/Forums/viewtopic/t=2289.html

That solved the problem for me. Just installed it, reuploaded all the data gathered with the latest CP and GP


Didn't do anything for me.. still got the same problem.
Fistula
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Wed Jan 03, 2007 9:40 am

Re: Bugs with patch 2.0.3

Postby Fistula » Thu Jan 11, 2007 12:07 am

Fistula wrote:
Dernes wrote:http://www.wowroster.net/Forums/viewtopic/t=2289.html

That solved the problem for me. Just installed it, reuploaded all the data gathered with the latest CP and GP


Didn't do anything for me.. still got the same problem.



So any ideas why I am still getting the error? I have the latest updates and loaded the adapted luaparsers page.. but still having problems.

Fist
Fistula
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Wed Jan 03, 2007 9:40 am

Re: Bugs with patch 2.0.3

Postby Azrashan » Thu Jan 11, 2007 2:04 am

Im having the same problems and cant seem to get it fixed.

http://www.thefortythieves.net/roster/addon.php?roster_addon_name=guildbank

Suggestions?

Az
Azrashan
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Sep 26, 2006 5:34 am

Bugs with patch 2.0.3

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

Yes, please wait for a roster update, since Blizzard has decided to change their output format.

Be patient is my suggestion :) Peeps are working on it.
User avatar
Mathos
Gimpy Developer
Gimpy Developer
 
Posts: 117
Joined: Wed Jul 05, 2006 11:00 am

Bugs with patch 2.0.3

Postby trell » Thu Jan 11, 2007 7:40 am

I had the same problem with our categorised guild bank. It would appear that without the fixed luaparser in place that some corrupted data was making its way into the roster database. I noticed that our eventcalendar and catguildbank were both showing data that was truncated to 1 character long.

Azrashan is suffering the same problem that we were suffering; you can see down in his Miscellaneous Items at the bottom of the page the items causing the errors. The errors are caused because the addon is splitting the itemid (a string that looks like '1047:0:0') on the ':' character.

Unfortunately there are some corrupted data that have item id's without a ':' in them. Thus the undefined offset errors. CGB should probably ignore any items that have invalid item ids, but it currently doesn't.

The way I fixed it was to remove the corruption from the database. You can see if you have corruption by running the following SQL query against your roster db (assuming roster_ for the db prefix):

Code: Select all
 select count(*) from roster_items where length(item_id) = 1;


This will return all the objects in the database which have an item_id of only one character (and thus definitely can't be valid item_ids).

If you get a result of greater than 0 for this then you have corrupted data in the database. To delete it you'll then need to run:

Code: Select all
 delete from roster_items where length(item_id) = 1;


Of course, be very very very careful if you do run this SQL query as missing out any part of it, or getting it wrong could wipe out all of your items, your entire roster, or possibly all life on this planet.

Good Luck!
:)

-trell
trell
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 19
Joined: Wed Dec 06, 2006 4:11 pm
Location: UK

Re: Bugs with patch 2.0.3

Postby Fistula » Thu Jan 11, 2007 10:00 am

Mathos wrote:Yes, please wait for a roster update, since Blizzard has decided to change their output format.

Be patient is my suggestion :) Peeps are working on it.


um... well I understand there was a roster update.. so will there be another one?
Fistula
WR.net Apprentice
WR.net Apprentice
 
Posts: 13
Joined: Wed Jan 03, 2007 9:40 am

Bugs with patch 2.0.3

Postby Mathos » Thu Jan 11, 2007 7:03 pm

User avatar
Mathos
Gimpy Developer
Gimpy Developer
 
Posts: 117
Joined: Wed Jul 05, 2006 11:00 am

Re: Bugs with patch 2.0.3

Postby Adariel » Sat Jan 13, 2007 2:06 pm

trell wrote:I had the same problem with our categorised guild bank. <snip>

The way I fixed it was to remove the corruption from the database. You can see if you have corruption by running the following SQL query against your roster db (assuming roster_ for the db prefix):

Code: Select all
 select count(*) from roster_items where length(item_id) = 1;


This will return all the objects in the database which have an item_id of only one character (and thus definitely can't be valid item_ids).

If you get a result of greater than 0 for this then you have corrupted data in the database. To delete it you'll then need to run:

Code: Select all
 delete from roster_items where length(item_id) = 1;


Of course, be very very very careful if you do run this SQL query as missing out any part of it, or getting it wrong could wipe out all of your items, your entire roster, or possibly all life on this planet.

Good Luck!
:)

-trell


That fixed the errors I was getting on my CGB page ... I backed up the DB first just in case. So now with the updated wowdb and luaparser my problems seem to be fixed.
Last edited by Adariel on Sat Jan 13, 2007 2:07 pm, edited 1 time in total.
User avatar
Adariel
WR.net Apprentice
WR.net Apprentice
 
Posts: 36
Joined: Tue Jul 25, 2006 9:14 am

Re: Bugs with patch 2.0.3

Postby xsignedx » Sat Jan 13, 2007 8:33 pm

Running those queries worked for me also. Thanks =)
xsignedx
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Jan 13, 2007 8:12 pm

Bugs with patch 2.0.3

Postby tholoc » Sat Jan 13, 2007 9:22 pm

running those queries worked for some corrupt data.

I am still getting some of those lines as i get a few items without any itemid by cp v2.04 they will produce the same issue.

But be aware you may not delete all length = 0 items since all bags have no itemid. And cp will create them again.

looking into characterprofiler.lua for those items itemid is missing.

Any idea or Help?

Thx
tholoc
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Jan 13, 2007 8:28 pm

Next

Return to Categorized Guild Bank

Who is online

Users browsing this forum: No registered users and 0 guests

cron