Bug #17935
closed
Installation misses key-definition of table pages and create of table fe_users
0%
Description
after setup (done with new install) these compare results are given:
ALTER TABLE pages DROP KEY parent;
ALTER TABLE pages ADD KEY parent (pid,sorting,deleted,hidden);
CREATE fe_users ...
I don't think that this concerns to new installer, so i report this here as seen with a fresh trunk version.
(issue imported from #M6998)
Files
Updated by Kasper Ligaard almost 17 years ago
I also missed the fe_users table after upgrading using the new install tool.
Updated by Stig Nørgaard Færch almost 17 years ago
I can also confirm that a fresh install of the latest TYPO3 4.2 trunk misses to create the fe_users table.
Updated by Steffen Müller over 16 years ago
In 4.2.0, the fe_users table seems to be correct. But we still have the pages key problem:
ALTER TABLE pages DROP KEY parent;
ALTER TABLE pages ADD KEY parent (pid,sorting,deleted,hidden);
It might be because the 1-2-3-tool uses /t3lib/stddb/tables.sql with:
KEY parent (pid,sorting)
But the Database Analyser COMPARE uses typo3/sysext/cms/ext_tables.sql with:
KEY parent (pid,sorting,deleted,hidden)
Since /t3lib/stddb/tables.sql misses the 'hidden' column, changing the KEY value requires to add this column first.
I don't know if this is harmless - the applied patch adds this column and adjusts the KEY.
Updated by Steffen Müller about 16 years ago
Fixed in rev. 3765
Bug can be closed.
Updated by Christian Jul Jensen about 16 years ago
submitted to svn by ingmar in rev3765