GetPostsQuery fails when you use a custom database prefix

[GoogleCodeExporter]

I've created a custom post type, created a image field, given no specific 
parameters and cliked save.

Added content in this specific content type, clicked the button to add image, 
popup shows up but there are no image list.

Weird thing is that pagnitation seems to be working fine in the popup window.

Happens on all my websites that use the plugin.

this bug as been there since 0.9.5 and is still there in 0.9.5.2 (i've tested 
them all)

*SYSTEM INFO* 
------------------------ 
Plugin Version: 0.9.5.0-pl
WordPress Version: 3.3
PHP Version: 5.3.6
MySQL Version: 5.1.52-cll
Server OS: Linux
------------------------ 
Other Active plugins: 
 * All in One SEO Pack v.1.6.13.8 [http://semperfiwebdesign.com]
 * Contact Form to DB Extension v.2.2.4 [http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/]
 * Contact Form 7 v.3.0.2.1 [http://contactform7.com/]
 * DBC Backup v.1.1 [http://www.t3-design.com/]
 * Google Analyticator v.6.2 [http://ronaldheft.com/code/analyticator/]
 * Google XML Sitemaps v.3.2.6 [http://www.arnebrachhold.de/redir/sitemap-home/]
 * Hello Dolly v.1.6 [http://wordpress.org/extend/plugins/hello-dolly/]
 * qTranslate v.2.5.25 [http://www.qianqin.de/qtranslate/]
 * Really Simple CAPTCHA v.1.2 [http://ideasilo.wordpress.com/2009/03/14/really-simple-captcha/]
 * WP Nivo Slider v.2.0 [http://www.nerdhead.com.br/en/wp-nivo-slider-en/]

Original issue reported on code.google.com by tobiushi...@gmail.com on 4 Jan 2012 at 12:53

Attachments:

• cctm_site.cctm.json

[GoogleCodeExporter]

Thanks for filing this in the bug tracker. 

I'm not able to duplicate this behavior in 0.9.5.3.  See the screencast here: 
http://screencast.com/t/qzWTSQtI

You should update to the latest version of the CCTM -- there were some bugs 
with this specifically in 0.9.5.0.

You can also try using the "Upload" button on your image fields (which fires up 
WP's media browser), then click on its "Media Library" tab...  you can select 
images there by selecting them and clicking the "Insert into Post" button.

Have you tried disabling all other plugins to verify whether the problem 
persists?  

Beyond that, I'd need to troubleshoot this on your server because it could be 
an environment issue (WP admin login and FTP login), but I'm leaning on this 
being something that's already fixed in 0.9.5.3 (the most current release as of 
this writing).

Original comment by ever...@fireproofsocks.com on 4 Jan 2012 at 1:08

• Changed state: CouldNotDuplicate

[GoogleCodeExporter]

Helo,

I've update to WP 3.3.1 and update to CCMT 0.9.5.3.  I've also disabled every 
plugin that my website uses and the problem still persists. 

I've also tried the media library method, which inserts nothing in the image 
field upon clicking on "insert into post".

I've deleted every plugins and the problem is still present

Original comment by tobiushi...@gmail.com on 4 Jan 2012 at 2:05

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I got your login info and I deleted the comment -- don't want logins floating 
around the bug tracker.  I'll need an FTP login to see what's causing this.  
Use the email address here: http://fireproofsocks.com/index.php/contact

Original comment by ever...@fireproofsocks.com on 4 Jan 2012 at 3:04

[GoogleCodeExporter]

Found it: custom database prefixes are causing this.  I didn't test that in my 
environments ... boo...  Working to find the fix now.

Original comment by ever...@fireproofsocks.com on 4 Jan 2012 at 4:07

• Changed title: GetPostsQuery fails when you use a custom database prefix
• Added labels: Milestone-Release0.9.5

[GoogleCodeExporter]

Ok, I tested this on your server.   Man, sorry about that -- I fixed this on a 
separate site that didn't have SVN and that fix didn't make it into the repo 
until now.

Committed revision 484273.

0.9.5.4 just got pushed live -- should show up in for downloading shortly.

Original comment by ever...@fireproofsocks.com on 4 Jan 2012 at 4:16

• Changed state: Fixed

[GoogleCodeExporter]

Alright ! Thanks for your quick support ! That rocks !

And by the way, don't need to be sorry, the account was for dev
purpose so didn't mind if you tested some things out

Have a good one!

Original comment by tobiushi...@gmail.com on 4 Jan 2012 at 1:12