Very useful addon. I'm always looking to see who isn't updating and this will save me time.

Other then the bland webpage, I'm having another issue. Where it would normally put the "Who never uploaded", I'm getting the following error message:

Who never uploaded
# Name
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 'select `name` from `roster_players` ) AND `guild_rank` <= 9 ORD

I haven't gone into my SQL and changed anything..as far as I know...

Any ideas?

Again, great addon..thanks for your hard work!

Getting the same as ^^

You have an error in your SQL syntax near 'select `name` from `roster_players` ) AND `guild_rank` <= 4 ORDER BY name asc' at line 1

dont have any errors on 2 different webservers with different mysql and php versions.
sql syntax looks correct for me

Code: Select all

"SELECT name, class FROM `".ROSTER_MEMBERSTABLE."` WHERE `name` not in ( select `name` from `".ROSTER_PLAYERSTABLE."` ) AND `guild_rank` <= ".$addon_conf['witchHunt']['gRank']." ORDER BY name asc"
 

try downloading v1.1 to see if there is still an error

i am using 1.1

only thing i can think of is removing all "`" from the query

Dracoking007 wrote:I'm having another issue. Where it would normally put the "Who never uploaded", I'm getting the following error message:

I am receiving the same error message after logging into this mod:

Code: Select all

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
'select name from roster_players ) AND guild_rank <= 4 ORDER BY

Version 1.1.1

The SQL error is because of the subquery. You need MySQL 4.1 for that. That's not a problem with this addon per se - Roster does require MySQL 4.1 or higher. However it is possible to rewrite this query with a LEFT JOIN then check if `member_id` IS NULL.

Thanks. Just checked and we are using MySQL 4.0.26-standard.

Oh and WoWRoster is working fine with this MySQL version btw. But, guess it's getting time to update to latest and greatest.

Yes, it works down to 4.0 unmodded and 3.something with minor changes IIRC. However it officially requires 4.1, and development takes place on 5.x.

Awesome! Thank you for doing my request!

If you look at my Roster you'll see that the Slackers arn't being ordered correctly. Any idea what gives?

http://wow.roa-guild.org/roster/addon.p ... =witchHunt

still not working for it may be my sql will find out mod look gd nice job

ds001 wrote:Awesome! Thank you for doing my request!

If you look at my Roster you'll see that the Slackers arn't being ordered correctly. Any idea what gives?

http://wow.roa-guild.org/roster/addon.p ... =witchHunt

problem is roster takes the update time as string from the lua file and stores it as string in the database.
example "02/23/07 09:49:10"
as you notice it shows all players who lalst updated in 2006 1st since (bunch of slackers u got there) in ordering by string in sql "02/23/06 09:49:10" < "02/23/07 09:49:10".
will try to take care of that in a future version

Hi there tested the add on on my host and yeah he has made som configs that don´t allow your add on to create folders and setting right!

Could you make it so its optional if you want your add on to create the folders or do it manually?

Because if your add on cannot make the folders initially it won´t run...
And I would really be glad to have an add on like that runnning....


Best Regards
microbone

I'm getting the same error about SQL and I'm running: MySQL Version 4.0.27-max-log

Any chance anyone can tell me how to mod the scripting to accept this version of sql?

microbone wrote:Hi there tested the add on on my host and yeah he has made som configs that don´t allow your add on to create folders and setting right!

Could you make it so its optional if you want your add on to create the folders or do it manually?

Because if your add on cannot make the folders initially it won´t run...
And I would really be glad to have an add on like that runnning....


Best Regards
microbone

sorry cant follow you there..my addon doesnt create any folders at all