[PHP] Problem z błędem ze skryptu Opcje

[szulczyk]

Witam,

Mam problem z pewną aplikacją webową, wszystko działało ok. Jednak od wczoraj podczas wykonywania skryptu *.bat , wyskakuje następujący komunikat :

D:\Scripts\xyz.pl>D:\Wapp\php\php.exe -f D:\Wapp\apache2\htdocs\aplikacja.xyz.pl\cron\scheduledTaskSet.php parameter1=m

PHP Fatal Error : Call to a member function query<> on a non-object in D:\Wapp\apache2\htdocs\aplikacja.xyz.pl\cron\scheduledTaskSet.php on line 17

Poniżej kod od 1 do 26 linijki z pliku scheduledTaskSet.php

Kod

<?php


include('D:\\Wapp\\apache2\\htdocs\\aplikacja.xyz.pl\\misc\\functions.php');
require_once('D:\\Wapp\\apache2\\htdocs\\aplikacja.xyz.pl\\misc\\class.phpmailer.php');
require_once('D:\\Wapp\\apache2\\htdocs\\aplikacja.xyz.pl\\misc\\class.smtp.php');

$xmlPotentials=simplexml_load_file('D:\\Wapp\\apache2\\htdocs\\aplikacja.xyz.pl\\language\\pl\\potentials.xml');

if($argc>1)
    parse_str(implode('&',array_slice($argv,1)),$_GET);

switch($_GET["parameter1"])
{
    case "m":
        //mailSend
     17 linia ->   $tempMails=$dbMaster->query(
        
        "SELECT
        *
        FROM
        fl_mail
        INNER JOIN fl_user ON user_id = mail_recipient_userid
        WHERE
        mail_issent = false"
        )->fetchAll(PDO::FETCH_ASSOC);[code]

Ten post edytował szulczyk 1.02.2017, 10:30:19

[szulczyk]

Poniżej cały kod , jest metoda send.

[PHP] pobierz, plaintext 
 
<?php
 
 
 
 
include('D:\\Wapp\\apache2\\htdocs\\xyz.pl\\misc\\3.php');
include('D:\\Wapp\\apache2\\htdocs\\xyz.pl\\misc\\functions.php');
require_once('D:\\Wapp\\apache2\\htdocs\\xyz.pl\\misc\\class.phpmailer.php');
require_once('D:\\Wapp\\apache2\\htdocs\\xyz.pl\\misc\\class.smtp.php');
 
 
 
 
 
$xmlPotentials=simplexml_load_file('D:\\Wapp\\apache2\\htdocs\\xyz.pl\\language\\pl\\potentials.xml');
 
if($argc>1)
    parse_str(implode('&',array_slice($argv,1)),$_GET);
 
switch($_GET["parameter1"])
{
    case "m":
        //mailSend
        $tempMails=$dbMaster->query(
                        "
        SELECT 
        *
        FROM
        fl_mail 
        INNER JOIN fl_user ON user_id = mail_recipient_userid
        WHERE
        mail_issent = false
        ")->fetchAll(PDO::FETCH_ASSOC);
 
        foreach($tempMails as $mailRow)
        {
            $mail          =new PHPMailer();
            $mail->SetLanguage("pl");
            $mail->IsSMTP();                                   // send via SMTP
            $mail->CharSet ="UTF-8";
            $mail->Host    ="192.168.1.5"; // SMTP servers
            $mail->SMTPAuth=false;     // turn on SMTP authentication
            $mail->Port    =25;
            switch($mailRow["mail_senderid"])
            {
                case 1:
                    $mail->From    ="it@xyz.pl";
                    $mail->FromName="xyz";
                    break;
                case 2:
                    $mail->From    ="office.plwa@xyz.pl";
                    $mail->FromName="xyze";
                    break;
                default:
                    $mail->From    ="it@xyz.pl";
                    $mail->FromName="xyz";
                    break;
            }
            $mail->AddAddress($mailRow["user_mail"]);
            $mail->WordWrap=80;                              // set word wrap
            $mail->IsHTML(true);                               // send as HTML?
            $mail->Subject =$mailRow["mail_subject"];
            $mail->Body    =$mailRow["mail_body"];
            if($mailRow["mail_senderid"]<0)
            {
                $tempMailIsSent=$dbMaster->query(
                        "
                UPDATE fl_mail 
                SET 
                mail_issent = true,
                mail_sent_datetime = 'n/a'
                WHERE
                mail_id = ".$mailRow["mail_id"]."
                ");
            }
            else
            {
                $mail->Send();
                $tempMailIsSent=$dbMaster->query(
                        "
                UPDATE fl_mail 
                SET 
                mail_issent = true,
                mail_sent_datetime = '".date("Y-m-d H:i:s")."'
                WHERE
                mail_id = ".$mailRow["mail_id"]."
                ");
            }
        }
        //mealReminder
        if(date("H:i")=="10:10")
        {
            $mealOrder  =$dbMaster->query(
                            "
            SELECT 
            *
            FROM
            fl_meal_order 
            WHERE
            meal_order_delivery_datetime = '".date("Y-m-d")."'
            AND meal_order_statusid = 1
        ")->fetchAll(PDO::FETCH_ASSOC);
            $tempSubject=$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->noPaymentReminder->subject;
            $tempBody   =$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->newMeal->header1;
            $tempBody.="<br/>";
            $tempBody.="<br/>";
            $tempBody.=$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->noPaymentReminder->body1;
            $tempBody.="<br/>";
            $tempBody.="<br/>";
            $tempBody.=str_replace("br","<br/>",$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->footer1);
 
            foreach($mealOrder as $rowOrder)
            {
                sendMail($tempSubject,$tempBody,$rowOrder["meal_order_userid"]);
            }
        }
 
        if(date("H:i")=="10:15")
        {
            $mealOrder  =$dbMaster->query(
                            "
            SELECT 
            *
            FROM
            fl_meal_order 
            WHERE
            meal_order_delivery_datetime = '".date("Y-m-d")."'
            AND meal_order_statusid = 1
        ")->fetchAll(PDO::FETCH_ASSOC);
            $tempSubject=$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->noPaymentReminder->subject;
            $tempBody   =$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->newMeal->header1;
            $tempBody.="<br/>";
            $tempBody.="<br/>";
            $tempBody.=$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->noPaymentReminder->body2;
            $tempBody.="<br/>";
            $tempBody.="<br/>";
            $tempBody.=str_replace("br","<br/>",$xmlPotentials->functions->office->subfunctions->meals72->orderNotification->footer1);
 
            foreach($mealOrder as $rowOrder)
            {
                sendMail($tempSubject,$tempBody,$rowOrder["meal_order_userid"]);
                $mealOrderUpdate=$dbMaster->query(
                        "
                        UPDATE 
                        fl_meal_order
                        SET meal_order_statusid = 6
                        WHERE
                        meal_order_id = ".$rowOrder["meal_order_id"]."
                        ");
            }
        }
        if(date("H:i")=="01:00")
        {
            $localCSVPath         ='D:\\Roger\\Events\\02_CSV\\01_Uploaded\\';
            $localCSVPathProcessed='D:\\Roger\\Events\\02_CSV\\02_Processed\\';
            $localCSVFiles        =scandir($localCSVPath);
 
            $localXMLPath         ='D:\\Roger\\Events\\01_XML\\01_Uploaded\\';
            $localXMLPathProcessed='D:\\Roger\\Events\\01_XML\\02_Processed\\';
            $localXMLFiles        =scandir($localXMLPath);
 
            $tempErrors="";
            foreach($localXMLFiles as $rowFile)
            {
                if(substr($rowFile,-3)=="xml")
                {
 
                    $xmlFile=simplexml_load_file($localXMLPath.$rowFile);
                    foreach($xmlFile->tables->table->rows->row as $row)
                    {
                        $fl_worktimeInsert=$dbMaster->prepare(
                                "
                    INSERT INTO fl_worktime
                    (
                    worktime_rogeruniqueid,
                    worktime_rogerid,
                    worktime_datetime,
                    worktime_code,
                    worktime_rogeruserid,
                    worktime_rogeruserguid,
                    worktime_readerid,
                    worktime_doortype,
                    worktime_modificationreason,
                    worktime_importdatetime,
                    worktime_importfilename
                    )
                    VALUES
                    (
                    '".$row->f[0]."',
                    '".$row->f[1]."',
                    '".$row->f[2]." ".$row->f[3]."',
                    '".$row->f[4]."',
                    '".$row->f[5]."',
                    '".$row->f[6]."',
                    '".$row->f[7]."',
                    '".$row->f[8]."',
                    '".$row->f[10]."',
                    '".date("Y-m-d H:i:s")."',
                    '".$rowFile."'
                    )
                    ");
                        if($fl_worktimeInsert->execute())
                        {
 
                        }
                        else
                        {
                            $tempErrors.=$rowFile.";".$row->f[0]."<br/>";
                        }
                    }
                    rename($localXMLPath.$rowFile,$localXMLPathProcessed.$rowFile);
                    sendMail("Roger Processing",$tempErrors,10);
                }
            }
        }
        break;
    default:
 
        break;
}
?>
 
[PHP] pobierz, plaintext 

Gdzie najlepiej wstawić to :file_put_contents(var_export($mail->ErrorInfo)) ?

Ten post edytował szulczyk 7.02.2017, 10:04:57