Commands out of sync; you can't run this command now - error on TYPO3 backend module of EXT:indexed_search
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
In the production environment of my TYPO3 8.7 installation I get this error message when I try to open the TYPO3 backend module "Indexing":
Commands out of sync; you can't run this command now
DoctrineDBALDriverMysqliMysqliException thrown in file
/home/www/html-data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php in line 280.
The problem seems to be in the loop in vendor/typo3/cms/typo3/sysext/indexed_search/Classes/Domain/Repository/AdministrationRepository.php in function getRecordsNumbers()
After some research it seems that closeCursor() is necessary, but I wasn't able to integrate that.
The funny thing is, that the error only occurs in my production environment. On the development machine, everything works fine!
So is this now a TYPO3 bug or a configuration problem of my production machine?
My environment:
- TYPO3 8.7.20
Production:
- PHP 7.2.8
- MySQL 5.6.37
- mysqlnd 5.0.12-dev
Development:
- PHP 7.2.7
- MySQL 5.5.60
- mysqlnd 5.0.12-dev
Only difference is that in the development environment pdo_mysql is not present.
mysql doctrine-orm typo3 typo3-8.x tx-indexed-search
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
add a comment |
In the production environment of my TYPO3 8.7 installation I get this error message when I try to open the TYPO3 backend module "Indexing":
Commands out of sync; you can't run this command now
DoctrineDBALDriverMysqliMysqliException thrown in file
/home/www/html-data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php in line 280.
The problem seems to be in the loop in vendor/typo3/cms/typo3/sysext/indexed_search/Classes/Domain/Repository/AdministrationRepository.php in function getRecordsNumbers()
After some research it seems that closeCursor() is necessary, but I wasn't able to integrate that.
The funny thing is, that the error only occurs in my production environment. On the development machine, everything works fine!
So is this now a TYPO3 bug or a configuration problem of my production machine?
My environment:
- TYPO3 8.7.20
Production:
- PHP 7.2.8
- MySQL 5.6.37
- mysqlnd 5.0.12-dev
Development:
- PHP 7.2.7
- MySQL 5.5.60
- mysqlnd 5.0.12-dev
Only difference is that in the development environment pdo_mysql is not present.
mysql doctrine-orm typo3 typo3-8.x tx-indexed-search
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06
add a comment |
In the production environment of my TYPO3 8.7 installation I get this error message when I try to open the TYPO3 backend module "Indexing":
Commands out of sync; you can't run this command now
DoctrineDBALDriverMysqliMysqliException thrown in file
/home/www/html-data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php in line 280.
The problem seems to be in the loop in vendor/typo3/cms/typo3/sysext/indexed_search/Classes/Domain/Repository/AdministrationRepository.php in function getRecordsNumbers()
After some research it seems that closeCursor() is necessary, but I wasn't able to integrate that.
The funny thing is, that the error only occurs in my production environment. On the development machine, everything works fine!
So is this now a TYPO3 bug or a configuration problem of my production machine?
My environment:
- TYPO3 8.7.20
Production:
- PHP 7.2.8
- MySQL 5.6.37
- mysqlnd 5.0.12-dev
Development:
- PHP 7.2.7
- MySQL 5.5.60
- mysqlnd 5.0.12-dev
Only difference is that in the development environment pdo_mysql is not present.
mysql doctrine-orm typo3 typo3-8.x tx-indexed-search
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
In the production environment of my TYPO3 8.7 installation I get this error message when I try to open the TYPO3 backend module "Indexing":
Commands out of sync; you can't run this command now
DoctrineDBALDriverMysqliMysqliException thrown in file
/home/www/html-data/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php in line 280.
The problem seems to be in the loop in vendor/typo3/cms/typo3/sysext/indexed_search/Classes/Domain/Repository/AdministrationRepository.php in function getRecordsNumbers()
After some research it seems that closeCursor() is necessary, but I wasn't able to integrate that.
The funny thing is, that the error only occurs in my production environment. On the development machine, everything works fine!
So is this now a TYPO3 bug or a configuration problem of my production machine?
My environment:
- TYPO3 8.7.20
Production:
- PHP 7.2.8
- MySQL 5.6.37
- mysqlnd 5.0.12-dev
Development:
- PHP 7.2.7
- MySQL 5.5.60
- mysqlnd 5.0.12-dev
Only difference is that in the development environment pdo_mysql is not present.
mysql doctrine-orm typo3 typo3-8.x tx-indexed-search
mysql doctrine-orm typo3 typo3-8.x tx-indexed-search
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
asked Nov 23 '18 at 14:34
Peter KraumePeter Kraume
9251620
9251620
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06
add a comment |
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06
add a comment |
1 Answer
1
active
oldest
votes
It turned out that the index of the database table index_rel was broken.
Deleting the table and rebuilding it solved my problem.
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
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%2f53448594%2fcommands-out-of-sync-you-cant-run-this-command-now-error-on-typo3-backend-mo%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 turned out that the index of the database table index_rel was broken.
Deleting the table and rebuilding it solved my problem.
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
add a comment |
It turned out that the index of the database table index_rel was broken.
Deleting the table and rebuilding it solved my problem.
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
add a comment |
It turned out that the index of the database table index_rel was broken.
Deleting the table and rebuilding it solved my problem.
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
It turned out that the index of the database table index_rel was broken.
Deleting the table and rebuilding it solved my problem.
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
answered Jan 11 at 13:14
Peter KraumePeter Kraume
9251620
9251620
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%2f53448594%2fcommands-out-of-sync-you-cant-run-this-command-now-error-on-typo3-backend-mo%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
As suggested I've posted this problem also to Forge: forge.typo3.org/issues/86986
– Peter Kraume
Nov 23 '18 at 15:06