id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
2441	Importieren bei Artikeleigenschaften führt zu Error und Warnings	noRiddle	somebody	"Beim Importieren von Artikeleigenschaften, wenn man dabei ""Optionswerte als Eigenschaften-Werte importieren?"" aktiviert, kommt es zu folgendem Error und den folgenden Warnings:
{{{
[2023-02-06 11:03:58]	[error]	[modified]	[pid:4007071]	ERROR found for URL: /admin/products_tags.php?page=1&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:58]	[error]	[modified]	[pid:4007071]	Duplicate entry '1-1' for key 'PRIMARY' in File: PATH/inc/db_functions_mysqli.inc.php on Line: 174	{}	{}
}}}


{{{
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	WARNING found for URL: /admin/products_tags.php?page=0&action=import_attributes	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	Undefined variable $oInfo in File: PATH/admin/products_tags.php on Line: 744	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	WARNING found for URL: /admin/products_tags.php?page=0&action=import_attributes	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	Attempt to read property ""options_id"" on null in File: PATH/admin/products_tags.php on Line: 744	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	WARNING found for URL: /admin/products_tags.php?page=0&action=import_attributes	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	Undefined variable $oInfo in File: PATH/admin/products_tags.php on Line: 753	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	WARNING found for URL: /admin/products_tags.php?page=0&action=import_attributes	{}	{}
[2023-02-06 11:02:50]	[warning]	[modified]	[pid:4007071]	Attempt to read property ""options_id"" on null in File: PATH/admin/products_tags.php on Line: 753	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	WARNING found for URL: /admin/products_tags.php?page=0&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	Undefined variable $hidden_fields in File: PATH/admin/products_tags.php on Line: 421	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	WARNING found for URL: /admin/products_tags.php?page=0&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	Undefined variable $oInfo in File: PATH/admin/products_tags.php on Line: 759	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	WARNING found for URL: /admin/products_tags.php?page=0&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007072]	Attempt to read property ""options_id"" on null in File: PATH/admin/products_tags.php on Line: 759	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	WARNING found for URL: /admin/products_tags.php?page=1&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	Undefined variable $hidden_fields in File: PATH/admin/products_tags.php on Line: 421	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	WARNING found for URL: /admin/products_tags.php?page=1&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	Undefined variable $oInfo in File: PATH/admin/products_tags.php on Line: 759	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	WARNING found for URL: /admin/products_tags.php?page=1&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:57]	[warning]	[modified]	[pid:4007070]	Attempt to read property ""options_id"" on null in File: PATH/admin/products_tags.php on Line: 759	{}	{}
[2023-02-06 11:03:58]	[warning]	[modified]	[pid:4007071]	WARNING found for URL: /admin/products_tags.php?page=1&oID=&action=import_confirm	{}	{}
[2023-02-06 11:03:58]	[warning]	[modified]	[pid:4007071]	1062 - Duplicate entry '1-1' for key 'PRIMARY'<br/><br/>INSERT INTO products_tags_values (values_id, options_id, values_name, languages_id, date_added, products_options_values_id) VALUES ('1', '1', 'black', '1', now(), '1') in File: PATH/inc/db_functions_mysqli.inc.php on Line: 161	{}	{}
[2023-02-06 11:03:58]	[warning]	[modified]	[pid:4007071]	Backtrace #0 - PATH/inc/db_functions.inc.php called at Line 76	{}	{}
[2023-02-06 11:03:58]	[warning]	[modified]	[pid:4007071]	Backtrace #1 - PATH/admin/products_tags.php called at Line 364	{}	{}
}}}


Wenn man vor Import bereits Artikeleigenschaften angelegt hatte ist der ""Duplicate entry"" dann natürlich bei der ersten nächsten eingetragenen ''values_id''.

Im Dev-Shop getestet und bestätigt.

Habe aus Zeitgründen den Code nicht zu Ende analysiert. Ein testweises 
{{{
$values_id = $check['values_id'] + 1;
}}}

in Zeile 350 änderte nichts an den Fehlern.


Gruß,
noRiddle
"	Bug/Fehler	closed	hoch	modified-shop-2.0.8.0	Admin	2.0.7.2	fixed