Particular custom Age Categories missing from table outputs

Hi Clive,

Thanks again for the comments, sorry about the delay I haven’t been to the support forum for a while.

I’m a bit confused by the above so what I’ll do it try recreate what you’ve done and hopefully narrow down the issue.

The age categories (I think) are stored as an option in the options table if you need to make a quick fix.

Hi Conor,

No problem at all.

The issue was due to the fact that wp_wpa_result.age_category field was defined as a varchar(4) and therefore wasn’t fully storing the age category identifiers which were longer than 4 chars. For example, “C1115” which represents the 11-14 age group was being stored as “C111”. I changed the data type of the aforementioned field to varchar(7) and ran a few SQL UPDATE queries to correct the truncated identifiers. Now everything is working nicely.

In the next release, I’d therefore recommend changing the data type of the wp_wpa_result.age_category field from varchar(4) to varchar(7) to avoid this issue reoccurring.

Hope that’s useful,
Clive

Hi stretchwickster,

I’m having the same issue and have updated my age_category field to a varchar(7). However, one of my categories is still not showing up on the results page. And the identifier for that category is A40, so I’m not sure that the varchar(4) even mattered.

Could this be because I added the category after I inserted the race result?

Another problem I’m having is that I inserted the wrong sex for one of my runners. I need to edit that buy I’m not sure where the plugin stores that information. Thanks for your help!

1) Regarding the missing age category…
a) From the plugin’s Manage Results facility, pick a result where the age category is missing and note down all the details connected with that result
b) In the wp_wpa_result table, find that same result and let me know what the age_category field is set to.
c) In the wp_options table, find the row where option_name='wp-athletics_age_cats' and let me know what the option_value field is set to.

2) To update the gender of one of your runners…
a) In the wp_users table, note down the number in the ID field for the user you wish to edit
b) In the wp_usermeta table, find the row where user_id matches the number you noted in Step 1 AND meta_key='wp-athletics_gender'
c) In the row found in Step 2, set meta_value to M or F as appropriate

Thanks SO much for the quick support. I’ve followed your directions for changing the sex of my runner (sounds weird) and it worked perfectly. Once I have more submissions (won’t be long) I will send you over the data in the tables in regards to the age_cats.

Thanks again for your help!

Okay, I’ve got another missing age category. For some reason the problem appears to be intermittent. I’ve followed your directions and this is what I found:

a) found the result in the plugins’s Manage Results area and the age category is empty. (I know I entered in the date of birth).

b) found the same result in the wp_wpa_result table, and the age_category field is blank.

c) here’s what I found inside of ‘wp-athletics_age_cats option_value’:

a:15:{s:5:”C1619″;a:3:{s:4:”name”;s:5:”16-19″;s:4:”from”;s:2:”16″;s:2:”to”;s:2:”19″;}s:5:”C2024″;a:3:{s:4:”name”;s:5:”20-24″;s:4:”from”;s:2:”20″;s:2:”to”;s:2:”24″;}s:5:”C2529″;a:3:{s:4:”name”;s:5:”25-29″;s:4:”from”;s:2:”25″;s:2:”to”;s:2:”29″;}s:5:”C3034″;a:3:{s:4:”name”;s:5:”30-34″;s:4:”from”;s:2:”30″;s:2:”to”;s:2:”34″;}s:3:”A35″;a:3:{s:4:”name”;s:5:”35-39″;s:4:”from”;s:2:”35″;s:2:”to”;s:2:”39″;}s:3:”A40″;a:3:{s:4:”name”;s:5:”40-44″;s:4:”from”;s:2:”40″;s:2:”to”;s:2:”44″;}s:3:”A45″;a:3:{s:4:”name”;s:5:”45-49″;s:4:”from”;s:2:”45″;s:2:”to”;s:2:”49″;}s:3:”A50″;a:3:{s:4:”name”;s:5:”50-54″;s:4:”from”;s:2:”50″;s:2:”to”;s:2:”54″;}s:3:”A55″;a:3:{s:4:”name”;s:5:”55-59″;s:4:”from”;s:2:”55″;s:2:”to”;s:2:”59″;}s:3:”A60″;a:3:{s:4:”name”;s:5:”60-64″;s:4:”from”;s:2:”60″;s:2:”to”;s:2:”64″;}s:3:”A65″;a:3:{s:4:”name”;s:5:”65-69″;s:4:”from”;s:2:”65″;s:2:”to”;s:2:”69″;}s:3:”A70″;a:3:{s:4:”name”;s:5:”70-74″;s:4:”from”;s:2:”70″;s:2:”to”;s:2:”74″;}s:3:”A75″;a:3:{s:4:”name”;s:5:”75-79″;s:4:”from”;s:2:”75″;s:2:”to”;s:2:”79″;}s:3:”A80″;a:3:{s:4:”name”;s:5:”80-84″;s:4:”from”;s:2:”80″;s:2:”to”;s:2:”84″;}s:3:”A85″;a:3:{s:4:”name”;s:5:”85-89″;s:4:”from”;s:2:”85″;s:2:”to”;s:2:”89″;}}