mkrakowiak

I emailed him, too, with no response. No point in renewing subscription of a plugin that doesn’t get updates or even simple responses from the developer. It beats me that the free version gets updated regularly, but the premium version was last updated in May 2022. At this point, charging people a recurring fee for no work feels scammy.

Confirming that the fix works! Thank you so much!

Disabling AJAX calls in wp-config.php works for me. Thank you!

Please see the error log above. It seems similar to this issue https://www.ads-software.com/support/topic/results-not-saved/

OK, I ran WP Debug and here are the errors registered:

[15-Nov-2022 17:25:36 UTC] WordPress database error Duplicate entry ‘2-15’ for key ‘pool_wp_predictions.PRIMARY’ for query INSERT INTO pool_wp_predictions ( user_id, match_id, home_score, away_score, has_joker )
VALUES ( 2, 15, NULL, 1, 0 ) made by do_action(‘wp_ajax_footballpool_update_team_prediction’), WP_Hook->do_action, WP_Hook->apply_filters, Football_Pool_Pool::update_prediction, QM_DB->query
[15-Nov-2022 17:25:47 UTC] WordPress database error Duplicate entry ‘2-16’ for key ‘pool_wp_predictions.PRIMARY’ for query INSERT INTO pool_wp_predictions ( user_id, match_id, home_score, away_score, has_joker )
VALUES ( 2, 16, NULL, 0, 0 ) made by do_action(‘wp_ajax_footballpool_update_team_prediction’), WP_Hook->do_action, WP_Hook->apply_filters, Football_Pool_Pool::update_prediction, QM_DB->query
[15-Nov-2022 17:25:48 UTC] WordPress database error Duplicate entry ‘2-16’ for key ‘pool_wp_predictions.PRIMARY’ for query INSERT INTO pool_wp_predictions ( user_id, match_id, home_score, away_score, has_joker )
VALUES ( 2, 16, NULL, 1, 0 ) made by do_action(‘wp_ajax_footballpool_update_team_prediction’), WP_Hook->do_action, WP_Hook->apply_filters, Football_Pool_Pool::update_prediction, QM_DB->query

I’m wondering if it has something to do with the fact that I ran another pool on this website before.

Hi Antoine. I’m experiencing the same thing. One of my pool participants has reported the issue to me. See here https://share.getcloudapp.com/2Nu6dQkn.

I tried clearing the cache (Nginx and Redis Object cache) and deactivating plugins like Perfmatters, antispam etc. I also switched to asynchronous saving to see if that would help. And the page worked ok longer, but after setting up the 6th or 7th score, the message “Something went wrong while saving the prediction” popped up. I’m happy to give you access to my site’s backend if you’re available to take a look.

Thanks for your help figuring it out.

Hi Abz,

Was this addressed in the newest update to version 6.0.3.1?

Thank you!

Hi @abzlevelup. Sorry I didn’t get back to you sooner. Here are the error messages we get with version 6.0.2 installed:

[client 64.229.228.114] ModSecurity: Warning. Pattern match "(?:\\\\b(?:c(?:d(?:\\\\b[^a-zA-Z0-9_]{0,}?[\\\\/]|[^a-zA-Z0-9_]{0,}?\\\\.\\\\.)|hmod.{0,40}?\\\\+.{0,3}x|md(?:\\\\b[^a-zA-Z0-9_]{0,}?\\\\/c|(?:\\\\.exe|32)\\\\b))|(?:echo\\\\b[^a-zA-Z0-9_]{0,}?\\\\by{1,}|n(?:et(?:\\\\b[^a-zA-Z0-9_]{1,}?\\\\blocalgroup|\\\\.exe)|(?:c|map)\\\\.exe)|t(? ..." at ARGS:data[thumbnail_data]. [file "/etc/httpd/conf/modsecurity.d/rules/custom/012_i360_1_generic.conf"] [line "73"] [id "77211210"] [msg "IM360 WAF: System Command Injection Attempt||MVN:ARGS:data[thumbnail_data]||MV:data:image/jpeg base64/9j/4aaqskzjrgabaqaaaqabaad/4giosundx1bst0zjteuaaqeaaaiyaaaaaaqwaabtbnryukdcifhzwiaaaaaaaaaaaaaaaabhy3nwaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaqaa9tyaaqaaaadtlqaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaalkzxnjaaaa8aaaahrywflaaaabzaaaabrnwflaaaabeaaaabriwflaaaabjaaaabryvfjdaaaboaaaachnvfjdaaaboaaaachivfjdaaaboaaaach3dhb0aaabyaaaabrjchj0aaab3aaaadxtbhvjaaaaaaaaaaeaaaamzw5vuwaaafgaaaacahmaugbhaeiaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa [hostname "oursite.com"] [uri "/wp-admin/admin-ajax.php"] [unique_id "Y1y4Qu5iPPLIedhrLnD31AAAAIU"], referer: https://oursite.com/wp-admin/admin.php?page=mailpoet-newsletters

—————————-

AH01071: Got error 'PHP message: WordPress database error Unknown column 'date' in 'order clause' for query \n\t\t\t\t\tSELECT wp_posts.ID\n\t\t\t\t\tFROM wp_posts INNER JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id\n\t\t\t\t\tWHERE 1=1 AND wp_posts.ID NOT IN (26569) AND ( \n wp_tec_occurrences.post_id IS NOT NULL \n AND \n CAST(wp_tec_occurrences.end_date AS DATETIME) >= '2022-10-29 01:19:48'\n) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish'))\n\t\t\t\t\tGROUP BY wp_tec_occurrences.occurrence_id\n\t\t\t\t\tORDER BY date DESC, CAST(wp_tec_occurrences.start_date AS CHAR) ASC, post_date ASC\n\t\t\t\t\tLIMIT 0, 1\n\t\t\t\t made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\\Config\\Initializer->postInitialize, MailPoet\\Router\\Router->init, call_user_func, MailPoet\\Router\\Endpoints\\ViewInBrowser->view, MailPoet\\Newsletter\\ViewInBrowser\\ViewInBrowserController-...', referer: https://oursite.com/wp-admin/admin.php?page=mailpoet-newsletters

—————————-

AH01071: Got error 'PHP message: WordPress database error Unknown column 'date' in 'order clause' for query \n\t\t\t\t\tSELECT wp_posts.ID\n\t\t\t\t\tFROM wp_posts JOIN wp_tec_occurrences ON wp_posts.ID = wp_tec_occurrences.post_id\n\t\t\t\t\tWHERE 1=1 AND wp_posts.ID NOT IN (26569) AND wp_posts.post_type = 'tribe_events' AND ((wp_posts.post_status = 'publish'))\n\t\t\t\t\t\n\t\t\t\t\tORDER BY date ASC\n\t\t\t\t\tLIMIT 0, 1\n\t\t\t\t made by do_action('wp_ajax_mailpoet'), WP_Hook->do_action, WP_Hook->apply_filters, MailPoet\\API\\JSON\\API->setupAjax, MailPoet\\API\\JSON\\API->processRoute, MailPoet\\API\\JSON\\v1\\AutomatedLatestContent->getBulkTransformedPosts, MailPoet\\Newsletter\\AutomatedLatestContent->getPosts, MailPoet\\WP\\Functions->getPosts, get_posts, WP_Query->query, WP_Query->get_posts, apply_filters_ref_array('posts_pre_query'), WP_Hook->apply_filters, TEC\\Events\\Custom_Tables\\V1\\WP_Query\\Modifiers\\Events_Only_Modifier->filter_posts_pre_query, TEC\\Events\\Custom_Tables\\V1\\WP_Query\\Custom_Tables_Query->get_posts, WP_Query->get_posts', referer: https://oursite.com/wp-admin/admin.php?page=mailpoet-newsletter-editor&id=7

—————————-

[client 64.229.228.114] ModSecurity: Warning. String match "wp-admin/load-scripts.php" at REQUEST_URI. [file "/etc/httpd/conf/plesk.conf.d/modsecurity.conf"] [line "16"] [id "31346"] [msg "WordPress_Admin_Load_Scripts"] [hostname "oursite.com"] [uri "/wp-admin/load-scripts.php"] [unique_id "Y1y3MxJpvIIPXmYeVkHEOgAAAAM"], referer: https://oursite.com/wp-admin/admin.php?page=mailpoet-newsletters

I replaced the domain name with oursite.com. With version 6.0.1.1, these error messages are gone. I hope this helps to figure out the issue. Thank you!

• This reply was modified 1 year, 11 months ago by mkrakowiak.

Thank you, Martynas. I made the change, but on the chart, it still shows Data not available%. Am I missing something?

reCaptcha for WooCommerce works wonders on dedicated pages. It’s paid ($29/year through the WooCommerce portal) but worth it.

Glad to find out it’s not only on my site… It used to work with no problem a few months ago.

@robert681 Why don’t you post a comparison table between free and pro versions on your website?

• This reply was modified 3 years, 1 month ago by mkrakowiak.

Never mind! To anyone looking for the answer: the plugin does handle multiple choice questions even allowing for multiple answers with a custom amount of points per user. And that comes without any custom coding as long as the admin enters the points manually. Just read the Help page of the plugin on your website.

Thank you, again, Antoine!

• This reply was modified 3 years, 4 months ago by mkrakowiak.
• This reply was modified 3 years, 4 months ago by mkrakowiak.

Hi Antoine. Thanks again for your help and for taking the time to answer my questions.

The broken link to the example script now works! Not sure what happened there but it’s ok now.

As for using the bonus questions for what I need, can you help me understand how to go about it?

So I assume that the only way to make calculations work and to pick a goalkeeper and three top scorers is to create a bonus question for every single option, is that correct? For example, would I need to create these questions (or more) for every goalkeeper or is it possible to use a single question with select/dropdown options? But then, how do I assign points to different answers?

• Manuel Neuer in your opinion will record most games with clean sheets/no goals conceded (penalty shootouts after extra time do not count). Neuer will get points for every match with the clean sheet (2 points), and every saved penalty during the game (1 point).
• Hugo Lloris in your opinion will record most games with clean sheets/no goals conceded (penalty shootouts after extra time do not count). Lloris will get points for every match with the clean sheet (2 points), and every saved penalty during the game (1 point).
• Thibaut Courtois in your opinion will record most games with clean sheets/no goals conceded (penalty shootouts after extra time do not count). Courtois will get points for every match with the clean sheet (2 points), and every saved penalty during the game (1 point).

So in this case I would end up with Neuer getting 9 points, Lloris getting 14 points and Courtois getting 10 points. If it was possible to assign different answers to different options, it would be awesome.

Thank you!

Awesome, looking forward to it. Thank you for the nice plugin!