Create New Athlete

Hi Darrin,

Thanks for using the plugin, I’d love to help you get it up and running on your site.

The first thing that comes to mind is that the “display_name” field of the user is not set, because that’s what it checks for when you search for a username.

Head into the users settings on the wordpress dashboard and check if the display name is set for the athletes that you are searching, if it’s not, set it. Let me know how this goes.

Cheers,

Conor.

Hi Conor

Thanks for coming back to me. I’ve just checked and the display name is set under Users for my name. I’ve also created a dummy account and made sure display name is set along with other fields.

Still not showing up when attempting to add a athlete to a race result.

Cheers

Darrin

Hi Darrin,

Ok, it’s hard to diagnose without having a look around your setup but there may be some information in the browser console.

I’m not sure if you are familiar with developer tools in browsers but if you are using Chrome, go to TOOL > DEVELOPER TOOLS and have a look at the console tab, there may be an error there that could give us more information.

If you are in Firefox, there is a similar developer console in tools you should be able to find it.

Give that a go and let me know if it brings up anything.

Conor.

Hi Conor

Sadly nothing of any significance (that I can see) comes up in console using FF debug.

I did alter my table prefix sometime back from wp_ to combat two hacks on the site (its only a small running club, why someone would want to is beyond me)

Is it permissions related perhaps? I really don’t know what to check at this stage.

Can provide you a Admin logon to site if required.

Thanks

Darrin

Hi Conor,

Appear to be in a worse state now after removing plugin and re-installing. It does not install cleanly as no menu option appears now in dashboard and no “Manage Results” page created.
No errors on activation.

Is there a way to cleanly remove (perhaps something I’ve missed) and try a fresh installation?

Thanks

Hi Daz,

I have no idea how that might have happened, I did some extensive testing on installing and uninstalling and once the plugin is uninstalled, there should be no trace of it including all the database tables. I’m guessing something else is causing your dashboard to be missing. Do you see any javascript errors in your console?

An admin login would be useful to login to check out your setup, you can email to conormccauley at gmail if you wish.

Regards,

Conor.

Hiya Conor,

When I say the dashboard is missing, your menu option is missing but is listed under plugins. If I hit settings under plugins though it just lists a blank area (but shows the dashboard menu. I guess it just needs cleaning out properly. Probably something I’ve done as made a few changes to site recently.

I’ve since emailed you the site details.

Cheers

Daz

Hi Conor!
Well making some progress in that I’m back to where I was originally.

I did an overhaul of the wp_options table as it was mahoosive. Cleared out redundant data (incl wp_athletics items) and now have the menu options back! woohoo!! I guess I corrupted the table somehow.

Everything is working, but plugin still unable to see user database. Have I tied down my permissions too tightly that this would stop your plugin communicating with the user db? Is there a tool I can utilise to track error logging (refusals etc.)?

Thanks,

Darrin

Just thinking aloud here.

I altered the wordpress database prefix some time back in an attempt to stop hacks from wp_ to something else. Could this have a bearing why it can’t “see” the users database?

Cheers

Further update…

Altered database prefix back to test and now working as far as able to see wp_users data. However “Manage Results” reveals no data at all. All other functionality appears to be working apart from Manage Results.

If you traverse to this area it shows no table entries apart from this line at the bottom…
“Showing 1 to NaN of NaN entries (filtered from 19 total entries)”

So it can see the entries I entered (19) in the dbase as test data but not displaying.

Any ideas Conor?

Please reply

Hi Darren,

Sorry for the delay been very busy recently but I will log in as admin as soon as I can and check out your setup.

In the meantime, can you browse into your wordpress database using phpMyAdmin or some other client and check if the tables all exist there.

Conor.

Hi Conor,

Yes I have access to phpMyAdmin

The only dbase I can see are:

wp_wpa_event
wp_wpa_event_cat
wp_wpa_log
wp_wpa_result

If I browse I can see the events and userdata(wpa_result).

I can post screen shots to your email addy

Thanks for coming back to me. I think we’re almost there.

Speak soon

Would appreciate some guidance on this Conor?

I also appreciate this may not be your plugin but my setup/theme, but a few things to try perhaps until you get time to look at it properly?

Just to summarise:

– “iTotalDisplayRecords”: null, which results in the summary shown as:
Showing 1 to NaN of NaN entries (filtered from 1 total entries)

Total entries is correct.

– Can see Personal Bests data from Manage Results page but no information under My Results or Statistics tab (may not be enough data).

– Viewing Manage Results via dashboard shows no results – “Showing 1 to NaN of NaN entries (filtered from 10 total entries)“

– using shortcode e.g. [wpa-event id=2] to show race results shows nothing (only the table headers) but clicking on the event link within Manage Events via dashboard shows the correct data.
https://www.suttonrunners.org/test-results

– CSS appears to behave odd (overrides) on the page when hovering?

– minor issue but personal photo is not saved when uploading thumbnail for athlete.

Thanks

Darren’s problem was that his hosting provider does not allow the creation of an SQL VIEW. This was causing no results to come back when we performed a query to the results view.

To overcome this issue, I added a setting in the plugin that allows users to disable using the view and the problem is now resolved.