Re: edit post query failed

Hi Pierre!

> Could you send me a SQL request, I could execute in phpMyAdmin to
> prouve my server provider they have something corrupted ?

Yes. Maybe it looks familiar to you *g*:

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

                     a.realname AS author,
                     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


                     GROUP BY e.id
                     ORDER BY timestamp DESC
                      LIMIT 0, 12

Best regards,
Garvin

-- 
++ Garvin Hicking | Web-Entwickler [PHP]    | www.garv.in | ICQ 21392242
++ Developer of   | www.phpMyAdmin.net      | www.s9y.org

++ Make me happy  | http://wishes.garv.in


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642