robbylai

That’s great. Tks for quick reply and supports!

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!

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

Ah, enjoy your holiday and good luck!

Thanks

I can see the total missed points by pie chart on Statistics page. I wonder how can I see (or select by coding) this missed point for each round of the tournament (group stage; round 1-16; quarter final…) sorry for my bad english.

Rob.