Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: glx_recent_articles
New version 0.3
I just updated the plugin, it now selects the permlink mode that is set under preferences instead.
Johan Nilsson
Offline
Re: glx_recent_articles
Cool. Thanks heaps Johan…
I’ll test it out now and tell you how it goes…
Offline
Re: glx_recent_articles
Works beautifully!
Thanks again Johan…
Offline
Re: glx_recent_articles
Doesn’t seem to work with RC3 latest revisions (around 280).
When I enable the plugin and active PHP error reporting I got this one :
Error 2 mysql_num_rows(): supplied argument is not a valid MySQL result resource in mysql_num_rows(), /usr/home/ludysnet/domains/shadowrun.fr/public_html/textpattern/lib/txplib_misc.php(304) : eval()’d code line 319
The plugin is called with < txp:glx_recent_articles section=“article” /> and he return a “no articles” string.
Offline
Re: glx_recent_articles
Thats strange, it doesnt show anything here when i have error reporting on.
But the way this plugin handles mysql queries should be changed so it uses txp functions instead, in fact this was my first plugin and i didnt realy understand how to use them at that point
but if you want to do some debugging you could search for the $query = “SELECT…” row and place a echo before and see what it outputs.
Johan Nilsson
Offline
Re: glx_recent_articles
Osei, could you provide link to version 0.2 (for pre-RC3) back?
Offline
Re: glx_recent_articles
ahh ofcourse, 0.2 is now available for download again, you can find it here
Johan Nilsson
Offline
Re: glx_recent_articles
Thanks a lot!
Offline
Re: glx_recent_articles
So I come back to this :)
Osei, you wanted an echo of the constructed query ?? It’s SELECT *, id as thisid, unix_timestamp(Posted) as posted FROM textpattern WHERE Status = 4 and Posted <=now() AND Section = 'article' ORDER BY Posted desc limit 0,10
I still got the no article string, I’m now with RC3#336.
Offline
Re: glx_recent_articles
Jeremie, i cant see anything wrong with the query, i feel dumb to ask but are you sure that you have articles posted to the section article?
Johan Nilsson
Offline
Re: glx_recent_articles
I had the same reaction, I even checked. Yes i have :)
Offline
Re: glx_recent_articles
If you run the query direct in for example phpmyadmin does it return anything for you?
Johan Nilsson
Offline