Log message #4221273

# At Username Text
# Jan 7th 2020, 13:16 ndm @val One could possibly sneak it in by using `Query::update()` directly and passing a table name manually, like `->update('posts AS Posts')` but that's kinda hackish. Also note that aliases are being removed from `UPDATE` and `DELETE` query conditions for various reasons, among others to avoid problems with association conditions, and because aliases aren't supported (without additional clauses) in all dialects. So you may have to resort to using
# Jan 7th 2020, 13:06 etibor i use to generate PDF from the view also the WkHtmlToPDF but in my case i need to use a predefinied pdf file,because sometimes its change. I only want to pass variables for it
# Jan 7th 2020, 13:05 lubos I am wondering if there is core validation rules to check letters only? there is `alphaNumeric`, `numeric` but nothing to check [a-zA-Z]... do i need to use custom and regex?
# Jan 7th 2020, 13:02 jotpe @etibor I normally generate PDFs by generating html first and then use WkHtmlToPDF
# Jan 7th 2020, 13:00 jotpe It'sa old db, so I had to migrate a lot.
# Jan 7th 2020, 13:00 jotpe Deadlock :(
# Jan 7th 2020, 12:59 dereuromark You should have those fields nullable (default null).
# Jan 7th 2020, 12:59 dereuromark @jotpe See https://github.com/dereuromark/cakephp-setup/blob/master/src/Shell/DbMaintenanceShell.php#L394
# Jan 7th 2020, 12:59 jotpe I can't change the modified field to null, this rises the Exception ;)
# Jan 7th 2020, 12:58 etibor i know its not a real cake specific question but you may know .do you have good solution to generate PDF from current PDF pattern file,i was trying with FPDM but main problem i could not render a flatten pdf(without inputs just only texts)
# Jan 7th 2020, 12:58 dereuromark just null :)
# Jan 7th 2020, 12:56 jotpe What is the default value for datetime fields? E.g. I have a migration to change some fields of my table but I got: PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0000-00-00 00:00:00' for column 'modified' at row
# Jan 7th 2020, 12:56 etibor hello all
# Jan 7th 2020, 12:42 val `updateAll()` does not generate an alias
# Jan 7th 2020, 12:41 val Hi, is there a way to generate UPDATE query with an alias like `UPDATE posts AS Post WHERE ....`? The alias is needed in the subquery.
# Jan 7th 2020, 12:07 jotpe :)
# Jan 7th 2020, 12:07 spriz :)
# Jan 7th 2020, 12:07 spriz Obviously fofi
# Jan 7th 2020, 12:07 spriz :thinking_face:
# Jan 7th 2020, 12:07 jotpe How to handle fifo then @spriz?
# Jan 7th 2020, 12:01 spriz thank me later
# Jan 7th 2020, 12:01 spriz queue from behind! `eueuq`!
# Jan 7th 2020, 11:45 jotpe Well, I guess I don't want to find (or even search) that wormhole. Better search a dict for more awful german words ;)
# Jan 7th 2020, 11:43 admad @jotpe Unless you find a wormhole to an alternate dimension where Hitler won WW2, you aren't going to see the plugin named warteschlange :)
# Jan 7th 2020, 10:22 jotpe + direct translation Warte (=Wait) schlange (=Snake) is super awful :trollface:
# Jan 7th 2020, 10:20 jotpe https://twitter.com/cakephp/status/1214179774136016896 <--- I suggest the convenient german word _Warteschlange_ (=queue) for this.
# Jan 7th 2020, 09:50 conehead Yeh. Just removed like 8 plugins...now will install them one after another again and see if that works
# Jan 7th 2020, 09:39 dereuromark you mean beta plugins? yeah, those require min stability dev/beta then.
# Jan 7th 2020, 09:37 conehead It was actually the ide helper. and the tags plugin. Seems like I gotta fix that manually
# Jan 7th 2020, 09:35 conehead Good morning
# Jan 7th 2020, 09:35 neon1024 Morning all
# Jan 7th 2020, 09:35 jotpe Good morning, folks!
# Jan 7th 2020, 09:34 dereuromark Or again: Do the simple thing, manually fix up the json file and run update globally. that will always work. Major jumps are always a bit harder.
# Jan 7th 2020, 09:33 dereuromark Bake is needed in v2 - and that is locked in your vendor to v1 still. You could additionally remove the vendor dir here.
# Jan 7th 2020, 09:24 conehead Just wondering why only I seem to have that error
# Jan 7th 2020, 09:23 conehead Just deleted the lock file. Same error
# Jan 7th 2020, 09:23 dereuromark you can also remove the lock file for now, that should have the same effect :)
# Jan 7th 2020, 09:23 dereuromark set cakephp into it, I mean. you have bake in the lock file and thats whats blocking you
# Jan 7th 2020, 09:22 conehead bake is not in my composer file. seems to be somewhere else. Am I in dependency hell?
# Jan 7th 2020, 09:21 dereuromark then adjust the composer.json and run global update. the lock file currently seems to block this.
# Jan 7th 2020, 09:20 conehead unfortunately still the same error