php - 安装 CMS Concrete5 版本 5.7.2.1 时出现疯狂长 "exception occurred"

Question

我终于在我的网站上安装了 Concrete5，我使用的是 Linux 操作系统上托管的 GoDaddy，PHP 版本为 5.3。

我卡住的安装页面的链接(显示错误)是: http://texasca.com/blog/concrete5.7.2.1/index.php/install

抛出的错误是:

    An exception occurred while executing 'INSERT INTO FileStorageLocationTypes 

    (fslTypeHandle, fslTypeName, pkgID) VALUES (?, ?, ?)' with params ["default", "Default", 0]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'default' for key 'fslTypeHandle'.

    Trace:
    #0 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(167): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO Fil...', Array) #1
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement->execute() #2
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(966): Doctrine\ORM\Persisters\BasicEntityPersister->executeInserts() #3
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork->commit(NULL) #5
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/File/StorageLocation/Type/Type.php(93): Doctrine\ORM\EntityManager->flush() #6 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Package/StartingPointPackage.php(149): Concrete\Core\File\StorageLocation\Type\Type::add('default', 'Default') #7
 [internal function]: Concrete\Core\Package\StartingPointPackage->import_files() #8
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/controllers/install.php(282): call_user_func(Array) #9 [internal function]: Concrete\Controller\Install->run_routine('elemental_full', 'import_files') #10
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Controller/AbstractController.php(156): call_user_func_array(Array, Array) #11
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Routing/ControllerRouteCallback.php(25): Concrete\Core\Controller\AbstractController->runAction('run_routine', Array) #12 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Routing/Router.php(59): Concrete\Core\Routing\ControllerRouteCallback->execute(Object(Concrete\Core\Http\Request), Object(Concrete\Core\Routing\Route), Array) #13
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Support/Facade/Facade.php(116): Concrete\Core\Routing\Router->execute(Object(Concrete\Core\Routing\Route), Array) #14
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Application/Application.php(340): Concrete\Core\Support\Facade\Facade::__callStatic('execute', Array) #15
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/src/Application/Application.php(340): Concrete\Core\Support\Facade\Route::execute(Object(Concrete\Core\Routing\Route), Array) #16
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/bootstrap/start.php(196): Concrete\Core\Application\Application->dispatch(Object(Concrete\Core\Http\Request)) #17
 /home/content/31/11023231/html/blog/concrete5.7.2.1/concrete/dispatcher.php(36): require('/home/content/3...') #18
 /home/content/31/11023231/html/blog/concrete5.7.2.1/index.php(2): require('/home/content/3...') #19 {main}

这是一个非常难以理解和修复的错误，因为它太长了，而且我不是 SQL 或安装 Concrete5 等 CMS 框架的专家。我所做的只是让 GoDaddy 使用其数据库创建工具创建一个空白的 MySQL 5.5 数据库。

我做错了什么？我希望这只是一个菜鸟问题。请帮忙!

谢谢:)

Answer 1

由于我的声誉较低，我还无法发表评论，但我认为这与位于 config 目录中的 site.php 文件有关。这通常会在混凝土 5 安装的早期阶段出现与 SQL 相关的错误。

检查您的 site.php 是否与 GoDaddy 控制面板上的 SQL 匹配

<?php
define('CACHE_FRONTEND_OPTIONS', serialize(array('automatic_cleaning_factor' => 0)));
define('DB_SERVER', 'example');
define('DB_USERNAME', 'example');
define('DB_PASSWORD', 'example.');
define('DB_DATABASE', 'example');

祝你好运