Project

General

Profile

Actions

Bug #17584

closed

4.2trunk: ALTER TABLE fe_users DROP KEY pid

Added by Franz Holzinger about 17 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
-
Start date:
2007-09-05
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

This is with current SVN trunk. I have made an update starting from TYPO3 4.1.

The install tool suggests me to drop the pid of the fe_users table. This is a bug.

Drop fields (really!)
ALTER TABLE fe_users DROP KEY pid;
ALTER TABLE sys_products_orders DROP KEY uid;

(issue imported from #M6273)

Actions #1

Updated by Franz Holzinger about 17 years ago

If you have tt_products installed, then the install tool also suggest this.

ALTER TABLE sys_products_orders DROP KEY uid;

This is a bug.

Actions #2

Updated by Franz Holzinger about 17 years ago

A very similar bug in the Extension Manager:
I have imported the whole database from another site. The tables are all there containing all contents. But the EM says:

ALTER TABLE static_countries ADD UNIQUE uid (uid);
ALTER TABLE static_country_zones ADD UNIQUE uid (uid);
ALTER TABLE static_currencies ADD KEY parent (pid);
ALTER TABLE static_languages ADD KEY parent (pid);
ALTER TABLE static_taxes ADD KEY parent (pid);
ALTER TABLE tx_staticinfotables_hotlist ADD KEY uid_local (uid_local);
Actions #3

Updated by Christian Kuhn about 15 years ago

Resolved, no change required:

- All proposed changes are key indexes only, no dropped fields.
- In case of fe_users there's a standard key in 4.2 on pid/username named parent.

Actions #4

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF