.cvs import error
-
Hi,
I’ve got the error “Invalid or missing home team value on row 2.” when trying to import the .cvs file for Matchs.
I got same error when I try the .txt file shiped.
Here the file link: https://drive.google.com/file/d/1h4Lcuaeu4I9YLB8hab0cWGZsVZyq_EdF/view?usp=sharing
Plz help to review.
Thank you!
-
Hi,
The CSV file is OK. I tested it and it worked perfectly. This means something else is happening and the only way to find out, is to enable debugging on your install (see point 3 in this post if you don’t know how to do this), retry the import and then look for clues in the error log.
Hi,
I got this on debug.log file:
[24-Mar-2021 10:16:09 UTC] WordPress database error Table 'wordpress864.pool_wp_leagues' doesn't exist for query SELECT id AS league_id, name AS league_name, user_defined, image FROM pool_wp_leagues ORDER BY user_defined ASC, name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, do_action('widgets_init'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, register_widget, WP_Widget_Factory->register, Football_Pool_Ranking_Widget->__construct, Football_Pool_Pool->__construct, Football_Pool_Pool->get_leagues [24-Mar-2021 10:16:09 UTC] WordPress database error Table 'wordpress864.pool_wp_teams' doesn't exist 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, group_order, t.comments FROM pool_wp_teams t LEFT OUTER JOIN pool_wp_groups g ON t.group_id = g.id ORDER BY t.name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, wp_widgets_init, do_action('widgets_init'), WP_Hook->do_action, WP_Hook->apply_filters, {closure}, register_widget, WP_Widget_Factory->register, Football_Pool_Ranking_Widget->__construct, Football_Pool_Pool->__construct, Football_Pool_Matches->__construct, Football_Pool_Matches->all_matches_info, Football_Pool_Teams->__construct, Football_Pool_Teams->get_teams [24-Mar-2021 10:16:09 UTC] WordPress database error Table 'wordpress864.pool_wp_matches' doesn't exist for query SELECT m.id, m.play_date, m.home_team_id, m.away_team_id, m.home_score, m.away_score, s.name AS stadium_name, s.id AS stadium_id, t.name AS matchtype, t.id AS type_id, t.id AS match_type_id, t.visibility AS match_is_visible FROM pool_wp_matches m JOIN pool_wp_stadiums s ON ( m.stadium_id = s.id ) JOIN pool_wp_matchtypes t ON ( m.matchtype_id = t.id )It’s seem your plugin doesn’t have write permission to DB.
Look fw you soon!
Thanks
There are some tables missing in the database that should have been created during the activation of the plugin. Can you try the following:
1. Check if the Football Pool plugin option “Keep data on uninstall” is set to true
2. Deactivate the plugin
3. Activate the plugin
4. Check the debug log againThis should re-install the tables in the database. If there are no new errors then you can try to import the data again. If there are errors, we should try to resolve those first.
Hi,
I’ve done as your suggests but still got same errors.
What should I do?
You can check your database for tables with the plugin’s prefix “pool_wp_”, like “pool_wp_leagues”. You can use a tool like phpmyadmin for that. If they don’t exist, then you can try the following:
1. Open the file /data/install.txt in a text editor
2. Replace all occurrences of “{$prefix}” with “pool_wp_”
3. Run the changed sql command in your database via phpmyadminIf there were already tables present in your database but maybe with a different prefix, let me know what you see. In that case I am especially interested in the prefix of my tables and the prefix of WordPress’s own tables.
Hi AntoineH,
I can’t find plugin’s prefix “pool_wp_”, like “pool_wp_leagues”.
Try the following:
1. Open the file /data/install.txt in a text editor —-> done
2. Replace all occurrences of “{$prefix}” with “pool_wp_” —-> done
3. Run the changed sql command in your database via phpmyadmin ——>WordPress database error Table ‘wordpress864.pool_wp_leagues’ doesn’t exist
No records on DB to change. It’s seems the plugin didn’t create in the table.I also try update MySQL 5.1 to 5.5; remove plugin and active again but no miracle appear.
So I have to re-install fresh wordpress with new DB. And now everything are fine, match imported!.
Many thanks for your supports!
Good to hear everything is working now. Have fun with the plugin.
The topic ‘.cvs import error’ is closed to new replies.