Bug #17935
closed
Installation misses key-definition of table pages and create of table fe_users
Added by Steffen Kamper almost 17 years ago.
Updated about 16 years ago.
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
I also missed the fe_users table after upgrading using the new install tool.
I can also confirm that a fresh install of the latest TYPO3 4.2 trunk misses to create the fe_users table.
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.
Fixed in rev. 3765
Bug can be closed.
submitted to svn by ingmar in rev3765
Also available in: Atom
PDF