Thanks! You are absolutely right. I didn't realize I did have another php in /usr/bin/ and that was the one cron used.
Problem solved. Again, thank you very much. On Dec 7, 11:48 am, Ryan Schmidt <[email protected]> wrote: > You have more than one copy of PHP installed on your computer, and they have > different capabilities. It sounds like the one you want (which has MySQL > support) is in /usr/local/bin, and it sounds like your PATH variable includes > the path /usr/local/bin before the location where your second copy of PHP is > installed (perhaps /usr/bin?). So everything works on your console. > > Cron has its own PATH, however. Perhaps cron's PATH does not include > /usr/local/bin, or perhaps it does, but it's after the location where the > other PHP is, so that the other PHP (which apparently doesn't have MySQL > support) is found, and you get an error about undefined MySQL functions. > > Figure out how to change cron's PATH. Or specify the PATH yourself before > running the cake console, e.g.: > > PATH=/usr/local/bin:/usr/bin:/bin /path/to/cake/console/cake > > Or if you're doing it as in the book page you linked to, and you already have > a wrapper script around the cake console, set the PATH within that wrapper > script. > > On Dec 7, 2010, at 13:23, [email protected] wrote: > > > I found out that I can fix the problem by calling php with its > > absolute path in cake/console/cake: > > > From: > > exec php -q ${LIB}cake.php -working "${APP}" "$@" > > > To: > > exec /usr/local/bin/php -q ${LIB}cake.php -working "${APP}" "$@" > > > However, I do not like that solution because it changes Cake core. > > > Anyone any clue? Thanks! > > > On Dec 6, 11:01 pm, "[email protected]" <[email protected]> wrote: > > >> I followed the instructions > >> onhttp://book.cakephp.org/view/1110/Running-Shells-as-cronjobs > >> and I still ran into a strange problem while running my shell in > >> cronjob. > > >> I am getting error when I try to use model in the shell: > > >> Fatal error: Call to undefined function mysql_query() in /home/ > >> cake1.3.6/cake/libs/model/datasources/dbo/dbo_mysql.php on line 600 > > >> The shell runs fine if I just fire it up manually. What can't PHP see > >> mysql_query() when it's done in a shell via cronjob? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
