No Data Displaying

I’ve got the same problem. I think this plugin isn’t supported anymore.

I try support it ?? but I work a full time job and spend my evenings training and I spend my nights sleeping. I put months of effort into this plugin and released it when I thought it was stable, stable enough for a hobby project. I get too many requests from people wanting me to fix different issue but I simply don’t have the time right now.

Without any information I can’t immediately tell you what’s wrong. All I suggest for now is in the general settings page, switch the ‘disable SQL view’ option to on.

Not getting any information back here, closing topic.

Ok I’ve just installed the plugin on a local site and an hosted site and both give the same problem: When I try to add event it seem all right but then nothing is displayed. I tried all the combination in andvanced options but nothing good. I looked at the tables but they are all empty. It seems something is going wrong when adding the record. Is there something I can do for helping you?

Can you check your local database and tell me if all the WPA tables have been created.

Please list me all the tables with the prefix wp_wpa and also check if the view v_wpa_results exists.

3 tables
_wpa_event_cat
_wpa_log
_wpa_result
and no it didn’t create the view. I tried both the options about view in settings. Locally I use a standard XAMPP installation

All the tables are empty. It’s the last wordpress 4.21 with the default plugins

You are missing wpa_event from your list.

There is no reason you shouldn’t be able to create a view locally but the application should still work without a view. You just need to enable the “Disable SQL View” setting in the advanced tab.

Maybe delete the plugin, download the latest version and try again.

Ok. Being a programmer ( not in the php/WP area ) I tried it in a fresh new WP installation. As I mentioned I tried both the options in settings about using views. I tried the same things on a hosting on one.com and with the same results. Not working a no event table created. I tried the same things on aruba.com and I had the same results. If I’ll find some time I’ll try to investigate why event table isn’t created. Bye

Ok I’ve tried to take a quick look on the code and I’ve found the problem: the problem is in the SQL that create the event table

CREATE TABLE $this->EVENT_TABLE (
……
event_type varchar(10),
……….
event_type varchar(10) DEFAULT NULL,
……….
UNIQUE KEY id (id)
);

as you see the event_type column is duplicated. Corrected this and “reinstalled” it works everywhere. Hope this helped.
I’m a programmer, a runner and a coach on the local team. I HAD to help to find the problem…..Bye

Ok that would explain that and thanks for spotting the bug. I’ll make a fix and release later.

Awesome – for me I ended up putting an earlier version of wordpress and got things working. It meant though I needed to run two separate sites. I understand the author is awesome A for sharing and B that he still is a runner so I get the no time.

I am up at 530am running working, getting home, food, family time, sleep. Repeat ??

Thanks for sharing originally. Sorry I didn’t get back on and give some more info.

So conormccauley does this mean that a fix will come out to support the latest wordpress?

thanks Graham

Hi Graham,

I’ll have a fix out this evening. Lucky for you I’ve been injured so I’ve had a lot of time to work on the project ??

Conor.

Conor,

Did that fix go out? I’ve seemingly got the same issue as Parme62 with a clean install of both WP 4.2.1 and WP Athletics 1.1.6 this evening. Installation _seemed_ to go ok, but adding a new event does nothing (the new event modal vanishes but nothing is stored). Looks like no wpa_event table has been created.

Any ideas?

Hi hyppy.

There was still a big in 1.1.6 causing problems with the creation of some tables (naughty me for not testing properly). This has now been fixed in version 1.1.7 along with some other new enhancements. Please try this version and let me know how you get on.

Thanks,

Conor.

Looks to have sorted things. Thanks, Conor!