Debug Kit show duplicated query
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
i was doing the cake toutorial and once i've ended, was looking on Debugkit sql log, inside the edit page of the article and looks like that the query to retrieve the article data is dupicated for some reason.
This is the query shown twice:
SELECT
Articles.id AS `Articles__id`,
Articles.user_id AS `Articles__user_id`,
Articles.title AS `Articles__title`,
Articles.slug AS `Articles__slug`,
Articles.body AS `Articles__body`,
Articles.published AS `Articles__published`,
Articles.created AS `Articles__created`,
Articles.modified AS `Articles__modified`
FROM
articles Articles
WHERE
Articles.slug = 'first-post'
LIMIT
1
This is the edit function:
public function edit($slug)
{
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
if ($this->request->is(['post', 'put'])) {
$this->Articles->patchEntity($article, $this->request->getData(), [
// Added: Disable modification of user_id.
'accessibleFields' => ['user_id' => false]
]);
if ($this->Articles->save($article)) {
$this->Flash->success(__('Your article has been updated.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to update your article.'));
}
$tags = $this->Articles->Tags->find('list');
$this->set('article', $article);
$this->set('tags', $tags);
}
The query should be executed only once at this line:
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
Correct?
mysql cakephp cakephp-3.0
add a comment |
i was doing the cake toutorial and once i've ended, was looking on Debugkit sql log, inside the edit page of the article and looks like that the query to retrieve the article data is dupicated for some reason.
This is the query shown twice:
SELECT
Articles.id AS `Articles__id`,
Articles.user_id AS `Articles__user_id`,
Articles.title AS `Articles__title`,
Articles.slug AS `Articles__slug`,
Articles.body AS `Articles__body`,
Articles.published AS `Articles__published`,
Articles.created AS `Articles__created`,
Articles.modified AS `Articles__modified`
FROM
articles Articles
WHERE
Articles.slug = 'first-post'
LIMIT
1
This is the edit function:
public function edit($slug)
{
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
if ($this->request->is(['post', 'put'])) {
$this->Articles->patchEntity($article, $this->request->getData(), [
// Added: Disable modification of user_id.
'accessibleFields' => ['user_id' => false]
]);
if ($this->Articles->save($article)) {
$this->Flash->success(__('Your article has been updated.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to update your article.'));
}
$tags = $this->Articles->Tags->find('list');
$this->set('article', $article);
$this->set('tags', $tags);
}
The query should be executed only once at this line:
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
Correct?
mysql cakephp cakephp-3.0
add a comment |
i was doing the cake toutorial and once i've ended, was looking on Debugkit sql log, inside the edit page of the article and looks like that the query to retrieve the article data is dupicated for some reason.
This is the query shown twice:
SELECT
Articles.id AS `Articles__id`,
Articles.user_id AS `Articles__user_id`,
Articles.title AS `Articles__title`,
Articles.slug AS `Articles__slug`,
Articles.body AS `Articles__body`,
Articles.published AS `Articles__published`,
Articles.created AS `Articles__created`,
Articles.modified AS `Articles__modified`
FROM
articles Articles
WHERE
Articles.slug = 'first-post'
LIMIT
1
This is the edit function:
public function edit($slug)
{
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
if ($this->request->is(['post', 'put'])) {
$this->Articles->patchEntity($article, $this->request->getData(), [
// Added: Disable modification of user_id.
'accessibleFields' => ['user_id' => false]
]);
if ($this->Articles->save($article)) {
$this->Flash->success(__('Your article has been updated.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to update your article.'));
}
$tags = $this->Articles->Tags->find('list');
$this->set('article', $article);
$this->set('tags', $tags);
}
The query should be executed only once at this line:
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
Correct?
mysql cakephp cakephp-3.0
i was doing the cake toutorial and once i've ended, was looking on Debugkit sql log, inside the edit page of the article and looks like that the query to retrieve the article data is dupicated for some reason.
This is the query shown twice:
SELECT
Articles.id AS `Articles__id`,
Articles.user_id AS `Articles__user_id`,
Articles.title AS `Articles__title`,
Articles.slug AS `Articles__slug`,
Articles.body AS `Articles__body`,
Articles.published AS `Articles__published`,
Articles.created AS `Articles__created`,
Articles.modified AS `Articles__modified`
FROM
articles Articles
WHERE
Articles.slug = 'first-post'
LIMIT
1
This is the edit function:
public function edit($slug)
{
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
if ($this->request->is(['post', 'put'])) {
$this->Articles->patchEntity($article, $this->request->getData(), [
// Added: Disable modification of user_id.
'accessibleFields' => ['user_id' => false]
]);
if ($this->Articles->save($article)) {
$this->Flash->success(__('Your article has been updated.'));
return $this->redirect(['action' => 'index']);
}
$this->Flash->error(__('Unable to update your article.'));
}
$tags = $this->Articles->Tags->find('list');
$this->set('article', $article);
$this->set('tags', $tags);
}
The query should be executed only once at this line:
$article = $this->Articles
->findBySlug($slug)
->contain('Tags') // load associated Tags
->firstOrFail();
Correct?
mysql cakephp cakephp-3.0
mysql cakephp cakephp-3.0
asked Nov 24 '18 at 14:40
picklerickpicklerick
32818
32818
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It's possible, the debugkit is loaded two times. See in the bootstrap.php config file. If is there remove it because in 3.6 is loading in the Application.php
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53459264%2fdebug-kit-show-duplicated-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It's possible, the debugkit is loaded two times. See in the bootstrap.php config file. If is there remove it because in 3.6 is loading in the Application.php
add a comment |
It's possible, the debugkit is loaded two times. See in the bootstrap.php config file. If is there remove it because in 3.6 is loading in the Application.php
add a comment |
It's possible, the debugkit is loaded two times. See in the bootstrap.php config file. If is there remove it because in 3.6 is loading in the Application.php
It's possible, the debugkit is loaded two times. See in the bootstrap.php config file. If is there remove it because in 3.6 is loading in the Application.php
answered Nov 25 '18 at 10:52
delAmuxdelAmux
383
383
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53459264%2fdebug-kit-show-duplicated-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown