Serendipity Forums

Query failed: <pre>SELECT count(DISTINCT e.id) AS orderkey


FROM
serendipity_entries AS e
LEFT OUTER JOIN serendipity_entryproperties ep_no_frontpage
ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
LEFT OUTER JOIN serendipity_entryproperties ep_cache_body
ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
LEFT OUTER JOIN serendipity_entryproperties ep_access
ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
WHERE e.timestamp >= 1259622000 AND e.timestamp <= 1262300399 AND isdraft = 'false' AND (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1)) AND (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')


ORDER BY orderkey DESC, timestamp DESC,/*categorytemplate*/
</pre> / 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 '' at line 17

$eventData['orderby'] = $this->sort_order;

$eventData['orderby'] = $this->sort_order . (!empty($this->sort_order) ? ',' : '') . $eventData['orderby'] . '/*categorytemplate*/';

garvinhicking wrote:Instead of !empty($this->sort_order) it should've read !empty($eventData['orderby'])

garvinhicking wrote:As for the other problem: Are you using french as the version for your backend? Maybe it cannot properly parse the entities. Would you maybe allow me to ftp-access your installation to try some debugging? I can't reproduce it on my machine, but I'd love to get a hold of this errors!