| # |
Jul 4th 2017, 20:23 |
 jeremyharris |
ack! please don’t drive and text! |
| # |
Jul 4th 2017, 20:22 |
jigzat |
hi, hold on I'm driving |
| # |
Jul 4th 2017, 20:20 |
jeremyharris |
usually :) |
| # |
Jul 4th 2017, 20:19 |
cleptric |
:see_no_evil: |
| # |
Jul 4th 2017, 20:18 |
jigzat |
Hello, is there anyone here? |
| # |
Jul 4th 2017, 20:17 |
jeremyharris |
I think that would be set in the datasource config under flags |
| # |
Jul 4th 2017, 20:16 |
Laureano |
I'm looking into that right now |
| # |
Jul 4th 2017, 20:16 |
Laureano |
Seems like CakePHP or MySQL is using an stricter mode, which is setting NO_ZERO_DATE for the session |
| # |
Jul 4th 2017, 20:15 |
Laureano |
But, looking at the exception to give you more context, I think I found the issue |
| # |
Jul 4th 2017, 20:15 |
Laureano |
Sadly, I can't ask the DBA because other components use that same table, and rely on the fact that it allows zero dates to compared ranges |
| # |
Jul 4th 2017, 20:10 |
jeremyharris |
thought: have you tried using ->update instead of updateAll? like $this->query()->update()->set()->where()->execute() |
| # |
Jul 4th 2017, 20:09 |
jeremyharris |
also I’d submit a ticket to your DBA to allow nulls in there if you can :slightly_smiling_face: |
| # |
Jul 4th 2017, 20:09 |
jeremyharris |
interesting. what exception do you get? can you gist a stack trace? |
| # |
Jul 4th 2017, 20:07 |
Laureano |
Thank you jeremyharris! I'm actually able to update the rows outside CakePHP, the engine is ok with that |
| # |
Jul 4th 2017, 20:05 |
jeremyharris |
I’m not familiar with MariaDB, you’ll have to look up the docs on your version to see if a 0-date is even allowed. If you’re receiving an error it’s like that it’s not allowed by the db engine |
| # |
Jul 4th 2017, 19:57 |
Laureano |
jeremyharris MySQL is MariaDB 10 |
| # |
Jul 4th 2017, 19:57 |
Laureano |
admad Would love to -- but it's outside my permissions. Don't have access to do it. I'm just patching an external tool. |
| # |
Jul 4th 2017, 19:55 |
admad |
mysql is silly for allowing it |
| # |
Jul 4th 2017, 19:55 |
admad |
storing '0000-00-00 00:00:00' is just wrong, set the field to null instead |
| # |
Jul 4th 2017, 19:54 |
jeremyharris |
depends on what version of mysql, if I remember right 0-dates like that don’t store in 5.7, you want a proper null field |
| # |
Jul 4th 2017, 19:52 |
Laureano |
I would like to bulk reset a field but every approach I tried raised an exception |
| # |
Jul 4th 2017, 19:52 |
Laureano |
What would be the correct way to store '0000-00-00 00:00:00' on a datetime field (MySQL) while using $model->updateAll() on CakePHP 3? |
| # |
Jul 4th 2017, 18:02 |
awi |
So i haven't moved a single file yet. |
| # |
Jul 4th 2017, 18:00 |
awi |
I think so... I am currently making my exif stuff |
| # |
Jul 4th 2017, 17:59 |
WyriHaximus |
awi: did you manage to get it working |
| # |
Jul 4th 2017, 17:16 |
vix |
Unable to use pagination with Raw Query $results = $connection->execute('SELECT * FROM articles')->fetchAll('assoc'); |
| # |
Jul 4th 2017, 16:54 |
jarard01 |
thanks neon1024 |
| # |
Jul 4th 2017, 16:53 |
neon1024 |
@jarard01 You need to use the table class when calling table classes from the controller, so it should be `$this->Properties->rhs()` |
| # |
Jul 4th 2017, 16:33 |
jarard01 |
my view says: Call to undefined method App\Controller\PropertiesController::rhs() |
| # |
Jul 4th 2017, 16:33 |
jarard01 |
in my Properties controller I call $this->rhs(); |
| # |
Jul 4th 2017, 16:32 |
jarard01 |
i have a method in my PropertiesTable.php called 'rhs' |
| # |
Jul 4th 2017, 15:50 |
awi |
thx |
| # |
Jul 4th 2017, 15:49 |
WyriHaximus |
gotte run for now |
| # |
Jul 4th 2017, 15:44 |
WyriHaximus |
It requires a webdav client to be used with as per this example: https://flysystem.thephpleague.com/adapter/webdav/ |
| # |
Jul 4th 2017, 15:43 |
awi |
just where can i find the vars for webdav? |
| # |
Jul 4th 2017, 15:42 |
WyriHaximus |
Np, anyway I can help? :) |
| # |
Jul 4th 2017, 15:41 |
jeremyharris |
summoned from the great beyond |
| # |
Jul 4th 2017, 15:41 |
awi |
didnt see you where there |
| # |
Jul 4th 2017, 15:41 |
neon1024 |
Lol, great service! |
| # |
Jul 4th 2017, 15:41 |
WyriHaximus |
=D |
| # |
Jul 4th 2017, 15:41 |
awi |
Oh... |