SQLSTATE [42S02]：找不到基表或视图：1146表'sf_sandbox.phpcr_workspaces'不存在

Question

I installed symfony-standard edition.After some struggle with parameters.yml there was progress... the database_driver was set to pdo_mysqln and the running proceeded however there were 6 occurences of the same error in different php files .and the error was:

Unexpected error talking to the backend: An exception occurred while executing 'SELECT 1 FROM phpcr_workspaces WHERE name = ?' with params ["default"]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sf_sandbox.phpcr_workspaces' doesn't exist

any ideas?

Answer 1

You must update your database with the current schema information, which includes creating the tables in the database:

# show the SQL commands to be applied (if you want to execute them yourself)
app/console doctrine:schema:update --force --dump-sql

# have Symfony apply the SQL commands
app/console doctrine:schema:update --force --complete