Bug #23021
closed
File Mounts are no longer displayed. Creating new File Mounts gives SQL Error
0%
Description
After upgrading from 4.3.3 to 4.4.0 file mounts are no longer displayed.
When I create a new file mount, I get this SQL error:
'Unknown column 'sorting' in 'field list'' (sys_filemounts:NEW4c28680155285)
Filemounts are not available. New file mounts exit with failure SQL error: 'Unknown column 'sorting' in 'field list'' (sys_filemounts:NEW4c28680155285).
In log file: Sys! - SQL error: 'Unknown column 'sorting' in 'field list'' (sys_filemounts:NEW4c28680155285) (msg#1.1.12)
(issue imported from #M14899)
Updated by Chris topher over 14 years ago
Please add a step by step description showing what you do to get this error!
Updated by Anne Arlt over 14 years ago
After Update from 4.3.3 to 4.4.0,
I 'm search for file mounts in Backend, file mounts was existed and was displayed under 4.3.3 version. Now nothing was displayed.
Then I try to create new data record - system record, file mounts.
I set a label and path. After saving I get the error: SQL error: 'Unknown column 'sorting' in 'field list'' (sys_filemounts:NEW4c28680155285).
I hope the description is okay.
Updated by Chris topher over 14 years ago
Yes, that is understandable. I updated the description accordingly.
The error points to a missing column in your DB. Please check the table sys_filemounts. There should be a column called sorting. Is it missing?
Updated by Anne Arlt over 14 years ago
Yes, column sorting is missing, only the following columns exist:
uid, pid, tstamp, title, path, base, hidden, deleted.
Updated by Chris topher over 14 years ago
This field was added with 4.4.0. Please use the Database Analyzer in the Install Tool to Compare your current DB with the structure needed to run TYPO3. You must add the fields which are new (for example the field sorting in sys_filemounts). Only delete unused columns if you are sure that you don't need them anymore.
Our upgrade guide is located here:
http://wiki.typo3.org/index.php/Upgrade