# |
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 |