NYCPHP Meetup

[Sasa Rakic - Gmail]

Hi David,

You will be recommended to another task when all this big country has done
small things ends, possible
Within next few months or till end of year. You know that each security has
section for jokes.

Best regards,
Sasa

-----Original Message-----
From: joomla-bounces at lists.nyphp.org [mailto:joomla-bounces at lists.nyphp.org]
On Behalf Of David Roth
Sent: Monday, February 27, 2012 8:38 PM
To: mysql at lists.nyphp.org; NYPHP SIG: Joomla
Subject: [joomla] mysqldump error - ' Can't create/write to file...'

I'm using Joomla 2.5.1 on my CentOS 6.2 server running MySQL Server
version: 5.1.61.  All the sudden I get error messages when logged in
as Admin when trying to access the Menu Manager items such as Home.
Things were working fine the night before so I look in the PHP error
log:

[27-Feb-2012 01:23:47] PHP Notice:  Trying to get property of
non-object in /home/www/html/staging/administrator/includes/application.php
on line 275
[27-Feb-2012 01:23:47] PHP Notice:  Undefined property:
stdClass::$params in
/home/www/html/staging/administrator/includes/application.php on line
276
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Notice:  Trying to get property of
non-object in /home/www/html/staging/administrator/includes/application.php
on line 275
[27-Feb-2012 01:23:47] PHP Notice:  Undefined property:
stdClass::$params in
/home/www/html/staging/administrator/includes/application.php on line
276
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in /home/www/html/staging/libraries/joomla/database/table.php
on line 406
[27-Feb-2012 01:23:47] PHP Notice:  Trying to get property of
non-object in
/home/www/html/staging/administrator/components/com_menus/models/item.php
on line 544
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in /home/www/html/staging/libraries/joomla/database/table.php
on line 406
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in
/home/www/html/staging/libraries/joomla/database/database/mysql.php
on line 377
[27-Feb-2012 01:23:47] PHP Warning:  Invalid argument supplied for
foreach() in /home/www/html/staging/libraries/joomla/database/table.php
on line 406

So it appears to be MySQL related. So I decided to do a mysqldump of
the database Joomla 2.5.1 is using to rebuild the database and come up
with this error message:

mysqldump: Couldn't execute 'show fields from `cmyzk_assets`': Can't
create/write to file '/tmp/#sql_6da_0.MYI' (Errcode: 13) (1)

I do a ' perror 13' command to see what Errcode 13 means and get this:
OS error code  13:  Permission denied

This doesn't make sense to me because I'm logged in as root doing all
this. Furthermore, I didn't change anything (that I know of).  I
looked to see how MySql is running:

root      1665  0.0  0.0 108256  1432 ?        S    12:15   0:00
/bin/sh /usr/bin/mysqld_safe --datadir=/home/mysql
--socket=/var/lib/mysql/mysql.sock
--pid-file=/var/run/mysqld/mysqld.pid --basedir=/usr --user=mysql
mysql     1754  0.0  0.5 217712 19536 ?        Sl   12:15   0:01
/usr/libexec/mysqld --basedir=/usr --datadir=/home/mysql --user=mysql
--log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
--socket=/var/lib/mysql/mysql.sock

I don't know what the next step should be. I'd appreciate suggestions.
Thanks!

David Roth
_______________________________________________
New York PHP SIG: Joomla! Mailing List
http://lists.nyphp.org/mailman/listinfo/joomla

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php