我想在yii中调度运行控制台命令。我编写了php脚本,并在web应用程序中尝试了它,效果很好。然而,当我把它作为控制台命令时,cron发送以下消息:
PHP Error[2]: include(User.php): failed to open stream: No such file or directory
in file /home/srv50213/htdocs/framework/YiiBase.php at line 427
#0 /home/srv50213/htdocs/framework/YiiBase.php(427): autoload()
#1 unknown(0): autoload()
#2 /home/srv50213/htdocs/doc/protected/commands/ReportMailerCommand.php(20): spl_autoload_call()
#3 unknown(0): ReportMailerCommand->actionIndex2()
#4 /home/srv50213/htdocs/framework/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#5 /home/srv50213/htdocs/framework/console/CConsoleCommandRunner.php(71): ReportMailerCommand->run()
#6 /home/srv50213/htdocs/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#7 /home/srv50213/htdocs/framework/base/CApplication.php(180): CConsoleApplication->processRequest()
#8 /home/srv50213/htdocs/framework/yiic.php(33): CConsoleApplication->run()
#9 /home/srv50213/htdocs/doc/protected/yiic.php(8): require_once()
似乎自动加载()不能正常工作。对于控制台应用$config,我使用config/console.php,其中我插入了db设置(来自main.php和用户设置)。
'components'=>array(
'db'=>array(
// настройки для конфигурации
'connectionString' =>
'mysql:host=localhost;dbname=xxx',
'emulatePrepare' => true,
'schemaCachingDuration' => 3600,
'username' => 'xxx',
'password' => 'xxx',
'charset' => 'utf8',
'tablePrefix' => 'yiiapp_',
'class' => 'CDbConnection'
),
'user'=>array(
'class' => 'WebUser',
//'class' => 'application.components.User',
// enable cookie-based authentication
'allowAutoLogin'=>true,
),
)
脚本是smth。这样的:
public function actionIndex2($args)
{
$users = User::model()->findAllByPk( array(177) );
foreach($users as $user)
{
$query = "SELECT e.id, e.Subject
FROM `yiiapp_doc_events` AS e
LEFT JOIN `yiiapp_doc_event_users` AS u ON e.id = u.eventId
WHERE e.StatusId NOT IN (5,7)
AND u.userId = {$user->id}
GROUP BY e.id";
$queryResult = Yii::app()->db->createCommand($query)->queryAll();
if ($queryResult)
{
foreach($queryResult as $res)
{
$i++;
$link = Yii::app()->createAbsoluteUrl('docEvents/update', array('id'=>$res['id']));
$table .= "<tr><td> {$i} </td><td> <a href='{$link}'>{$res['id']}</a> </td><td> <a href='{$link}'>{$res['Subject']}</a> </td></tr>";
}
//echo $table . '</table>';
$content= " $table . '</table>';
mail($user->email, "Report (". $i . ')', $content, 'Content-type: text/html');
}
}
}
出了什么问题,怎么解决?
<标题> 更新根据chris的建议,我在配置数组中添加了import参数。现在这个问题已经解决了。然而,由于我要求Yii::app()->createAbsoluteUrl()
,另一件事使Undefined index: SERVER_NAME
受挫:
PHP Error[8]: Undefined index: SERVER_NAME
in file /home/srv50213/htdocs/framework/web/CHttpRequest.php at line 317
#0 /home/srv50213/htdocs/framework/base/CApplication.php(560): CHttpRequest->getHostInfo()
#1 /home/srv50213/htdocs/doc/protected/commands/ReportMailerCommand.php(39): CConsoleApplication->createAbsoluteUrl()
...
解决方案是什么?
<标题> 解决方案在控制台命令中搜索createAbsoluteUrl后,我发现了有用的线程1和2。
在config/console.php中添加以下内容:
'components' => array(
'request' => array(
'hostInfo' => 'https://domainname.com',
'baseUrl' => '',
'scriptUrl' => '',
),
...
)
第二种方式类似:
'components' => array(
'urlManager' => array(
'baseUrl' => 'https://domain.com'
)
)
标题>标题>您是否正确定义了导入?我认为这不是默认的控制台配置。输入如下内容:
'import' => array(
'application.models.*',
),
编辑:到你的更新:不能在控制台应用程序中使用createUrl()
功能。就像你发现的那样,它使用$_SERVER['SERVER_NAME']
,它没有设置,因为控制台应用程序总是在没有服务器的情况下运行,直接通过php cli。