Can not do update 8002

Created on 28 June 2023, almost 2 years ago

Problem/Motivation

When i do

drush updatedb

if fails due to

[notice] Update started: paragraphs_update_8002
>  [error]  Field storage definition for 'id' could not be found. 
>  [error]  Update failed: paragraphs_update_8002

Then i try

drush pm:uninstall paragraphs

but get this instead

In ExceptionHandler.php line 42:
                                                                                                                                       
  SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'paragraphs_item'.: SELECT TOP (1) base_  
  table.[revision_id] AS [revision_id], base_table.[id] AS [id]                                                                        
  FROM                                                                                                                                 
  [paragraphs_item] [base_table]                                                                                                       
  GROUP BY base_table.revision_id, base_table.id; Array                                                                                
  (                                                                                                                                    
  )                                                                                                                                    
                                                                                                                                       

In StatementWrapper.php line 145:
                                                                                                                 
  SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'paragraphs_item'.  

Steps to reproduce

I do not know how it came to this.

Proposed resolution

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.paragraphs_item
	(
	id int NULL,
	revision_id int NULL
	)  ON [PRIMARY]
GO
ALTER TABLE YOURDATABASE.dbo.paragraphs_item SET (LOCK_ESCALATION = TABLE)
GO
COMMIT

Now uninstall works

Remaining tasks

User interface changes

API changes

Data model changes

πŸ› Bug report
Status

Active

Version

1.15

Component

Code

Created by

πŸ‡ΈπŸ‡ͺSweden arne_hortell

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024