Serendipity Forums

Code: Select all

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.username AS loginname,
                    a.email
                     
                     
                FROM
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                    INNER JOIN serendipity_entrytags AS entrytags ON (e.id = entrytags.entryid) 
                     WHERE e.timestamp >= 1324335600 AND e.timestamp <= 1324421999 AND isdraft = 'false' AND e.timestamp <= 1356011400 AND entrytags.tag = _utf8  'video' COLLATE utf8_general_ci 
                     GROUP BY e.id
                     
                     ORDER BY timestamp DESC
                      LIMIT -10, 5

/ 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 '-10, 5' at line 33

Code: Select all

$e     = serendipity_fetchEntries(array(($mints-$max_age*86400),
                                            ($maxts-$min_age*86400)), $full, $max_entries);

Code: Select all

echo "Executing serendipity_fetchEntries with parameters:
mints: $mints
max_age: $max_age
maxts: $maxts
full: $full
max_entries: $max_entries";

Code: Select all

Executing serendipity_fetchEntries with parameters: mints: 1358118000 max_age: 365 maxts: 1358204399 full: max_entries: 5Query failed:

Code: Select all

echo "Executing serendipity_fetchEntries with parameters:
mints: $mints
max_age: $max_age
maxts: $maxts
full: $full
max_entries: $max_entries
page: {$serendipity['GET']['page']}
fetchlimit: {$serendipity['fetchLimit']}
URL: {$_SERVER['REQUEST_URI']}
";

Code: Select all

Executing serendipity_fetchEntries with parameters: mints: 1358290800 max_age: 365 maxts: 1358377199 full: max_entries: 5 page: 94 fetchlimit: 15 URL: /blog/ Query failed:

Code: Select all

Executing serendipity_fetchEntries with parameters: mints: 1358290800 max_age: 365 maxts: 1358377199 full: max_entries: 5 page: 25 fetchlimit: 15 URL: /blog/categories/5-Hobbies Query failed:

Code: Select all

Executing serendipity_fetchEntries with parameters: mints: 1358290800 max_age: 365 maxts: 1358377199 full: max_entries: 5 page: 2 fetchlimit: 15 URL: /blog/plugin/tag/linux Query failed: