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

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

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

whats your mysql version?

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

: 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".

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?

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

You will also need to modify the menu button to link to the new location

ok will fix this as soon as possible

thanks for bug report and solutions

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

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

Works in current SVN WoWRoster v2.0.9.2123