| # |
Jul 2nd 2018, 16:27 |
camdenbassett |
https://thepasteb.in/p/AnhrPyoqV74fv |
| # |
Jul 2nd 2018, 16:27 |
camdenbassett |
$response = $conn->execute($replace_into_form); |
| # |
Jul 2nd 2018, 16:24 |
camdenbassett |
Ok, so I found out how to get the last inserted ID when executing a custom query using the connection object. But does anyone know if this is completely reliable? |
| # |
Jul 2nd 2018, 16:21 |
 afdm74 |
@josbeir That's the thing, I'm not using thoses classes directly... Some other code is using it. |
| # |
Jul 2nd 2018, 16:10 |
okelet |
hi all, quite new to cakephp here, great job! my question, how to do all queries to have default contains? I don't want to repeat the same contains multiple times, every time i do a search... Thanks! |
| # |
Jul 2nd 2018, 15:53 |
josbeir |
you should update your code accordingly |
| # |
Jul 2nd 2018, 15:53 |
josbeir |
yeah but thats just nice exceptions of classes that changed name/scope |
| # |
Jul 2nd 2018, 15:51 |
afdm74 |
@josbeir line 444 just include the Class file. But I was unable to point out the files that needed these classes.... |
| # |
Jul 2nd 2018, 15:50 |
afdm74 |
@josbeir The message I 'm getting is this: Use Cake\Mailer\Email instead of Cake\Network\Email\Email. - /home/pbxcircus/app/vendor/composer/ClassLoader.php, line: 444 and this: Use Cake\Http\ServerRequest instead of Cake\Network\Request. |
| # |
Jul 2nd 2018, 15:48 |
afdm74 |
@josbeir I don think that it is a bug yet..... (investigating....) I'm talking as a Bug because the code is not my code and it looks like is something that didn't get updated in the update process. |
| # |
Jul 2nd 2018, 15:39 |
camdenbassett |
I've been doing a little more research on my question. And I haven't found any answer that seems to work. I could just run a select statement to get the highest id, but that's not completely reliable. Is there any way to access the underlying PDO functions when using a custom query maybe? |
| # |
Jul 2nd 2018, 15:29 |
josbeir |
ah cake has one too |
| # |
Jul 2nd 2018, 15:29 |
josbeir |
isn't classloader is a composer file ? |
| # |
Jul 2nd 2018, 15:28 |
josbeir |
@afdm74 why do you think it is a bug? |
| # |
Jul 2nd 2018, 15:19 |
afdm74 |
Other question, just updated from 3.4.10 to 3.6.6 and started getting Deprecated Messages for Bootstrap.php and ClassLoader.php. The Bootstrap file I fixed changing config() to setConfig(). The ClassLoader.php could not find the error source... As this is not my code, where should I search and file a bug report? And If it is a bug... |
| # |
Jul 2nd 2018, 15:16 |
camdenbassett |
There's a pastebin of all the approaches I've tried. Any pointers would be appreciated. |
| # |
Jul 2nd 2018, 15:15 |
camdenbassett |
https://thepasteb.in/p/Y6hkvRl9rgxf7 |
| # |
Jul 2nd 2018, 15:15 |
camdenbassett |
Hello everyone. I'm running a custom mysql "REPLACE INTO" statement via the connection object, and I can't seem to figure out how to get the id of the inserted row. |
| # |
Jul 2nd 2018, 15:14 |
afdm74 |
@lorenzo Will try that, thanks! |
| # |
Jul 2nd 2018, 15:10 |
rudy1976s |
which are not directly related to cake queries |
| # |
Jul 2nd 2018, 15:10 |
rudy1976s |
we have traced logs and performance monitor and there are plenty of queries generated many times |
| # |
Jul 2nd 2018, 15:09 |
rudy1976s |
and we need to understad if they depends on some missing PDO setting |
| # |
Jul 2nd 2018, 15:08 |
rudy1976s |
we are detecting a lot of strange queries created by sqlserver when working on it |
| # |
Jul 2nd 2018, 15:07 |
lorenzo |
@rudy1976s what do you need to change? |
| # |
Jul 2nd 2018, 15:07 |
lorenzo |
@afdm74 I recommend this plugin that will help you do that https://github.com/FriendsOfCake/search |
| # |
Jul 2nd 2018, 15:06 |
rudy1976s |
I need to tweak it because we are facing performance problem using cake on sqlserver |
| # |
Jul 2nd 2018, 15:06 |
rudy1976s |
@lorenzo thank you |
| # |
Jul 2nd 2018, 15:06 |
lorenzo |
you need to make the post arguments into get arguments |
| # |
Jul 2nd 2018, 15:03 |
afdm74 |
Hi guys, Having trouble using pagination and custom queries. When clicking in next page it loses all filter information and display a Not Found page. I debugged it and the reason is because the Paginator uses Get requests. The paginator is not geeting or keeping the filters and resetting when clicked on the next page. What am I doing wrong? |
| # |
Jul 2nd 2018, 15:03 |
lorenzo |
it shuld be `[PDO::CONSTANT_THING => $value]` |
| # |
Jul 2nd 2018, 15:00 |
rudy1976s |
@lorenzo, so the array should only contain PDO constants or should I need to add as [‘pdo_name’ => ‘pdo_constant’] |
| # |
Jul 2nd 2018, 14:52 |
lorenzo |
you need to use the constants |
| # |
Jul 2nd 2018, 14:52 |
lorenzo |
yeah, it can be any PDO flag |
| # |
Jul 2nd 2018, 14:47 |
rudy1976s |
I need to add some PDO flag to the sql server datasources: I know from docs this is supported, but the associative array could contain all PDO supported flag ? and what is the correct names to build associative array ? on pdo docs I was only able to find the constants |
| # |
Jul 2nd 2018, 14:45 |
itmpls |
good morning |
| # |
Jul 2nd 2018, 14:45 |
rudy1976s |
good afternoon |
| # |
Jul 2nd 2018, 14:10 |
dereuromark |
PRs |
| # |
Jul 2nd 2018, 14:10 |
qq |
@dereuromark how to improve the cakephp documents in Chinese? the Chinese(zh) document has not been updated for ages. |
| # |
Jul 2nd 2018, 14:06 |
itmpls |
it happens to all of us :slightly_smiling_face: np |
| # |
Jul 2nd 2018, 14:06 |
rrd564 |
:slightly_smiling_face: |
| # |
Jul 2nd 2018, 14:06 |
rrd564 |
eh what a silly mistake |