Bug #87535

Error There is no column with name 't3ver_oid' on table 'tt_address'.

Added by Stefan Froemken about 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
Start date:
2019-01-24
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Hello TYPO3 Team,

I have a TYPO3 9.5.4 with installed maps2 4.2.6. tt_address is currently NOT installed/active
In ext_tables.sql we have added following lines:

#
# Table structure for table 'tt_address'
#
CREATE TABLE tt_address (
    tx_maps2_uid int(11) unsigned DEFAULT '0' NOT NULL
);

Database looks OK and has table tt_address with ONE column called tx_maps2_uid.

COMPOSER: Install tt_address, deactivate it in ExtensionManager, remove all columns tt_address columns from DB by hand or Database Analyzer.
Now activate tt_address again.
NON-COMPOSER: Install or activate tt_address

You will get the Error:

There is no column with name 't3ver_oid' on table 'tt_address'.

Stefan

#1

Updated by Stefan Froemken about 2 years ago

In DefaultTcaSchema.php there is a $tables variable which contains all columns to create. But there are two entries for tt_address in there at array key position 50 and 69 (in my case). In entry 50 I have a Table object with the ONE column of my maps2 extension and at position 69 there is a table object with all columns of tt_address.
It seems that you try to add an index for column t3ver_oid while processing entry 50 although t3ver_oid is defined in entry 69 first.

#2

Updated by Stefan Froemken about 2 years ago

Oh dear. Found it. I have added these lines to ext_emconf.php of maps2:

'suggests' => [
    'tt_address' => '3.0.0-4.99.99',
],
#3

Updated by Stefan Froemken about 2 years ago

  • Status changed from New to Resolved
#4

Updated by Benni Mack almost 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF