NYCPHP Meetup

NYPHP.org

[joomla] mysqldump error - ' Can't create/write to file...'

Scott Wolpow scott at wolpow.com
Tue Feb 28 07:42:11 EST 2012


Glad you found it.
When troubleshooting always start with the most permissive user and the 
simplest task.
Then add complications.
SW

On 2/27/2012 10:12 PM, David Roth wrote:
> Hi everyone.
>
> Unreal, I solved the problem. I don't know how or why, but /tmp
> instead of it being 1777 and owned by root and belonging to group
> root, it was owned by owner 502 (no 502 on this server) and group
> david. And the permissions were off too so it couldn't be written to.
> 502 is on another server here, with user 'david' (that's me!) is on
> every server.
>
> How this happened I don't know. This is one for the X-files.
>
> Special Agent David ;-)
>
>
>
> On Mon, Feb 27, 2012 at 9:58 PM, David Roth<davidalanroth at gmail.com>  wrote:
>> Hi Rolan.
>>
>> Space doesn't seem to be an issue even /tmp has 7.1G free.
>>
>> This is a strange problem, and not sure what even caused it. Could
>> Joomla 2.5.1 have corrupted the database? Is this a bug from a new
>> release of MySQL?
>>
>> I did an fsck on the disks and looked in the logs, nothing wrong there either.
>>
>> I just checked via admin the other Joomla installations on the same
>> in-house server and all of this same problem with:
>>
>> 500 - An error has occurred.
>> Missing field in the database: JTableContent   id. Missing field in
>> the database: JTableContent   id.
>>
>> So did MySQL get hosed up on this server? Should I consider
>> re-installing MySQL? Thanks!
>>
>> David Roth
>>
>> On Mon, Feb 27, 2012 at 9:47 PM, Rolan Yang<rolan at omnistep.com>  wrote:
>>> Checked the amount of free disk space on the machine?
>>>
>>> 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:
>>> _______________________________________________
>>> 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
>



More information about the Joomla mailing list