NYCPHP Meetup

[Scott Wolpow]

Hmm,
Sounds like you MySql root user got corrupted.

I suggest you search on lost MySql root password and follow those 
directions.
SW


On 2/27/2012 2:37 PM, David Roth wrote:
> 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
>