The summarize post on pages doesn't work!

[GoogleCodeExporter]

BEFORE YOU FILE: Are you using the latest version of the CCTM?  Please
check http://wordpress.org/extend/plugins/custom-content-type-manager/
Yes

What steps will reproduce the problem? (Be specific enough so that someone
else can make the plugin fail for themselves. Remember: the issue can't
be fixed if it can't be reproduced!)
1.Upgrate to the new version of CCTM
2.
3.

What is the expected output? What do you see instead?
A page with the listing of posts, from a specific custom type, made with the 
summarize-post tool available.

Does the problem continue if you disable all other plugins? (plugin
conflicts cause a LOT of problems, so please isolate the problem)
The page is empty.

Please copy and paste the system information that appears in a yellow
textarea when you click on "Report a Bug" on any CCTM admin screen (this
includes the version of the
plugin, the version of PHP, the version of MySQL, a list of other active
plugins etc.):

Original issue reported on code.google.com by hananyaz...@gmail.com on 14 May 2013 at 12:54

[GoogleCodeExporter]

See https://code.google.com/p/wordpress-custom-content-type-manager/wiki/Invalid

Original comment by ever...@fireproofsocks.com on 14 May 2013 at 12:56

• Changed state: Invalid

[GoogleCodeExporter]

Sorry for the lack of info.
Here are the system information, from the big yellow textarea. I hope it will 
help

*SYSTEM INFO* 
------------------------ 
Plugin Version: 0.9.7.2-pl
WordPress Version: 3.5.1
PHP Version: 5.4.11
MySQL Version: 5.5.29
Server OS: WINNT
Language: 
------------------------ 
ACTIVE PLUGINS: 
 * Add Link to Facebook v.1.183 [http://wordpress.org/extend/plugins/add-link-to-facebook/]
 * Advanced Featured Post Widget v.2.8.6 [http://wasistlos.waldemarstoffel.com/plugins-fur-wordpress/advanced-featured-post-widget]
 * Advanced Post List v.0.3.b6 [http://ekojr.com/advanced-post-list/]
 * Akismet v.2.5.7 [http://akismet.com/?return=true]
 * All In One SEO Pack v.2.0.1 [http://semperfiwebdesign.com]
 * Auto Post Thumbnail v.3.3.2 [http://www.sanisoft.com/blog/2010/04/19/wordpress-plugin-automatic-post-thumbnail/]
 * Auto ThickBox Plus v.1.9 [http://attosoft.info/en/blog/auto-thickbox-plus/]
 * Contact Form 7 v.3.4.1 [http://contactform7.com/]
 * Dynamic To Top v.3.4.2 [http://www.mattvarone.com/featured-content/dynamic-to-top/]
 * Dynamic Widgets v.1.5.4 [http://www.qurl.nl/dynamic-widgets/]
 * Edit Flow v.0.7.6 [http://editflow.org/]
 * WordPress Editorial Calendar v.2.7 [http://stresslimitdesign.com/editorial-calendar-plugin]
 * Enhanced Text Widget v.1.4.1 [http://pomelodesign.com/enhanced-text-widget]
 * Intuitive Category Checklist v.1.0.1 [http://www.truimage.net]
 * jQuery Archive List Widget v.2.0.1 [http://skatox.com/blog/jquery-archive-list-widget/]
 * Limit Login Attempts v.1.7.1 [http://devel.kostdoktorn.se/limit-login-attempts]
 * Meteor Slides v.1.5.1 [http://www.jleuze.com/plugins/meteor-slides]
 * Polylang v.1.1 [http://polylang.wordpress.com/]
 * Really Simple CAPTCHA v.1.6 [http://contactform7.com/captcha/]
 * Simple History v.1.2 [http://eskapism.se/code-playground/simple-history/]
 * Simple Image Widget v.3.0.3 [https://wordpress.org/extend/plugins/simple-image-widget/]
 * Slideshow Gallery v.1.2.3.2 [http://wpgallery.tribulant.net]
 * Social Media Feather v.1.2.1 [http://synved.com/wordpress-social-media-feather/]
 * Social Media Widget v.4.0.2 [http://wordpress.org/extend/plugins/social-media-widget/]
 * Statpress Visitors v.1.5.4 [http://additifstabac.webuda.com/index.php/statpress-visitors-new-statistics-wordpress-plugin/]
 * TW Pagination v.1.0 [http://vuckovic.biz/wordpress-plugins/tw-pagination]
 * Wordfence Security v.3.6.8 [http://www.wordfence.com/]
 * WordPress File Monitor Plus v.2.2 [http://l3rady.com/projects/wordpress-file-monitor-plus/]
 * WordPress Importer v.0.6.1 [http://wordpress.org/extend/plugins/wordpress-importer/]
 * WP-Mail-SMTP v.0.9.1 [http://www.callum-macdonald.com/code/wp-mail-smtp/]
 * WP Security Scan v.3.0.9 [http://www.websitedefender.com/news/free-wordpress-security-scan-plugin/]
 * Wysija Newsletters v.2.4.4 [http://www.wysija.com/]
------------------------ 
CURRENT THEME: Generated with Lubith v. http://www.lubith.com

Original comment by hananyaz...@gmail.com on 14 May 2013 at 6:24

[GoogleCodeExporter]

Dear Everett,
I tried many things to understand the problem (deactivate all the other 
plugings, etc). But at the end, it seems that the problem is in the getPost 
query.
It's working perfectly well with the widget.
But when I use the summarize post in a page, the query doesn't work anymore.

The query generated by the summarize_post includes automatically a "WHERE" 
parameter with meta_key = 'data' that doesn't work.
I used the "help" argument, in my shortcode, and I had the following message:

Errors : There were no errors.
Warnings : Search parameters ignored: search_term and search_columns must be 
set.
Notices : Filtering on direct column/value: data: = author,parent,thumbnail
Execution Time : 0.00 seconds
Arguments: 
    orderby: ID
    order: DESC
    post_type: Array (my_custom_type)
    omit_post_type: Array (revision, nav_menu_item, wpcf7_contact_form)
    post_status: Array (publish, inherit)
    taxonomy_depth: 1
    search_columns: Array (post_title, post_content)
    join_rule: AND
    data: author,parent,thumbnail
    match_rule: contains
    date_column: post_modified

And here is the resulting sql query:
SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_postmeta ON 
wp_posts.ID=wp_postmeta.post_id WHERE ( 1 AND (wp_postmeta.meta_key = 'data' 
AND wp_postmeta.meta_value = 'author,parent,thumbnail') AND wp_posts.post_type 
NOT IN ('revision','nav_menu_item','wpcf7_contact_form') AND wp_posts.post_type 
IN ('my_custom_type') AND wp_posts.post_status IN ('publish','inherit') ) GROUP 
BY wp_posts.ID ORDER BY wp_posts.ID DESC

That doesn't retrieve any record. The parameters that are making problem are: 
"(wp_postmeta.meta_key = 'data' AND wp_postmeta.meta_value = 
'author,parent,thumbnail')"

I didn't change anything in my parameters and my database. And whatever I do in 
the summarize_post, the query includes the same parameters.
Do you have any idea why this problem appeared? And how to correct it?

Thanks a lot

Original comment by hananyaz...@gmail.com on 14 May 2013 at 2:10

[GoogleCodeExporter]

thank you for providing the details.

The wrong code must be in the GetPostsQuery class.  I've had trouble with WP 
packaging on and off.  Check your copy: on line 949, it should have a case for 
'join':

        case 'join':

That was added re issue #480.

The correct working code should be in the current package... it is in the dev 
branch.

Original comment by ever...@fireproofsocks.com on 14 May 2013 at 3:40

• Changed state: InReview

Attachments:

• GetPostsQuery.php

[GoogleCodeExporter]

I wrote unit tests for this and released them in 0.9.7.3, so please download 
the latest version and see if that corrects the problem.  I couldn't reproduce 
this, however. 

Original comment by ever...@fireproofsocks.com on 14 May 2013 at 7:54

• Changed state: CouldNotDuplicate

[GoogleCodeExporter]

Thanks Everett.
I downloaded this new version. And it's working again.
But the strange thing is that even before, the case for 'Join' was included (it 
was the newest version, updated the 13th). Did you change any thing else?
Anyway, it's working perfectly now.
Thanks again!

Original comment by hananyaz...@gmail.com on 15 May 2013 at 12:30

[GoogleCodeExporter]

I released 3 versions of the plugin yesterday: the current is 0.9.7.5, so yes, 
I've changed a lot of things.  I don't know what would have caused the problem 
you experienced.  I'd have to look at the old copy of the file to see where it 
was failing, but it's not worth the time to do that -- if the new one works, 
call it good :)

Original comment by ever...@fireproofsocks.com on 15 May 2013 at 2:41

[GoogleCodeExporter]

Sure, I call it perfect! ;))

Original comment by hananyaz...@gmail.com on 15 May 2013 at 3:05