kayue / KayueWordpressBundle

A Symfony 2 bundle for providing WordPress repositories and authenticating users (login).
101 stars 43 forks source link

Update symfony db #30

Closed querinimarco closed 10 years ago

querinimarco commented 10 years ago

Hello, I am using the KayueWordpressBundle and it works very well! (i can retrieve data about posts, blogs, users, ... correctly).

The problem is that i would like to add a new table to the database, so i generated a new entity and run the command:

php app/console doctrine:schema:update --force

Could you help me :) ?

Thank you!!

I got the following error, so actually i can't update the db (i am using wordpress 3.8.1 and the last realease of the kayueWordpressBundle).

[Doctrine\DBAL\DBALException]
An exception occurred while executing 'ALTER TABLE wp_postmeta ADD CONSTRAINT FK_41C0A2764B89032C FOREIGN KEY (post_id) REFERENCES wp_posts (ID)':

SQLSTATE[HY000]: General error: 1005 Can't create table 'flywers.#sql-456_108' (errno: 150)

[PDOException]
SQLSTATE[HY000]: General error: 1005 Can't create table 'flywers.#sql-456_108' (errno: 150)

benglass commented 10 years ago

See #36

@kayue I think this can be closed