Bug #23021
closed
File Mounts are no longer displayed. Creating new File Mounts gives SQL Error
Added by Anne Arlt almost 14 years ago.
Updated almost 14 years ago.
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)
Please add a step by step description showing what you do to get this error!
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.
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?
Yes, column sorting is missing, only the following columns exist:
uid, pid, tstamp, title, path, base, hidden, deleted.
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
Closed, configuration issue.
Also available in: Atom
PDF
Updated by 
Updated by