Installing OBBLM on GoDaddy hosted site

[Rewslaun]

Greetings,

I'm setting up a website for my league and I decided to start with OBBLM. While running the install script I get the following error:

FATAL ERROR: One or more OBBLM MySQL functions/procedures could not be created. This error is most likely due to your database user NOT having the "CREATE ROUTINE" privilege. Some web hosts are willing to help you work around this problem by running this install/upgrade script for you. If not, you will have to find another web host allowing "CREATE ROUTINE".

MySQL error (errno 1419):
You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

The function/procedure SQL code that failed was:
CREATE FUNCTION getPlayerStatus(pid MEDIUMINT SIGNED, mid MEDIUMINT SIGNED) RETURNS TINYINT UNSIGNED NOT DETERMINISTIC READS SQL DATA BEGIN DECLARE status TINYINT UNSIGNED DEFAULT NULL; IF !EXISTS(SELECT f_match_id FROM match_data WHERE f_player_id = pid LIMIT 1) THEN RETURN 1; END IF; IF mid = -1 OR EXISTS(SELECT match_id FROM matches WHERE match_id = mid AND date_played IS NULL) THEN SELECT inj INTO status FROM match_data, matches WHERE f_player_id = pid AND match_id = f_match_id AND date_played IS NOT NULL ORDER BY date_played DESC LIMIT 1; ELSE SELECT inj INTO status FROM match_data, matches WHERE match_data.f_player_id = pid AND matches.match_id = match_data.f_match_id AND matches.date_played IS NOT NULL AND matches.date_played < (SELECT date_played FROM matches WHERE matches.match_id = mid) ORDER BY date_played DESC LIMIT 1; END IF; RETURN IF(status IS NULL, 1, status); END


I've put in a request with the support team to have them run the install script and I'm still waiting to hear back from them? I'm just curious if anyone else is running the OBBLM software hosted on GoDaddy?

[Blammaham]

PM Watpstone, I think we host on godaddy and I know we use OLBBM. S.

[Rewslaun]

PM Watpstone, I think we host on godaddy and I know we use OLBBM. S.

I tried PMing Watpstone but it showed that he wasn't a valid User. I saw someone named Warpstone and sent them a pm. Hopefully that's the right person.

Thanks

[Blammaham]

PM Watpstone, I think we host on godaddy and I know we use OLBBM. S.

I tried PMing Watpstone but it showed that he wasn't a valid User. I saw someone named Warpstone and sent them a pm. Hopefully that's the right person.

Thanks

Damn phone. Yes that's the right guy! S.

[Wylder]

Now that the original question is (hopefully) solved, time to hijack the thread for my own purposes...

I just installed OBBLM on my home web server and it's all running nicely from what I can tell. However I have basically no knowledge of how to use the site. I'm reading the wiki guide on it when I get the time but I have a question to start with.

We've got a local league running. 6 teams currently participating. We're midway through a round robin tournament. Is there any reasonably straightforward way to get the teams and results so far into the OBBLM site? I looked at the team upload thingy and it seems horribly cumbersome to manually edit that xml file for each team. I'm almost certain I would make errors doing it that way. Is this the only option?

[Kikurasis]

You have two options:

1] Set up a scheduled league, with all 6 teams, and set it to 1 round of round-robin. Since the games don't have to be recorded in OBBLM in order, you can put in the games that have been played and just play out the rest of your season the same way.

2] Set up an unscheduled league (open league) and just report the played games already done and report the rest as you play them. This requires creating the matches individually (instead of having them already created by doing the round-robin), but works just as well.

[Warpstone]

Wylder, once you setup matches as Kikurasis mentioned, you should see a fixture created in your tournaments page. Go there, click on view and you should get a match report page where you can fill in all the spp and related data for the game.

You do not report a match from your team screen (at least not on th versions I've used). Rather, you navigate to the game in your schedule and report from there.

BTW, if you want a match report sheet, Thunderbowl has one that is layed out similarly to OBBLM's data entry form: http://thunderbowl.ca/Thunderbowl%20Lar ... eports.pdf
It makes it easier to transfer your game notes to OBBLM.

[ryan.bright1]

I would like to ask, what is the OBBLM and how do you install it and what doe sit do for you?

[Rewslaun]

I would like to ask, what is the OBBLM and how do you install it and what doe sit do for you?

Directly from the OBBLM site

"OBBLM is a Blood Bowl league manager that works by coaches submitting match data after each played match in a tournament.
League commissioners (league admins) may create tournaments and include certain coaches' teams to participate in a tournament. When a tournament is created, the two coaches participating in any match may submit a match report to the system. The manager will thereby be able to update tournament stats and team details - including giving the team coach access to chose new player skills etc."

Install instructions are here:
http://nicholasmr.dk/obblmwiki/index.php/Installation

[Shteve0]

The very easiest way to install it is to buy your hosting from mercuryvps (run by tff's funnyfingers). It's $25 a year and includes email accounts, domains and obblm is installed automatically when you register.

[ryan.bright1]

Ok, thank you for the information.

[Vanguard]

I went through a few ISPs before I found one that would properly support OBBLM - I'm now using HostGator, which is working for me.
The important bit from the wiki is "Your MySQL database user must have the privileges CREATE PROCEDURE and CREATE FUNCTION or CREATE ROUTINE" Not many ISPs seem willing to offer these rights to users. Also, most of their sales agents and even tech support guys are a bit fuzzy on this. I signed up with three hosts who assured me it would be fine, when they didn't support it in practice.