potjekak

That was the solution! Thank you Antoine! Didn’t know it would reinstall all database tables. Solution solved!

I’ll try that. I’ll let you know if this option works.

Hi Antoine, the debug log says the following:

[04-Apr-2024 08:12:09 UTC] WordPress database error Unknown column 't.is_favorite' in 'field list' for query SELECT
t.id, t.name, t.photo, t.flag, t.link, g.id AS group_id, g.name as group_name, t.is_real, t.is_active, t.is_favorite, t.group_order, t.comments
FROM pool_wp_teams t

It’s like you’re a wizard ??

When I changed the year, the error appeared when doing the calculation. Just like you said. Then I ran the query above, and all was good again. The calculation worked; no error message.

I changed the year back to 2022 and all problems are solved!

Thank you very much!

• This reply was modified 2 years, 6 months ago by potjekak.

No, not finished a calculation yet. It’s for Qatar 2022, so there’s no match yet. When I run the calculation, it also says there’s nog match yet.

But I did run the query in phpMyAdmin, and the AJAX-update works! Yeah! So the solution was to alter the database. Many thanks!

• This reply was modified 2 years, 6 months ago by potjekak.

Thank you for the quick response. I get the following error in de debug:

Column 'home_score' cannot be null bij query INSERT INTO pool_wp_predictions ( user_id, match_id, home_score, away_score, has_joker ) 
VALUES ( 1, 5, NULL, 0, 0 ) gemaakt door do_action('wp_ajax_footballpool_update_team_prediction'), WP_Hook->do_action, WP_Hook->apply_filters, Football_Pool_Pool::update_prediction

I used Google Chrome and Microsoft Edge. Both of the browsers get the same error.

• This reply was modified 2 years, 6 months ago by potjekak.

Hello Antoine,

The saving of predictions on the background via AJAX calls is not working in the latest version of the Football Pool (at least with me). You see the Pool is thinking, and then the prediction disappears; a notification appears with the text that something went wrong.

When I then fill in the score, the score stays, and I can manualy save the prediction (via the save button).

The saving via AJAX calls is great… if it’s working ?? Is it possible to disable this? I can’t find it in the backend, in the admin panel, anymore.

Yeah, the query works. Now I see the questions I used back in 2018. They’re back ??
New questions do also appear when I create them! Everythin works fine!
Thanks!

The upgrade path is the same as the paths you used. I always update them immediately.
I just didn’t use it anymore since Euro 2018.

When I do a debug in WordPress, it says something about the Question Order…

WordPress databasefout: [Unknown column 'question_order' in 'order clause']
SELECT id, match_id FROM pool_wp_bonusquestions WHERE match_id > 0 ORDER BY match_id ASC, question_order ASC, answer_before_date ASC

WordPress databasefout: [Unknown column 'question_order' in 'field list']
INSERT INTO pool_wp_bonusquestions ( question, points, answer_before_date, answer, match_id, question_order ) VALUES ( 'Welk land wordt Europees kampioen?', 20, '2021-06-10 22:00', '', 0, 1 )

WordPress databasefout: [Unknown column 'q.question_order' in 'field list']
SELECT q.id, q.question, q.answer, q.points, q.answer_before_date AS question_date, DATE_FORMAT( q.score_date, '%Y-%m-%d %H:%i' ) AS score_date, DATE_FORMAT( q.answer_before_date, '%Y-%m-%d %H:%i' ) AS answer_before_date, q.match_id, qt.type, qt.options, qt.image, qt.max_answers, q.question_order FROM pool_wp_bonusquestions q INNER JOIN pool_wp_bonusquestions_type qt ON ( q.id = qt.question_id ) ORDER BY q.answer_before_date ASC, q.question_order ASC

• This reply was modified 3 years, 10 months ago by potjekak.

Hi Antoine, unfortunately there are no caching plugins, and also the option within JetPack is disabled. I tried it in Google Chrome and in Microsoft Edge, but none of these browsers show the bonus questions. It says “question saved” (in Dutch), but nothing to see.