We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum


Thread tagged as: Error

Login error…

My client has just contacted me to tell me they're getting this error message:

The following error occurred: ALTER TABLE perch2_categories CHANGE catDisplayPath catDisplayPath CHAR(255) NOT NULL DEFAULT '' SQLSTATE[HY000]: General error: 3 Error writing file './gustoresearch/#sql-db1_21cf.frm' (Errcode: 28)

I updated the site about a month ago and here are the diagnostics:

Perch: 2.8.29, PHP: 5.6.10, MySQL: mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $, with PDO
Server OS: Darwin, apache2handler
Installed apps: content (2.8.29), assets (2.8.29), categories (2.8.29), perch_blog (5.0), perch_forms (1.8.3), perch_members (1.5), perch_backup (1.2)
App runtimes: <?php $apps_list = array( 'content', 'categories', 'perch_forms', 'perch_members', 'perch_blog', ); ?>
PERCH_PATH: /Users/TemperTemper/Sites/Gusto/gustoresearch.com/cms
PERCH_CORE: /Users/TemperTemper/Sites/Gusto/gustoresearch.com/cms/core
PERCH_RESFILEPATH: /Users/TemperTemper/Sites/Gusto/gustoresearch.com/cms/resources
Image manipulation: GD
PHP limits: Max upload 32M, Max POST 32M, Memory: 128M, Total max file upload: 32M
F1: 2edba60ed1f613d6dd804feb202456a2
Resource folder writeable: Yes
HTTP_HOST: gustoresearch.local
DOCUMENT_ROOT: /Users/TemperTemper/Sites/Gusto/gustoresearch.com
REQUEST_URI: /cms/core/settings/diagnostics/
SCRIPT_NAME: /cms/core/settings/diagnostics/index.php

Is it ok to 'accept these errors and continue'? Or has something sinister happened…?



Martin Underhill

Martin Underhill 5 points

  • 3 years ago
Rachel Andrew

Rachel Andrew 394 points
Perch Support

That error has nothing to do with Perch, you need to contact your host.

In general if a site starts throwing an error and you haven't touched it, that isn't going to be Perch or anything running on the site.

I thought it was weird. I'll speak to my hosting guy. Thanks :)

Drew McLellan

Drew McLellan 2638 points
Perch Support

A .frm file is one of MySQL's internal files - so this looks like some sort of db corruption that will need repairing.

I managed to fix this – it was a db corruption due to their server (24GB!) running out of space. Thanks for your steer in the right direction :)