Topic: WP-Download Manager hides all files after WP update (Read 2229 times)

Fabio · « **on:** 21 November 2009, 15:38 »

Hi to all.

Yesterday I've updated my WP from 2.8.5 to 2.8.6 and I've noticed that all the files in my downloads page are disappeared, so I've gone in WPD settings and all the permissions was switched to "Hidden". This is the second time that happens, also in the update from 2.8.4 to 2.8.5.

There's a way to resolve this problem? Isn't funny to switch all the permissions for many files and I won't touch the sql query anytime it happens 'cause I'm not so good as programmer and I could do troubles soon or later.

MySQL: 4.0.30-standard-log
PHP: 5.2.11

Thanks and sorry for my bad english.

GaMerZ · « **Reply #1 on:** 21 November 2009, 15:50 »

I am aware of this issue, still finding way to fix it. The only way to solve this now is to run sql query, http://forums.lesterchan.net/index.php/topic,3858.msg26862.html#msg26862

Fabio · « **Reply #2 on:** 21 November 2009, 21:49 »

Hi Lester, thanks for your kind reply.

I had read the post in the link and I've just 2 questions:

1. Isn't strange that this happens to me and Aldo that (maybe), both using WP in italian?

2. The code that you wrote in that post it must to be used only when the bug appears at any update?

GaMerZ · « **Reply #3 on:** 22 November 2009, 08:12 »

1. Yeap. I am still figuring it out, technically the upgrade code should not work this way.
2. Yes

Fabio · « **Reply #4 on:** 27 November 2009, 22:56 »

I've found the problem.

Today I've disactivated all the plugins to test a problem with an user, so when I've reactivated it, the files in the "Manage Downloads" was all hidden.

So I've tried the query script in the other thread but MySQL replied:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$wpdb->query("UPDATE $wpdb->downloads SET file_permission = -2 WHERE file_permis' at line 1

Surely I've wronged something 'cause I'm not good as programmer.

GaMerZ · « **Reply #5 on:** 28 November 2009, 06:35 »

I just check the query is ok. If you want to paste the SQl code into the query window, you cannot include php code. I got a feeling you paste the php code.

You should just paste:

Code: [Select]

UPDATE wp_downloads SET file_permission = -2 WHERE file_permission = -1;

Fabio · « **Reply #6 on:** 28 November 2009, 08:42 »

I've "queryied" the entire code that you wrote in the other thread!

Sorry, I'm musician and a graphician, I'm able more with an instrument or Photoshop that with codes! ;-)

So, next time I'll disactivate the plugin (until you'll resolve the problem), can I know which will be the correct string to launch? May you be more detailed also for the idiot as me, please? I suppose that I've must to go in the phpMyAdmin, see the state of the files (-2 or -1 or 0) and launch the string that fit exactly for the problem?!

Please as soon you can do, fit this problem and create a sort of radio button or similar to un/select it.

Thanks for all that you do for us.

GaMerZ · « **Reply #7 on:** 28 November 2009, 08:57 »

Run this query:

Code: [Select]

UPDATE wp_downloads SET file_permission = -2 WHERE file_permission = -1;
Then:

Code: [Select]

UPDATE wp_downloads SET file_permission = -1 WHERE file_permission = 0;
Then:

Code: [Select]

UPDATE wp_downloads SET file_permission = 0 WHERE file_permission = 1;

Confession · « **Reply #8 on:** 05 January 2010, 08:36 »

I've the same problem as well on an English installation of WordPress. All files reverted to Hidden status after WP upgrade.

TheDesigner · « **Reply #9 on:** 06 January 2010, 19:30 »

WP 2.9.x
Theme Pixeled 1.5
jasonthedesigner.com
WP Download (latest)
mySQL 5, PHP 5

I upgraded from WP 2.8x to 2.9x (English) with no problems.
I installed WP-SuperCache (latest) and then this happened.

I then deactivated WP-SuperCache.

I then ran your MySQL queries to correct the issue and nothing happened. All files still hidden.

:-)

Also, you should state that you require 1 capital and 1 digit for your registration password to prevent having to re-enter the info twice. Having the fields red with an exclamation point next to it means to me that the two fields should match. I though I would get the check mark when they matched. Found out the requirements after submitting.

Forgive me if it is stated somewhere on the page I did not notice.

Love the plugin, thanks for the continued work.

GaMerZ · « **Reply #10 on:** 07 January 2010, 04:05 »

Did you run the query one after the other instead or running them together?

The registration is automated by the forum (SMF)

syntaxys · « **Reply #11 on:** 07 January 2010, 16:37 »

First a big THX to your work, it helped me a lot! I got the same problem after upgrading to 2.9.1 as english version. I'm using WP since some days and I still have to find out all the possible things. After an upgrade of WP all the plugins might be deactivated by default? And then, always you reactivate the DLM plugin, a change of the file permissions is initiated at line 1466 of wp-downloadmanager.php:

Code: [Select]

$update_permission_1 = $wpdb->query("UPDATE $wpdb->downloads SET file_permission = -2 WHERE file_permission = -1;");
I'm a PHP developer and I took only a glance to the script, to short to understand all functions for writing a fast patch. Right now I don't understand the need of an update of the file permissions at this place. IMHO it would be just enough to initialize that variable against a case condition. Any idea?

Regards
Achim

GaMerZ · « **Reply #12 on:** 07 January 2010, 16:51 »

Oh yes, I overlook that, I need to check whether they are on a prev version first.

I have updated it, http://plugins.trac.wordpress.org/changeset/191137 . This should fix it.

syntaxys · « **Reply #13 on:** 07 January 2010, 20:20 »

Yes, it works great. Thanks a lot!

But please remove the trailing dot from the link above, otherwise it does not work properly

Regards
Achim

GaMerZ · « **Reply #14 on:** 08 January 2010, 07:04 »

Thanks for the feedback

TheDesigner · « **Reply #15 on:** 08 January 2010, 18:31 »

How would I modify this code (from your link above) on my end from my own WP Admin?

GaMerZ · « **Reply #16 on:** 08 January 2010, 18:36 »

You can just download the Dev version http://downloads.wordpress.org/plugin/wp-downloadmanager.zip and replace the files.

TheDesigner · « **Reply #17 on:** 08 January 2010, 18:47 »

Thx for the help Lester!

SaltAireMo · « **Reply #18 on:** 12 January 2010, 21:10 »

I did a test of this plug in on a site I already had up running wordpress 2.8.4. It worked great. I was using Mondo Zen Theme. wp-downloadmanager 1.5.

I created a new site, installed wordpress 2.9.1 and it appeared everything was working ok until I started testing the downloads. I kept getting 404 message. I switched to default theme and deactivated all other plug ins. Got the same error. After several attempts I created a work around using the first test that I had created on a site running wordpress 2.8.4. I'm going to need to come up with a better solution eventually. Unfortunately, I am a designer and don't know the first thing about running a querry or any of the other cool stuff you mentioned in the other solutions.

All this to say, it appears that it does not work with new installs of wp 2.9.1.
other info: php: 5.2.11, MYSQL: 5.1.42 tried in url:www.buybelvedere.com/contact/retailer-log-in & www.tuttledesigns.com

I think God is trying to tell me to quit technology and try fine arts. Any ideas?

ps. love the plug in and I will donate if I can get it working on any of my sites. even if you do suggest a change of career.

GaMerZ · « **Reply #19 on:** 13 January 2010, 01:32 »

In WP-Admin -> Downloads -> Download Options.

"Download Nice Permalink:" Set to "No"
"Download Method:" Set to "Redirect to File"

News:

Author Topic: WP-Download Manager hides all files after WP update (Read 2229 times)