PleegWat wrote: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.

done

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

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

wow.roa-guild.org/rost...=witchHunt

fixed date order bug

new version 1.1.2

I'm getting the following sql error. Seems a bit different then the other one?

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 '(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate, p.name, m.nam

My host runs phpmyadmin 4.0.26

I'm using witch hunt 1.1.2

If this is fixable other then updateing phpmyadmin (I wold if I could but not my server) I'd love to use this addon. It looks really nice and usefull. I agree however with one of the posts above that it would be nice to open it up for the rest of guildies to see. Seeing about 90% of our members are slackers .

Elethil wrote:I'm getting the following sql error. Seems a bit different then the other one?

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 '(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate, p.name, m.nam

My host runs phpmyadmin 4.0.26

I'm using witch hunt 1.1.2

I am receiving the same error and have the same versions as you listed.

Carasak just forget my post about folders.....

wrong post, wrong place sry for that m8 must have been sleepy or something!

But I´m getting the same error as already mentioned twice.

Best Regards
microbone

Mysql error "...(p.dateupdatedutc,'%m/%d/%y %H:%i:%s')..."

Using a function to format the date which is available from Mysql v4.1

until find time to change the code to work with 4.0.x only option to ifix it is upgrading your mysql version

This is the code you use, right?

Code: Select all

$resultChar = $wowdb->query("SELECT STR_TO_DATE(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate, p.name, m.name, m.class, m.guild_rank FROM ".ROSTER_PLAYERSTABLE." as p, ".ROSTER_MEMBERSTABLE." as m where m.guild_rank<= ".$addon_conf['witchHunt']['gRank']." AND m.name=p.name ORDER BY MyDate Desc  ") or die(mysql_error());

If STR_TO_DATE is what you use to convert the date, isn't it possible to convert that to variable earlier? by using php date()?

cant convert it earlier cause there is no earlier moment then the query of the string to convert from the database.
only thing i can do there is not convert it in the sql query and process the data after with php (but thats what i wanted to avoid)

p.dateupdatedutc...
where do you get this from?
From roster?

yes from roster_players table

as far as I can see, what you are doing, is comparing char names from one table to the other?
how does it work, if a GM upload the guildprofiler.lua it populates one list. when a player uploads characterprofiler.lua the other is populated?

reshurc wrote:as far as I can see, what you are doing, is comparing char names from one table to the other?
how does it work, if a GM upload the guildprofiler.lua it populates one list. when a player uploads characterprofiler.lua the other is populated?

uploading the roster as GM with characterprofiler populates the roster_members table. (well and the charinfo of the uloading person into roster_players table)
uploading characterprofiler as normal member populates roster_players table.
so those not in roster_players table never uploaded their char

just a side note guildprofiler.lua is never uploaded. data from guildprofiler addon is stored in characterprofiler.lua

getting the smae SQL error, and nope, i cannot update my MYSSQL DB as it is not mine

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 '(p.dateupdatedutc,'%m/%d/%y %H:%i:%s') as MyDate, p.name, m.nam

any other alternatives

only alternative is putting the logic of reformating the date and ordering into php code instead of doing it directly in SQL but i rather wouldnt do that.

For those of you stuck on 4.0.x (like I am) try this...

Change

Code: Select all

SELECT STR_TO_DATE(p.dateupdatedutc, '%m/%d/%Y %H:%i:%s') as MyDate

To

Code: Select all

SELECT p.dateupdatedutc as MyDate

...

Then Change

Code: Select all

$dat2 = explode('-',$dat1[0]);
$newDate= $dat2[2].'/'.$dat2[1].'/'.$dat2[0].' '.$dat1[1];

To

Code: Select all

$dat2 = explode('/',$dat1[0]);
$dat3 = date("m/d/Y", mktime(0,0,0,$dat2[0],$dat2[1],$dat2[2]));
$newDate= $dat3.' '.$dat1[1];

thanks Guntak
that should get rid of mysql errors on pre 4.1 version

disadvantage...date is not ordered correctly