Cant create new product

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #241882

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.5.1

Hi
I can't create new product after it have deleted it.
The product has the same Product ID.
I have tried to find the product in the database table _hikashop_product, and deleted it.
But their is still a problem to create it.

Where can i find more about that, so i can create it again?

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 3 months ago #241885

Hi,

I don't understand. What is the problem ? You have an error message ? What is is exactly ? What do you do to create your new product ?

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242107

The product cant be created again, with the same product_code, after the first one was deleted.

How do i manage to create it again?

My client has done it it for some products.

Best regards
Brian
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 12953
  • Thank you received: 1778
9 years 3 months ago #242111

Hello Brian,

Firstly, can you use the "Check database" button via "Hikashop->System->Configuration" ? And then can you :
- Activate the Joomla debug mode ("Administration->Global configuration->System->Debug System/Language")
- Set the "error reporting" option of the Joomla configuration to "maximum"
- Test it again so that you can see if it display an error message which will help you to understand from what your issue is coming.

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242184

this is what i get



Best regards
Brian
Attachments:
Last edit: 9 years 3 months ago by Nowweb.

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 3 months ago #242226

Hi,

That error doesn't indicate a problem with the product_code.
It indicates an unknown problem with the INSERT or UPDATE query done for the save of the product data to the database.
Please look in the MySQL query profiling data at the bottom of the page with the error.
You should see an INSERT or UPDATE query done on the hikashop_product table. That's the query which is failing. Please provide the query so that we can try to understand why it fails.

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242502

Hi Nicolas
is it this you are talking about.

INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) 
  VALUES ( 'test','test-008','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','<p>fgsdfsdgs</p>','1465458642','1465458642','main' )
**Explain**
**EXPLAIN not possible on query: INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) VALUES ( 'test','test-008','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','<p>fgsdfsdgs</p>','1465458642','1465458642','main' )**
**Profile**
**Call Stack**
#	**Caller**	**File and line number**
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
15	JDatabase->query()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1702
14	hikashopClass->save()	JROOT/administrator/components/com_hikashop/classes/product.php:1594
13	hikashopProductClass->save()	JROOT/administrator/components/com_hikashop/classes/product.php:586
12	hikashopProductClass->backSaveForm()	JROOT/administrator/components/com_hikashop/classes/product.php:50
11	hikashopProductClass->saveForm()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1465
10	hikashopController->store()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1401
9	hikashopController->apply()	JROOT/libraries/legacy/controller/legacy.php:728
8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1630
7	hikashopController->execute()	JROOT/administrator/components/com_hikashop/hikashop.php:54
6	require_once JROOT/administrator/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/administrator.php:98
3	JApplicationAdministrator->dispatch()	JROOT/libraries/cms/application/administrator.php:152
2	JApplicationAdministrator->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/administrator/index.php:51
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]


`g4r9h_extensions`

  SET `params` = '{\"mediaversion\":\"dfa3561fe8fe73d4a7c6e2f9abacc38c\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
**Explain**
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where
**Profile**
Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.10 ms
updating	176.41 ms
end	0.05 ms
query end	0.11 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.02 ms
**Call Stack**
#	**Caller**	**File and line number**
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/administrator.php:68
3	JApplicationAdministrator->dispatch()	JROOT/libraries/cms/application/administrator.php:152
2	JApplicationAdministrator->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/administrator/index.php:51

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242506 

57 Queries Logged 10331.60 ms

8 duplicate found!
2 duplicates: #21  #25
2 duplicates: #22  #26
2 duplicates: #47  #49
2 duplicates: #48  #50
Query Time: 7173.37 ms Query memory: 0.028 MB Memory before query: 2.772 MB Rows returned: 1
SELECT `data`

  FROM `g4r9h_session`

  WHERE `session_id` = 'f3f4f62952a5eaa9bd9abbc6562a2837'
Explain
Profile
Call Stack
Query Time: 9.59 ms After last query: 10.19 ms Query memory: 0.016 MB Memory before query: 3.599 MB Rows returned: 74
SELECT folder AS type, element AS name, params

  FROM g4r9h_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2,3,6)

  ORDER BY ordering
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_extensions	ref	extension	extension	82	const	169	100.00	Using index condition; Using where; Using filesort
Profile
Call Stack
Query Time: 4.00 ms After last query: 9.83 ms Query memory: 0.013 MB Memory before query: 4.882 MB Rows returned: 1
SELECT `enabled`

  FROM `g4r9h_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
Explain
Profile
Call Stack
Query Time: 3.58 ms After last query: 7.24 ms Query memory: 0.019 MB Memory before query: 5.674 MB Rows returned: 1
SELECT extension_id AS id, element AS "option", params, enabled

  FROM g4r9h_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 2425.74 ms After last query: 1.22 ms Query memory: 0.012 MB Memory before query: 5.782 MB
UPDATE `g4r9h_extensions`

  SET `params` = '{\"mediaversion\":\"efa09cc633d93ce56c76f3ea409975f8\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
Explain
Profile
Call Stack
Query Time: 3.87 ms After last query: 1.61 ms Query memory: 0.010 MB Memory before query: 5.998 MB Rows returned: 1
SELECT template, s.params

  FROM g4r9h_template_styles as s

  LEFT JOIN g4r9h_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id

  WHERE s.client_id = 1 
  AND home = '1'

  ORDER BY home
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_home	idx_home	28	const	2	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	brianronnow_phimp.s.template,const	1	100.00	Using where
Profile
Call Stack
Query Time: 3.88 ms After last query: 1.48 ms Query memory: 0.017 MB Memory before query: 6.135 MB Rows returned: 33
SELECT extension_id AS id, element AS "option", params, enabled

  FROM g4r9h_extensions

  WHERE `type` = 'component'
Explain
Profile
Call Stack
Query Time: 10.68 ms After last query: 21.23 ms Query memory: 0.027 MB Memory before query: 8.761 MB Rows returned: 320
SELECT * 
  FROM g4r9h_hikashop_config
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	320	100.00	NULL
Profile
Call Stack
Query Time: 505.53 ms After last query: 24.79 ms Query memory: 0.029 MB Memory before query: 11.456 MB Rows returned: 2
SELECT hk_parent.* 
  FROM g4r9h_hikashop_category AS hk_cat  
  LEFT JOIN g4r9h_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (2)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	hk_parent	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where
Profile
Call Stack
Query Time: 5.35 ms After last query: 0.96 ms Query memory: 0.024 MB Memory before query: 11.569 MB Rows returned: 1
SELECT a.id

  FROM g4r9h_user_usergroup_map AS map

  LEFT JOIN g4r9h_usergroups AS a 
  ON a.id = map.group_id

  WHERE map.user_id = 606
Explain
Profile
Call Stack
Query Time: 5.25 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 11.589 MB Rows returned: 1
SELECT * 
  FROM g4r9h_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.field_table='product' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')  
  AND ((((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) 
  AND field_products="") OR (field_products LIKE '%,0,%')) 
  ORDER BY a.`field_ordering` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 4.95 ms After last query: 1.14 ms Query memory: 0.024 MB Memory before query: 11.631 MB Rows returned: 1
SELECT field.* 
  FROM g4r9h_hikashop_field as field 
  WHERE field.field_table = 'product' 
  ORDER BY field.`field_ordering` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 5.83 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 11.655 MB Rows returned: 0
SELECT shipping_id 
  FROM g4r9h_hikashop_shipping 
  WHERE shipping_published=1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 5.74 ms After last query: 2.83 ms Query memory: 0.021 MB Memory before query: 11.963 MB Rows returned: 1
SELECT category_id 
  FROM g4r9h_hikashop_category 
  WHERE category_type='root' 
  LIMIT 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where
Profile
Call Stack
Query Time: 4.24 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 11.983 MB Rows returned: 1
SELECT category_id 
  FROM g4r9h_hikashop_category 
  WHERE category_parent_id=1 
  AND category_type='product' 
  LIMIT 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where
Profile
Call Stack
Query Time: 9.26 ms After last query: 1.72 ms Query memory: 0.019 MB Memory before query: 12.126 MB Rows returned: 2
SELECT product_id 
  FROM g4r9h_hikashop_product 
  WHERE product_alias='test'
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_product	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6168	100.00	Using where
Profile
Call Stack
Query Time: 11.89 ms After last query: 30.15 ms Query memory: 0.028 MB Memory before query: 15.102 MB Rows returned: 0
SELECT * 
  FROM g4r9h_hikashop_massaction 
  WHERE massaction_published=1 && massaction_triggers!=''
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 3.93 ms After last query: 0.60 ms Query memory: 0.020 MB Memory before query: 15.129 MB
INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) 
  VALUES ( 'test','test-009','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','','1465459487','1465459487','main' )
Explain
Profile
Call Stack
Query Time: 8.92 ms After last query: 0.20 ms Query memory: 0.019 MB Memory before query: 15.148 MB Rows returned: 0
SELECT product_id 
  FROM g4r9h_hikashop_product 
  WHERE product_code  = 'test-009' 
  AND NOT (product_id = 0) 
  LIMIT 0, 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_product	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6168	100.00	Using where
Profile
Call Stack
Query Time: 3.09 ms After last query: 36.85 ms Query memory: 0.027 MB Memory before query: 17.534 MB Rows returned: 1
SELECT c.* 
  FROM g4r9h_hikashop_category AS c 
  WHERE c.category_id IN (2)
Explain
Profile
Call Stack
Query Time: 3.77 ms After last query: 3.82 ms Query memory: 0.023 MB Memory before query: 17.825 MB Rows returned: 0
Duplicate queries: #25
SHOW TABLES LIKE 'g4r9h_falang_content'
Explain
Profile
Call Stack
Query Time: 4.53 ms After last query: 0.13 ms Query memory: 0.023 MB Memory before query: 17.847 MB Rows returned: 0
Duplicate queries: #26
SHOW TABLES LIKE 'g4r9h_jf_content'
Explain
Profile
Call Stack
Query Time: 3.49 ms After last query: 0.27 ms Query memory: 0.026 MB Memory before query: 17.871 MB Rows returned: 3
SELECT * 
  FROM g4r9h_hikashop_currency 
  WHERE (currency_published = 1) OR (currency_id IN (47,47))
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_currency	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	181	100.00	Using where
Profile
Call Stack
Query Time: 4.40 ms After last query: 0.63 ms Query memory: 0.029 MB Memory before query: 17.910 MB Rows returned: 1
SELECT * 
  FROM g4r9h_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_display` LIKE '%;field\_product\_form=1;%' 
  AND a.field_table='product' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')  
  AND ((((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) 
  AND field_products="") OR (field_products LIKE '%,0,%')) 
  ORDER BY a.`field_ordering` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 4.41 ms After last query: 3.89 ms Query memory: 0.029 MB Memory before query: 18.299 MB Rows returned: 0
Duplicate queries: #21
SHOW TABLES LIKE 'g4r9h_falang_content'
Explain
Profile
Call Stack
Query Time: 4.54 ms After last query: 0.13 ms Query memory: 0.029 MB Memory before query: 18.327 MB Rows returned: 0
Duplicate queries: #22
SHOW TABLES LIKE 'g4r9h_jf_content'
Explain
Profile
Call Stack
Query Time: 4.40 ms After last query: 0.17 ms Query memory: 0.034 MB Memory before query: 18.360 MB Rows returned: 4
SELECT c.* 
  FROM g4r9h_hikashop_category AS c 
  WHERE c.category_type IN ('product','root','vendor','manufacturer') 
  AND c.category_depth >= 0 
  AND c.category_depth <= 1 
  ORDER BY c.category_parent_id ASC, c.category_ordering 
  LIMIT 0, 200
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 2.99 ms After last query: 0.22 ms Query memory: 0.033 MB Memory before query: 18.412 MB Rows returned: 1
SELECT c.*  
  FROM g4r9h_hikashop_category AS c  
  WHERE c.category_id IN (2)
Explain
Profile
Call Stack
Query Time: 3.09 ms After last query: 0.14 ms Query memory: 0.033 MB Memory before query: 18.425 MB Rows returned: 0
SELECT c.*  
  FROM g4r9h_hikashop_category AS c  
  INNER JOIN g4r9h_hikashop_category AS cp 
  ON (c.category_left <= cp.category_left 
  AND c.category_right >= cp.category_left)  
  WHERE cp.category_id IN (1) 
  AND c.category_id > 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cp	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	394	99.75	Using where
Profile
Call Stack
Query Time: 3.69 ms After last query: 0.68 ms Query memory: 0.033 MB Memory before query: 18.442 MB Rows returned: 0
SELECT c.* 
  FROM g4r9h_hikashop_category AS c 
  WHERE c.category_type IN ('manufacturer') 
  AND c.category_namekey NOT IN ('manufacturer') 
  ORDER BY c.category_name ASC 
  LIMIT 0, 10
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	category_namekey	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 2.84 ms After last query: 8.58 ms Query memory: 0.032 MB Memory before query: 18.980 MB Rows returned: 0
SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft

  FROM g4r9h_tags AS a

  LEFT JOIN `g4r9h_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  WHERE `a`.`lft` > 0 
  AND a.published IN (0,1)

  ORDER BY a.lft ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	tag_idx,idx_left_right	idx_left_right	4	NULL	1	100.00	Using index condition; Using where; Using temporary
1	SIMPLE	b	ALL	idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Range checked for each record (index map: 0x20); Distinct
Profile
Call Stack
Query Time: 3.04 ms After last query: 4.54 ms Query memory: 0.028 MB Memory before query: 19.207 MB Rows returned: 1
SELECT category_id 
  FROM g4r9h_hikashop_category 
  WHERE  category_parent_id=0 
  LIMIT 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where
Profile
Call Stack
Query Time: 4.12 ms After last query: 0.28 ms Query memory: 0.028 MB Memory before query: 19.237 MB Rows returned: 2
SELECT a.category_name,a.category_id,a.category_namekey 
  FROM g4r9h_hikashop_category AS a 
  WHERE (a.category_type = 'tax') 
  AND (a.category_parent_id != 1) 
  AND (a.category_published = 1) 
  ORDER BY a.category_ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 2.64 ms After last query: 0.41 ms Query memory: 0.029 MB Memory before query: 19.267 MB Rows returned: 1
SELECT * 
  FROM g4r9h_hikashop_currency 
  WHERE currency_id IN (47)
Explain
Profile
Call Stack
Query Time: 2.85 ms After last query: 1.36 ms Query memory: 0.032 MB Memory before query: 19.382 MB Rows returned: 9
SELECT a.*, a.title as text, a.id as value 
  FROM `g4r9h_usergroups` AS a 
  ORDER BY a.lft ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using filesort
Profile
Call Stack
Query Time: 3.10 ms After last query: 11.31 ms Query memory: 0.039 MB Memory before query: 20.213 MB Rows returned: 1
SELECT *

  FROM g4r9h_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_wf_profiles	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 4.64 ms After last query: 8.18 ms Query memory: 0.044 MB Memory before query: 20.505 MB Rows returned: 17
SHOW FULL COLUMNS 
  FROM `g4r9h_extensions`
Explain
Profile
Call Stack
Query Time: 5.33 ms After last query: 1.45 ms Query memory: 0.036 MB Memory before query: 20.607 MB Rows returned: 1
SELECT `extension_id`

  FROM `g4r9h_extensions`

  WHERE type = 'component' 
  AND element = 'com_hikashop'
Explain
Profile
Call Stack
Query Time: 3.71 ms After last query: 0.38 ms Query memory: 0.040 MB Memory before query: 20.645 MB Rows returned: 1
SELECT *

  FROM g4r9h_extensions

  WHERE `extension_id` = '10000'
Explain
Profile
Call Stack
Query Time: 3.31 ms After last query: 0.69 ms Query memory: 0.040 MB Memory before query: 20.698 MB Rows returned: 1
SELECT `extension_id`

  FROM `g4r9h_extensions`

  WHERE type = 'plugin' 
  AND folder = 'editors' 
  AND element = 'jce'
Explain
Profile
Call Stack
Query Time: 2.93 ms After last query: 0.34 ms Query memory: 0.044 MB Memory before query: 20.739 MB Rows returned: 1
SELECT *

  FROM g4r9h_extensions

  WHERE `extension_id` = '10124'
Explain
Profile
Call Stack
Query Time: 3.07 ms After last query: 0.39 ms Query memory: 0.040 MB Memory before query: 20.781 MB Rows returned: 1
SELECT `extension_id`

  FROM `g4r9h_extensions`

  WHERE type = 'component' 
  AND element = 'com_jce'
Explain
Profile
Call Stack
Query Time: 3.17 ms After last query: 0.35 ms Query memory: 0.044 MB Memory before query: 20.822 MB Rows returned: 1
SELECT *

  FROM g4r9h_extensions

  WHERE `extension_id` = '10123'
Explain
Profile
Call Stack
Query Time: 2.74 ms After last query: 9.51 ms Query memory: 0.038 MB Memory before query: 21.110 MB Rows returned: 1
SELECT id, template

  FROM g4r9h_template_styles

  WHERE client_id = 0 
  AND home = '1'
Explain
Profile
Call Stack
Query Time: 2.29 ms After last query: 25.29 ms Query memory: 0.028 MB Memory before query: 22.401 MB Rows returned: 0
SELECT warehouse_id, warehouse_name  
  FROM g4r9h_hikashop_warehouse 
  WHERE warehouse_published = 1  
  ORDER BY warehouse_name 
  LIMIT 0, 30
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 2.32 ms After last query: 1.78 ms Query memory: 0.031 MB Memory before query: 22.552 MB Rows returned: 0
SELECT characteristic_value, characteristic_alias, characteristic_id 
  FROM g4r9h_hikashop_characteristic 
  WHERE characteristic_parent_id = 0
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 2.99 ms After last query: 0.77 ms Query memory: 0.034 MB Memory before query: 22.556 MB Rows returned: 4
Duplicate queries: #49
SELECT c.*, 0 as `base_depth` 
  FROM g4r9h_hikashop_category AS c  
  WHERE c.category_type IN ('product','manufacturer','vendor','root') 
  AND c.category_depth >= 0 
  AND c.category_depth <= 1 
  ORDER BY c.category_left ASC, c.category_name ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 3.38 ms After last query: 0.30 ms Query memory: 0.039 MB Memory before query: 22.609 MB Rows returned: 0
Duplicate queries: #50
SELECT p.*, c.category_id 
  FROM g4r9h_hikashop_product AS p  
  INNER JOIN g4r9h_hikashop_product_category AS pc 
  ON p.product_id = pc.product_id 
  INNER JOIN g4r9h_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  WHERE pc.category_id IN (0) 
  ORDER BY c.category_left ASC, c.category_name ASC, p.product_name ASC 
  LIMIT 0, 200
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 2.60 ms After last query: 0.53 ms Query memory: 0.035 MB Memory before query: 22.613 MB Rows returned: 4
Duplicate queries: #47
SELECT c.*, 0 as `base_depth` 
  FROM g4r9h_hikashop_category AS c  
  WHERE c.category_type IN ('product','manufacturer','vendor','root') 
  AND c.category_depth >= 0 
  AND c.category_depth <= 1 
  ORDER BY c.category_left ASC, c.category_name ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	394	100.00	Using where; Using filesort
Profile
Call Stack
Query Time: 3.38 ms After last query: 0.25 ms Query memory: 0.039 MB Memory before query: 22.667 MB Rows returned: 0
Duplicate queries: #48
SELECT p.*, c.category_id 
  FROM g4r9h_hikashop_product AS p  
  INNER JOIN g4r9h_hikashop_product_category AS pc 
  ON p.product_id = pc.product_id 
  INNER JOIN g4r9h_hikashop_category AS c 
  ON c.category_id = pc.category_id 
  WHERE pc.category_id IN (0) 
  ORDER BY c.category_left ASC, c.category_name ASC, p.product_name ASC 
  LIMIT 0, 200
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 2.48 ms After last query: 3.82 ms Query memory: 0.033 MB Memory before query: 22.725 MB Rows returned: 9
SELECT a.*, a.title as text, a.id as value  
  FROM g4r9h_usergroups AS a 
  ORDER BY a.lft ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using filesort
Profile
Call Stack
Query Time: 2.60 ms After last query: 0.55 ms Query memory: 0.036 MB Memory before query: 22.763 MB Rows returned: 0
SELECT b.*, a.*, c.currency_symbol 
  FROM g4r9h_hikashop_shipping AS a  
  LEFT JOIN g4r9h_hikashop_shipping_price AS b 
  ON a.shipping_id = b.shipping_id 
  AND b.shipping_price_ref_id = 0 
  INNER JOIN g4r9h_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id  
  WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%')  
  AND (b.shipping_price_ref_id IS NULL OR (b.shipping_price_ref_id = 0 
  AND b.shipping_price_ref_type = 'product')) 
  ORDER BY a.shipping_id, b.shipping_price_min_quantity
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 3.15 ms After last query: 4.55 ms Query memory: 0.019 MB Memory before query: 22.794 MB Rows returned: 11
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM g4r9h_modules AS m

  LEFT JOIN g4r9h_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN g4r9h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2016-06-09 08:04:47') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-06-09 08:04:47') 
  AND m.access IN (1,1,2,3,6) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	25	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	brianronnow_phimp.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	brianronnow_phimp.m.module,const	1	100.00	Using index condition; Using where
Profile
Call Stack
Query Time: 2.54 ms After last query: 5.55 ms Query memory: 0.017 MB Memory before query: 22.943 MB Rows returned: 1
SELECT COUNT(*)

  FROM g4r9h_messages

  WHERE state = 0 
  AND user_id_to = 606
Explain
Profile
Call Stack
Query Time: 3.17 ms After last query: 0.18 ms Query memory: 0.017 MB Memory before query: 22.961 MB Rows returned: 1
SELECT COUNT(session_id)

  FROM g4r9h_session

  WHERE guest = 0 
  AND client_id = 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
Profile
Call Stack
Query Time: 2.31 ms After last query: 0.24 ms Query memory: 0.017 MB Memory before query: 22.977 MB Rows returned: 1
SELECT COUNT(session_id)

  FROM g4r9h_session

  WHERE guest = 0 
  AND client_id = 0
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	g4r9h_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
Profile
Call Stack
Query Time: 2.90 ms After last query: 13.55 ms Query memory: 0.024 MB Memory before query: 23.258 MB Rows returned: 34
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

  FROM g4r9h_menu AS m

  LEFT JOIN g4r9h_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1

  ORDER BY m.lft
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid	idx_client_id_parent_id_alias_language	1	const	34	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	brianronnow_phimp.m.component_id	1	100.00	Using where
Profile
Call Stack
40 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × SELECT c.* 
  FROM g4r9h_hikashop_category AS c
3 × SELECT category_id 
  FROM g4r9h_hikashop_category
3 × SELECT * 
  FROM g4r9h_extensions
3 × SELECT `extension_id` 
  FROM `g4r9h_extensions`
2 × SELECT c.*, 0 as `base_depth` 
  FROM g4r9h_hikashop_category AS c
2 × SELECT * 
  FROM g4r9h_hikashop_currency
2 × SELECT * 
  FROM g4r9h_hikashop_field as a
2 × SELECT product_id 
  FROM g4r9h_hikashop_product
2 × SELECT p.*, c.category_id 
  FROM g4r9h_hikashop_product AS p  
  INNER JOIN g4r9h_hikashop_product_category AS pc 
  ON p.product_id = pc.product_id 
  INNER JOIN g4r9h_hikashop_category AS c 
  ON c.category_id = pc.category_id
2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM g4r9h_extensions
2 × SELECT COUNT(session_id) 
  FROM g4r9h_session
1 × SELECT warehouse_id, warehouse_name  
  FROM g4r9h_hikashop_warehouse
1 × SELECT id, template 
  FROM g4r9h_template_styles
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM g4r9h_menu AS m 
  LEFT JOIN g4r9h_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT COUNT(*) 
  FROM g4r9h_messages
1 × SELECT a.*, a.title as text, a.id as value  
  FROM g4r9h_usergroups AS a
1 × SELECT b.*, a.*, c.currency_symbol 
  FROM g4r9h_hikashop_shipping AS a  
  LEFT JOIN g4r9h_hikashop_shipping_price AS b 
  ON a.shipping_id = b.shipping_id 
  AND b.shipping_price_ref_id = 0 
  INNER JOIN g4r9h_hikashop_currency AS c 
  ON c.currency_id = a.shipping_currency_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM g4r9h_modules AS m 
  LEFT JOIN g4r9h_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN g4r9h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT characteristic_value, characteristic_alias, characteristic_id 
  FROM g4r9h_hikashop_characteristic
1 × SELECT * 
  FROM g4r9h_wf_profiles
1 × SELECT c.*  
  FROM g4r9h_hikashop_category AS c  
  INNER JOIN g4r9h_hikashop_category AS cp 
  ON (c.category_left <= cp.category_left 
  AND c.category_right >= cp.category_left)
1 × SELECT hk_parent.* 
  FROM g4r9h_hikashop_category AS hk_cat  
  LEFT JOIN g4r9h_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)
1 × SELECT a.id 
  FROM g4r9h_user_usergroup_map AS map 
  LEFT JOIN g4r9h_usergroups AS a 
  ON a.id = map.group_id
1 × SELECT * 
  FROM g4r9h_hikashop_confi
1 × SELECT template, s.params 
  FROM g4r9h_template_styles as s 
  LEFT JOIN g4r9h_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT folder AS type, element AS name, params 
  FROM g4r9h_extensions
1 × SELECT `enabled` 
  FROM `g4r9h_extensions`
1 × SELECT field.* 
  FROM g4r9h_hikashop_field as field
1 × SELECT shipping_id 
  FROM g4r9h_hikashop_shipping
1 × SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft 
  FROM g4r9h_tags AS a 
  LEFT JOIN `g4r9h_tags` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt
1 × SELECT a.category_name,a.category_id,a.category_namekey 
  FROM g4r9h_hikashop_category AS a
1 × SELECT `data` 
  FROM `g4r9h_session`
1 × SELECT c.*  
[code]  FROM g4r9h_hikashop_category AS c
1 × SELECT * 
  FROM g4r9h_hikashop_massaction
1 × SELECT a.*, a.title as text, a.id as value 
  FROM `g4r9h_usergroups` AS a
OTHER Tables:
2 × SHOW TABLES LIKE 'g4r9h_jf_content
2 × SHOW TABLES LIKE 'g4r9h_falang_content
1 × SHOW FULL COLUMNS 
  FROM `g4r9h_extensions
1 × INSERT IGNORE INTO `g4r9h_hikashop_product` ( `product_name`,`product_code`,`product_quantity`,`product_manufacturer_id`,`product_published`,`product_tax_id`,`product_msrp`,`product_page_title`,`product_url`,`product_meta_description`,`product_keywords`,`product_alias`,`product_canonical`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_access`,`product_warehouse_id`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_height`,`product_dimension_unit`,`product_layout`,`product_quantity_layout`,`beskrivelse`,`product_group_after_purchase`,`product_id`,`product_description`,`product_modified`,`product_created`,`product_type` ) 
  VALUES ( 'test','test-009','-1','','1','488','','','','','','test','','0','0','','','all','','','kg','','','','m','','','','','0','','1465459487','1465459487','main'
1 × UPDATE `g4r9h_extensions` 
  SET `params` = '{\"mediaversion\":\"efa09cc633d93ce56c76f3ea409975f8\"}'

Best regards
Brian
Last edit: 9 years 3 months ago by nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 3 months ago #242532

Hi,

As far as I can see the problem is that the product code "test" is already used by another product.
Can you try with a new product code that you're sure is not being used by any product ?

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242627

Hi

It is new products, i have tried to make new producs,
Both test products is made as new.

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
9 years 3 months ago #242647

Hi,

Stumbling over this, I see this line in your original post:

Nowweb wrote: I have tried to find the product in the database table _hikashop_product, and deleted it.


Reads like you deleted the product not by using the perfectly well working "delete" function in the HikaShop backend, but by deleting one row in one table directly in the database.

If that's true, I suspect that's the root cause of your problem. Nicolas might be able and willing to tell you more details for your case, but generally it's always risky to mess around in the database directly unless you know exactly what you're doing.

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )
Last edit: 9 years 3 months ago by lousyfool.

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242653

I have tried to delete the files in the database.

That did i do after,
my client made an product, deleted it again.
Then he would have the product again, this the same name and product code (it is a number).
Then all the troubles began.

hope to find the solution very soon.

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242655

I can provide access to the website, if you like ?

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242671

I have seen that the ID i missing


and if i try to edit the product, the content is missing.

Best regards
Brian
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 26274
  • Thank you received: 4045
  • MODERATOR
9 years 3 months ago #242685

Hi,

It looks like you altered the HikaSho product table and that you removed the "auto increment" on the "product_id" field.
So when HikaShop ask for a product insertion, no "id" is provided by the database, "0" is used but the product with ID "0" already exists.
And that's not something which could be possible knowing that HikaShop set the autoincrement and that the ID cannot be under "1".

Regards;

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 145
  • Thank you received: 1
9 years 3 months ago #242956

Yes i have been there to set all product prices to view only in registred mode.
I have not changes anything else.

How do i get it back to normal, without any loss of products?

I am open for suggestions.

Best regards
Brian

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 3 months ago #243000

Hi,

It's simple. Go in your PHPMyAdmin and:
- set a unique product_id for each products in the hikashop_product table.
- activate again the "auto_increment" feature in the hikashop_product table.

The following user(s) said Thank You: Nowweb

Please Log in or Create an account to join the conversation.

Time to create page: 0.143 seconds
Powered by Kunena Forum