Bug #15449
closedDump static data IMPORT fails
0%
Description
From the install, trying to IMPORT the static tables fails if I check 'Import the whole file 'CURRENT_STATIC' directly (ignores selections above)' with this error:
Warning: Invalid argument supplied for foreach() in /dana/data/typo3/docs/TYPO3core/typo3/sysext/install/mod/class.tx_install.php on line 3615
Using latest CVS.
(issue imported from #M2311)
Files
Updated by old_pss7 almost 19 years ago
have the same problem here
PHP 5.1.2-1 (cli) (built: Jan 18 2006 06:49:47)
php5-mysql 5.1.2-1
mysql-server-5.0 5.0.18-7
=> debian sarge
typo 3 v4 beta 2
Updated by Franz Holzinger almost 19 years ago
Warning: Invalid argument supplied for foreach() in /home/httpd/vhosts/fholzinger.com/httpdocs/TYPO3core/typo3/sysext/install/mod/class.tx_install.php on line 3558 * $Id: class.tx_install.php,v 1.42.2.8 2006/01/29 20:40:24 kraftb Exp $
Updated by Franz Holzinger almost 19 years ago
This error happens when you did not click on
"Update required tables COMPARE"
before you start the import.
Updated by Martin Koch almost 19 years ago
No. Also if you did click compare before.
Updated by Peter Niederlag over 18 years ago
can be reproduced here. ;(
Can you describe in more details please how to reproduce the problem?
Are you having a virgin-databse on beforehand or having thoses tables already available?
steps to reproduce...
There is no foreach on 3558 anymore as of now. ;)
oregon:~# apt-show-versions mysql-server-4.1
mysql-server-4.1/testing uptodate 4.1.15-1
some mysql-versions are known to produce issues evry once a while but foreach does not sound like a mysql-version thingy.
Updated by Franz Holzinger over 18 years ago
I have made a fresh install of Beta3 with the original typo3conf and source, but before I have imported the database of TYPO3 3.8.1.
It is with SuSE 9.3 and PHP 4.3.10
mysqld Ver 4.1.10a for suse-linux on i686 (SUSE MySQL RPM)
Updated by Peter Niederlag over 18 years ago
Still not reproduciable under any circumstances here.
Have you really compared tables beforehand?
Can you please post again the exact error-message from beta3?
Updated by Franz Holzinger over 18 years ago
I get the following error messages. However the code is 2 days old because cvs.sourceforge.net has fallen out at the moment.
Maybe the duplicate keys come because I have tried to import the static tables for many times.
I suggest that the static tables should be deleted if existant and then reimported.
caller t3lib_DB::admin_query
ERROR Table 'tx_commerce_address_types' already exists
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Duplicate entry '1' for key 1
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Duplicate entry '2' for key 1
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Table 'tx_commerce_article_types' already exists
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Duplicate entry '1' for key 1
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Duplicate entry '2' for key 1
lastBuiltQuery SELECT count()
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
caller t3lib_DB::admin_query
ERROR Duplicate entry '3' for key 1
lastBuiltQuery SELECT count(*)
FROM static_template
debug_backtrace require // tx_install->init // tx_install->checkTheDatabase // t3lib_DB->admin_query // t3lib_DB->debug
Updated by Peter Niederlag over 18 years ago
Since error message starts with 'tx_commerce_address_types'' and I don't have that one here to have a look: Could you please deinstall that one so we can be 100% sure it is not something that is caused by the 'commerce' extension?
Handling of static data is a bit tricky and since commerce is rahter in any state but stable imho you should get rid of extensions like that before testing or at least take a look yourself to be sure it is not the one causing trouble.
Please list which static tables you are trying to import!
To me it pretty much looks like a problem with EXT:commerce static data
Updated by Franz Holzinger over 18 years ago
When I have deinstalled the Commerce extension everything went fine without any error message.
I have clicked the option 'Import the whole file 'CURRENT_STATIC' directly'
Updated by Peter Niederlag over 18 years ago
Please contact extension-authors to get that problem fixed.
read about "ext_tables_static+adt.sql" in http://typo3.org/documentation/document-library/core-documentation/doc_core_api/current/view/2/1/
Since I don't consider it to be a CORE-Issue I'll set the status to "done".
If anyone feels the problem still existsts with static-dumps provided by core please opene again and attach as detailed information as possible.