Unknown column '$ID_MEMBER' in 'on clause'

[IchBin]

Did you make some other edit? The edit I gave you does not edit a template. It edits a source file. If you take the edit out, does the forum load again?

[tx3bass]

ya that was my fault.  your code did fix it... thanks a lot...

[Lum-chan]

Maybe it's a good idea to mark this topic as Solved? Worked for me too

[Martine M]

Thanks IchBin I changed  the lines.

[clothahump]

Thank you!

Yep, looks like a mistake on my part.

Find this line in TPmodules.php

Code Select Expand

LEFT JOIN {db_prefix}tp_data as log ON (log.value = art.id AND log.type = 1 AND log.ID_MEMBER = $ID_MEMBER)

Replace with this line:

Code Select Expand

LEFT JOIN {db_prefix}tp_data as log ON (log.value = art.id AND log.type = 1 AND log.ID_MEMBER = '.$ID_MEMBER.')

Got this problem in latest version of TP, lines to change are different to what you have posted here. 

[IchBin]

If you received this error after your upgrade, it is likely that your file did not get replaced as this error was fixed. On line 231 in TPmodules.php it now uses $context['user']['id'] instead of $ID_MEMBER.

Attach your file if you still need assistance.

[clothahump]

Looks like I made a mistake, errors were out of date, sorry.

[IchBin]

It's a good idea to clear that log and see if you get more.

[clothahump]

Cleared it earlier and nothing to report yet, normally would be something by now so looks good.