Also ich war die letzten Wochen mehrfach mit einem Techniker meines Server-Anbieters in Kontakt
Vor zwei Tagen haben wir sogar fast 2 Stunden telefoniert und versucht die Migration über die Bühne zu bekommen.
Aber es hat einfach nicht funktioniert!!!
Er meinte im PHP-Errorlog würde auch nichts wirkliches drin stehen. Es war eine Zeit-Meldung da aber diverse Änderungen haben auch nichts gebracht.
Die Log-Dateien vom Migrationstool habe ich mittlerweile gefunden, die sind natürlich an einer ganz anderen Stelle als in der Beschreibung des Tools angegeben.
Ich habe hier jetzt schon viel Geld für ein Theme ausgegeben aber die Migration funzt einfach nicht, dass kann doch nicht sein!!!
Ich frage mich wirklich woran das liegt!
Folgende Log-Dateien (insgesamt 5 Stück) wurde soeben bei meinem letzten Versuch der Migraton angelegt (viellleicht findet hier ja doch noch jemand den Fehler):
<<<=======================>>>
11:50:57
<<<=======================>>>
SQL
SHOW DATABASES
PARAMETER
TYPES
2
DURATION
0.466125965118
<<<============ END OF QUERY ============>>>
SQL
SHOW DATABASES
PARAMETER
TYPES
2
DURATION
0.466723918915
<<<============ END OF QUERY ============>>>
<<<=======================>>>
11:51:56
<<<=======================>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='1')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
0.000170946121216
<<<============ END OF QUERY ============>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='2')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
8.10623168945E-5
<<<============ END OF QUERY ============>>>
SQL
SELECT `id` , `description` as name
FROM `s_core_states` AS `s`
WHERE `group`='state'
ORDER BY `position` ASC
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s
type => ALL
possible_keys =>
key =>
key_len =>
ref =>
rows => 29
Extra => Using where; Using filesort
TYPES
32
DURATION
5.60283660889E-5
<<<============ END OF QUERY ============>>>
<<<=======================>>>
11:52:58
<<<=======================>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='1')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
0.000125885009766
<<<============ END OF QUERY ============>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='2')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
0.000113010406494
<<<============ END OF QUERY ============>>>
SQL
SELECT `id` , `description` as name
FROM `s_core_states` AS `s`
WHERE `group`='state'
ORDER BY `position` ASC
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s
type => ALL
possible_keys =>
key =>
key_len =>
ref =>
rows => 29
Extra => Using where; Using filesort
TYPES
32
DURATION
7.39097595215E-5
<<<============ END OF QUERY ============>>>
<<<=======================>>>
11:53:24
<<<=======================>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='1')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
0.000102996826172
<<<============ END OF QUERY ============>>>
SQL
SELECT `s_core_snippets`.`name`, `s_core_snippets`.`value` FROM `s_core_snippets` WHERE (namespace='backend/swag_migration/main') AND (shopID='1') AND (localeID='2')
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_snippets
type => ref
possible_keys => namespace
key => namespace
key_len => 771
ref => const,const
rows => 263
Extra => Using index condition
TYPES
32
DURATION
6.50882720947E-5
<<<============ END OF QUERY ============>>>
SQL
SELECT `id`, `description` as name
FROM `s_core_tax`
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => s_core_tax
type => ALL
possible_keys =>
key =>
key_len =>
ref =>
rows => 4
Extra =>
TYPES
32
DURATION
3.50475311279E-5
<<<============ END OF QUERY ============>>>
<<<=======================>>>
11:54:22
<<<=======================>>>
SQL
SELECT
c.id_category as categoryID,
IF(c.id_parent=1, '', c.id_parent) as parentID,
cl.id_lang as languageID,
cl.name as description,
c.position as position,
cl.meta_title as meta_title,
cl.meta_keywords as metaKeywords,
cl.meta_description as metaDescription,
c.active as active,
cl.meta_title as cmsheadline,
cl.description as cmstext
FROM `ps_category` AS `c`
LEFT JOIN `ps_category_lang` AS `cl`
ON cl.id_category=c.id_category
WHERE c.id_category>1
ORDER BY c.id_parent ASC
PARAMETER
EXPLAIN
id => 1
select_type => SIMPLE
table => c
type => range
possible_keys => PRIMARY
key => PRIMARY
key_len => 4
ref =>
rows => 84
Extra => Using where; Using filesort
id => 1
select_type => SIMPLE
table => cl
type => ref
possible_keys => PRIMARY
key => PRIMARY
key_len => 4
ref => d024a9a5.c.id_category
rows => 1
Extra =>
TYPES
32
DURATION
0.000921964645386
<<<============ END OF QUERY ============>>>
Ich würde mich wirklich freuen wenn das ganze mit Shopware keine Zeit und Geld-Verschwendung gewesen wäre!!!
VG
Tom
