Witch Hunt v2.0.0 beta

Keep track of who updates their character profile and when

Moderator: Carasak

Re: Witch Hunt v2.0.0 beta

Postby tuigii » Mon Mar 10, 2008 10:28 pm

Carasak wrote:about the name of the installer class:
you sure you downloaded the correct ZIP from the download section?
I just verified it... and the class is named witchhuntInstall


Well, I used the first mail in this thread, it point to this page, which seems correct to me : http://www.wowroster.net/Downloads/get=118.html

I used the fist line of three download possibilities :
www.exdream.net witchhunt_v2.0.0.0b.zipReport broken 10.17 KB

And believe me, open the ZIP file => install.def.php isn't (wasn't) correct.


PS : big lol - just posted - checked again : file are updated ^^
Now, it's ok ^^
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Re: Witch Hunt v2.0.0 beta

Postby Carasak » Mon Mar 10, 2008 10:32 pm

i left the old version available for download
now they are removed since i saw that this might create confusion

the correct version is 2.0.0.1b
Last edited by Carasak on Mon Mar 10, 2008 10:32 pm, edited 1 time in total.
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

Witch Hunt v2.0.0 beta

Postby shadowfox » Tue Sep 09, 2008 11:43 pm

so i probably am just blind after reviewing and searching but this is the error im getting when trying to display witchhunt on our roster...

Code: Select all
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY MyDate Desc' at line 1
SQL:
SELECT p.dateupdatedutc as MyDate,p.member_id, m.last_online as lastDate, p.name, m.name, m.class, m.note FROM roster_players as p, roster_members as m where m.note not like '[ALT]%' AND m.name=p.name AND m.guild_id= ORDER BY MyDate Desc
File: lib/dbal/mysql.php
Line: 234
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Re: Witch Hunt v2.0.0 beta

Postby Carasak » Wed Sep 10, 2008 3:12 pm

whats your mysql version?
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

Re: Witch Hunt v2.0.0 beta

Postby tuigii » Wed Sep 10, 2008 4:38 pm

Having close look and you'll get it:
shadowfox wrote:
Code: Select all
......AND m.guild_id= ORDER .....


For some reason, just after the "=" sign, the Guid ID is missing.
The bad thing is, this isn't the fault of the addon.

This variable: $roster->data['guild_id'] isn't set to a valid value, like "1".

It's time to communicate some more info about your roster, I think.

Btw : this has nothing to do with your SQL version.

Note : my observations are valid for the 2.0.0.1 version -I'll update to 2.0.0.1b right after the commercial break.
Note 2 : mine 's working ok : http://www.papy-team.fr/roster/index.ph ... hunt&a=g:1

:rofl: : I actually used the file "7842_witchhunt_v2.0.0.1b.zip" but the info in the installer array still says "2.0.0.1".
Last edited by tuigii on Wed Sep 10, 2008 4:53 pm, edited 2 times in total.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Re: Witch Hunt v2.0.0 beta

Postby shadowfox » Wed Sep 10, 2008 5:53 pm

info is :
OS Linux
Server Software Apache
MySQL Version 5.0.51a-9-log
PHP Version 5.2.6
PHP API Type apache2handler
safe_mode Off
open_basedir On
allow_url_fopen On
file_uploads On
upload_max_filesize 1M
version 2.0.0
db_version 6
use_update_triggers On
rs_mode On
GD Status On
GD Version bundled (2.0.34 compatible)
FreeType Support Yes
FreeType Linkage with freetype
T1Lib Support Yes
GIF Read Support Yes
GIF Create Support Yes
JPG Support Yes
PNG Support Yes
WBMP Support Yes
XPM Support Yes
XBM Support Yes
JIS-mapped Japanese Font Support No



And something weird.... since I posted this it works fine.. didnt do anything didnt even change clothes ( work ) it works fine... any idea as to why its fine now but not before?
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Witch Hunt v2.0.0 beta

Postby PleegWat » Fri Sep 12, 2008 2:27 am

This is an addon bug. The page requires a guild ID, however it is a page in the util scope.

To fix the issue, move the affected entry page to the 'guild' subdirectory of the addon, and fix any internal links to use 'guild' rather than 'util'.

'guild_id' and other guild-level data are only guaranteed to be set in the guild or character scope. In util or realm scope, they may occasionally be set, but they are not guaranteed to be.

This URL on Tuigii's roster is affected by the bug. Notice the missing 'a' parameter.

http://www.papy-team.fr/roster/index.ph ... -witchhunt
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

Witch Hunt v2.0.0 beta

Postby zanix » Fri Sep 12, 2008 6:31 am

You will also need to modify the menu button to link to the new location
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: Witch Hunt v2.0.0 beta

Postby Carasak » Sat Sep 13, 2008 2:04 am

ok will fix this as soon as possible

thanks for bug report and solutions
User avatar
Carasak
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 114
Joined: Tue Aug 15, 2006 2:33 am
Location: Spain

Re: Witch Hunt v2.0.0 beta

Postby shadowfox » Fri Sep 26, 2008 5:41 am

PleegWat wrote:This is an addon bug. The page requires a guild ID, however it is a page in the util scope.

To fix the issue, move the affected entry page to the 'guild' subdirectory of the addon, and fix any internal links to use 'guild' rather than 'util'.

'guild_id' and other guild-level data are only guaranteed to be set in the guild or character scope. In util or realm scope, they may occasionally be set, but they are not guaranteed to be.

This URL on Tuigii's roster is affected by the bug. Notice the missing 'a' parameter.

http://www.papy-team.fr/roster/index.ph ... -witchhunt



Ok I just understood after weeks what youre saying here... *bonks self* So let me get this straight...
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Re: Witch Hunt v2.0.0 beta

Postby shadowfox » Sat Oct 25, 2008 7:02 pm

ok run this by me one more time...

So I need to redirect the addon to ident the guild tag rather then "A" after the = sign and redirect all shortcuts to use the "guild" rather then utility tags... alright I think I have that done... still having the same issue randomly...

every once in a while it will do the following:

Code: Select all
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY MyDate Desc' at line 1
SQL:
SELECT p.dateupdatedutc as MyDate,p.member_id, m.last_online as lastDate, p.name, m.name, m.class, m.note FROM roster_players as p, roster_members as m where m.note not like '[ALT]%' AND m.name=p.name AND m.guild_id= ORDER BY MyDate Desc
File: lib/dbal/mysql.php
Line: 234


Since the first post Ive actually gone to a new server. New stats are the following:

GD Status On
GD Version bundled (2.0.34 compatible)
FreeType Support Yes
FreeType Linkage with freetype
T1Lib Support No
GIF Read Support Yes
GIF Create Support Yes
JPG Support Yes
PNG Support Yes
WBMP Support Yes
XPM Support Yes
XBM Support Yes
JIS-mapped Japanese Font Support No

PHP Version 5.2.6
PHP API Type apache2handler
safe_mode Off
open_basedir On
allow_url_fopen On
file_uploads On
upload_max_filesize 10M

OS Linux
Server Software Apache/2.2.10 (Unix) mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_perl/2.0.4 Perl/v5.8.8
MySQL Version 5.0.51a-community

version 2.0.0
db_version 6
db_prefix roster_
debug_mode Off
roster_lang enUS
img_url img/
interface_url img/
img_suffix jpg
use_update_triggers On
rs_mode On
User avatar
shadowfox
WR.net Apprentice
WR.net Apprentice
 
Posts: 35
Joined: Sun Oct 14, 2007 11:47 am
Location: Modesto, California
Realm: Moon Guard (RP) - US

Re: Witch Hunt v2.0.0 beta

Postby GemDog » Sun Feb 21, 2010 1:08 am

Works in current SVN WoWRoster v2.0.9.2123 :glad:
Image
User avatar
GemDog
WR.net Apprentice
WR.net Apprentice
 
Posts: 37
Joined: Sat Jan 31, 2009 8:57 am

Previous

Return to Witch Hunt

Who is online

Users browsing this forum: No registered users and 0 guests

cron