[SOLVED] NEOS 2.1 node:repair

Using Neos & Flow
1

When trying to run ./flow node:repair on NEOS 2.1 I am geting following errors

Run integrity checks related to Neos features

An exception occurred while executing ‘SELECT t0.name AS name1, t0.title AS title2, t0.description AS description3, t0.owner AS owner4, t0.baseworkspace AS bworkspace t0 WHERE t0.name = ?’ with params [“live”]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.title’ in
‘field list’

Type: Doctrine\DBAL\Exception\InvalidFieldNameException
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriv
er.php
Line: 71

Nested exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.title’ in ‘field list’

Type: Doctrine\DBAL\Driver\PDOException
Code: 42S22
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line: 93

Nested exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.title’ in ‘field list’

Type: PDOException
Code: 42S22
File: Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line: 91

Any hints how I can solve that?

2

Did you run the migrations coming with the upgrade of a new version of Neos CMS ?

3

Yes, I have executed instructions listed here https://www.neos.io/download-and-extend/upgrade-instructions-2-0-2-1.html

4

Any hints where should I look, start debug to solve a problem? I am not very familiar with NEOS - and did not perform upgrade so far. My goal is to upgrade at least to LTS 2 version now.

5

Run ./flow doctrine:migrationstatus and add the output here in the thread

6

Here it is

./flow doctrine:migrationstatus

== Configuration
>> Name: Doctrine Database Migrations
>> Database Driver: pdo_mysql
>> Database Name: […]
>> Configuration Source: manually configured
>> Version Table Name: flow_doctrine_migrationstatus
>> Migrations Namespace: TYPO3\Flow\Persistence\Doctrine\Migrations
>> Migrations Target Directory: […]/Data/DoctrineMigrations
>> Current Version: 2016-06-01 16:43:32 (20160601164332)
>> Latest Version: 2016-06-01 16:43:32 (20160601164332)
>> Executed Migrations: 101
>> Available Migrations: 101
>> New Migrations: 0

== Migration Versions
>> 2011-06-13 22:38:37 (20110613223837) TYPO3.Flow migrated
>> 2011-06-13 22:45:37 (20110613224537) TYPO3.Party migrated
>> 2011-06-20 15:50:01 (20110620155001) TYPO3.TYPO3CR migrated
>> 2011-06-20 15:50:02 (20110620155002) TYPO3.Neos migrated
>> 2011-07-14 21:29:00 (20110714212900) TYPO3.Party migrated
>> 2011-08-24 12:48:35 (20110824124835) TYPO3.Flow migrated
>> 2011-08-24 12:49:35 (20110824124935) TYPO3.Party migrated
>> 2011-08-24 12:50:35 (20110824125035) TYPO3.Neos migrated
>> 2011-08-24 12:51:35 (20110824125135) TYPO3.TYPO3CR migrated
>> 2011-09-19 16:48:35 (20110919164835) TYPO3.Neos migrated
>> 2011-09-20 10:47:39 (20110920104739) TYPO3.TYPO3CR migrated
>> 2011-09-20 12:57:36 (20110920125736) TYPO3.Flow migrated
>> 2011-09-23 12:55:35 (20110923125535) TYPO3.Flow migrated
>> 2011-09-23 12:55:36 (20110923125536) TYPO3.Party migrated
>> 2011-09-23 12:55:37 (20110923125537) TYPO3.TYPO3CR migrated
>> 2011-09-23 12:55:38 (20110923125538) TYPO3.Neos migrated
>> 2011-09-25 12:31:19 (20110925123119) TYPO3.Neos migrated
>> 2011-09-25 12:31:20 (20110925123120) TYPO3.Media migrated
>> 2011-09-28 11:40:48 (20110928114048) TYPO3.TYPO3CR migrated
>> 2011-12-15 17:20:27 (20111215172027) TYPO3.TYPO3CR migrated
>> 2012-03-28 15:20:41 (20120328152041) TYPO3.Flow migrated
>> 2012-03-29 22:03:40 (20120329220340) TYPO3.Flow migrated
>> 2012-03-29 22:03:41 (20120329220341) TYPO3.Party migrated
>> 2012-03-29 22:03:42 (20120329220342) TYPO3.TYPO3CR migrated
>> 2012-03-29 22:03:43 (20120329220343) TYPO3.Neos migrated
>> 2012-03-29 22:03:44 (20120329220344) TYPO3.Media migrated
>> 2012-04-12 09:37:48 (20120412093748) TYPO3.Flow migrated
>> 2012-04-29 21:34:45 (20120429213445) TYPO3.Flow migrated
>> 2012-04-29 21:34:46 (20120429213446) TYPO3.Party migrated
>> 2012-04-29 21:34:47 (20120429213447) TYPO3.TYPO3CR migrated
>> 2012-04-29 21:34:48 (20120429213448) TYPO3.Neos migrated
>> 2012-05-20 21:13:54 (20120520211354) TYPO3.Flow migrated
>> 2012-05-21 12:54:01 (20120521125401) TYPO3.Party migrated
>> 2012-05-25 14:15:45 (20120525141545) TYPO3.Party migrated
>> 2012-06-25 21:16:47 (20120625211647) TYPO3.Flow migrated
>> 2012-08-29 12:45:49 (20120829124549) TYPO3.TYPO3CR migrated
>> 2012-09-30 20:34:52 (20120930203452) TYPO3.Flow migrated
>> 2012-09-30 21:15:42 (20120930211542) TYPO3.Party migrated
>> 2012-10-01 18:11:37 (20121001181137) TYPO3.Media migrated
>> 2012-10-01 20:17:12 (20121001201712) TYPO3.TYPO3CR migrated
>> 2012-10-01 20:22:23 (20121001202223) TYPO3.Neos migrated
>> 2012-10-11 14:09:46 (20121011140946) TYPO3.Media migrated
>> 2012-10-14 00:59:02 (20121014005902) TYPO3.TYPO3CR migrated
>> 2012-10-30 22:11:51 (20121030221151) TYPO3.Neos migrated
>> 2012-10-31 19:02:13 (20121031190213) TYPO3.Neos migrated
>> 2013-02-01 10:43:44 (20130201104344) TYPO3.TYPO3CR migrated
>> 2013-02-13 13:05:15 (20130213130515) TYPO3.Neos migrated
>> 2013-02-18 10:03:24 (20130218100324) TYPO3.TYPO3CR migrated
>> 2013-03-19 13:14:00 (20130319131400) TYPO3.Flow migrated
>> 2013-05-22 13:16:41 (20130522131641) TYPO3.Media migrated
>> 2013-05-22 13:28:35 (20130522132835) TYPO3.Media migrated
>> 2013-06-05 17:47:12 (20130605174712) TYPO3.Media migrated
>> 2013-07-02 15:14:25 (20130702151425) TYPO3.TYPO3CR migrated
>> 2013-07-30 15:13:19 (20130730151319) TYPO3.TYPO3CR migrated
>> 2013-09-19 14:33:52 (20130919143352) TYPO3.TYPO3CR migrated
>> 2013-09-30 18:28:39 (20130930182839) TYPO3.TYPO3CR migrated
>> 2013-11-11 23:58:27 (20131111235827) TYPO3.Neos migrated
>> 2013-11-29 11:03:02 (20131129110302) TYPO3.TYPO3CR migrated
>> 2013-12-05 17:46:31 (20131205174631) TYPO3.TYPO3CR migrated
>> 2014-02-06 12:41:23 (20140206124123) TYPO3.TYPO3CR migrated
>> 2014-02-08 17:31:40 (20140208173140) TYPO3.TYPO3CR migrated
>> 2014-03-25 17:31:51 (20140325173151) TYPO3.TYPO3CR migrated
>> 2014-08-26 16:42:46 (20140826164246) TYPO3.TYPO3CR migrated
>> 2014-10-01 15:14:17 (20141001151417) TYPO3.TYPO3CR migrated
>> 2014-10-03 23:37:38 (20141003233738) TYPO3.TYPO3CR migrated
>> 2014-10-15 12:58:41 (20141015125841) TYPO3.Flow migrated
>> 2014-10-17 17:45:59 (20141017174559) TYPO3.Neos migrated
>> 2014-11-13 17:37:12 (20141113173712) TYPO3.Flow migrated
>> 2014-11-14 11:52:41 (20141114115241) TYPO3.Neos migrated
>> 2014-11-18 17:23:22 (20141118172322) TYPO3.Media migrated
>> 2015-01-29 22:51:52 (20150129225152) TYPO3.Flow migrated
>> 2015-01-31 17:48:06 (20150131174806) TYPO3.TYPO3CR migrated
>> 2015-02-06 11:39:11 (20150206113911) TYPO3.Party migrated
>> 2015-02-06 11:48:20 (20150206114820) TYPO3.Flow migrated
>> 2015-02-11 18:17:36 (20150211181736) TYPO3.TYPO3CR migrated
>> 2015-02-17 14:58:53 (20150217145853) TYPO3.Party migrated
>> 2015-02-24 17:11:07 (20150224171107) TYPO3.Neos migrated
>> 2015-02-28 15:42:01 (20150228154201) TYPO3.Media migrated
>> 2015-03-09 18:16:35 (20150309181635) TYPO3.Flow migrated
>> 2015-03-09 18:16:36 (20150309181636) TYPO3.Party migrated
>> 2015-03-09 21:53:16 (20150309215316) TYPO3.TYPO3CR migrated
>> 2015-03-09 21:53:17 (20150309215317) TYPO3.Neos migrated
>> 2015-03-24 18:50:18 (20150324185018) TYPO3.Media migrated
>> 2015-03-24 18:50:19 (20150324185019) TYPO3.TYPO3CR migrated
>> 2015-04-08 11:28:32 (20150408112832) TYPO3.TYPO3CR migrated
>> 2015-05-07 20:44:50 (20150507204450) TYPO3.Media migrated
>> 2015-05-07 20:44:52 (20150507204452) TYPO3.Neos migrated
>> 2015-05-24 15:02:34 (20150524150234) TYPO3.TYPO3CR migrated
>> 2015-06-11 15:44:19 (20150611154419) TYPO3.Flow migrated
>> 2015-06-12 09:33:51 (20150612093351) TYPO3.Party migrated
>> 2015-06-23 11:22:00 (20150623112200) TYPO3.TYPO3CR migrated
>> 2015-07-01 11:32:46 (20150701113246) TYPO3.Media migrated
>> 2015-07-24 09:11:48 (20150724091148) TYPO3.Neos migrated
>> 2015-09-13 17:38:32 (20150913173832) TYPO3.Media migrated
>> 2015-11-10 11:36:50 (20151110113650) TYPO3.Flow migrated
>> 2015-11-17 12:54:37 (20151117125437) TYPO3.TYPO3CR migrated
>> 2015-11-17 12:55:51 (20151117125551) TYPO3.Neos migrated
>> 2015-12-16 05:23:38 (20151216052338) TYPO3.Media migrated
>> 2015-12-16 14:37:56 (20151216143756) TYPO3.Media migrated
>> 2015-12-16 14:44:08 (20151216144408) TYPO3.Media migrated
>> 2016-06-01 16:43:32 (20160601164332) TYPO3.Flow migrated

7

And here output of doctrine:migrate

./flow doctrine:migrate
No migration was necessary.

8

Check your database and the table neos_contentrepository_domain_model_workspace if there is a column named title.

9

Seems there is no such table at all… Below there is a list of tables in my database:

| flow_doctrine_migrationstatus |
| typo3_flow_mvc_routing_objectpathmapping |
| typo3_flow_resource_resource |
| typo3_flow_security_account |
| typo3_media_domain_model_adjustment_abstractimageadjustment |
| typo3_media_domain_model_asset |
| typo3_media_domain_model_asset_tags_join |
| typo3_media_domain_model_assetcollection |
| typo3_media_domain_model_assetcollection_assets_join |
| typo3_media_domain_model_assetcollection_tags_join |
| typo3_media_domain_model_audio |
| typo3_media_domain_model_document |
| typo3_media_domain_model_image |
| typo3_media_domain_model_imagevariant |
| typo3_media_domain_model_tag |
| typo3_media_domain_model_thumbnail |
| typo3_media_domain_model_video |
| typo3_neos_domain_model_domain |
| typo3_neos_domain_model_site |
| typo3_neos_domain_model_user |
| typo3_neos_domain_model_userpreferences |
| typo3_neos_eventlog_domain_model_event |
| typo3_party_domain_model_abstractparty |
| typo3_party_domain_model_abstractparty_accounts_join |
| typo3_party_domain_model_electronicaddress |
| typo3_party_domain_model_person |
| typo3_party_domain_model_person_electronicaddresses_join |
| typo3_party_domain_model_personname |
| typo3_typo3cr_domain_model_contentobjectproxy |
| typo3_typo3cr_domain_model_nodedata |
| typo3_typo3cr_domain_model_nodedimension |
| typo3_typo3cr_domain_model_workspace |
| typo3_typo3cr_migration_domain_model_migrationstatus |
±------------------------------------------------------------+
33 rows in set (0.00 sec)

10

You’re still on Neos 2.1, so the table is named typo3_typo3cr_domain_model_workspace. Check if that has a field called “title”, though.

11

After adding two fields (also description) into this table, I was able to finalize upgrade to NEOS 2.1. Thank you very much @beheist @sorenmalling

	ALTER TABLE typo3_typo3cr_domain_model_workspace ADD title VARCHAR(255);
	ALTER TABLE typo3_typo3cr_domain_model_workspace ADD description text;
12

Sounds good. However, normally you shouldn’t have to do that, as the migrations should have taken care of it… let’s hope your database is in a consistent state otherwise.