php - Doctrine generating wrong INSERT statement -


i generated mysql database using doctrine symfony , had modify 1 table, extracting 2 of attributes , assign them new entity. first entity called "area" , second 1 called "formato". previously, when wanted create new area, provided id, name, width , height. (as application designed in spanish, width called "ancho" , height called "alto") now, new design, idea provide id, name, , formatid. of course, there formats inserted in format table, , area have formatid foreign key formato. far it's not complex thing do, however, when try create new area, receive error:

abstractmysqldriver->convertexception('an exception occurred while executing \'insert areas (descripcion, nombre, idarea, ancho, alto, idmedio, idformato) values (?, ?, ?, ?, ?, ?, ?)\' params ["", "zilosoft area7", "21626759324", null, null, "28545628", "1"]:sqlstate[42s22]: column not found: 1054 unknown column \'ancho\' in \'field list\'', object(pdoexception))

so, can see, new insert statement mixing old attributes new one, generating sort of "mixed" or "merged" statement.

i've been searching on , on through source files can't understand how happening, entities date, meaning area has format , not "ancho" nor "alto", , formato separated entity "ancho" , "alto" inside it.

do know if should "reset" or "clean cache" in doctrine generates correct insert statement?

by way, formato data taken combo box in twig template, , loaded formatos table.

you're missing final step

so updated entities improve, update, or modify data structure, mysql database still has no idea made changes. way remedy telling doctrine update schema. way running following command on machine:

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

note --force try running query directly. if rather run queries yourself, can use --dump-sql option, print out queries


Comments

Post a Comment

Popular posts from this blog

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

i running os ububtu 16.04. ultimate goal able run php script cron job every minute. here php script located @ /var/www/html/tests/test/index.php : <?php $directorypath = $_server['document_root']."/tests/test/data/"; echo "directorypath: $directorypath<br><br>";//check $imagefilepathsarray = glob($directorypath . "*.{png,gif}", glob_brace); echo "<br><br>imagefilepathsarray: "; print_r($imagefilepathsarray);//check ?> when open php script in browser visiting url my-ip-address/tests/test/index.php , get: directorypath: /var/www/html/tests/test/data/ imagefilepathsarray:array( [0] => /var/www/html/tests/test/data/pic.png [1] => /var/www/html/tests/test/data/pic.gif ) before writing cron job in crontab file, need check if can run anywhere using terminal . opened ubuntu terminal @ /home/ location, , executed in terminal: sudo php /var/www/html/tests/test/index.php i got following out...
Read more

php - How can i create a user dashboard -

today have questions you, want create user dashboard site, include (obviously), users data, example -email -username -and others stuff how can information, , print them in html page? if can, how can these information via php sessions? shuld use session? example, if user login, , start new session ( session_start() ), how can data print in dashboard? should use php "project"? in advice, have day , thank time!
Read more

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -

i have jquery mobile page fixed full-screen toolbar, data-tap-toggle enabled. straight under toolbar have positioned banner should slide upwards when toolbar hiding , slide downward when toolbar showing. jquery mobile toggles toolbar applying , removing ui-fixed-hidden class - sadly, can't find in documentation of toolbar widget toggle , hide or show event that. how can detect when toolbar toggled, reposition banner? .banner { position: fixed; background-color: darkseagreen; top: 46px; min-height: 48px; width: 100%; text-align: center; line-height: 48px; } <!doctype html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no"> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"> <script src="https://code.jquery.com/jquery-1....
Read more