🇬🇧United Kingdom @TomChiverton

Account created on 20 February 2006, about 19 years ago
#

Recent comments

🇬🇧United Kingdom TomChiverton

Running

insert into drupal_live.file_usage
select * from drupal.file_usage

and doing `drush cr` again may have fixed the usage counts, as most of them now say used on 1 page.

🇬🇧United Kingdom TomChiverton

Looks like I lost these some time ago (D9 ?) when the recommended approach was to use a new parallel database to update.

Whatever and when ever that was, it didn't copy them, I had to manually with the below, then run `drush cr`. This makes them appear on content pages, and in the Files list in admin. It says they are all used by no content though, so make sure Media>Files has auto delete 'temporary' files turned off !

insert into drupal_live.file_managed
(fid, uuid, langcode, uid, filename, uri, filemime, filesize, status, created, changed)
select fid ,uuid(),'en',uid,filename ,uri,filemime , filesize ,status ,`timestamp` ,`timestamp`
from drupal.file_managed
;
update drupal_live.file_managed
set created =1699716080,changed =1699716080,status=0
Production build 0.71.5 2024