HotFix for WoWRoster 1.7.2

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

Re: WoWRoster and wow 2.0.3

Postby civette » Mon Jan 15, 2007 5:20 am

I tested this patch and it seems to work fine.

I have a small question regarding the luaparser.php

I used that as a library to parse lua of my own for various purpose. Since ages it worked fine and patch 2.0.3 put all that work on the ground for incomprehensible reasons. Why changing savedvariable output ?!?!?

My question is : On changing the luaparser.php, do we have too deeply modify the file doing the parsing itself ( wowdb.php here ) ? If no wath are the changes ?

Thanks in advance.
civette
WR.net Apprentice
WR.net Apprentice
 
Posts: 8
Joined: Tue Jul 04, 2006 5:28 pm

WoWRoster and wow 2.0.3

Postby zanix » Mon Jan 15, 2007 5:29 am

Well, the changes to the luaparser adds indexes to array for php

lua seems to be able to have arrays with no indexes
php needs indexes for every array, that's just how php works

As for the changes to wowdb, we now need to detect for nil values in the array
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: WoWRoster and wow 2.0.3

Postby PleegWat » Mon Jan 15, 2007 5:48 am

zanix wrote:Well, the changes to the luaparser adds indexes to array for php

lua seems to be able to have arrays with no indexes
php needs indexes for every array, that's just how php works


Actually I think the LUA arrays without a specified keys are just like the PHP ones. No key is specified so it is added automatically.

The problem was that the parser relied on the LUA array definition having keys.
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

WoWRoster and wow 2.0.3

Postby momo » Mon Jan 15, 2007 9:29 am

Yess!! thanks pleegWat fir this fix, my roster is OK, no error in parsing files, upload ok! great, good job!

(merci pour ce fix, la mise à jours se passe correctement désormais, un grand soulagement!)
http://www.france-games.com/Necronomico ... /index.php
momo
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Sat Dec 16, 2006 8:04 am

WoWRoster and wow 2.0.3

Postby Gholbine » Mon Jan 15, 2007 10:57 am

Hmm now i start to get error

Notice: Undefined offset: 1 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 2 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 1 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 2 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 1 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 2 in /customers/celtic-light.org/celtic-light.org/httpd.www/modules/Roster/addons/guildbank/gbank.php on line 247

When i click on Guildbank under addons is show that line, i dont get any error when i upload the lua file

U can see it Here
Last edited by Gholbine on Mon Jan 15, 2007 10:57 am, edited 1 time in total.
Image
User avatar
Gholbine
WR.net Apprentice
WR.net Apprentice
 
Posts: 15
Joined: Sun Aug 27, 2006 8:12 am

WoWRoster and wow 2.0.3

Postby Brastfield » Mon Jan 15, 2007 1:05 pm

Getting this error:

Cannot update Character Data
1264: Out of range value adjusted for column 'talent_points' at row 1


Character is a lvl 6, so doesnt have any talent points.

Edit: Nvm! The fix given by Zanix at the bottom of page 5 fixed it. Awesome, thanks! :)
Last edited by Brastfield on Mon Jan 15, 2007 7:46 pm, edited 1 time in total.
Brastfield
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Sat Jan 13, 2007 9:46 am

Re: WoWRoster and wow 2.0.3

Postby Scatmanicus » Mon Jan 15, 2007 8:38 pm

I installed WOWRoster 1.7.2 as a new install with a new database. Installation was fine and the base WOWRoster looked and worked fine.

I am using rpgo-CharacterProfiler_2.0.5b, rpgo-GuildProfiler_2.0.5 and GroupCalendar_2.2.1.

I made the changes to the luaparser.php and the wowdb.php file recommended by Polodude. I have made the changes for talents recommended by Zanix.

I removed the CharacterProfiler.lua, CharacterProfiler.lua.bak, GroupCalendar.lua, GroupCalendar.lua.bak, CT_RaidTracker.lua and CT_RaidTracker.lua.bak files. Started game, save individual info, saved guild info, added 2 calendar events after complete synchronization and exited game. Performed an updated. The talents looks fine, at least on a couple of my characters..didn't check all of them. The guild update seemed to have worked fine.

However, I'm still having problems with the Event Calendar not updating, Main/Alts not being setup, RaidTracker not updating (last one updated was 12/04/2006 and yes, there are other raids in the CT_Raidtracker.lua file) and now I am getting errors about reputation.

Here is the error display concerning reputation:
Code: Select all
Update Errors

Reputation for Thorium Brotherhood could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Gelkis Clan Centaur could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Bloodsail Buccaneers could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Cenarion Circle could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Darkmoon Faire could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Zandalar Tribe could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Timbermaw Hold could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Shen'dralar could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Hydraxian Waterlords could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Ravenholdt could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Magram Clan Centaur could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Brood of Nozdormu could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Argent Dawn could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Stormpike Guard could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Silverwing Sentinels could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for The League of Arathor could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Everlook could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Ratchet could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Gadgetzan could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Booty Bay could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Exodar could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Ironforge could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Stormwind could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Gnomeregan Exiles could not be inserted
1054: Unknown column 'Value' in 'field list'
Reputation for Darnassus could not be inserted
1054: Unknown column 'Value' in 'field list'


I have attached a troubleshooting.zip file with the CharacterProfiler.lua, GroupCalendar.lua, CT_RaidTracker.lua, luaparser.php, wowdb.php and update_log.txt.
Attachments
troubleshooting.zip
CharacterProfiler.lua
GroupCalendar.lua
CT_RaidTracker.lua
luaparser.php
wowdb.php
update_log.txt
(401.65 KiB) Downloaded 58 times
Last edited by Scatmanicus on Mon Jan 15, 2007 8:41 pm, edited 1 time in total.
Just another ol' Hacker!
Image
User avatar
Scatmanicus
WR.net Apprentice
WR.net Apprentice
 
Posts: 39
Joined: Fri Aug 11, 2006 4:03 am

WoWRoster and wow 2.0.3

Postby ajsl » Mon Jan 15, 2007 10:24 pm

I've applied both patches and am running the latest versions of GP and CP and am getting the following error on update:

Code: Select all
Cannot update Character Data
1054: Unknown column 'honorpoints' in 'field list'


Any ideas?
ajsl
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Thu Aug 10, 2006 9:05 pm

Re: WoWRoster and wow 2.0.3

Postby Kilghard » Tue Jan 16, 2007 6:31 am

ajsl wrote:I've applied both patches and am running the latest versions of GP and CP and am getting the following error on update:

Code: Select all
Cannot update Character Data
1054: Unknown column 'honorpoints' in 'field list'


Any ideas?


i've the same problem :scratch:
Kilghard
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Sun Dec 24, 2006 6:17 am

WoWRoster and wow 2.0.3

Postby bloopster » Tue Jan 16, 2007 7:13 am

Maybe its a small thing but when i update my char on the roster it still says lvl60 max xp. i cant see the new xp.
And i have installed the Burning Crusade maybe that the problem lies there.
Last edited by bloopster on Tue Jan 16, 2007 7:13 am, edited 1 time in total.
bloopster
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Dec 20, 2006 6:11 am

Re: WoWRoster and wow 2.0.3

Postby Malkom » Thu Jan 18, 2007 5:32 am

bloopster wrote:Maybe its a small thing but when i update my char on the roster it still says lvl60 max xp. i cant see the new xp.
And i have installed the Burning Crusade maybe that the problem lies there.


Here you can find the issue :

http://www.wowroster.net/Forums/viewtopic/t=2378.html
Last edited by Malkom on Thu Jan 18, 2007 5:33 am, edited 1 time in total.
Image
User avatar
Malkom
WR.net Journeyman
WR.net Journeyman
 
Posts: 144
Joined: Tue Jan 09, 2007 11:02 am
Location: France - 91 - Longjumeau

WoWRoster and wow 2.0.3

Postby Kilghard » Thu Jan 18, 2007 5:51 am

ok, we using the beta versione so, if u want tu update correctly your profile , open DB and add :
in roster_reputation after name :
`curr_rep` int(8) NULL,
`max_rep` int(8) NULL

in roster_players after lifetimeRankName :
`honorpoints` int(11) NOT NULL default '0',
`arenapoints` int(11) NOT NULL default '0'




i hope i could resolve the problem.


bye
Kilghard
WR.net Apprentice
WR.net Apprentice
 
Posts: 3
Joined: Sun Dec 24, 2006 6:17 am

Re: WoWRoster and wow 2.0.3

Postby Nyth » Thu Jan 18, 2007 6:30 am

I am running the newest version v1.7.2, I added the 2 .lua files updates. When I do an update I don't get any errors. I have forced a guild update: /gp export but I still can't see Titles.

Any Suggestions:


UPDATE:

It just started to work. Not sure but maybe there was a cache issue on my webhost or with MySQL.
Last edited by Nyth on Thu Jan 18, 2007 10:02 am, edited 4 times in total.
Nyth
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Tue Dec 12, 2006 2:41 pm

Re: WoWRoster and wow 2.0.3

Postby bloopster » Thu Jan 18, 2007 7:15 am

Malkom wrote:
bloopster wrote:Maybe its a small thing but when i update my char on the roster it still says lvl60 max xp. i cant see the new xp.
And i have installed the Burning Crusade maybe that the problem lies there.


Here you can find the issue :

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



It worked thanks a lot :thumleft:
bloopster
WR.net Apprentice
WR.net Apprentice
 
Posts: 2
Joined: Wed Dec 20, 2006 6:11 am

Re: WoWRoster and wow 2.0.3

Postby greg05330 » Fri Jan 19, 2007 8:16 pm

Hello.

First, thank you for this job.

I'm sorry, but i'm french and i can't understand all you're writting here.
I have average 50 errors in the page of the guildbank addon

Notice: Undefined offset: 1 in /home.10.2/firstfie/www/roster/addons/guildbank/gbank.php on line 247

Notice: Undefined offset: 2 in /home.10.2/firstfie/www/roster/addons/guildbank/gbank.php on line 247

see here

I have fixed the bug with the 2 files, no errors with the versions of the files, using the latest versions of CP and GP.

I think i'm not alone, but if somebody can help me... Maybe in french?

Thanks
greg05330
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Fri Jan 19, 2007 7:47 pm

PreviousNext

Return to General Support & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests

cron