We are also receiving this same error: "2- In the posts which have already received one (or more) Thank You (I mean in the first installation), it is written that “For this post, 0 member gave a thank you”!."
By way of background information, we have just started to see in
some member profiles the following error:
Column 'id_msg' in where clause is ambiguous
File: /home/welovea2/public_html/JDBTest/Sources/Profile-ThankYouPost.php
Line: 199
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.2, while your database is at version 2.0.1. The above error might possibly go away if you execute the latest version of upgrade.php.
We've tried a couple of different approaches in our test forums to correct the problem, both of which resulted in the error message described by vdamanafshan.
We first deleted the error log and then recalculated the thank-o-matic stats. That resulted in elimination of the "Column 'id_msg'...... but also in the 0 posts error.
We restored our database, uninstalled our previous version of Thank-O-Matic, which was emulated for 2.0.1 and installed the current version. Again this resulted in the error described by vdamanafshan. On all previous re-installs of thank-o-matic, we have never lost data.
We do know how to access phpmyadmin but don't know what to do to fix the error.
Thanks for any assistance that can be provided.