Problem with the Plugin -> serendipity_plugin_showentries

Creating and modifying plugins.
Post Reply
Googol
Posts: 4
Joined: Thu Nov 16, 2006 12:13 pm

Problem with the Plugin -> serendipity_plugin_showentries

Post by Googol »

Hello

Ive installed the plug and get on the front end instead of the Sidebar this

Code: Select all

Query failed:

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
                     , e.body, e.extended
                     
                FROM
                    blog_karlauer_entries AS e
                    LEFT JOIN blog_karlauer_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN blog_karlauer_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN blog_karlauer_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN blog_karlauer_authorgroups AS acl_a
                                   ON acl_a.authorid = 13
                            LEFT JOIN blog_karlauer_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )
                    WHERE isdraft = 'false' AND e.timestamp <= 1169571900 AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = acl_a.groupid OR acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY e.id
            ORDER BY timestamp DESC
                      LIMIT 0, 15, 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 ' 5' at line 44
Can someone help me?

Iam using Serendipity 1.1 and PHP 4.4.1
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Problem with the Plugin -> serendipity_plugin_showent

Post by garvinhicking »

Hi!

The error is that "Limit 0, 15, 5" statement. Could it be that you modified some plugin files, or entered some a "15, 5" string in the configuration of the amount of entries per page in the s9y configuration?

Actually that plugin should not be related to this problem, I guess it must be something else you did?

Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Googol
Posts: 4
Joined: Thu Nov 16, 2006 12:13 pm

Post by Googol »

thx a lot for this hint, there was such a string in the config :(
Your plugin works fine!!!
Post Reply