l8gravely

Yeah, the first MYSQL statement was written for my setup. If you take out the “WHERE league_id = 1” part, do you get any more output?

I’m surprised the second one doesn’t produce more output. Do you have a seperate leaguemanager plugin setup for each of your leagues? You’re data just doesn’t look proper. Basically, I don’t see the definition of the ‘custom’ column in your output, which is what you need to have it work properly.

Can you dump your entire DB and send me a PDF? We can take this offline to email if you like. l8gravely at gmail dot com will do it.

I’m disappointed that Kolke isn’t active on here, talking with people about hit plugin and how it works. I hope to have some time tonight to hack on it for my site…

Renald, from looking at the errors and the mysql output you showed me, I wonder if the problem is in the last column, the ‘custom’ one.

See how it’s got “a:0:{}” as the value? I bet that’s wrong. Oh wait… I just went and looked at my single league and all my matches have the same setup for the ‘custom’ column. Can you check your other leagues with the following mysql code:

select id, custom from wp_leaguemanager_matches WHERE league_id = 1 GROUP BY custom;

And you should get two results. One is the header which tells LeagueManager what the custom columns are (I suppose, haven’t looked at the code yet…) and then the actual matches just use the a:0:{} as a placeholder for the formatting.

You could also check your Schema for each of your leagues with:

SELECT league_id, id, custom FROM wp_leaguemanager_matches GROUP BY custom ORDER BY league_id

and see if all your leagues have the same setup. If they don’t, you might be able to get away with just inserting the missing data into the DB. But let’s work on that once we know more what the issue is.

Cheers,
John

Well, I suspect that if you upgrade to the 3.6.4 version, you might be ok with your update. Can you tell us which version of the plugin your using right now? And which version of WP?

I do see that 3.6.6 has been released as well, but haven’t managed to look at it yet to see what changes have been made.

John

Gah! He’s upgraded the plugin yet again, and without any notice to the Forum. Frustrating. Anyone know how to reach the author, or where he/she hangs out?

Anyway, do you have just one site for your club, with six different leagues, with each league having it’s own set of teams and matches?

And which league ID is having the troubles?

One thought would be to poke at the Mysql DB directly and look at the data in there and see if you can figure out what’s going on there.

If you can, look at the http logs for your site, but the access_log and the error_log, as well as any PHP logs you can find.

when you exported the data, did it look correct? And did it re-import properly? What about if you export the data, make a modification and re-import, does the modification show up or not?

Can you post the output of:

SELECT * FROM wp_leaguemanager_matches WHERE league_id = #;

using # of your problematic league? What I’m thinking is that something strange is going on, and there’s an error in the PHP code somewhere which needs to be tracked down.

So looking for any and all logs from your site is a key thing. Is this a hosted solution where you only have limited access, or do you have full control of a Virtual Server running this site so you can poke around a bit? Hopefully it’s the later…

Cheers,
John

This is a nice nice hack. It would be even better if we could pull this out and make it customizable as well.

What I’d love to see is the ability to change the display of match selection to use the *date* of the match(es) to be selected. I can’t remember which match number is which match, I just want to update the scores on all matches for a specific date.

Am I making sense here?

Can you give us more details about your setup? Version of plugin you’re using, etc?

Have you looked at the error logs for your site as well when you try to enter scores?

When you try to update the scores in the match(es), which URL are you using at the time? I assume you’re properly logged into the site and can add/modify/delete pages and such?

Is it just *some* matches which are giving you problems, or all matches? Can you update the scores for some other matches later in the year as a test, to see what happens?

Also, do you have enough disk space on your hosting site? Or maybe you’ve hit the limit on your backend MySQL setup. It’s hard to know without more details though.

I haven’t seen this issue myself, but I’m *very* new to leaguemanager and trying to come upto speed with it as well. I’m happy to hack code a bit, but learning this code is a bit of a struggle since the docs are lacking.

I wish there was an example sport. Sorry, I’m off topic here.

Good luck!
John

Which version of the plugin are you using? And which sport have you defined? The more details, the better.

Some thoughts (though I’m still new to this too!) are to login as your WP admin. Then goto the plugins->leaguemanager->league->season and look at the matches.

Do you see the for/against scores there properly? If so, then I suspect a simple (or not so simple!) edit to the sports code might be the fix you need.

John

P.S. Anyone know how I can get emails of all www.ads-software.com forum posts with the tag ‘leaguemanager’ so it’s easier to follow this forum and get/give help? It sucks having to remember to check all the time…

Did you define a new sport for your snooker league, or are you using the default ones? From the looks of your site, you’re not sorting properly.

I suspect that if you look in wp-content/plugins/leaguemanager/sports/ at the sport you’re using, you should be able to tweak your scoring calculations without too much problem.

I’d be happy to help you, if you’d show me how you setup your site to do the display of the standings on the home page. I’m still trying to wrap my brain around wordpress.

Did you use a different theme?

Thanks,
John

Well, I’ve started to hack a new module called “Soccer-coed” for my purposes. I’ll post it once it’s working better. Right now, it’s not generating the input fields properly on the form to let you easily toggle coed or not.

It would be nice if the Soccer module would support setup options so that you could customize it more easily to support different scoring methods.

For example, I don’t care about half-time scores at all, but I do care about Co-ed or not games. So ideally, you could just decide to use the soccer modele, and then enable/disable options as you liked.

I think I need to also update the DB for the plugin so that it stores the coed status properly. Still poking.

I don’t know how to do it either, but I wanted to reply and get people’s opinions on how to add more scoring options to LeagueManager, specifically Co-Ed matches?

In our Soccer league, teams that play with a woman in a game get a point added to their standings. Since a win is six points, it’s a big incentive to get more women playing in the league.

Right now I’ve copied sports/soccer.php to sports/soccer-coed.php and I’m busy trying to hack in support. I’d appreciate hearing what other’s think?

Another change is that we don’t keep track of score by half, just the ending score. Not sure how big a deal that really is, or if other leagues do the same thing.

Thoughts?
Thanks,
John