Cannot uninstall modules due to missing table br_schedule
When I hit the Uninstall tab in the UI or try to uninstall a module with Drush I get the following errors:
Drush:
SQLSTATE[42S02]: Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist
Drupal Log:
DrupalCoreDatabaseDatabaseExceptionWrapper: SQLSTATE[42S02]:
Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist:
SELECT base_table.vid AS vid,
base_table.id AS id FROM {br_schedule}
base_table LIMIT 1 OFFSET 0; Array ( ) in
DrupalCoreEntityEntityStorageBase->hasData()
(line 552 of MYSITEPATH/core/lib/Drupal/Core/Entity/EntityStorageBase.php).
I have no idea what br_schedule is so I don't know how to rebuild that table. I have Businesses Rules installed but I see no br_schedule module.
database uninstalling
add a comment |
When I hit the Uninstall tab in the UI or try to uninstall a module with Drush I get the following errors:
Drush:
SQLSTATE[42S02]: Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist
Drupal Log:
DrupalCoreDatabaseDatabaseExceptionWrapper: SQLSTATE[42S02]:
Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist:
SELECT base_table.vid AS vid,
base_table.id AS id FROM {br_schedule}
base_table LIMIT 1 OFFSET 0; Array ( ) in
DrupalCoreEntityEntityStorageBase->hasData()
(line 552 of MYSITEPATH/core/lib/Drupal/Core/Entity/EntityStorageBase.php).
I have no idea what br_schedule is so I don't know how to rebuild that table. I have Businesses Rules installed but I see no br_schedule module.
database uninstalling
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
1
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybedrush updb
could solve the issue (it should run entup as well these days).
– mradcliffe
Feb 3 at 18:15
add a comment |
When I hit the Uninstall tab in the UI or try to uninstall a module with Drush I get the following errors:
Drush:
SQLSTATE[42S02]: Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist
Drupal Log:
DrupalCoreDatabaseDatabaseExceptionWrapper: SQLSTATE[42S02]:
Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist:
SELECT base_table.vid AS vid,
base_table.id AS id FROM {br_schedule}
base_table LIMIT 1 OFFSET 0; Array ( ) in
DrupalCoreEntityEntityStorageBase->hasData()
(line 552 of MYSITEPATH/core/lib/Drupal/Core/Entity/EntityStorageBase.php).
I have no idea what br_schedule is so I don't know how to rebuild that table. I have Businesses Rules installed but I see no br_schedule module.
database uninstalling
When I hit the Uninstall tab in the UI or try to uninstall a module with Drush I get the following errors:
Drush:
SQLSTATE[42S02]: Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist
Drupal Log:
DrupalCoreDatabaseDatabaseExceptionWrapper: SQLSTATE[42S02]:
Base table or view not found:
1146 Table 'DATABASENAME.br_schedule' doesn't exist:
SELECT base_table.vid AS vid,
base_table.id AS id FROM {br_schedule}
base_table LIMIT 1 OFFSET 0; Array ( ) in
DrupalCoreEntityEntityStorageBase->hasData()
(line 552 of MYSITEPATH/core/lib/Drupal/Core/Entity/EntityStorageBase.php).
I have no idea what br_schedule is so I don't know how to rebuild that table. I have Businesses Rules installed but I see no br_schedule module.
database uninstalling
database uninstalling
asked Feb 3 at 17:21
Brad OBrad O
474
474
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
1
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybedrush updb
could solve the issue (it should run entup as well these days).
– mradcliffe
Feb 3 at 18:15
add a comment |
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
1
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybedrush updb
could solve the issue (it should run entup as well these days).
– mradcliffe
Feb 3 at 18:15
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
1
1
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybe
drush updb
could solve the issue (it should run entup as well these days).– mradcliffe
Feb 3 at 18:15
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybe
drush updb
could solve the issue (it should run entup as well these days).– mradcliffe
Feb 3 at 18:15
add a comment |
3 Answers
3
active
oldest
votes
Found the issue. My database updates are not happening. Ran updatedb:status with drush and I get:
file_entity 8004 hook_update_n Fix entity field mismatches on the file type field.
business_rules_schedule entity type entity-update The Schedule entity type needs to be installed.
file entity type entity-update The File type field needs to be updated.
node entity type entity-update The node.field_zipcode field needs to be updated.
"Fix entity field mismatches on the file type field." is failing so the "business_rules_schedule" update isn't happening.
add a comment |
I spun up a blank D8 with Business Rules installed and exported the br_schedule table and imported it into the effected site. Now I can uninstall modules.
add a comment |
Perhaps the easiest workaround as @kevin mentions would be to download adminer or use existing phpmyadmin if you have and create that table with no content running the following (or similar) SQL command
CREATE TABLE br_schedule (
ID int
);
then try again to see if it can uninstall
NOTE: use with caution its not a bulletproof technique, I have used it a few times and was able to complete broken uninstalls on messed up databases but as mradcliffe mentions it might screw things up as well.
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of whatbr_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB
– GiorgosK
Feb 3 at 18:41
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "220"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdrupal.stackexchange.com%2fquestions%2f276060%2fcannot-uninstall-modules-due-to-missing-table-br-schedule%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Found the issue. My database updates are not happening. Ran updatedb:status with drush and I get:
file_entity 8004 hook_update_n Fix entity field mismatches on the file type field.
business_rules_schedule entity type entity-update The Schedule entity type needs to be installed.
file entity type entity-update The File type field needs to be updated.
node entity type entity-update The node.field_zipcode field needs to be updated.
"Fix entity field mismatches on the file type field." is failing so the "business_rules_schedule" update isn't happening.
add a comment |
Found the issue. My database updates are not happening. Ran updatedb:status with drush and I get:
file_entity 8004 hook_update_n Fix entity field mismatches on the file type field.
business_rules_schedule entity type entity-update The Schedule entity type needs to be installed.
file entity type entity-update The File type field needs to be updated.
node entity type entity-update The node.field_zipcode field needs to be updated.
"Fix entity field mismatches on the file type field." is failing so the "business_rules_schedule" update isn't happening.
add a comment |
Found the issue. My database updates are not happening. Ran updatedb:status with drush and I get:
file_entity 8004 hook_update_n Fix entity field mismatches on the file type field.
business_rules_schedule entity type entity-update The Schedule entity type needs to be installed.
file entity type entity-update The File type field needs to be updated.
node entity type entity-update The node.field_zipcode field needs to be updated.
"Fix entity field mismatches on the file type field." is failing so the "business_rules_schedule" update isn't happening.
Found the issue. My database updates are not happening. Ran updatedb:status with drush and I get:
file_entity 8004 hook_update_n Fix entity field mismatches on the file type field.
business_rules_schedule entity type entity-update The Schedule entity type needs to be installed.
file entity type entity-update The File type field needs to be updated.
node entity type entity-update The node.field_zipcode field needs to be updated.
"Fix entity field mismatches on the file type field." is failing so the "business_rules_schedule" update isn't happening.
answered Feb 3 at 18:39
Brad OBrad O
474
474
add a comment |
add a comment |
I spun up a blank D8 with Business Rules installed and exported the br_schedule table and imported it into the effected site. Now I can uninstall modules.
add a comment |
I spun up a blank D8 with Business Rules installed and exported the br_schedule table and imported it into the effected site. Now I can uninstall modules.
add a comment |
I spun up a blank D8 with Business Rules installed and exported the br_schedule table and imported it into the effected site. Now I can uninstall modules.
I spun up a blank D8 with Business Rules installed and exported the br_schedule table and imported it into the effected site. Now I can uninstall modules.
answered Feb 3 at 18:56
Brad OBrad O
474
474
add a comment |
add a comment |
Perhaps the easiest workaround as @kevin mentions would be to download adminer or use existing phpmyadmin if you have and create that table with no content running the following (or similar) SQL command
CREATE TABLE br_schedule (
ID int
);
then try again to see if it can uninstall
NOTE: use with caution its not a bulletproof technique, I have used it a few times and was able to complete broken uninstalls on messed up databases but as mradcliffe mentions it might screw things up as well.
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of whatbr_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB
– GiorgosK
Feb 3 at 18:41
add a comment |
Perhaps the easiest workaround as @kevin mentions would be to download adminer or use existing phpmyadmin if you have and create that table with no content running the following (or similar) SQL command
CREATE TABLE br_schedule (
ID int
);
then try again to see if it can uninstall
NOTE: use with caution its not a bulletproof technique, I have used it a few times and was able to complete broken uninstalls on messed up databases but as mradcliffe mentions it might screw things up as well.
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of whatbr_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB
– GiorgosK
Feb 3 at 18:41
add a comment |
Perhaps the easiest workaround as @kevin mentions would be to download adminer or use existing phpmyadmin if you have and create that table with no content running the following (or similar) SQL command
CREATE TABLE br_schedule (
ID int
);
then try again to see if it can uninstall
NOTE: use with caution its not a bulletproof technique, I have used it a few times and was able to complete broken uninstalls on messed up databases but as mradcliffe mentions it might screw things up as well.
Perhaps the easiest workaround as @kevin mentions would be to download adminer or use existing phpmyadmin if you have and create that table with no content running the following (or similar) SQL command
CREATE TABLE br_schedule (
ID int
);
then try again to see if it can uninstall
NOTE: use with caution its not a bulletproof technique, I have used it a few times and was able to complete broken uninstalls on messed up databases but as mradcliffe mentions it might screw things up as well.
edited Feb 3 at 18:42
answered Feb 3 at 17:57
GiorgosKGiorgosK
4,44511032
4,44511032
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of whatbr_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB
– GiorgosK
Feb 3 at 18:41
add a comment |
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of whatbr_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB
– GiorgosK
Feb 3 at 18:41
1
1
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
This might cause further errors because the table is provided by a content entity type.
– mradcliffe
Feb 3 at 18:16
1
1
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of what
br_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB– GiorgosK
Feb 3 at 18:41
@mradcliffe perhaps you are right its a trial and error not to be tried on live site, I am not aware of what
br_schedule
is but the above technique has saved me a few times when I get in my hands a broken DB– GiorgosK
Feb 3 at 18:41
add a comment |
Thanks for contributing an answer to Drupal Answers!
- 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%2fdrupal.stackexchange.com%2fquestions%2f276060%2fcannot-uninstall-modules-due-to-missing-table-br-schedule%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
It doesn’t have to be a module necessarily, a module can create as many tables as it needs to. An easy way to get out of this is to create a bare table using a database editor/interface called br_schedule then try to uninstall the module. This will get you around the error. The rest sounds like a bug for the Business rules module.
– Kevin
Feb 3 at 17:25
1
br_schedule is the base table for the business_rules_schedule entity type. Perhaps the module was previously installed before the entity type existed in the current version. Maybe
drush updb
could solve the issue (it should run entup as well these days).– mradcliffe
Feb 3 at 18:15