# |
Jul 20th 2017, 14:17 |
admad |
your association config is fine. I aint gonna read whatever mess you have in controller :slightly_smiling_face: |
# |
Jul 20th 2017, 14:13 |
admad |
or better yet full PropertiesTable |
# |
Jul 20th 2017, 14:13 |
mccp |
https://gist.github.com/mccp/8b135e5556c57671ab17c756c9af34fa |
# |
Jul 20th 2017, 14:13 |
admad |
show your association config |
# |
Jul 20th 2017, 14:12 |
mccp |
but still can't |
# |
Jul 20th 2017, 14:12 |
mccp |
yes, i've set the db to nullable |
# |
Jul 20th 2017, 14:12 |
neon1024 |
If it’s baked :slightly_smiling_face: |
# |
Jul 20th 2017, 14:12 |
neon1024 |
It’d probably fail the Rules though |
# |
Jul 20th 2017, 14:12 |
admad |
make sure that column is nullable in db |
# |
Jul 20th 2017, 14:12 |
admad |
you can |
# |
Jul 20th 2017, 14:11 |
mccp |
if i have an PropertiesTable that belongsTo PropertyCategories, so can't I specify $property->property_category_id = null? |
# |
Jul 20th 2017, 14:11 |
hmic |
you cant save an associated entity without the entity it is associated with - makes sense, does it? |
# |
Jul 20th 2017, 14:10 |
hmic |
so you need to refer to another entity actually in your case |
# |
Jul 20th 2017, 14:10 |
hmic |
you cant? there is no way a primary key can be null |
# |
Jul 20th 2017, 14:10 |
mccp |
oh, wait, how can i allow it to be null? |
# |
Jul 20th 2017, 14:10 |
hmic |
so this is what it is |
# |
Jul 20th 2017, 14:09 |
mccp |
the error says it's null |
# |
Jul 20th 2017, 14:09 |
hmic |
you said its NULL |
# |
Jul 20th 2017, 14:09 |
mccp |
but the id i give it exists in database. |
# |
Jul 20th 2017, 14:04 |
hmic |
you are saving to an entity that does not exist |
# |
Jul 20th 2017, 14:04 |
mccp |
can anyone help me why i'm getting record not found in table with primary key [NULL] when the association jointype is left and null is allowed. |
# |
Jul 20th 2017, 13:40 |
hmic |
welcome |
# |
Jul 20th 2017, 13:36 |
Ecorce |
Yeeeeeees, problem solved. Thx hmic. |
# |
Jul 20th 2017, 13:26 |
hmic |
but an unauthorized request would be handled like you setup Auth anyways, so thats good already. maybe you could add a flashmessage to be shown and return false; |
# |
Jul 20th 2017, 13:25 |
hmic |
Ecorce, you could. but thats not what it is meant for really. NotAuthorizedException e.g. |
# |
Jul 20th 2017, 13:24 |
Ecorce |
(to provide a useful message) |
# |
Jul 20th 2017, 13:24 |
awi |
how can i put the download attribute into HtmlHelper::link()? Is it some sort of option? |
# |
Jul 20th 2017, 13:24 |
Ecorce |
Can isAuthorized return an exception? |
# |
Jul 20th 2017, 13:17 |
mccp |
here is a gist https://gist.github.com/mccp/8b135e5556c57671ab17c756c9af34fa |
# |
Jul 20th 2017, 13:17 |
mccp |
Hi, I'm trying to save my Listing entity that is associated with Properties entity by belongsTo which is also associated with a PropertyCategories entity by belongsTo. I've set the joinType between Propertiess and PropertyCategories to left. When a null value is assigned to $listing->property->property_category_id and called with $listingTable->save($listing), I get a Record not found in table property_categories with primary key [NULL |
# |
Jul 20th 2017, 13:17 |
hmic |
second, you add check if a user is logged in in the Controller::isAuthorized($user) returning true if you find a user in the session (well: return (bool)$user; or return array_key_exists('id', $user); or something) |
# |
Jul 20th 2017, 13:15 |
hmic |
so first: you allow all actions that should be accessible without beeing logged in in the Controller::initialize() with Auth->allow() |
# |
Jul 20th 2017, 13:14 |
Ecorce |
I've just the loginAction specified and that's all in the config |
# |
Jul 20th 2017, 13:14 |
Ecorce |
Yes, it's already done : "authorize' => ['Controller'] |
# |
Jul 20th 2017, 13:14 |
hmic |
"authorize" => "Controller" i think |
# |
Jul 20th 2017, 13:13 |
hmic |
you need to specify in the auth config |
# |
Jul 20th 2017, 13:13 |
Ecorce |
hmic, that'd be perfect to me, but... Auth don't want to look at my isAuthorized function, he redirects to loginAction first -_- |
# |
Jul 20th 2017, 13:12 |
awi |
hm. Does htmlHelper->link support the download tag? https://www.w3schools.com/tags/att_a_download.asp |
# |
Jul 20th 2017, 13:00 |
hmic |
3 lines of code there |
# |
Jul 20th 2017, 13:00 |
hmic |
you can put that in the appcontroller too and return true if a user exists. |
# |
Jul 20th 2017, 12:59 |
hmic |
you need to implement an isauthorized method |