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

Patch 2.0.3 is messing with everything

Wait for a newer version of CP

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

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

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

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 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

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

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.

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

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?

Read this:
http://www.wowroster.net/Forums/viewtop ... art=0.html

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.

Running those queries worked for me also. Thanks =)

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