| # |
Mar 13th 2019, 18:38 |
 ruc0la |
this cakephp2 was installed with composer and I get server error (500) |
| # |
Mar 13th 2019, 18:38 |
slackebot |
<ruc0la> |
| # |
Mar 13th 2019, 18:37 |
ruc0la |
Hey all, Can somebody assist me with some nginx configuration for cakephp2? |
| # |
Mar 13th 2019, 18:08 |
slackebot |
+-----------+---------------+---------+---------------------+ ``` The part which I can't figure out and can't find in the docs, is how to alias the table in the subquery. Any help would be greatly appreciated. |
| # |
Mar 13th 2019, 18:08 |
slackebot |
query which fetches the current version for every `software_name` in the table. The SQL which does this, looks like this: ``` select server_id, software_name, version, state_date from server_software_versions WHERE state_date = (select MAX(myAlias.state_date) FROM server_software_versions myAlias WHERE server_software_versions.software_name = myAlias.software_name) order by state_date; ``` The results of this query: ``` |
| # |
Mar 13th 2019, 18:08 |
slackebot |
+-----------+---------------+---------+---------------------+ | server_id | software_name | version | state_date | +-----------+---------------+---------+---------------------+ | 7 | keepalived | 1.2.13 | 2018-06-12 09:22:01 | | 7 | haproxy | 1.7.11 | 2018-06-18 13:00:46 | | 7 | filebeat | 5.6.10 | 2018-06-18 13:00:46 | | 7 | exim | 4.84_2 | 2018-06-18 13:00:46 | |
| # |
Mar 13th 2019, 18:08 |
slackebot |
2018-06-12 09:22:01 | | 7 | 7 | keepalived | 1.2.13 | 2018-06-12 09:22:01 | | 8 | 7 | exim | 4.84_2 | 2018-06-12 09:22:01 | | 9 | 7 | haproxy | 1.7.11 | 2018-06-18 13:00:46 | | 10 | 7 | filebeat | 5.6.10 | 2018-06-18 13:00:46 | | 11 | 7 | exim | 4.84_2 | 2018-06-18 13:00:46 | +----+-----------+---------------+---------+---------------------+ ``` What I want, is to have on |
| # |
Mar 13th 2019, 18:08 |
slackebot |
+----+-----------+---------------+---------+---------------------+ | 1 | 7 | haproxy | 1.7.11 | 2018-06-05 17:23:10 | | 2 | 7 | filebeat | 5.6.9 | 2018-06-05 17:23:10 | | 3 | 7 | keepalived | 1.2.13 | 2018-06-05 17:23:10 | | 4 | 7 | exim | 4.84_2 | 2018-06-05 17:23:10 | | 5 | 7 | haproxy | 1.7.11 | 2018-06-12 09:22:01 | | 6 | 7 | filebeat | 5.6.9 | |
| # |
Mar 13th 2019, 18:08 |
tunafish |
Hi everyone! I'm having some trouble writing a query in the ORM. It uses a where with a subquery referencing the main query to select the row with a maximum value in it, and aliases the table in the subquery. I'll clarify: My table looks like this: ``` +----+-----------+---------------+---------+---------------------+ | id | server_id | software_name | version | state_date | |
| # |
Mar 13th 2019, 16:41 |
this.impetus |
ah ha. ok. tyvm. I'm on my way now |
| # |
Mar 13th 2019, 16:32 |
this.impetus |
So in the example page you linked, the key 'photo'—is that a sample field name? Or should the photos array contain a "fields" key? |
| # |
Mar 13th 2019, 16:27 |
this.impetus |
sadly I'm someone who doesn't reallllly understand cake but once I learn to accomplish a thing I can repeat it lol. assembling enough pieces eventually passes for competence |
| # |
Mar 13th 2019, 16:26 |
this.impetus |
yeah I guessed as much. seems like a pretty cakey logic |
| # |
Mar 13th 2019, 16:26 |
ricksaccous |
okay, to give you a further hint it has to do with the name of your image field in the actual upload form |
| # |
Mar 13th 2019, 16:25 |
this.impetus |
second I am looking at my project and trying to understand what you're suggesting before asking further questions |
| # |
Mar 13th 2019, 16:25 |
ricksaccous |
hehe |
| # |
Mar 13th 2019, 16:25 |
this.impetus |
I *definitely* need to better understand cake.. I used cake2 a *lot* once upon a time, I am totally lost with 3+ |
| # |
Mar 13th 2019, 16:25 |
ricksaccous |
you are making these configuration changes where you add the behavior, most likely in your model's initialize |
| # |
Mar 13th 2019, 16:24 |
ricksaccous |
in the behavior set up |
| # |
Mar 13th 2019, 16:24 |
ricksaccous |
you need to dig deeper into reading about the configuration/docs and if you're not understanding what you're reading you probably need to understand more about cake but basically your image field name has to be configured |
| # |
Mar 13th 2019, 16:23 |
ricksaccous |
hehe |
| # |
Mar 13th 2019, 16:23 |
this.impetus |
I don't think, sorry, that I really understand the fields option. What's their purpose/function? |
| # |
Mar 13th 2019, 16:22 |
this.impetus |
Nope; paths exist, permissions correct |
| # |
Mar 13th 2019, 16:22 |
ricksaccous |
but those are possible as well |
| # |
Mar 13th 2019, 16:22 |
ricksaccous |
it could be a number of issues, including you might not have your fields option set up correctly |
| # |
Mar 13th 2019, 16:21 |
neon1024 |
Perhaps the folder doesn’t exist, or there is a permissions issue? |
| # |
Mar 13th 2019, 16:20 |
this.impetus |
@ricksaccous Ok—so I looked here; I tried adding a path configuration here, but it seemed to do nothing—neither errors nor any files arriving in the designated path. Sorry I am out of my depth here but taking over a project from someone else |
| # |
Mar 13th 2019, 16:17 |
ricksaccous |
@this.impetus https://cakephp-upload.readthedocs.io/en/latest/examples.html |
| # |
Mar 13th 2019, 16:12 |
this.impetus |
as an added note, in the "Configuration" section of the docs there is a lot of sample code, but, I don't know where that might go in order to emulate it. |
| # |
Mar 13th 2019, 16:10 |
this.impetus |
heyo... novice here. trying to use jose gonzlez's Upload Plugin. Have installed it, don't really understand how to configure it... uploading an image at this point "works" from the front end but the files don't seem to go anywhere |
| # |
Mar 13th 2019, 16:08 |
admad |
cakenub: just ask your question and wait for someone to respond |
| # |
Mar 13th 2019, 16:05 |
cakenub |
hey room.. need some cake help. anyone free? |
| # |
Mar 13th 2019, 15:58 |
steinkel |
and https://github.com/CakeDC/auth/releases/tag/4.0.0 |
| # |
Mar 13th 2019, 15:58 |
ricksaccous |
np |
| # |
Mar 13th 2019, 15:58 |
kaliel |
thx :slightly_smiling_face: |
| # |
Mar 13th 2019, 15:58 |
kaliel |
oh yes sure |
| # |
Mar 13th 2019, 15:58 |
ricksaccous |
can be a field that doesn't exist in db if it doesn't need to be saved |
| # |
Mar 13th 2019, 15:58 |
kaliel |
i tought about it but i will have a duplicate field :S |
| # |
Mar 13th 2019, 15:57 |
ricksaccous |
@kaliel create another field that you populate yourself with Time::now(); |
| # |
Mar 13th 2019, 15:53 |
kaliel |
I'd like to create a custom validation rule based on previous persisted entity by checking the filed 'created' populated by TimestampBehavior. Seems that TimestampBehavior adds 'created' in beforeSave so i can't validate, any idea on how to manage this please ? |
| # |
Mar 13th 2019, 15:44 |
dereuromark |
https://github.com/dereuromark/cakephp-tinyauth/pull/97/files if anyone can help maybe? |