Can not uninstall feeds

Created on 28 June 2023, almost 2 years ago

Updated 5 July 2023, almost 2 years ago

Problem/Motivation

When running

drush pm:uninstall feeds

the following occurrs

[error] Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'feeds_feed'.: SELECT TOP (100) base_table.[fid] AS [fid], base_table.[fid] AS [base_table_fid], feeds_feed_2.[imported] AS [imported]
FROM
[feeds_feed] [base_table]
INNER JOIN [feeds_feed] [feeds_feed] ON [feeds_feed].[fid] = [base_table].[fid]
LEFT JOIN [feeds_feed] [feeds_feed_2] ON [feeds_feed_2].[fid] = [base_table].[fid]
WHERE ([feeds_feed].[queued] = :db_condition_placeholder_0) AND ([feeds_feed].[next] <= :db_condition_placeholder_1) AND ([feeds_feed].[next] <> :db_condition_placeholder_2) AND ([feeds_feed].[status] = :db_condition_placeholder_3)
ORDER BY [feeds_feed_2].[imported] ASC; Array
(
[:db_condition_placeholder_0] => 0
[:db_condition_placeholder_1] => 1687919283
[:db_condition_placeholder_2] => -1
[:db_condition_placeholder_3] => 1
)
in Drupal\Core\Entity\Query\Sql\Query->result() (line 272 of core/lib/Drupal/Core/Entity/Query/Sql/Query.php).

Steps to reproduce

I dont really understand how, what,when this occurred but probably due to some problems on installation

Proposed resolution

Create missing tables

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE akeriwebb2.dbo.feeds_feed
	(
	fid int NULL,
	status int NULL,
	next int NULL,
	imported int NULL,
	feeds_log int NULL
	)  ON [PRIMARY]
GO
ALTER TABLE YOURDATABASE.dbo.feeds_feed SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE YOURDATABASE.dbo.feeds_subscription
	(
	fid int NULL
	)  ON [PRIMARY]
GO
ALTER TABLE YOURDATABASE.dbo.feeds_subscription SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE YOURDATABASE.dbo.feeds_import_log
	(
	import_id int NULL
	)  ON [PRIMARY]
GO
ALTER TABLE YOURDATABASE.dbo.feeds_import_log SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

Then drush pm:uninstall feeds works

Remaining tasks

User interface changes

API changes

Data model changes

💬 Support request

Status

Fixed

Version

3.0

Component

Code

Created by

🇸🇪Sweden arne_hortell

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @arne_hortell
Status changed to Fixed almost 2 years ago7:10am 5 July 2023
Comment almost 2 years ago →
🇳🇱Netherlands megachriz
It sounds like that during the installation of Feeds something went wrong. This can be caused by a number of things: the database not responding or a bug in an other module that disrupted the installation process.

Looks like you were able to find a fix, so marking this as fixed. A random failure caused by something else that happened to occur during the installation of Feeds is not something we can prevent or fix in Feeds.
Comment over 1 year ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024