USER ERROR(256): "SQL Error"

Was sagt denn das logfile?

 

Hallo,

hab auch den Fehler USER ERROR(256): "SQL Error" beim Speichern eines neuen Artikels erhalten. Was ist zu tun, gab's einen workaround?
Ciao
Lutz

 

Hallo Lutz,

Diese SQL Errors können unterschiedliche Ursachen haben. Es wäre gut, wenn du mir einen Logeintrag zu dem betreffenden SQL-Error geben könntest.
Am Besten postest du die Logeinträge in einem Codeblock, dadurch sollten die Zeilenumbrüche nicht entfernt werden, wodurch das Ganze besser lesbar sein sollte.

 

Hallo Torben,

anbei das log-file.
Was meinst Du?
Vielleicht liegt's am Hoster wie Strato...?

Beste Grüße aus Köln
Lutz

Code:

- gm_gmotion_sort_order_3: 4
	- products_price: 15.00
	- products_price_1: 0
	- products_quantity_staffel_1: Array
		(
		    [0] => 
		)
		
	- products_price_staffel_1: Array
		(
		    [0] => 0
		)
		
	- products_price_2: 0
	- products_quantity_staffel_2: Array
		(
		    [0] => 
		)
		
	- products_price_staffel_2: Array
		(
		    [0] => 0
		)
		
	- products_price_3: 0
	- products_quantity_staffel_3: Array
		(
		    [0] => 
		)
		
	- products_price_staffel_3: Array
		(
		    [0] => 0
		)
		
	- products_discount_allowed: 
	- products_tax_class_id: 1
	- products_date_added: 2015-02-09
	- products_id: 
	- page_token: 01d8fab983466f3812130299d2d39c26

Get: 
	- cPath: 1
	- pID: 
	- action: insert_product


================================================================================

2015-02-09 12:39:47 (70badd874434ad517fab1317edabf0b7) SQL ERROR(1062): "Duplicate entry '2147483647' for key 'PRIMARY'" in /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_error.inc.php:23

#5	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_error.inc.php:23


#4	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_query.inc.php:77


#3	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_perform.inc.php:147


#2	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/includes/classes/categories.php:2457


#1	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/includes/classes/categories.php:1662


#0	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/categories.php:303


Request: POST /admin/categories.php?action=multi_action_confirm&cPath=0_3
	- duration: ~1ms
	- server: Apache/2.2.29 (Unix)
	- server address: 
	- user agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36
	- remote address: 70badd874434ad517fab1317edabf0b7

Post: 
	- cPath: 0_3
	- multi_products: Array
		(
		    [0] => _19
		)
		
	- dest_category_id: 1
	- copy_as: duplicate
	- gm_copy_attributes: 1
	- gm_copy_specials: 1
	- gm_copy_cross_sells: 1
	- page_token: b7ae0dedd71cd97cadc558546cf0fb95
	- multi_copy_confirm: Kopieren

Get: 
	- action: multi_action_confirm
	- cPath: 0_3

Information:
Query:
INSERT INTO products (products_ean, use_properties_combis_quantity, products_quantity, use_properties_combis_shipping_time, products_shippingtime, products_model, products_sort, products_price, products_discount_allowed, products_date_added, products_last_modified, products_date_available, use_properties_combis_weight, products_weight, products_status, products_tax_class_id, product_template, options_template, manufacturers_id, products_fsk18, products_vpe, products_vpe_status, products_vpe_value, products_startpage, products_startpage_sort, group_ids, nc_ultra_shipping_costs, gm_show_date_added, gm_show_price_offer, gm_show_weight, gm_price_status, gm_min_order, gm_graduated_qty, gm_options_template, gm_priority, gm_changefreq, gm_show_qty_info, gm_sitemap_entry, products_image_w, products_image_h, properties_dropdown_mode, properties_show_price, product_type, group_permission_0, group_permission_1, group_permission_2, group_permission_3) VALUES ('8851473001450', '0', '998.0000', '0', '1', 'B009IZWZDI', '0', '13.4454', '0.00', NOW(), '2015-02-09 11:38:22', '', '0', '0.5250', '0', '1', 'default', 'default', '0', '0', '0', '0', '0.0000', '0', '0', '', '0.0000', '0', '0', '1', '0', '1.0000', '1.0000', 'default', '0.5', 'weekly', '0', '1', '150', '100', '', '', '1', '0', '0', '0', '0')
================================================================================

2015-02-09 12:39:47 (70badd874434ad517fab1317edabf0b7) USER ERROR(256): "SQL Error" in /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_error.inc.php:24

#5	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_error.inc.php:24

	Function: trigger_error('SQL Error', 256)
		- $message: ### indeterminate value ###
		- $error_type: ### indeterminate value ###

	Code:
		line 22: 	$coo_logger = LogControl::get_instance();
		line 23: 	$coo_logger->notice($p_error, 'error_handler', 'errors', 'notice', 'SQL ERROR', $p_errno, 'Query:' . "\r\n" . trim($p_query));
		line 24: 	trigger_error('SQL Error', E_USER_ERROR);
		line 25: }
#4	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_query.inc.php:77

	Function: xtc_db_error('INSERT INTO products (products_ean, use_properties_combis_quantity, products_quantity, use_properties_combis_shipping_time, products_shippingtime, products_model, products_sort, products_price, products_discount_allowed, products_date_added, products_last_modified, products_date_available, use_properties_combis_weight, products_weight, products_status, products_tax_class_id, product_template, options_template, manufacturers_id, products_fsk18, products_vpe, products_vpe_status, products_vpe_value, products_startpage, products_startpage_sort, group_ids, nc_ultra_shipping_costs, gm_show_date_added, gm_show_price_offer, gm_show_weight, gm_price_status, gm_min_order, gm_graduated_qty, gm_options_template, gm_priority, gm_changefreq, gm_show_qty_info, gm_sitemap_entry, products_image_w, products_image_h, properties_dropdown_mode, properties_show_price, product_type, group_permission_0, group_permission_1, group_permission_2, group_permission_3) VALUES (\'8851473001450\', \'0\', \'998.0000\', \'0\', \'1\', \'B009IZWZDI\', \'0\', \'13.4454\', \'0.00\', NOW(), \'2015-02-09 11:38:22\', \'\', \'0\', \'0.5250\', \'0\', \'1\', \'default\', \'default\', \'0\', \'0\', \'0\', \'0\', \'0.0000\', \'0\', \'0\', \'\', \'0.0000\', \'0\', \'0\', \'1\', \'0\', \'1.0000\', \'1.0000\', \'default\', \'0.5\', \'weekly\', \'0\', \'1\', \'150\', \'100\', \'\', \'\', \'1\', \'0\', \'0\', \'0\', \'0\')', 1062, 'Duplicate entry \'2147483647\' for key \'PRIMARY\'')
		- $p_query: ### indeterminate value ###
		- $p_errno: ### indeterminate value ###
		- $p_error: ### indeterminate value ###

	Code:
		line 75: 		# ALL OTHER RUN MODES
		line 76: 		# execute query
		line 77: 		$result = mysql_query($p_query, $$link) or xtc_db_error($p_query, mysql_errno(), mysql_error());		
		line 78: 	}
		line 79: 	

#3	File: /mnt/weba/e2/83/53699183/htdocs/shop/inc/xtc_db_perform.inc.php:147

	Function: xtc_db_query('INSERT INTO products (products_ean, use_properties_combis_quantity, products_quantity, use_properties_combis_shipping_time, products_shippingtime, products_model, products_sort, products_price, products_discount_allowed, products_date_added, products_last_modified, products_date_available, use_properties_combis_weight, products_weight, products_status, products_tax_class_id, product_template, options_template, manufacturers_id, products_fsk18, products_vpe, products_vpe_status, products_vpe_value, products_startpage, products_startpage_sort, group_ids, nc_ultra_shipping_costs, gm_show_date_added, gm_show_price_offer, gm_show_weight, gm_price_status, gm_min_order, gm_graduated_qty, gm_options_template, gm_priority, gm_changefreq, gm_show_qty_info, gm_sitemap_entry, products_image_w, products_image_h, properties_dropdown_mode, properties_show_price, product_type, group_permission_0, group_permission_1, group_permission_2, group_permission_3) VALUES (\'8851473001450\', \'0\', \'998.0000\', \'0\', \'1\', \'B009IZWZDI\', \'0\', \'13.4454\', \'0.00\', NOW(), \'2015-02-09 11:38:22\', \'\', \'0\', \'0.5250\', \'0\', \'1\', \'default\', \'default\', \'0\', \'0\', \'0\', \'0\', \'0.0000\', \'0\', \'0\', \'\', \'0.0000\', \'0\', \'0\', \'1\', \'0\', \'1.0000\', \'1.0000\', \'default\', \'0.5\', \'weekly\', \'0\', \'1\', \'150\', \'100\', \'\', \'\', \'1\', \'0\', \'0\', \'0\', \'0\')', 'db_link')
		- $p_query: ### indeterminate value ###
		- $link: ### indeterminate value, default value: 'db_link' ###
		- $p_enable_data_cache: ### indeterminate value, default value: true ###
		- $p_enable_logging: ### indeterminate value, default value: true ###

	Code:
		line 145: 	if(empty($t_sql) == false)
		line 146: 	{
		line 147: 		$t_result = xtc_db_query($t_sql, $p_link);
		line 148: 	}	
		line 149: 	

#2	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/includes/classes/categories.php:2457

	Function: xtc_db_perform('products', array (
			  'products_ean' => '8851473001450',
			  'use_properties_combis_quantity' => '0',
			  'products_quantity' => '998.0000',
			  'use_properties_combis_shipping_time' => '0',
			  'products_shippingtime' => '1',
			  'products_model' => 'B009IZWZDI',
			  'products_sort' => '0',
			  'products_price' => '13.4454',
			  'products_discount_allowed' => '0.00',
			  'products_date_added' => 'now()',
			  'products_last_modified' => '2015-02-09 11:38:22',
			  'products_date_available' => NULL,
			  'use_properties_combis_weight' => '0',
			  'products_weight' => '0.5250',
			  'products_status' => 0,
			  'products_tax_class_id' => '1',
			  'product_template' => 'default',
			  'options_template' => 'default',
			  'manufacturers_id' => '0',
			  'products_fsk18' => '0',
			  'products_vpe' => '0',
			  'products_vpe_status' => '0',
			  'products_vpe_value' => '0.0000',
			  'products_startpage' => 0,
			  'products_startpage_sort' => '0',
			  'group_ids' => '',
			  'nc_ultra_shipping_costs' => '0.0000',
			  'gm_show_date_added' => '0',
			  'gm_show_price_offer' => '0',
			  'gm_show_weight' => '1',
			  'gm_price_status' => '0',
			  'gm_min_order' => '1.0000',
			  'gm_graduated_qty' => '1.0000',
			  'gm_options_template' => 'default',
			  'gm_priority' => '0.5',
			  'gm_changefreq' => 'weekly',
			  'gm_show_qty_info' => '0',
			  'gm_sitemap_entry' => '1',
			  'products_image_w' => '150',
			  'products_image_h' => '100',
			  'properties_dropdown_mode' => '',
			  'properties_show_price' => '',
			  'product_type' => '1',
			  'group_permission_0' => '0',
			  'group_permission_1' => '0',
			  'group_permission_2' => '0',
			  'group_permission_3' => '0',
			), 'insert', '', 'db_link', true)
		- $p_table: ### indeterminate value ###
		- $p_data_array: ### indeterminate value, default value: array (
			) ###
		- $p_action: ### indeterminate value, default value: 'insert' ###
		- $p_parameters: ### indeterminate value, default value: '' ###
		- $p_link: ### indeterminate value, default value: 'db_link' ###
		- $p_quoted_values: ### indeterminate value, default value: true ###

	Code:
		line 2455: 	function wrapped_db_perform($p_called_from, $p_table, $p_data_array = array(), $p_action = 'insert', $p_parameters = '', $p_link = 'db_link', $p_quoted_values = true)
		line 2456: 	{
		line 2457: 		return xtc_db_perform($p_table, $p_data_array, $p_action, $p_parameters, $p_link, $p_quoted_values);
		line 2458: 	}
		line 2459: 

#1	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/includes/classes/categories.php:1662

	Class: categories_ORIGIN
		- $redirect_url: NULL

	Method: wrapped_db_perform('duplicate_product', 'products', array (
			  'products_ean' => '8851473001450',
			  'use_properties_combis_quantity' => '0',
			  'products_quantity' => '998.0000',
			  'use_properties_combis_shipping_time' => '0',
			  'products_shippingtime' => '1',
			  'products_model' => 'B009IZWZDI',
			  'products_sort' => '0',
			  'products_price' => '13.4454',
			  'products_discount_allowed' => '0.00',
			  'products_date_added' => 'now()',
			  'products_last_modified' => '2015-02-09 11:38:22',
			  'products_date_available' => NULL,
			  'use_properties_combis_weight' => '0',
			  'products_weight' => '0.5250',
			  'products_status' => 0,
			  'products_tax_class_id' => '1',
			  'product_template' => 'default',
			  'options_template' => 'default',
			  'manufacturers_id' => '0',
			  'products_fsk18' => '0',
			  'products_vpe' => '0',
			  'products_vpe_status' => '0',
			  'products_vpe_value' => '0.0000',
			  'products_startpage' => 0,
			  'products_startpage_sort' => '0',
			  'group_ids' => '',
			  'nc_ultra_shipping_costs' => '0.0000',
			  'gm_show_date_added' => '0',
			  'gm_show_price_offer' => '0',
			  'gm_show_weight' => '1',
			  'gm_price_status' => '0',
			  'gm_min_order' => '1.0000',
			  'gm_graduated_qty' => '1.0000',
			  'gm_options_template' => 'default',
			  'gm_priority' => '0.5',
			  'gm_changefreq' => 'weekly',
			  'gm_show_qty_info' => '0',
			  'gm_sitemap_entry' => '1',
			  'products_image_w' => '150',
			  'products_image_h' => '100',
			  'properties_dropdown_mode' => '',
			  'properties_show_price' => '',
			  'product_type' => '1',
			  'group_permission_0' => '0',
			  'group_permission_1' => '0',
			  'group_permission_2' => '0',
			  'group_permission_3' => '0',
			))
		- $p_called_from: 'duplicate_product'
		- $p_table: 'products'
		- $p_data_array: array (
			  'products_ean' => '8851473001450',
			  'use_properties_combis_quantity' => '0',
			  'products_quantity' => '998.0000',
			  'use_properties_combis_shipping_time' => '0',
			  'products_shippingtime' => '1',
			  'products_model' => 'B009IZWZDI',
			  'products_sort' => '0',
			  'products_price' => '13.4454',
			  'products_discount_allowed' => '0.00',
			  'products_date_added' => 'now()',
			  'products_last_modified' => '2015-02-09 11:38:22',
			  'products_date_available' => NULL,
			  'use_properties_combis_weight' => '0',
			  'products_weight' => '0.5250',
			  'products_status' => 0,
			  'products_tax_class_id' => '1',
			  'product_template' => 'default',
			  'options_template' => 'default',
			  'manufacturers_id' => '0',
			  'products_fsk18' => '0',
			  'products_vpe' => '0',
			  'products_vpe_status' => '0',
			  'products_vpe_value' => '0.0000',
			  'products_startpage' => 0,
			  'products_startpage_sort' => '0',
			  'group_ids' => '',
			  'nc_ultra_shipping_costs' => '0.0000',
			  'gm_show_date_added' => '0',
			  'gm_show_price_offer' => '0',
			  'gm_show_weight' => '1',
			  'gm_price_status' => '0',
			  'gm_min_order' => '1.0000',
			  'gm_graduated_qty' => '1.0000',
			  'gm_options_template' => 'default',
			  'gm_priority' => '0.5',
			  'gm_changefreq' => 'weekly',
			  'gm_show_qty_info' => '0',
			  'gm_sitemap_entry' => '1',
			  'products_image_w' => '150',
			  'products_image_h' => '100',
			  'properties_dropdown_mode' => '',
			  'properties_show_price' => '',
			  'product_type' => '1',
			  'group_permission_0' => '0',
			  'group_permission_1' => '0',
			  'group_permission_2' => '0',
			  'group_permission_3' => '0',
			)
		- $p_action: ### default value: 'insert' ###
		- $p_parameters: ### default value: '' ###
		- $p_link: ### default value: 'db_link' ###
		- $p_quoted_values: ### default value: true ###

	Code:
		line 1660: 		// EOF GM_MOD
		line 1661: 
		line 1662: 		$this->wrapped_db_perform(__FUNCTION__, TABLE_PRODUCTS, $sql_data_array);
		line 1663: 
		line 1664: 		//get duplicate id

#0	File: /mnt/weba/e2/83/53699183/htdocs/shop/admin/categories.php:303

	Class: categories_ORIGIN
		- $redirect_url: NULL

	Method: duplicate_product('19', '1')
		- $src_products_id: '19'
		- $dest_categories_id: '1'

	Code:
		line 301: 								}
		line 302: 								elseif ($_POST['copy_as'] == 'duplicate') {
		line 303: 									$catfunc->duplicate_product($product_id, $dest_category_id);
		line 304: 								} else {
		line 305: 									$messageStack->add_session('Copy type not specified.', 'error');

Request: POST /admin/categories.php?action=multi_action_confirm&cPath=0_3
	- duration: ~1ms
	- server: Apache/2.2.29 (Unix)
	- server address: 
	- user agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.111 Safari/537.36
	- remote address: 70badd874434ad517fab1317edabf0b7

Session: 
	- tpl: EyeCandy
	- MOBILE_ACTIVE: false
	- language: german
	- languages_id: 2
	- language_charset: utf-8
	- language_code: de
	- currency: EUR
	- customers_status: Array
		(
		    [customers_status_id] => 0
		    [customers_status_name] => Admin
		    [customers_status_image] => admin_status.gif
		    [customers_status_public] => 0
		    [customers_status_min_order] => 0
		    [customers_status_max_order] => 0
		    [customers_status_discount] => 0.00
		    [customers_status_ot_discount_flag] => 1
		    [customers_status_ot_discount] => 0.00
		    [customers_status_graduated_prices] => 1
		    [customers_status_show_price] => 1
		    [customers_status_show_price_tax] => 1
		    [customers_status_add_tax_ot] => 1
		    [customers_status_payment_unallowed] => 
		    [customers_status_shipping_unallowed] => 
		    [customers_status_discount_attributes] => 0
		    [customers_fsk18] => 1
		    [customers_fsk18_display] => 1
		    [customers_status_write_reviews] => 1
		    [customers_status_read_reviews] => 1
		)
		
	- cart: shoppingCart Object
		(
		    [contents] => Array
		        (
		            [19] => Array
		                (
		                    [qty] => 1.0000
		                )
		
		        )
		
		    [total] => 14.98
		    [weight] => 0.525
		    [cartID] => 62786
		    [content_type] => 
		    [tax] => Array
		        (
		            [1] => Array
		                (
		                    [value] => 2.3917647058824
		                    [desc] => inkl. 19% MwSt.
		                )
		
		        )
		
		)
		
	- wishList: wishList Object
		(
		    [contents] => Array
		        (
		        )
		
		    [total] => 0
		    [weight] => 0
		    [cartID] => 
		    [content_type] => 
		)
		
	- customer_id: 1
	- payment: ### Session entry not present ###
	- shipping: ### Session entry not present ###
	- cartID: ### Session entry not present ###
	- sendto: ### Session entry not present ###
	- billto: ### Session entry not present ###

Post: 
	- cPath: 0_3
	- multi_products: Array
		(
		    [0] => _19
		)
		
	- dest_category_id: 1
	- copy_as: duplicate
	- gm_copy_attributes: 1
	- gm_copy_specials: 1
	- gm_copy_cross_sells: 1
	- page_token: b7ae0dedd71cd97cadc558546cf0fb95
	- multi_copy_confirm: Kopieren

Get: 
	- action: multi_action_confirm
	- cPath: 0_3

 

Hallo Lutz,

laut deinem Logfile wird zwar versucht, einen Artikel anzulegen, das funktionierrt aber nicht, weil es schon einen Artikel in der Datenbank gibt, der die selbe eindeutige ID hat, wie der neu anzulegende Artikel.

Hast du in letzter Zeit etwas an der Datenbank verändert, bzw. wie ist dein Shop konfiguriert? Die ID die da zu vergeben versucht wird, ist nämlich der maximal verfügbare Wert. Hast du tatsächlich so viele Artikel in deinem Shop oder verwendest du die Produkt ID für andere Dinge? Dafür ist diese nämlich nicht gedacht.

 

das problem habe ich auch. habe einen neuen shop aufgesetzt und mit dem importer die daten ins neue system importiert.
wenn ich eine neue kategorie oder artikel anlegen will, dann kommt ein sql fehler.

grüße

 

Hallo erimarv-der-osten,

auch hier müsste man gezielt einen Blick in die Logs werfen um zu sehen was das Problem ist.

 

Hallo Torben,

ich habe die Artikel mit einer *.csv-Datei hochgeladen, Werde diese einfach exportieren und schauen, was da falsch ist. Product IDs löschen und dann sehen, was passiert.
Melde mich.
Herzlich Dank schon einmal für Deine Hilfe!
Ciao
Lutz

 

Hallo Torben,

Fehler gefunden. es waren im Shop 2 Kategorien angelegt und es war ein Artikel unter derselben Hierarchie der beiden Kategrien angelegt.
Den habe ich gelöscht und das Problem war gelöst.
Merci noch einmal!
Ciao
Lutz

 

Hallo Lutz,

vielen dank für die Rückmeldung und schön das du den Fehler gefunden hast

Beste Grüße
Torben

 

Habe leider auch das Problem bein Anlegen einer neuen Kategorie das der Fehler kommt


User error 256 SQL

 

Hallo,

was hast du getan, bevor der Fehler aufgetreten ist? Hast du Artikel und Kategorien importiert? Hast du unseren Import-Assistenten oder den Import einer CSV-Datei verwendet?

Ohne genau Informationen ist es da sehr schwer, einen konkreten Lösungsvorschlag zu machen. Am Besten wäre es, wenn du uns ein Logfile zur Verfügung stellst. Und es wäre hilfreich, wenn du uns deine Shopversion mitteilst

 

Shopversion ist
2.1.4.1
Fehler ist nach dem Wechsel von GX 1 auf GX 2 aufgetreten
Daten wurden mit dem Importassistenten durchgeführt


Ist nun aufgefallen nachdem neue Kategorien eingepflegt werden sollten

 

- Neu laden in: ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - coID: 13 - content: Kundenmeinungen - XTCsid: 8go831psu1v790adfmkkuutqi0 ================================================================================ 2015-02-25 07:20:43 (fe827d8587cfedb558692ded29085513) USER ERROR(256): "Smarty error: unable to read resource: "EyeCandy/module/gm_guestbook.html"" in /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1104 #11 File: /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1104 Code: │ line 1102: { │ line 1103: $msg = htmlentities_wrapper($error_msg); ├─ line 1104: trigger_error("Smarty error: $msg", $error_type); │ line 1105: } │ line 1106: #10 File: /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1649 Code: │ line 1647: if (!$_return) { │ line 1648: if (!$params['quiet']) { ├─ line 1649: $this->trigger_error('unable to read resource: "' . $params['resource_name'] . '"', E_USER_ERROR); │ line 1650: } │ line 1651: } else if ($_return && $this->security) { #9 File: /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1475 Code: │ line 1473: │ line 1474: $_params = array('resource_name' => $resource_name); ├─ line 1475: if (!$this->_fetch_resource_info($_params)) { │ line 1476: return false; │ line 1477: } #8 File: /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1266 Code: │ line 1264: if ($display && !$this->caching && count($this->_plugins['outputfilter']) == 0) { │ line 1265: if ($this->_is_compiled($resource_name, $_smarty_compile_path) ├─ line 1266: || $this->_compile_resource($resource_name, $_smarty_compile_path)) │ line 1267: { │ line 1268: include($_smarty_compile_path); #7 File: /mnt/web7/c0/05/51184605/htdocs/GX2/includes/classes/Smarty/Smarty.class.php:1117 Code: │ line 1115: function display($resource_name, $cache_id = null, $compile_id = null) │ line 1116: { ├─ line 1117: $this->fetch($resource_name, $cache_id, $compile_id, true); │ line 1118: } │ line 1119: #6 File: /mnt/web7/c0/05/51184605/htdocs/GX2/media/content/gm_guestbook.php:77 Code: │ line 75: │ line 76: ├─ line 77: $smarty_gm_guestbook->display(CURRENT_TEMPLATE.'/module/gm_guestbook.html'); │ line 78: ?> #5 File: /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/ShopContentContentView.inc.php:128 Code: │ line 126: } │ line 127: ├─ line 128: include (DIR_FS_CATALOG . 'media/content/' . $this->content_file); │ line 129: │ line 130: if(strpos($this->content_file, '.txt')) #4 File: /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/ShopContentContentView.inc.php:301 Code: │ line 299: if($this->content_file != '') │ line 300: { ├─ line 301: $content_body = $this->get_file_output(); │ line 302: $this->set_content_data('file', $content_body); │ line 303: } #3 File: /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/ShopContentContentView.inc.php:111 Code: │ line 109: { │ line 110: $this->set_content_template('content.html'); ├─ line 111: $this->add_content_data(); │ line 112: } │ line 113: } #2 File: /mnt/web7/c0/05/51184605/htdocs/GX2/system/core/ContentView.inc.php:110 Code: │ line 108: { │ line 109: $t_html_output = ''; ├─ line 110: $this->prepare_data(); │ line 111: if($this->build_html == true) │ line 112: { #1 File: /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/ShopContentContentControl.inc.php:123 Code: │ line 121: } │ line 122: ├─ line 123: $this->v_output_buffer = $this->coo_content_view->get_html(); │ line 124: │ line 125: return true; #0 File: /mnt/web7/c0/05/51184605/htdocs/GX2/shop_content.php:60 Code: │ line 58: $coo_shop_content_control->set_('email_address', $t_email_address); │ line 59: $coo_shop_content_control->set_('message_body', $t_message_body); ├─ line 60: $coo_shop_content_control->proceed(); │ line 61: │ line 62: $t_redirect_url = $coo_shop_content_control->get_redirect_url(); Request: GET /shop_content.php?XTCsid=o465ja9ft32t5lk7trlmpgubp7&coID=13 - duration: ~0ms - server: Apache/2.2.29 (Unix) - server address: - user agent: Mozilla/5.0 (compatible; SemrushBot/0.98~bl; http://www.semrush.com/bot.html) - remote address: fe827d8587cfedb558692ded29085513 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 1 [customers_status_name] => Gast [customers_status_image] => guest_status.gif [customers_status_discount] => 0.00 [customers_status_public] => 1 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_ot_discount_flag] => 0 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 1 [customers_status_add_tax_ot] => 0 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [content_type] => ) - wishList: wishList Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [content_type] => ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - XTCsid: o465ja9ft32t5lk7trlmpgubp7 - coID: 13 ================================================================================ 2015-02-25 07:47:07 (0905ffd7b6b41e47e378a7692a8b8fd1) USER ERROR(256): "could not proceed module [JSproduct_info]" in /mnt/web7/c0/05/51184605/htdocs/GX2/gm_javascript.js.php:109 #0 File: /mnt/web7/c0/05/51184605/htdocs/GX2/gm_javascript.js.php:109 Code: │ line 107: if($t_proceed_status != true) │ line 108: { ├─ line 109: trigger_error('could not proceed module ['.htmlentities_wrapper($t_class_name).']', E_USER_ERROR); │ line 110: } │ line 111: } Request: GET /gm_javascript.js.php?XTCsid=9nqdcaste08e11gcq0v52gm100&cPath=45_11_209&products_id=93&page=product_info - duration: ~0ms - server: Apache/2.2.29 (Unix) - server address: - user agent: Mozilla/5.0 (compatible; Googlebot/2.1; http://www.google.com/bot.html) - remote address: 0905ffd7b6b41e47e378a7692a8b8fd1 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 1 [customers_status_name] => Gast [customers_status_image] => guest_status.gif [customers_status_discount] => 0.00 [customers_status_public] => 1 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_ot_discount_flag] => 0 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 1 [customers_status_add_tax_ot] => 0 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [content_type] => ) - wishList: wishList Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [content_type] => ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - XTCsid: 9nqdcaste08e11gcq0v52gm100 - cPath: 45_11_209 - products_id: 93 - page: product_info ================================================================================ 2015-02-25 09:37:30 (13cc664c28fef041a1884d4f6b3131ce) FATAL ERROR(1): "Call to a member function is_valid() on a non-object" Request: GET /request_port.php?module=CallbackService&action=check&name=Daniel Schranck&telephone=00352 691198232&vvcode=undefined&recaptcha_response_field=undefined&recaptcha_challenge_field=undefined&XTCsid=8eqn6ecpn3vlknlvuqub44rtf5 - duration: ~0ms - server: Apache/2.2.29 (Unix) - server address: - user agent: Mozilla/5.0 (Linux; U; Android 4.1.2; de-de; GT-I8190 Build/JZO54K) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30 - remote address: 13cc664c28fef041a1884d4f6b3131ce Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 1 [customers_status_name] => Gast [customers_status_image] => guest_status.gif [customers_status_discount] => 0.00 [customers_status_public] => 1 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_ot_discount_flag] => 0 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 1 [customers_status_add_tax_ot] => 0 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - wishList: wishList Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - module: CallbackService - action: check - name: Daniel Schranck - telephone: 00352 691198232 - vvcode: undefined - recaptcha_response_field: undefined - recaptcha_challenge_field: undefined - XTCsid: 8eqn6ecpn3vlknlvuqub44rtf5 Information: Fatal error: Call to a member function is_valid() on a non-object in /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/CallbackServiceAjaxHandler.inc.php on line 45 ================================================================================ 2015-02-25 09:38:00 (524464abd5cda55af85a45409b8afff0) FATAL ERROR(1): "Call to a member function is_valid() on a non-object" Request: GET /request_port.php?module=CallbackService&action=check&name=Daniel Schranck&telephone=00352 691198232&vvcode=undefined&recaptcha_response_field=undefined&recaptcha_challenge_field=undefined&XTCsid=8eqn6ecpn3vlknlvuqub44rtf5 - duration: ~0ms - server: Apache/2.2.29 (Unix) - server address: - user agent: Mozilla/5.0 (Linux; U; Android 4.1.2; de-de; GT-I8190 Build/JZO54K) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30 - remote address: 524464abd5cda55af85a45409b8afff0 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 1 [customers_status_name] => Gast [customers_status_image] => guest_status.gif [customers_status_discount] => 0.00 [customers_status_public] => 1 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_ot_discount_flag] => 0 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 1 [customers_status_add_tax_ot] => 0 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - wishList: wishList Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - module: CallbackService - action: check - name: Daniel Schranck - telephone: 00352 691198232 - vvcode: undefined - recaptcha_response_field: undefined - recaptcha_challenge_field: undefined - XTCsid: 8eqn6ecpn3vlknlvuqub44rtf5 Information: Fatal error: Call to a member function is_valid() on a non-object in /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/CallbackServiceAjaxHandler.inc.php on line 45 ================================================================================ 2015-02-25 09:38:17 (524464abd5cda55af85a45409b8afff0) FATAL ERROR(1): "Call to a member function is_valid() on a non-object" Request: GET /request_port.php?module=CallbackService&action=check&name=Daniel Schranck&telephone=0035 691198232&vvcode=undefined&recaptcha_response_field=undefined&recaptcha_challenge_field=undefined&XTCsid=8eqn6ecpn3vlknlvuqub44rtf5 - duration: ~0ms - server: Apache/2.2.29 (Unix) - server address: - user agent: Mozilla/5.0 (Linux; U; Android 4.1.2; de-de; GT-I8190 Build/JZO54K) AppleWebKit/534.30 (KHTML, like Gecko) Version/4.0 Mobile Safari/534.30 - remote address: 524464abd5cda55af85a45409b8afff0 Session: - tpl: EyeCandy - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: Array ( [customers_status_id] => 1 [customers_status_name] => Gast [customers_status_image] => guest_status.gif [customers_status_discount] => 0.00 [customers_status_public] => 1 [customers_status_min_order] => 0 [customers_status_max_order] => 0 [customers_status_ot_discount_flag] => 0 [customers_status_ot_discount] => 0.00 [customers_status_graduated_prices] => 1 [customers_status_show_price] => 1 [customers_status_show_price_tax] => 1 [customers_status_add_tax_ot] => 0 [customers_status_payment_unallowed] => [customers_status_shipping_unallowed] => [customers_status_discount_attributes] => 0 [customers_fsk18] => 1 [customers_fsk18_display] => 1 [customers_status_write_reviews] => 1 [customers_status_read_reviews] => 1 ) - cart: shoppingCart Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - wishList: wishList Object ( [contents] => Array ( ) [total] => 0 [weight] => 0 [cartID] => [content_type] => ) - customer_id: ### Session entry not present ### - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Get: - module: CallbackService - action: check - name: Daniel Schranck - telephone: 0035 691198232 - vvcode: undefined - recaptcha_response_field: undefined - recaptcha_challenge_field: undefined - XTCsid: 8eqn6ecpn3vlknlvuqub44rtf5 Information: Fatal error: Call to a member function is_valid() on a non-object in /mnt/web7/c0/05/51184605/htdocs/GX2/system/classes/shop_content/CallbackServiceAjaxHandler

 

Hallo,

ich habe gerade mal einen Blick in deinen Shop geworfen und zum Test eine Kategorie und einen Artikel dort angelegt und wieder gelöscht. Das hat ohne Probleme funktioniert. Hast du das Problem inzwischen anderweitig gelöst bekommen?

LG Torben

 

Hallo Torben,
Problem wurde gelöst


Group_permissions_4 fehlte in der Tabelle categories

 

Danke für die Rückmeldung, gut dass du den Fehler gefunden hast