Jump to content

jpsoft

Members
 View Profile  See their activity

  • Posts

    9

  • Joined

  • Last visited

 Content Type 

Posts posted by jpsoft

    [Solved] Cron Job

    in Customer Service

    Posted

    [Mon Nov 13 12:20:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 12:20:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 12:15:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 12:15:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 12:10:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 12:10:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 12:05:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 12:05:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 12:00:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 12:00:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:58:31 2017] [error] [client 201.208.13.239] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:58:31 2017] [error] [client 201.208.13.239] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:58:30 2017] [error] [client 201.208.13.239] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:58:30 2017] [error] [client 201.208.13.239] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:58:11 2017] [error] [client 201.208.13.239] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:58:11 2017] [error] [client 201.208.13.239] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:50:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:50:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:45:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:45:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:40:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:40:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:35:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:35:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:30:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:30:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:25:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:25:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:20:04 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:20:04 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:15:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:15:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:10:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:10:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:05:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:05:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 11:00:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 11:00:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:55:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:55:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:50:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:50:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:45:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:45:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:40:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:40:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:35:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:35:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:30:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:30:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:25:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:25:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:20:01 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:20:01 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:15:03 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:15:03 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:10:02 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:10:02 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

    [Mon Nov 13 10:05:05 2017] [error] [client 64.62.211.133] File does not exist: /home/jpsoft/public_html/500.shtml

    [Mon Nov 13 10:05:05 2017] [error] [client 64.62.211.133] SoftException in Application.cpp:256: File "/home/jpsoft/public_html/load-cron.php" is writeable by group

     

    [Solved] Cron Job

    in Customer Service

    Posted

    Hi, can somebody check Why mi cron job URL don't work ??

     

     

    http://jpsoft.heliohost.org/load-cron.php

     

     

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, webmaster@jpsoft.heliohost.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

     

    User_Max_Connectios

    in Customer Service

    Posted

    Hi, and thanks, I really appreciate your time.

     

    I have this function to connect to my BD. (funciones.php)

    function conectarse() {
    
    $conexion = mysqli_connect("localhost", "user", "pass", "DB") or die("Error de conexion: " . mysqli_connect_error());

    if (!$conexion) {

        return False;
    }

    return $conexion;
}

    And have this one to select data on my DB. (funciones.php)

    function armame($date, $MarketName, $cod) {
    
    $conexion=conectarse();
    
    switch ($cod) {
        case "24H":
            $date2 = strtotime ( '-24 hour' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "4H":
            $date2 = strtotime ( '-4 hour' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "2H":
            $date2 = strtotime ( '-2 hour' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "1H":
            $date2 = strtotime ( '-1 hour' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "30M":
            $date2 = strtotime ( '-30 minute' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "15M":
            $date2 = strtotime ( '-15 minute' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "10M":
            $date2 = strtotime ( '-10 minute' , strtotime ( $date ) ) ;
            $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;
        case "5M":
            $date2 = strtotime ( '-5 minute' , strtotime ( $date ) ) ;
        $date2 = date ( 'Y-m-d H:i:s' , $date2 );
            break;

        case "":
            exit();
    }
    

    $qry = "SELECT * FROM `summaries` WHERE MarketName = '$MarketName' AND date <= '$date2' ORDER BY id DESC LIMIT 1";
    $run = mysqli_query($conexion, $qry) or die(mysqli_error($conexion));
    $result = mysqli_fetch_assoc($run);
    
    $precio_Armame = number_format($result['Last'], 8, '.', ' ');
    $volumen_Armame = $result['Volumen'];
    
    $thread_id = mysqli_thread_id($conexion);

    mysqli_kill($conexion, $thread_id);
    
    mysqli_free_result($run);
    
    mysqli_close($conexion);
    
    return array($precio_Armame, $volumen_Armame);

}

    I call this function from another file: (index3.php)

     

    This "while" can be more than 200 rows... 

    .
.
.

$qry = "SELECT `MarketName` FROM `summaries` WHERE `MarketName` LIKE 'BTC%' GROUP BY MarketName HAVING COUNT(*) > 1";
    $run = mysqli_query($conexion, $qry) or die("Error: ". mysqli_error($conexion));
    $result2 = mysqli_fetch_assoc($run);
    mysqli_close($conexion);
    
    $i=0;
    if($result2){
        while ($result = mysqli_fetch_assoc($run)){

#24H
###################################################################################################################################


list($precio24H, $volumen24H) = armame($date, $result['MarketName'], '24H');

.
.
.

    I always receive the message:

     

    Warning: mysqli_connect(): (HY000/1203): User jpsoft_desa already has more than 'max_user_connections' active connections in /home/jpsoft/public_html/php/funciones.php on line 25
    Error de conexion2: User jpsoft_desa already has more than 'max_user_connections' active connections.

     

     

     

    But, look, in my function I always close the connections, kills the thread and free the result....

     

     

    What It's wrong?

     

×
×
  • Create New...