Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. WordPress (Developer)
  3. Cron tasks

Cron tasks

Scheduled Pinned Locked Moved Solved WordPress (Developer)
35 Posts 3 Posters 3.6k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • mdreiraM mdreira

    @girish have you seen anything in error log? https://prnt.sc/26qc3mk

    EDIT: The plugin guys tell us that the problem is the way we call to wp-cron.

    So even though Cloudron calls wp-cron every minute, I would like to call it twice a day more with the typical type of call from the cron tab. Something like:

    0 */12 * * * /usr/bin/php -q /public/wp-cron.php >/dev/null 2

    This is the type of call that the plugin needs. It's possible?

    We are interested in this image optimization plugin because it optimizes images in the cloud without a limit of megabytes. I have to try to make it work.

    If you know of another plugin that does the same and works on cloudron, we can switch.

    girishG Offline
    girishG Offline
    girish
    Staff
    wrote on last edited by girish
    #11

    @mdreira We use WP CLI to run cron jobs like so:

    sudo -u www-data -i -- /app/pkg/wp --skip-themes --path=/app/data/public/ cron event run --due-now
    

    Are you able to run the command above manually and see if it produces the error message ? Also, remove the --skip-themes and check if that helps as well, maybe that's causing the problem. TBH, I am not 100% sure why we have --skip-themes there, it should probably be removed.

    mdreiraM 1 Reply Last reply
    0
    • girishG girish

      @mdreira We use WP CLI to run cron jobs like so:

      sudo -u www-data -i -- /app/pkg/wp --skip-themes --path=/app/data/public/ cron event run --due-now
      

      Are you able to run the command above manually and see if it produces the error message ? Also, remove the --skip-themes and check if that helps as well, maybe that's causing the problem. TBH, I am not 100% sure why we have --skip-themes there, it should probably be removed.

      mdreiraM Offline
      mdreiraM Offline
      mdreira
      translator
      wrote on last edited by mdreira
      #12

      @girish Here I send you the screenshot of the terminal after sending those commands:

      Captura de pantalla 2022-02-09 a las 21.20.31.jpg

      Running it like this did not make the plugin work.

      The plugin cron task is this:

      Captura de pantalla 2022-02-09 a las 21.20.42.jpg

      When the cron executes this task it gives me this error:

      Captura de pantalla 2022-02-09 a las 21.20.53.jpg

      Is there any other way to execute that task? I have to get that plugin working. The plugin people don't know what's going on because our cloudron server is something special πŸ˜„

      girishG 2 Replies Last reply
      0
      • mdreiraM mdreira

        @girish Here I send you the screenshot of the terminal after sending those commands:

        Captura de pantalla 2022-02-09 a las 21.20.31.jpg

        Running it like this did not make the plugin work.

        The plugin cron task is this:

        Captura de pantalla 2022-02-09 a las 21.20.42.jpg

        When the cron executes this task it gives me this error:

        Captura de pantalla 2022-02-09 a las 21.20.53.jpg

        Is there any other way to execute that task? I have to get that plugin working. The plugin people don't know what's going on because our cloudron server is something special πŸ˜„

        girishG Offline
        girishG Offline
        girish
        Staff
        wrote on last edited by
        #13

        @mdreira please post the images inline in this forum. You can just ctrl+v the screenshot to paste in the forum. I am afraid those images will go away at some point and this post will be meaningless if those images go away....

        1 Reply Last reply
        0
        • mdreiraM mdreira

          @girish Here I send you the screenshot of the terminal after sending those commands:

          Captura de pantalla 2022-02-09 a las 21.20.31.jpg

          Running it like this did not make the plugin work.

          The plugin cron task is this:

          Captura de pantalla 2022-02-09 a las 21.20.42.jpg

          When the cron executes this task it gives me this error:

          Captura de pantalla 2022-02-09 a las 21.20.53.jpg

          Is there any other way to execute that task? I have to get that plugin working. The plugin people don't know what's going on because our cloudron server is something special πŸ˜„

          girishG Offline
          girishG Offline
          girish
          Staff
          wrote on last edited by
          #14

          @mdreira Also, can you tell me which plugin this is? From the screenshot it says weimgoptimizer but https://wordpress.org/plugins/search/weimgoptimizer/ is a not found.

          mdreiraM 1 Reply Last reply
          0
          • girishG girish

            @mdreira Also, can you tell me which plugin this is? From the screenshot it says weimgoptimizer but https://wordpress.org/plugins/search/weimgoptimizer/ is a not found.

            mdreiraM Offline
            mdreiraM Offline
            mdreira
            translator
            wrote on last edited by
            #15

            @girish The plugin is optimizador.io (https://optimizador.io/)

            Right now I edit the links of the screenshots and upload the images directly.

            girishG 3 Replies Last reply
            0
            • mdreiraM mdreira

              @girish The plugin is optimizador.io (https://optimizador.io/)

              Right now I edit the links of the screenshots and upload the images directly.

              girishG Offline
              girishG Offline
              girish
              Staff
              wrote on last edited by
              #16

              @mdreira I will give it a try locally to see if I can reproduce the problem.

              1 Reply Last reply
              0
              • girishG Offline
                girishG Offline
                girish
                Staff
                wrote on last edited by
                #17

                Struggling to get this API key. https://optimizador.io/registro-clave-api/ has no form to fill anything, not sure how to proceed.

                mdreiraM 1 Reply Last reply
                0
                • girishG girish

                  Struggling to get this API key. https://optimizador.io/registro-clave-api/ has no form to fill anything, not sure how to proceed.

                  mdreiraM Offline
                  mdreiraM Offline
                  mdreira
                  translator
                  wrote on last edited by mdreira
                  #18
                  This post is deleted!
                  girishG 1 Reply Last reply
                  0
                  • mdreiraM mdreira

                    This post is deleted!

                    girishG Offline
                    girishG Offline
                    girish
                    Staff
                    wrote on last edited by
                    #19

                    @mdreira apparently, that page doesn't work in firefox. works in chrome.

                    1 Reply Last reply
                    1
                    • girishG Offline
                      girishG Offline
                      girish
                      Staff
                      wrote on last edited by
                      #20

                      You can run the specific hook like this

                      root@d2c84f40-ba29-47fd-87a5-48c873006e89:/app/code# sudo -u www-data -i -- /app/pkg/wp --skip-themes --path=/app/data/public/ cron event run my_schedule_hook
                      

                      I am getting the same exception you posted.

                      mdreiraM 1 Reply Last reply
                      2
                      • girishG girish

                        You can run the specific hook like this

                        root@d2c84f40-ba29-47fd-87a5-48c873006e89:/app/code# sudo -u www-data -i -- /app/pkg/wp --skip-themes --path=/app/data/public/ cron event run my_schedule_hook
                        

                        I am getting the same exception you posted.

                        mdreiraM Offline
                        mdreiraM Offline
                        mdreira
                        translator
                        wrote on last edited by
                        #21

                        @girish Yes, it seems that something is failing

                        1 Reply Last reply
                        0
                        • mdreiraM mdreira

                          @girish The plugin is optimizador.io (https://optimizador.io/)

                          Right now I edit the links of the screenshots and upload the images directly.

                          girishG Offline
                          girishG Offline
                          girish
                          Staff
                          wrote on last edited by
                          #22

                          @mdreira It seems that global variables are not working. The clue is from this error message:

                          WordPress database error Table 'c801e5ebba2fb24b.wp_' doesn't exist for query 
                                  SELECT *
                                  FROM wp_
                                  WHERE meta_id = 6
                                  AND thumb_size = 'we_original_size'
                                  ORDER BY time DESC
                                made by include('phar:///app/pkg/wp/php/boot-phar.php'), include('phar:///app/pkg/wp/vendor/wp-cli/wp-cli/php/wp-cli.php'), WP_CLI\bootstrap, WP_CLI\Bootstrap\LaunchRunner->process, WP_CLI\Runner->start, WP_CLI\Runner->run_command_and_exit, WP_CLI\Runner->run_command, WP_CLI\Dispatcher\Subcommand->invoke, call_user_func, WP_CLI\Dispatcher\CommandFactory::WP_CLI\Dispatcher\{closure}, call_user_func, Cron_Event_Command->run, Cron_Event_Command::run_event, do_action_ref_array('my_schedule_hook'), WP_Hook->do_action, WP_Hook->apply_filters, oiwe_my_schedule_function, oiwe_optimize_concurrent_image_by_att_id, oiwe_isOptimized
                          

                          The relevant code is:

                          function oiwe_get_optimization_data_by_attID($id){
                          
                                  global $wpdb;
                                  global $OIWE_TABLENAME;
                          
                                  $table_name = $wpdb->prefix . $OIWE_TABLENAME ;
                          
                                   $querystr = "
                                      SELECT *
                                      FROM $table_name
                                      WHERE meta_id = $id
                                  AND thumb_size = 'we_original_size'
                                          GROUP BY uuid
                                      ORDER BY time DESC
                                   ";
                          
                                  $optimizations = $wpdb->get_results($querystr, OBJECT);
                          
                                  return $optimizations ;
                          }
                          

                          In the above, OIWE_TABLENAME is null . In fact, all the globals in that file are "null" which is why we later get the error that string is expected. My PHP skillz are being put to test...

                          1 Reply Last reply
                          1
                          • girishG Offline
                            girishG Offline
                            girish
                            Staff
                            wrote on last edited by
                            #23

                            So strange, I cannot figure why this is. There is a constants.php in the plugin. I put the logs below:

                            <?php
                            
                            $OIWE_API_URL = "http://apiv1.optimizador.io:80/";
                            global $OIWE_API_URL ;
                            $PLUGIN_VERSION = "1.0.22";
                            error_log('The version is ' . $PLUGIN_VERSION);
                            global $PLUGIN_VERSION;
                            error_log('The version is now ' . $PLUGIN_VERSION);
                            
                            $OIWE_TABLENAME =  "imgoptimizations";
                            global $OIWE_TABLENAME;
                            
                            

                            Now, if I run via PHP cli:

                            root@d2c84f40-ba29-47fd-87a5-48c873006e89:/app/data# php /app/data/public/wp-content/plugins/weimgoptimizer/includes/constants.php
                            The version is 1.0.22
                            The version is now 1.0.22
                            

                            So, the above works as expected. But if I now run this via WP CRON:

                            root@d2c84f40-ba29-47fd-87a5-48c873006e89:/app/code# sudo -u www-data -i -- /app/pkg/wp --path=/app/data/public/ cron event run my_schedule_hook
                            The version is 1.0.22
                            The version is now 
                            

                            The version is empty for the second one! In fact, all the global things like global $PLUGIN_VERSION; in constants.php become immediately empty . FWIW, the global usage above seems to be incorrect. In PHP AFAIK, global is to declare that you are going to use a global variable and not that a variable has to become global.

                            1 Reply Last reply
                            0
                            • mdreiraM mdreira

                              @girish The plugin is optimizador.io (https://optimizador.io/)

                              Right now I edit the links of the screenshots and upload the images directly.

                              girishG Offline
                              girishG Offline
                              girish
                              Staff
                              wrote on last edited by
                              #24

                              @mdreira BTW, it seems the plugin uploads all images via http and not https (see the API URL in constants.php).

                              mdreiraM 1 Reply Last reply
                              0
                              • girishG girish

                                @mdreira BTW, it seems the plugin uploads all images via http and not https (see the API URL in constants.php).

                                mdreiraM Offline
                                mdreiraM Offline
                                mdreira
                                translator
                                wrote on last edited by
                                #25

                                @girish As I don't understand anything about php, I don't really know what's going on. πŸ˜…

                                Is the error you're seeing something on our side or is the side of plugin guys?

                                girishG 2 Replies Last reply
                                0
                                • mdreiraM mdreira

                                  @girish As I don't understand anything about php, I don't really know what's going on. πŸ˜…

                                  Is the error you're seeing something on our side or is the side of plugin guys?

                                  girishG Offline
                                  girishG Offline
                                  girish
                                  Staff
                                  wrote on last edited by
                                  #26

                                  @mdreira I don't understand either. It seems that global variables get reset immediately after global xx when using WP CLI. I don't get why.

                                  1 Reply Last reply
                                  0
                                  • mdreiraM mdreira

                                    @girish As I don't understand anything about php, I don't really know what's going on. πŸ˜…

                                    Is the error you're seeing something on our side or is the side of plugin guys?

                                    girishG Offline
                                    girishG Offline
                                    girish
                                    Staff
                                    wrote on last edited by girish
                                    #27

                                    @mdreira OK, I found the issue. The usage of global is incorrect in the plugin. The global keyword is for stating the use of a global variable (as opposed to 'make this variable global').

                                    With that in mind, the code in the plugin's constant.php is like this:

                                    <?php
                                    
                                    $OIWE_API_URL = "http://apiv1.optimizador.io:80/";
                                    global $OIWE_API_URL ;
                                    
                                    

                                    The above code will break when the above file is included from a "function". This is the case when we use WP CLI where entire WordPress is loaded into a function. So, for example, the rough equivalent is:

                                    function load() {
                                        require_once(".../constants.php");
                                    }
                                    

                                    When it's like above, the global $OIWE_API_URL keyword then says, use OIWE_API_URL from global context, which is not the same as the one you defined one line above (it's a function local variable). So, the solution is to move the global keyword before setting it in constants.php. Like this:

                                    global $OIWE_API_URL ;
                                    $OIWE_API_URL = "http://apiv1.optimizador.io:80/";
                                    
                                    // .. do same for other constants in the file ..
                                    

                                    Of course, this is why globals are not used in WP plugins. You should use superglobals like $GLOBAL or define or database etc. See https://codex.wordpress.org/Global_Variables and https://onlinewebtutorblog.com/wordpress-global-variables-step-by-step-complete-guide/

                                    mdreiraM 1 Reply Last reply
                                    2
                                    • girishG girish

                                      @mdreira OK, I found the issue. The usage of global is incorrect in the plugin. The global keyword is for stating the use of a global variable (as opposed to 'make this variable global').

                                      With that in mind, the code in the plugin's constant.php is like this:

                                      <?php
                                      
                                      $OIWE_API_URL = "http://apiv1.optimizador.io:80/";
                                      global $OIWE_API_URL ;
                                      
                                      

                                      The above code will break when the above file is included from a "function". This is the case when we use WP CLI where entire WordPress is loaded into a function. So, for example, the rough equivalent is:

                                      function load() {
                                          require_once(".../constants.php");
                                      }
                                      

                                      When it's like above, the global $OIWE_API_URL keyword then says, use OIWE_API_URL from global context, which is not the same as the one you defined one line above (it's a function local variable). So, the solution is to move the global keyword before setting it in constants.php. Like this:

                                      global $OIWE_API_URL ;
                                      $OIWE_API_URL = "http://apiv1.optimizador.io:80/";
                                      
                                      // .. do same for other constants in the file ..
                                      

                                      Of course, this is why globals are not used in WP plugins. You should use superglobals like $GLOBAL or define or database etc. See https://codex.wordpress.org/Global_Variables and https://onlinewebtutorblog.com/wordpress-global-variables-step-by-step-complete-guide/

                                      mdreiraM Offline
                                      mdreiraM Offline
                                      mdreira
                                      translator
                                      wrote on last edited by
                                      #28

                                      @girish Then.. what should I do?.

                                      Do I have to tell the plugin guys that they should move the globals in constants.php file or rather use superglobals?

                                      I have no idea how to tell them this. Can we do something from our side?

                                      girishG 1 Reply Last reply
                                      0
                                      • mdreiraM mdreira

                                        @girish Then.. what should I do?.

                                        Do I have to tell the plugin guys that they should move the globals in constants.php file or rather use superglobals?

                                        I have no idea how to tell them this. Can we do something from our side?

                                        girishG Offline
                                        girishG Offline
                                        girish
                                        Staff
                                        wrote on last edited by
                                        #29

                                        @mdreira said in Cron tasks:

                                        @girish Then.. what should I do?.

                                        Sorry, I wasn't clear. Please send the plugin authors the link to my comment. There is nothing we can do, they have to fix the plugin. They can easily reproduce this by running cron tasks using the WP CLI tool outside Cloudron. WP CLI is pretty much part of standard WP - https://make.wordpress.org/cli/handbook/

                                        mdreiraM 2 Replies Last reply
                                        2
                                        • girishG girish

                                          @mdreira said in Cron tasks:

                                          @girish Then.. what should I do?.

                                          Sorry, I wasn't clear. Please send the plugin authors the link to my comment. There is nothing we can do, they have to fix the plugin. They can easily reproduce this by running cron tasks using the WP CLI tool outside Cloudron. WP CLI is pretty much part of standard WP - https://make.wordpress.org/cli/handbook/

                                          mdreiraM Offline
                                          mdreiraM Offline
                                          mdreira
                                          translator
                                          wrote on last edited by
                                          #30

                                          @girish you are the best!!

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Bookmarks
                                          • Search