Log message #4019385

# At Username Text
# Apr 21st 2017, 16:23 hmic thats the proper solution to the problem.
# Apr 21st 2017, 16:22 watermark no, that is logical, it won't work
# Apr 21st 2017, 16:21 hmic set the clock correct and set the alarms 10 mins before the events
# Apr 21st 2017, 16:21 watermark so, slightly off topic, my boss just said we cannot use two factor totp because he wants to set the clock on his phone 10 minutes fast so he's not late to things. What do?
# Apr 21st 2017, 16:20 hmic *shudder*
# Apr 21st 2017, 16:20 hmic there is lots of things that need to be fixed
# Apr 21st 2017, 16:19 Dinossaur Literal queries was done on my first encounter with CakePHP. I just had not learn ORM then. Not escaping was a blunder. I'll fix it
# Apr 21st 2017, 16:15 hmic are you kiding me?
# Apr 21st 2017, 16:15 hmic $conn->execute($query);
# Apr 21st 2017, 16:15 hmic );
# Apr 21st 2017, 16:15 hmic $_SERVER['clienteDominio']
# Apr 21st 2017, 16:15 hmic $req->query['Usuario_id'],
# Apr 21st 2017, 16:15 hmic $entity->id,
# Apr 21st 2017, 16:15 hmic you use literal queries with user data, not escaping it at all, not binding the values at least and not using the orm in the same function for no reason? $query = sprintf("insert ignore into sis_usuario_perfil (Perfil_id,Usuario_id,Cliente_id) values (%d,%d,%d)",
# Apr 21st 2017, 16:15 Dinossaur sorry... I'm not sure what is "super globals from a tables callback function"...
# Apr 21st 2017, 16:14 Dinossaur https://thepasteb.in/p/vghOxz56BZof3
# Apr 21st 2017, 16:14 hmic no wonder this spits on you!
# Apr 21st 2017, 16:14 hmic you are setting super globals from a tables callback function?
# Apr 21st 2017, 16:14 hmic $_SERVER['ENTITY'] = $entity;
# Apr 21st 2017, 16:14 hmic you know what, that code is really really bad! check this: if (isset($req->query['Usuario_id'])) {
# Apr 21st 2017, 16:12 hmic can you show the query from UsersController line 147?
# Apr 21st 2017, 16:08 Dinossaur @hmic i made the changes, but the error persists as before.
# Apr 21st 2017, 16:06 hmic probably you just need to add the behaviour after setting the tablename and alias, so move that line further down
# Apr 21st 2017, 16:05 hmic additionally call parent::initialize in the end of that function, not the beginning
# Apr 21st 2017, 16:04 hmic Dinossaur, do you need the setAlias('users') really? - i dont use that. and if you do, make sure it reads "Users" not "users" IMHO
# Apr 21st 2017, 16:04 birdy247 import charges
# Apr 21st 2017, 16:03 hmic does it matter? costs 50$ shipping and a week of waiting
# Apr 21st 2017, 16:02 birdy247 Im UK
# Apr 21st 2017, 16:02 birdy247 All in the states
# Apr 21st 2017, 16:02 hmic these are dead cheap!
# Apr 21st 2017, 16:02 birdy247 I think id rather just buy new for ease of life
# Apr 21st 2017, 16:01 hmic if the smart values of the disks are ok, you could maybe get a year or so out of them before needing to replace them really. for me thats just not worth it. but if you do backups - really do them, you will be good with one of those for quite some time. they do use enterprise harddisks and ssds, so the wear should be bearable. but you never know where the machines come from...
# Apr 21st 2017, 15:59 hmic www.ebay.co.uk/itm/LENOVO-THINKSTATION-S30-M-XEON-E5-2665-8C-2-4GHZ-DDR3-48-0GB-1TBx2-256-GB-SSD/262935543897
# Apr 21st 2017, 15:59 birdy247 I need 2
# Apr 21st 2017, 15:58 hmic buy a new samsung ssd and bob's your uncle
# Apr 21st 2017, 15:58 hmic but the more current p310 is a good choice too, just get a xeon and ecc ram, if you ask me
# Apr 21st 2017, 15:58 hmic it has ecc ram and an xeon e5 server cpu... and is really really cheap for this kind of hardware
# Apr 21st 2017, 15:57 hmic my current workstation is similar to this, just with ssd and different graphics
# Apr 21st 2017, 15:57 hmic http://www.ebay.co.uk/itm/Lenovo-ThinkStation-S30-Xeon-E5-1620-3-60GHz-Quad-Core-16GB-DDR3-Win10-pro-K600-/122416688150?hash=item1c809a6c16:g:j7kAAOSw4A5Y2Ckf
# Apr 21st 2017, 15:56 hmic yes
# Apr 21st 2017, 15:56 birdy247 so youd buy a refurb and swap out the hard disk?