Bug #87876

destroyed Database - cause not really clear

Added by Dieter Porth 9 days ago. Updated 9 days ago.

Status:
Needs Feedback
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2019-03-11
Due date:
% Done:

0%

TYPO3 Version:
9
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

After some unknown actions the table cf_cache_hash_tags is no longer avaiable for my TYPO3 9.5.5.
I can't easyly delete the entry with the programm HeidiSQL. (Screenshot)
The Installtool recognize the table in a wrong way. The installation won't fix the bug.(Screenshot)
The DB-Request 'DROP VIEW cf_cache_hash_tags;'

It's the second time something like this happens.

I useed windows 10 home, XAMPP 7.2 in this case.

My Workaround is horrible:
1. I make a dump from the Database with HeuidiSQL
2. I removed the Database and reimported it with HeidiSQL. Ignring the Error at the end of the import.)
3. I restartetd the MySQL-Server.
4. I run the installtool.

I find hints in the internet to delete the file cf_cache_hash_tags.idb or cf_cache_hash_tags.frm.
In Combination with the installtool it did not work for me. It only cause additional trouble.

2019-03-11 09_23_55-Window.png View (97.1 KB) Dieter Porth, 2019-03-11 10:44

2019-03-11 09_28_00-Window.png View (204 KB) Dieter Porth, 2019-03-11 10:44

History

#1 Updated by Mathias Schreiber 9 days ago

The error is weird... why is this a VIEW?

#2 Updated by Susanne Moog 9 days ago

  • Status changed from New to Needs Feedback

We will need more information to be able to reproduce the issue. Try to figure out, which actions did produce that result. Does this also happen on clean install? If so, what exact system and versions are you using?

Also available in: Atom PDF