remove user cache entirely (it works fine by itself, but the app is later run over multiple processes that have separate memory, so the cache can be updated in one process but not in another :/)

we cascade the LEFT JOIN-ed queries to ensure correct cardinality of records (probably not necessary when joining affiliations + keywords because affiliations are 1 to 1, but definitely needed when joining affs + kws + hashtags)

(not necessary it actually worked well inside docker)

This reverts commit 3daf2376.

prevent login when user is registered but didnt validate his registration yet (+add a message in login modal +better fetch promise unwrapping)

DOORS_HOST for dev is now outside our docker + its default port is 443 (TODO make implicit) + made LOG_TEE more visible

Ok using local API in testMailFormatAndExistence (case register has now 2 chained ajax to Doors then to local: email must be used in neither)

local api to check if email exists on comexdb side (TODO use it in register case of testMailFormatAndExistence)

php bugfixes + 2 workarounds for DB current state (affiliation = lab and position and affiliation can have a null placeholder)

php bugfixes + 2 workarounds for DB current state (affiliation = lab and position and affiliation can have a null placeholder)