WordPress.org

Ready to get started?Download WordPress

Forums

podPress
[closed] Upgrade script stuck (40 posts)

  1. jbc3k
    Member
    Posted 1 year ago #

    Hi,

    After upgrading the podpress plugin, it told me to go to 'General Settings' to complete the Setup.
    If I access that page, it brings up the update-script but it got stuck.
    looks like this, for over an hour now:
    http://i.imgur.com/SYT9VRj.jpg

    http://wordpress.org/extend/plugins/podpress/

  2. jbc3k
    Member
    Posted 1 year ago #

    Okay I've found there are errors, when the script is loaded:

    [02:30:58.351] Use of getAttributeNode() is deprecated. Use getAttribute() instead. @ http://www.####.de/wp-content/plugins/podpress/js/jquery/jquery-1.4.2.min.js?ver=3.5.1:48
    [02:30:58.351] Use of attributes' specified attribute is deprecated. It always returns true. @ http://www.####.de/wp-content/plugins/podpress/js/jquery/jquery-1.4.2.min.js?ver=3.5.1:48
    [02:30:59.778] SyntaxError: JSON.parse: unexpected character @ http://www.####.de/wp-admin/load-scripts.php?c=1&load%5B%5D=jquery,utils&ver=3.5.1:2
  3. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks for the report! This interesting. Which web browser did you use? Which version?

    This problem might occur only in some browser. Do you have the possibility to open the admin pages with Firefox? it would be great if you could do this. If gets still stuck then it could be a problem which is related with the execution time limit for PHP scripts on the server. Do you know what the max_execution_time on your server is? (Plugins like the WP System Health could help finding it out.)

  4. jbc3k
    Member
    Posted 1 year ago #

    Browser is Firefox 20.0 (all stuff-blocking addons disabled) and also same result in IE9.
    'max_execution_time' is set to 1800(Local Value) and 60(Master Value)
    It's a managed hosting package.

  5. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    I will do some tests tomorrow. So far I have tested only with stable Firefox versions (e.g. 19.0.2) and unfortunately I installed the upgrade to IE 10 last week. I can not reproduce this situation nor the error message in IE 10. But I will do a roll back tomorrow.

  6. thelanj
    Member
    Posted 1 year ago #

    same problem on osx mountain lion in both chrome and mozilla firefox.

  7. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    @thelanj: Please, look for related error messages in the javascript consoles of your browsers and post them here. It would be great if you could also post the version numbers of your browsers.

    @jbc3k: I have deinstalled the IE 10 and made several tests with the IE 9. But I could not reproduce the problem nor could I see the error messages you have posted.
    Are these error message from the javascript console of your Firefox 20?

  8. jbc3k
    Member
    Posted 1 year ago #

    Yes they are.
    I can try to run the scripts on Mac (Safari/FF) tomorrow from work.

  9. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    @jbc3k: I installed Firefox 20b4 a couple of minutes ago (my OS is Win 7 Professional 64bit). But I could also not reproduce the situation. Do you uses special web developer Add-Ons in your FF?

  10. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    For all who encounter this or other problems with this part of the upgrade, I will tell you that this part of the plugin will effect only the statistic database tables of podPress. Nothing else. This process will correct entries which were made with podPress 8.8.10 - 8.8.10.12.

  11. jbc3k
    Member
    Posted 1 year ago #

    Tried it today on Safari(don't know which version but it was a fresh updated OSX10.8.something) and FireFox 19.
    All same result. I don't think this is a browser issue. :(

  12. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    All same result. I don't think this is a browser issue.

    Yes, it seems like the cause of the problem in your case is not browser-related.

    Do you get in all browsers the same error messages? Or do you get them only in the Firefox browser?

    How many entries are in the _podpress_statcounts and how many are the _podpress_stats table? Is one of them empty? Which one?

  13. jbc3k
    Member
    Posted 1 year ago #

    I have to check for the error-output on other browsers on monday, don't know where the error-consoles are.

    mcwp_podpress_statcounts has 10 entries
    mcwp_podpress_stats has 6,190 entries

    none empty

  14. Rafael Fischmann
    Member
    Posted 1 year ago #

    I'm also stuck on that dialog over here, doesn't look like a browser-related issue at all although I'm using Chrome's latest version on my Mac.

    What should I do to clear it out and be able to continue using podPress?

  15. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    What should I do to clear it out and be able to continue using podPress?

    Since this part updates only older statistic table entries, you may skip it: http://wordpress.org/support/topic/alternative-for-updating-wp_podpress_stats
    But you should follow these instructions only if you are experienced with the database interface! Make a db backup before you try custom db commands!

    But in order solve this issue it would be helpful if you could describe a little more what you mean with "stuck". (e.g.: When (during the upgrade of which db table) does it stop? Does the dialog appear at all? Can you observe Javascript errors? Which WP version do you use?)

  16. Rafael Fischmann
    Member
    Posted 1 year ago #

    I'm not comfortable with those DB commands, so I won't do it.

    Whenever I go to General Settings inside podPress, the page loads and this dialog box appears:

    http://d.pr/i/dJYL

    It's stuck there. I can close the box, but this doesn't go away from the top of my WordPress Admin:

    Notice: The podPress upgrade is not complete. Please, go to the General Settings page of podPress to finish this process manually.

    I'm using WP's latest version.

  17. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    So far I can only acknowledge problems in combination with WP 2.7.x. In this combination (WP 2.7.x + podPress 8.8.10.17) the upgrade dialog on the general settings page of podPress does not appear.
    I'm working on an upgrade which will solve this problem. But I doubt that it will solve problems which occur in combination with newer WP versions.
    The problem for me is that I have trouble to reproduce the problem which you reported with newer WP version. Because I can only try to guess what the problem might be, it is hard to find and fix the problem.
    But every detail you can give me is helpful and would make it easier for me to guess.

  18. Rafael Fischmann
    Member
    Posted 1 year ago #

    What other details can I give you? I'm willing to help.

    Also, it would be great if you could tell me what does the dialog box do, so maybe we can do it manually and get rid of it.

  19. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    Rafael, thank you for the screenshot! In your case the problem is probably connected to a time limit. On most servers a script is only allowed to run for a certain time. In your case the limit seems to be 2 seconds or at least that is what the upgrade script could retrieve.
    2 seconds is very low limit. If it this value is really that low then it is possible that the database action needs more time than it is allowed to run. The result is that the script and upgrade process get stuck.
    I did not expect that the time limit could be that low and thought that the lowest limit would be at least 10 seconds.

    I will revise the script and will try to find a better solution to handle low time limits.

    But it would be great if you could find out whether the max_execution_time limit is really 2 seconds.
    I recommend using one of the monitoring plugins for that purpose. My favourite is WP System Health. This plugin will tell you also which server software is running on the server.

  20. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    Also, it would be great if you could tell me what does the dialog box do, so maybe we can do it manually and get rid of it.

    The dialog box is a precaution in regard to the execution time limit for php scripts. If you open the general settings page it starts to update a low amount of rows in the database and measures the time while doing that.
    This time is the basis for the maximum increment. When this works correctly the database requests are quick enough to avoid the time limit.

    In most cases the upgrade of all database entries at once would take longer than the limit allows. One solution is to upgrade only a limited amount of entries at once.
    The dialogue lets you choose an increment (amount of rows per upgrade action) and clicking on the button in the right bottom corner of the dialogue window would start a new upgrade action until all entries are corrected. Almost every click on that button starts a database command like I have posted in the other thread.

    At the moment the only two ways to make this dialogue go away are
    - to erase the _podPress_upgrade entry in the wp_options table
    - or to clear the podPress statistics tables.

    But I'm sure that the next podPress upgrade will contain a solution for this situation. Until than you may use the current podPress version the dialogue has no effect on the rest of the plugin.

  21. Rafael Fischmann
    Member
    Posted 1 year ago #

    I installed that plugin, what information do you need from it?

  22. Rafael Fischmann
    Member
    Posted 1 year ago #

    I think I'll wait for the plugin's next version to solve this, if you say everything else works just fine. Thanks.

  23. mchilson
    Member
    Posted 1 year ago #

    Same issue here... Some information for you.

    In this case the max. execution time for the blog software is: 2 seconds.

    The time needed to correct 10 rows in the data base: 0.00461411476135 seconds

    Select an increment: <= 9 (The increment should be smaller than this value)

    Number of rows in the data base table wp_podpress_statcounts: 803

    Number of rows which need be processed: 634
    the increment starts at 10 and every time you run it it counts down by 1. Then if you let it try and run with any of the values it just hangs. Have tried in firefox, chrome, and IE and running wordpress 3.5.1

  24. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    It would be interesting for me to know the max_execution_time value which the other plugin retrieves.

  25. Rafael Fischmann
    Member
    Posted 1 year ago #

    I cloudn't find that value from the information the plugin retrieves. Are you sure it shows that?

  26. jbc3k
    Member
    Posted 1 year ago #

    So no idea how to fix it, without dropping my stats?
    If so, I will switch to Podlove Podcast Publisher (http://podlove.org/).

  27. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    I'm working on a solution and there will be an upgrade. But I will need 1-2 weeks for it. Meanwhile podPress will work and continue to collect statistics despite the incomplete upgrade.

    @Raphael: Go to the WP System Health page in your blog. Open the PHP panel and display the Core information. One of these value should be max_exectuion_time.

  28. jbc3k
    Member
    Posted 1 year ago #

    Okay, I'll be patient.

  29. Rafael Fischmann
    Member
    Posted 1 year ago #

    Here you go:

    max_execution_time 0 30

  30. ntm
    Member
    Plugin Author

    Posted 1 year ago #

    @jbc3k: It would be interesting and helpful for me to know what the max_execution_time values are on the server of your blog. Could you try to find out, how high (or low) these values are? and whether they are different from each other like in Rafaels case?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.