error in your SQL syntax, mem.realName,art.author

[sona67]

SMF version: SMF ver. 1.1.13
TP version: TP ver. 1.102
Default Forum Language: English UTF8
Theme name and version: SMF default
Browser Name and Version: tried on IE8/Firefox, and Chrome

Error message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(mem.realName,art.author) as realName FROM smf_tp_articles AS art
LEFT JOIN s' at line 2
File: /host/Sources/TPortal.php
Line: 1770

The error happens when activating a "Articles in a Category" within Front Panel Block. Please see picture attached.

When I search for "mem.realName,art.author", there are actually 5 threads on it - but they are related on upgrades that caused the problem

PS: what I intended to do is to put an article on top of the forum board..

[IchBin]

Open Soureces/TPortal.php

Code (find) Select Expand

   // any cat listings from blocks?
    if(isset($test_catbox) && $fetchtitles!='')
{
$request =  tp_query("SELECT art.id, art.subject, art.date, art.category, art.authorID, art.shortname

Put a comma right after shortname.

Code Select Expand

   // any cat listings from blocks?
    if(isset($test_catbox) && $fetchtitles!='')
{
$request =  tp_query("SELECT art.id, art.subject, art.date, art.category, art.authorID, art.shortname,

[sona67]

Solved, thanks!