Hi Scott. Thanks for the reply.
I'm able at the command line do a mysql -p and login with the usual password. Are you referring to resetting some other password/permissions for the mysqld? Never had a serious MySQL problem like this before. Time for the long pants. :-) David Roth On Mon, Feb 27, 2012 at 7:13 PM, Scott Wolpow <sc...@wolpow.com> wrote: > 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 >> > _______________________________________________ > 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 _______________________________________________ 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
