Title: Prediction Import Extension SQL error
Last modified: November 30, 2022

---

# Prediction Import Extension SQL error

 *  Resolved [Shai-li](https://wordpress.org/support/users/shailib/)
 * (@shailib)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/)
 * Hi,
    I’m trying to use the Prediction Import extension. I tried to upload multiple
   CSV files for different users, but I keep getting the same error message: “SQL
   error for match ID […]”. Screenshot of the error: [https://snipboard.io/vfUuan.jpg](https://snipboard.io/vfUuan.jpg)
   Screenshot of the CSV: [https://snipboard.io/cmSvwx.jpg](https://snipboard.io/cmSvwx.jpg)
 * What am I doing wrong?
 * Thanks!

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16248555)
 * Not sure what is going wrong. Can you check your error logs for any errors? I
   would really like to see the SQL query that was executed.
 * I also updated the [extension plugin](https://wordpress.org/support/topic/extension-plugins-for-the-football-pool-plugin/#post-8998133)
   a bit to better match the new version of the plugin. Maybe you can also try the
   newer version of the files?
 *  Thread Starter [Shai-li](https://wordpress.org/support/users/shailib/)
 * (@shailib)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16250930)
 * Thanks, Antoine
    I updated the extension but I’m still getting the same error.
   I uploaded the error log here: [https://cloudvyzor.com/logpad/?query&database=sandbox-e97b120e48f1f6f56f471482a35dee24](https://cloudvyzor.com/logpad/?query&database=sandbox-e97b120e48f1f6f56f471482a35dee24)
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16251113)
 * Thanks. There is a duplicate key error in your log. I think I know what the problem
   is (the user that you tested with, has a partial prediction for the match). Something
   that was not possible back when I first created this extension. I will be able
   to fix this tonight.
 *  Thread Starter [Shai-li](https://wordpress.org/support/users/shailib/)
 * (@shailib)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16251122)
 * You’re the best, thank you!
 *  Plugin Author [AntoineH](https://wordpress.org/support/users/antoineh/)
 * (@antoineh)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16252575)
 * I updated the [plugin](https://wordpress.org/support/topic/extension-plugins-for-the-football-pool-plugin/#post-8998133)
   once again. Hope this helps.
 *  Thread Starter [Shai-li](https://wordpress.org/support/users/shailib/)
 * (@shailib)
 * [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16252661)
 * Thanks a lot, Antoine!
    Now it’s working perfectly. After I uploaded the CSV 
   files, I used the “recalculate scores” option from the Plugin Options screen 
   and it sorted out the rankings as well.
 * Many thanks for your hard work and patience, much appreciated!

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Prediction Import Extension SQL error’ is closed to new replies.

 * ![](https://ps.w.org/football-pool/assets/icon-256x256.png?rev=983880)
 * [Football Pool](https://wordpress.org/plugins/football-pool/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/football-pool/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/football-pool/)
 * [Active Topics](https://wordpress.org/support/plugin/football-pool/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/football-pool/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/football-pool/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Shai-li](https://wordpress.org/support/users/shailib/)
 * Last activity: [3 years, 6 months ago](https://wordpress.org/support/topic/prediction-import-extension-sql-error/#post-16252661)
 * Status: resolved