Hi,
I have Typo3 13 running locally with DDEV as composer a installation taken from standard setup.
I found that some of the system modules in the BE were missing and other optional modules were installed.
Missing: DB check, Configuration !!!
Optionals installed: Reactions, Webhook (don’t need)
So I did a full installation with DDEV & composer on the existing installation, hoping to get the missing modules.
Launching my system now gets this error:
(1/3) #1146 Doctrine\DBAL\Exception\TableNotFoundException
An exception occurred while executing a query: Table ‘db.sys_workspace’ doesn’t exist
in /var/www/html/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 40
1213 => new DeadlockException($exception, $query),
1205 => new LockWaitTimeoutException($exception, $query),
1050 => new TableExistsException($exception, $query),
1051,
1146 => new TableNotFoundException($exception, $query),
Could somebody help me to get the system back running?
Does somebody know, why these standard modules were missing?
Kind regards
Bernd
To fix this error, log into the Install Tool of your TYPO3 installation (/typo3/install.php) and in the Maintenance module run Analyze Database Structure.
If you install a new extension you need to run this to have new tables created that are otherwise missing.
Regarding your other question:
You mentioned something about a “standard” setup. Which one was that?
There’s different distributions and install sets of TYPO3, one for example being the “Minimal” set which only includes the extensions required for TYPO3 to actually run.
Then there’s specific distributions and at the very end of it there also is a TYPO3 full installation containing all extensions.
Are you getting the same error when you visit the URL just like that? The Install Tool can be accessed independently from TYPO3 and shouldn’t be affected by missing table errors.
There is a composer way:
You can install helhum/typo3-console to get a command to do this. (./vendor/bin/typo3 database:updateschema)
I’m getting into the BE again, see my pages and the modules but the system is damaged.
the system tools database analyzer, maintenance, upgrades … don’t work anymore. The tools start but don’t do anything. Viewing a page causes an error…
I saved my database.
Any idea how to fix the system?
Hmm, I’d recommend at first maybe trying to just export the database (using ddev export-db) as a safety measure.
Delete everything that was installed, as in the vendor folder, the var folder, TYPO3-specific contents of the public folder etc. etc. and try reinstalling (using composer install again) to see if it works again afterwards. If that doesn’t fix the issue, maybe a combination of extensions that you have installed is causing that issue?
You could also go and check the logs in var/log/ to see if these actually contain any errors that you cannot see in the backend for some reason.
I really crashed the database somehow. Luckily I had a backup.So I reinstalled the whole system, imported the database and the system is running again.