Unknown column '$ID_MEMBER' in 'on clause'

[tx3bass]

SMF version: SMF ver. 2.0
TP version: TP ver. here
Default Forum Language: English
Theme name and version: Custom
Browser Name and Version: FF
Related Error messages:Unknown column '$ID_MEMBER' in 'on clause'

When I click on Show latest comments in the user box I get this error
Unknown column '$ID_MEMBER' in 'on clause'
I just upgraded from SM1.14 to 2.0 and upgraded to the latest version of TP

[IchBin]

Can you post the full error with the line number and filename that is referenced please? The error doesn't happen here, or I would find out myself. lol

[tx3bass]

Unknown column '$ID_MEMBER' in 'on clause'
File: *****/Sources/TPmodules.php
Line: 237

[IchBin]

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.')

[tx3bass]

Code Select Expand

Template Parse Error!
165: echo '<br /><input name="blockbody' .$context['TPortal']['blockedit']['id']. '" type="radio" value="dl-stats3" ' , $context['TPortal']['blockedit']['body']=='dl-stats3' ? 'checked' : '' , '>'.$txt['tp-module3'];
166: echo '<br /><input name="blockbody' .$context['TPortal']['blockedit']['id']. '" type="radio" value="dl-stats4" ' , $context['TPortal']['blockedit']['body']=='dl-stats4' ? 'checked' : '' , '>'.$txt['tp-module4'];
167: echo '<br /><input name="blockbody' .$context['TPortal']['blockedit']['id']. '" type="radio" value="dl-stats5" ' , $context['TPortal']['blockedit']['body']=='dl-stats5' ? 'checked' : '' , '>'.$txt['tp-module5'];
168: echo '<br /><input name="blockbody' .$context['TPortal']['blockedit']['id']. '" type="radio" value="dl-stats6" ' , $context['TPortal']['blockedit']['body']=='dl-stats6' ? 'checked' : '' , '>'.$txt['tp-module6'].'<br />';
169: }
170: elseif($context['TPortal']['blockedit']['type']=='3'){
171: // userbox type
172:
173:

174: <br />';

175: }
176: elseif($context['TPortal']['blockedit']['type']=='15'){
177: // RSS feed type
178: echo '<br /><input style="width: 95%" name="blockbody' .$context['TPortal']['blockedit']['id']. '" value="' .$context['TPortal']['blockedit']['body']. '"><br /><br />';


[tx3bass]

I get Sorry, you are not allowed to post external links. when I try to make the lat post a BBC code

[WillyP]

Thanks to the incessant activities of the spammers, we have a mod in place to prevent links in posts, when you are under a certain post count.

I guess you missed this message, which appears when you post:

Note: We do not allow the newbies user group to post links.
Please type your link out like this if you get an error about it when posting.
"yourdomain dot com"

[tx3bass]

I am not trying to post a link I was trying to put the code in a BBC block...

[Lesmond]

tx3bass, I have edited your post for you, not sure why you cant post [code][/code] though

[tx3bass]

thanks