When creating a new instances from the tab 'TYPO3 Instances' in the 'Options' dialog, the following tables will not work in the new instance:
cache_hash, cache_imagesizes, sys_log, cache_pages, cache_pagesection, cache_typo3temp_log, cache_md5params, fe_session_data, and fe_sessions
(the table definitions are found in the files t3lib/stddb/tables.sql and typo3/sysext/cms/ext_tables.sql).
The reason seems to be that these are defined to use InnoDB as their storage engine. InnoDB table files can not be copied (MyISAM table files can).
Steps to reproduce:
1) Create a new instance from TYPO3Winstaller -> Options -> TYPO3 Instances -> Add
2) Log in to the newly created instance and install the extension 'Frontend Login for Website Users', EXT:felogin (comes with Typo3).
3) Configure the extension (i.e. create a SysFolder with FE users, and put the plug-in on a page).
4) Try to login as a FE user. Result: You can not login.
5) Go to phpMyAdmin and verify that the table is not working.
In phpMyAdmin I get the following error mesage:
Error
SQL query: Edit
SHOW INDEX FROM `fe_sessions` ;
MySQL said: Documentation
#1016 - Can't open file: 'fe_sessions.ibd' (errno: 1)
I do not know how to solve this in TYPO3Winstaller, so this bug report only states the problem, not the solution - sorry :-(
Another user having the same problem as I did with TYPO3Winstaller can be found here: http://www.typo3forum.net/forum/typo3-4-x-fragen-probleme/31533-felogin-funktioniert.html
Hi Kasper,
i have already the solution, thank you for your bug-reports!
solution will come with 4.2.3 ;-)
Andreas