Euro 2024 import matches

  • Resolved potjekak

    (@potjekak)


    11 months, 3 weeks ago

    Hi Antoine, I love the football pool, and using it every major football competition (Euro and World Cup). Now I’m trying to import matches from the .csv of Euro 2024 in the new version (UEFA-EURO-2024-en_US-en_GB.csv), but I’m getting the following error message:

    Dutch: “Ongeldige of missende thuisteam waarde op rij 2.”
    English: “Invalid or missing home team value on row 2.”

    Do you have any idea what is wrong?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter potjekak

    (@potjekak)

    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

    Plugin Author AntoineH

    (@antoineh)

    Looks like one of the upgrades didn’t work out well. I will check tonight and can give you some update scripts to solve it.

    Other option, at least if you don’t have any football pool data that you would like to keep, is to deactivate the plugin with the “keep data on uninstall” option disabled and then activate it again. That will reinstall all database tables.

    Thread Starter potjekak

    (@potjekak)

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

    Thread Starter potjekak

    (@potjekak)

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

    Plugin Author AntoineH

    (@antoineh)

    Just make sure you enable the data setting when you want to keep the data when you disable the plugin ??

    Although, it is enabled by default to avoid accidental deletes.

    cheesecity

    (@cheesecity)

    Hi potjekak, Are you willing to share that file?

    UEFA-EURO-2024-en_US-en_GB.csv

    Kind regards,
    Marcel

    Hi,
    Can you please share that CSV file?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Euro 2024 import matches’ is closed to new replies.