vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php at lin

Question

hi 在 cPanel 主机中上传 Symfony2 项目后：

执行时发生异常

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id0 FROM (SELECT n0_.id AS id0, n0_.type AS type1, n0_.annoDate AS annoDate2, n0_.solarDate AS solarDate3, n0_.title AS title4, n0_.body AS body5, n0_.bodyMore AS bodyMore6, n0_.fileName AS fileName7, n0_.user_username AS user_username8 FROM NewsOrNotification n0_ WHERE n0_.type = 1 ORDER BY n0_.annoDate DESC) dctrn_result) dctrn_table:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'darspard_h4mit.NewsOrNotification' doesn't exist 
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'darspard_h4mit.User' doesn't exist 
 in .../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php at line 646  -+
                    $stmt->execute($params);
                }
            } else {
                $stmt = $this->_conn->query($query);
            }
        } catch (Exception $ex) {
            throw DBALException::driverExceptionDuringQuery($ex, $query, $this->resolveParams($params, $types));

Answer 1

运行php app/console doctrine:schema:update --force .如果无法访问控制台，请上传在开发环境中生成的"就绪且干净"的数据库

Answer 2

我在 Windows 操作系统上的开发环境不区分大小写，但 Linux 服务器区分大小写。结果，具有相同名称、实体和我的问题的重命名表得到了解决。例如：

表新闻或通知

将名称更改为新闻或通知