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
QuoteYou 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..
Open Soureces/TPortal.php
// 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.
// 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,
Solved, thanks!