php – 尝试测试Symfony 2 app时出现SQL错误 – 列已经存在,表缺

[DoctrineORMToolsToolsException]
Schema-Tool failed with Error ‘An exception occurred while executing ‘CREATE INDEX deletedAtidx ON SurveyHash (deletedAt)’:
SQLSTATE[HY000]: General error: 1 index deletedAtidx already exists’ while executing DDL: CREATE INDEX deletedAtidx ON SurveyHash (deletedAt)

[DoctrineDBALExceptionTableExistsException]
An exception occurred while executing ‘CREATE INDEX deletedAtidx ON SurveyHash (deletedAt)’:
SQLSTATE[HY000]: General error: 1 index deletedAtidx already exists

[DoctrineDBALDriverPDOException]
SQLSTATE[HY000]: General error: 1 index deletedAtidx already exists

[PDOException]
SQLSTATE[HY000]: General error: 1 index deletedAtidx already exists

doctrine:schema:create [–dump-sql] [–em[=”…”]]

purging database

[DoctrineDBALDBALException]
An exception occurred while executing ‘DELETE FROM PageImage’:
SQLSTATE[HY000]: General error: 1 no such table: PageImage

[PDOException]
SQLSTATE[HY000]: General error: 1 no such table: PageImage

doctrine:fixtures:load [–fixtures[=”…”]] [–append] [–em=”…”] [–purge-with-truncate]

DoctrineDBALExceptionTableNotFoundException : An exception occurred while executing ‘SELECT t0.label AS label_1,t0.value AS value_2 FROM Setting t0 WHERE t0.label = ? LIMIT 1’ with params [“webservice”]:

SQLSTATE[HY000]: General error: 1 no such table: Setting

查看我的实体,在SurveyHash实体中没有声明deletedAt索引两次,并且我有PageImage和Setting的实体,但是这些表没有被创建,正如sqliteman验证的那样.进一步的测试(参见下面其中一个答案中的注释)表明,由于多个表使用相同的索引名称,它会引发错误.

我的config_test.yml具有以下内容：

doctrine:
   dbal:
       driver: pdo_sqlite
       path: %kernel.cache_dir%/test.db
       charset: UTF8
   orm:
       auto_generate_proxy_classes: true
       auto_mapping: true

由于NDA,我可以分享的数据库信息有点受限,所以我希望这些错误是上面链接或我的config_test.yml的结果.我正在使用Symfony 2.4.6,如果这有所不同.