Closed GoogleCodeExporter closed 8 years ago
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
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
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
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
Attachments:
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
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
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
Sure, I call it perfect! ;))
Original comment by hananyaz...@gmail.com
on 15 May 2013 at 3:05
Original issue reported on code.google.com by
hananyaz...@gmail.com
on 14 May 2013 at 12:54