Forums

Query Errors on Installation

Permalink
Installing 5.7.3.1 on Goddady economy linux
Php v 5.3
MySQL version 5.5
I get the following error during installation at the point where the page says
"Adding Block Types"

An exception occurred while executing 'SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS CollactionName FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'KrazyKids' AND TABLE_NAME = 'Files'': SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/mysqltmp/#sql_579f_0.MYI'; try to repair it.

Trace:
#0 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT COLUMN_N...', Array) #1 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(630): Doctrine\DBAL\Connection->executeQuery('SELECT COLUMN_N...', Array, Array) #2 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php(160): Doctrine\DBAL\Connection->fetchAll('SELECT COLUMN_N...') #3 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php(267): Doctrine\DBAL\Schema\AbstractSchemaManager->listTableColumns('Files') #4 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php(254): Doctrine\DBAL\Schema\AbstractSchemaManager->listTableDetails('Files') #5 /home/content/03/7999803/html/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/AbstractSchemaManager.php(986): Doctrine\DBAL\Schema\AbstractSchemaManager->listTables() #6 /home/content/03/7999803/html/concrete/src/Package/Package.php(211): Doctrine\DBAL\Schema\AbstractSchemaManager->createSchema() #7 /home/content/03/7999803/html/concrete/src/Block/BlockController.php(96): Concrete\Core\Package\Package::installDB('/home/content/0...') #8 /home/content/03/7999803/html/concrete/src/Block/BlockType/BlockType.php(155): Concrete\Core\Block\BlockController->install('/home/content/0...') #9 /home/content/03/7999803/html/concrete/src/Backup/ContentImporter.php(406): Concrete\Core\Block\BlockType\BlockType::installBlockType('tags') #10 /home/content/03/7999803/html/concrete/src/Backup/ContentImporter.php(73): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #11 /home/content/03/7999803/html/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #12 /home/content/03/7999803/html/concrete/src/Package/StartingPointPackage.php(127): Concrete\Core\Backup\ContentImporter->importContentFile('/home/content/0...') #13 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #14 /home/content/03/7999803/html/concrete/controllers/install.php(286): call_user_func(Array) #15 [internal function]: Concrete\Controller\Install->run_routine('elemental_blank', 'install_blockty...') #16 /home/content/03/7999803/html/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #17 /home/content/03/7999803/html/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #18 /home/content/03/7999803/html/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #19 /home/content/03/7999803/html/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #20 /home/content/03/7999803/html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #21 /home/content/03/7999803/html/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #22 /home/content/03/7999803/html/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #23 /home/content/03/7999803/html/concrete/dispatcher.php(36): require('/home/content/0...') #24 /home/content/03/7999803/html/index.php(2): require('/home/content/0...') #25 {main}
 
aZuL2001 replied on at Permalink Reply
aZuL2001
Similar issue on One.com (Version 5.7.3.1)
Tried with standard US English install language and with Dutch.


Database server
    Server: 10.246.16.234 via TCP/IP
    Software: MariaDB
    Software version: 5.5.41-MariaDB-1~wheezy - mariadb.org binary distribution
    Protocol version: 10
    User: xxx@10.246.16.251
    Server charset: UTF-8 Unicode (utf8)
Web server
    Apache/2.2.16 (Debian)
    Database client version: libmysql - 5.1.66
    PHP extension: mysqli


An exception occurred while executing 'INSERT INTO BlockTypes (btIgnorePageThemeGridFrameworkContainer, btHandle, btName, btDescription, btCopyWhenPropagate, btIncludeAll, btIsInternal, btSupportsInlineEdit, btSupportsInlineAdd, btInterfaceHeight, btInterfaceWidth, pkgID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [0, "core_area_layout", "Area Layout", "Proxy block for area layouts.", 0, 0, 1, 1, 1, "400", "400", 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'core_area_layout' for key 'btHandle'.
Trace:
#0 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(167): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO Blo...', Array) #1 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute() #2 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(966): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts() #3 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork->commit(NULL) #5 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Block/BlockType/BlockType.php(178): Doctrine\ORM\EntityManager->flush() #6 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Backup/ContentImporter.php(406): Concrete\Core\Block\BlockType\BlockType::installBlockType('core_area_layou...') #7 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Backup/ContentImporter.php(73): Concrete\Core\Backup\ContentImporter->importBlockTypes(Object(SimpleXMLElement)) #8 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Backup/ContentImporter.php(60): Concrete\Core\Backup\ContentImporter->doImport(Object(SimpleXMLElement)) #9 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Package/StartingPointPackage.php(127): Concrete\Core\Backup\ContentImporter->importContentFile('/customers/8/9/...') #10 [internal function]: Concrete\Core\Package\StartingPointPackage->install_blocktypes() #11 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/controllers/install.php(286): call_user_func(Array) #12 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'install_blockty...') #13 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #14 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #15 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #16 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #17 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #18 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/src/Application/Application.php(342): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #19 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #20 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/concrete/dispatcher.php(36): require('/customers/8/9/...') #21 /customers/8/9/a/reeshof-business-centrum.nl/httpd.www/index.php(2): require('/customers/8/9/...') #22 {main}
aZuL2001 replied on at Permalink Reply
aZuL2001
Decided to ditch One.com and tried Strato.
That works like it should.