search

TheNAF / naflm

NAFLM - NAF League Manager
Other
35 stars 34 forks source link

Points are all zero #247

Open BenLuts opened 6 years ago

BenLuts commented 6 years ago

Hi,

I'm not sure what caused this, but all of a sudden all points of my league are zero. I can see all the match data, all wins, losses, score etc... But points are no longer calculated.

I have allready tried doing a synchAll() from the core panel, but that fails. It gives me an error saying Request failed : Ran syncAll(). After that my DB seems to be unavailable for a minute or 2.

Any ideas on what I can do/try/change?

BenLuts commented 6 years ago

I was still tinkering a little on the problem and decided to dive into my PHPMyAdmin and have a look at the stored procedures. When I call synchAll from phpmyadmin same thing happens, the DB sort of crashes. When however I run all the procedures of synchAll in order everything is fine and the PTS are calculated again.

williamleonard commented 6 years ago

Can you describe your installation. Github, extra patches, customizations, etc.

From: BenLuts notifications@github.com Sent: Monday, March 12, 2018 9:41:29 AM To: TheNAF/naflm Cc: Subscribed Subject: Re: [TheNAF/naflm] Points are all zero (#247)

I was still tinkering a little on the problem and decided to dive into my PHPMyAdmin and have a look at the stored procedures. When I call synchAll from phpmyadmin same thing happens, the DB sort of crashes. When however I run all the procedures of synchAll in order everything is fine and the PTS are calculated again.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHubhttps://github.com/TheNAF/naflm/issues/247#issuecomment-372312992, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMwJjMVHskfqJhdRIPtgX3jeJyuKHZC3ks5tdnsIgaJpZM4SmhyB.

BenLuts commented 6 years ago

I'm using the version downloaded from here https://www.thenaf.net/2016/06/naflm-official-release-1-0/ I have enabled the blood bowl 2016 rules and updated the translations for the Bretonnia team as it was officially added as a NAF team. The problem only started occuring after I deleted a scheduled match, that was scheduled by mistake and never played. What I find confusing is that running the stored procedures in order by itself works fine.

williamleonard commented 6 years ago

Maybe you could see if you could recreate the problem with only the release version.

From: BenLuts notifications@github.com Sent: Monday, March 12, 2018 9:59:52 AM To: TheNAF/naflm Cc: williamleonard; Comment Subject: Re: [TheNAF/naflm] Points are all zero (#247)

I'm using the version downloaded from here https://www.thenaf.net/2016/06/naflm-official-release-1-0/ I have enabled the blood bowl 2016 rules and updated the translations for the Bretonnia team as it was officially added as a NAF team. The problem only started occuring after I deleted a scheduled match, that was scheduled by mistake and never played. What I find confusing is that running the stored procedures in order by itself works fine.

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/TheNAF/naflm/issues/247#issuecomment-372318963, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMwJjCVEdZSiGkKIalk-StmAhScUJEZQks5tdn9XgaJpZM4SmhyB.

BenLuts commented 6 years ago

Will try, although I hadn't had any problems until I deleted that one scheduled match. Are there any patches that I might need downloading? My only concern I have had with this wonderful peace of software up until now is scattered info :-)

williamleonard commented 6 years ago

I would try that same action then. That may be the bug with anything beyond the official release. Could be a bug in the release, but seems a common action.

From: BenLuts notifications@github.com Sent: Monday, March 12, 2018 10:48:40 AM To: TheNAF/naflm Cc: williamleonard; Comment Subject: Re: [TheNAF/naflm] Points are all zero (#247)

Will try, although I hadn't had any problems until I deleted that one scheduled match. Are there any patches that I might need downloading? My only concern I have had with this wonderful peace of software up until now is scattered info :-)

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/TheNAF/naflm/issues/247#issuecomment-372335802, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AMwJjD5JXPBqcXpPEH_sCY2YlD8hfQauks5tdorIgaJpZM4SmhyB.