Project

General

Profile

Actions

Bug #15449

closed

Dump static data IMPORT fails

Added by Martin Koch about 18 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Must have
Category:
-
Target version:
-
Start date:
2006-01-18
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
5
Tags:
Complexity:
Is Regression:
Sprint Focus:

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

import-static_files.tar.gz (7.05 KB) import-static_files.tar.gz Administrator Admin, 2006-02-01 22:28
Actions #1

Updated by old_pss7 about 18 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

Actions #2

Updated by Franz Holzinger about 18 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 $

Actions #3

Updated by Franz Holzinger about 18 years ago

This error happens when you did not click on
"Update required tables COMPARE"

before you start the import.

Actions #4

Updated by Martin Koch about 18 years ago

No. Also if you did click compare before.

Actions #5

Updated by Peter Niederlag about 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.

Actions #6

Updated by Franz Holzinger about 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)

Actions #7

Updated by Peter Niederlag about 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?

Actions #8

Updated by Michael Stucki about 18 years ago

Feedback requested.

Actions #9

Updated by Franz Holzinger about 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

Actions #10

Updated by Peter Niederlag about 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

Actions #11

Updated by Franz Holzinger about 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'

Actions #12

Updated by Peter Niederlag about 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.

Actions

Also available in: Atom PDF