Log message #4054598

# At Username Text
# 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
# Jul 20th 2017, 12:59 hmic you cant if you want to use allow, allow does just allow an action to be accessed like before (without auth beeing enabled), nothing else.
# Jul 20th 2017, 12:58 Ecorce nop, I juste need to check if user is connected with Auth, no more
# Jul 20th 2017, 12:58 hmic if you want to decide on a user basis, this is not authentication, but authorization and you would need an isauthorized in the controller (and set controllerauthorization in the auth config), like i said before
# Jul 20th 2017, 12:57 hmic you need to allow before auth has run!