please help for "Manage Athletes" and Race because I've got some errors

Hi Enrico

I would try to play with the Advanced settings

https://www.dropbox.com/s/9wxjrwn24i3izai/Schermata%202015-12-30%20alle%2018.35.20.png?dl=0

If that doesn’t help, maybe disabling and activating the plugin does the trick.

Cheers Jakob

Dear Jakob,
I follow your suggestions, changed SQL-Views and NON-WP-PAGE , deactivated
and reactivated wihtout any improvement. After that I changed language from italian to english and the last I remove and reinstall this pluing without solving.
This plugin is very useful for my team and I’d like to use it. How can I do ? There are other possibilities?
Many thanks !!
Best Regards
Enrico

Sorry Enrico that’s all I can help with, maybe someone else can jump in…

I myself waiting patiently for the long awaited version 1.1.8, I guess that’s all we can do.

Cheers

Jakob

Hi Jakob, all of us hope Conor come back and give us a new version
because this plugin is very very useful.
As we all together contact him to get it back to develop his project ?
It would be really cool.
The passion for running that unites us can help us !

bye
Enrico

[resolved]
Hi all,
the problem was inside wp-athletics-db.php since there are some queries that don’t support prefix table:

“SELECT meta_value FROM wp_usermeta …”

change all lines add right table name.

Regards
Enrico

Hi Enrico

Great you found the error, so kind of you to post the fix… thank you!

About your previous post, I think Conor is working on the new version as he said so. If not I don’t think we can pressure him into doing so, life changes and sometime there isn’t enough time for everything. We shall see…

Cheers

Jakob

Hi Enrico,

I kind of understand what you have written above but not sure exactly how to make the changes you suggest.

In wp-athletics-db.php I found this section of code below that refers to “SELECT meta_value FROM wp_usermeta …”

Are you suggesting changing wp_usermeta to wp_PT9Z_usermeta (where PT9Z is my database prefix?) and anywhere else wp_usermeta crops up in this php file?

:-

// gte the actual results
$results = $wpdb->get_results(
“
SELECT u.id, u.display_name as athlete_name, u.user_login, u.user_email, date_format(u.user_registered,'” . WPA_DATE_FORMAT . “‘) as user_registered,

(SELECT meta_value FROM wp_usermeta um WHERE um.user_id = u.id AND um.meta_key = ‘wp-athletics_profile_photo’) as athlete_photo,

(SELECT meta_value FROM wp_usermeta um WHERE um.user_id = u.id AND um.meta_key = ‘wp-athletics_dob’) as athlete_dob,

(SELECT meta_value FROM wp_usermeta um WHERE um.user_id = u.id AND um.meta_key = ‘wp-athletics_gender’) as athlete_gender

FROM $this->USER_TABLE u $where ORDER BY $sortCol $sortDir LIMIT $offset,$limit
“
);

Regards

Phil

OK so I thought I’d give it a go anyway and it solved my issue with displaying members.

I found all db references to wp_ fields and replaced it with wp_PREFIX_ and all sorted.

eg. (SELECT meta_value FROM wp_usermeta um WHERE um.user_id = u.id AND um.meta_key = ‘wp-athletics_profile_photo’) as athlete_photo,

changed to

(SELECT meta_value FROM wp_PREFIX_usermeta um WHERE um.user_id = u.id AND um.meta_key = ‘wp-athletics_profile_photo’) as athlete_photo,

Many thanks

I know about my english is terrible but I’m happy to read
you post .
Thanks !
Bye
Enrico