ThankYou 3.0.7 Find All Thanked Posts

[ecanikajo]

Option Find All Thanked Posts not works. When I choose this option results is all member posts.

[skywalker2208]

Have you tried to PM the author of the plug in?

Which thanked post plug in are you using? I think there is more then one.

[ecanikajo]

http://mods.mybboard.net/view/thankyou
I find only this plugin.
Author of the plugin is TechMiX. I send PM, but, Last Visit is 5-12-2009 10:03 PM.

[skywalker2208]

I will try and look at the mod at some point later today and see if I can find the issue. While oyu are waiting for a fix you could always remove the link from the template.

---

It looks like it might take some work to fix it. I would suggest removing the link till the author fixes it.

[freerider]

Came here looking for a solution to the same problem

[TechMiX]

Hi everyone ,

This problem occurs when you use this plugin on version that are greater than 1.4.4 . @ first I designed this feature for 1.4.4 , but then in the greater versions , search.php got some changes that made this feature unusable ... I can fix it for later versions , but it will stop working for older ones ...

I'm thinking how to figure this out .. till then, use this trick to bring it alive :

Open thx.php in inc\plugins folder of your forum , find this line :

global $mybb,$where_sql,$db,$searcharray;

replace with:

global $mybb,$where_sql,$db,$searcharray,$pids,$options;

also search for this :

$searcharray["querycache"] = $db->escape_string($where_sql);

replace it with this piece of code :

$query = $db->simple_select("posts", "pid", "{$where_sql}", $options);
$pids = "";
$comma = "";
while($pid = $db->fetch_field($query, "pid"))
{
	$pids .= $comma.$pid;
	$comma = ",";
}
$searcharray["posts"] = $db->escape_string($pids);

by the way , srry for my bad attendance !

[AndrewPH]

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1054 - Unknown column 'p.thx' in 'where clause'
Query:
SELECT pid FROM xxxx WHERE uid='1' AND NOT p.thx='0' ORDER BY dateline DESC

doesnt work

[AndrewPH]

any fix from the author?

[Sammyed]

Well...I changed the code as the author suggested and...the search still goes to all the posts and not only the "Thanked posts".

[ecanikajo]

any fix from the author?

TechMiX is the author.

Well...I changed the code as the author suggested and...the search still goes to all the posts and not only the "Thanked posts".

Same problem.