Error saving product

I'm in a real pinch.

I am using Joomla 1.6 and was able to create a product before and put it in a category that I made.

But I went to edit the photo and changed it, it was actually added with the other photo so I deleted the image and saved. Then it gave me an error that says "Error saving", so I couldnt save it and deleted the product to start a new one. Now I can't even save a NEW product! It still gives me the same error!

Is there a way to reset the database for Hikashop or fix this problem? In a big hurry so I need help badly!

Thanks in advance.

JB

Could you activate the debug mode in the joomla configuration page and try again ?

That should display a better error message which will help us understand why that happens.

Yes here is the error(s) it produced...

500 - **An error has occurred.**

JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'TEST PRODUCT','','','','product0000001','','','','0','-1','0','0','','kg','','','m','','1','all','','main','0','','1301060509','1301060509' )

**Return to Control Panel**

Call stack
# Function Location
1 JAdministrator->dispatch() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/index.php:47
2 JComponentHelper::renderComponent() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/includes/application.php:154
3 require_once() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/application/component/helper.php:152
4 JController->execute() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/admin.hikashop.php:47
5 hikashopController->apply() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/application/component/controller.php:649
6 hikashopController->store() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:639
7 hikashopProductClass->saveForm() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:694
8 hikashopProductClass->save() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/classes/product.php:127
9 hikashopClass->save() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/classes/product.php:303
10 JDatabaseMySQLi->query() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:775
11 JError::raiseError() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/database/database/mysqli.php:230
12 JError::raise() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/error/error.php:179
**Errors**

1. JDatabaseMySQL::query: 1054 - Unknown column 'product_contact' in 'field list' SQL=INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'TEST PRODUCT','','','','product0000001','','','','0','-1','0','0','','kg','','','m','','1','all','','main','0','','1301060509','1301060509' )
**Information**


**Backtrace**
Call stack
# Function Location
1 JAdministrator->dispatch() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/index.php:47
2 JComponentHelper::renderComponent() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/includes/application.php:154
3 require_once() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/application/component/helper.php:152
4 JController->execute() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/admin.hikashop.php:47
5 hikashopController->apply() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/application/component/controller.php:649
6 hikashopController->store() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:639
7 hikashopProductClass->saveForm() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:694
8 hikashopProductClass->save() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/classes/product.php:127
9 hikashopClass->save() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/classes/product.php:303
10 JDatabaseMySQLi->query() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/helpers/helper.php:775
11 JError::raiseError() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/database/database/mysqli.php:230
12 JError::raise() /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/libraries/joomla/error/error.php:179

**Profile Information**
Application 0.001 seconds (+0.001); 0.34 MB (+0.34) - afterLoad
Application 0.066 seconds (+0.065); 3.17 MB (+2.82) - afterInitialise
Application 0.066 seconds (+0.000); 3.17 MB (+0.00) - afterRoute
**Memory Usage**
5.63 MB (5,902,316 Bytes)
**12 Queries Logged**

1. SELECT `data`
FROM `jos_session`
WHERE `session_id` = '41eb3994f60e9d63ce50f90642afba30'
2. DELETE
FROM `jos_session`
WHERE `time` < 1301059609
3. SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
4. SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
5. SELECT template, params
FROM jos_template_styles
WHERE client_id = 1
AND home = 1
6. SELECT extension_id AS "id", element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_hikashop'
7. SELECT *
FROM jos_hikashop_config
8. SELECT *
FROM jos_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_backend` = 1
AND a.field_table='product'
ORDER BY a.`field_ordering` ASC
9. SELECT category_id
FROM jos_hikashop_category
WHERE category_type='root'
LIMIT 1
10. SELECT category_id
FROM jos_hikashop_category
WHERE category_parent_id=1
AND category_type='product'
LIMIT 1
11. INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` )
VALUES ( 'TEST PRODUCT','','','','product0000001','','','','0','-1','0','0','','kg','','','m','','1','all','','main','0','','1301060509','1301060509' )
12. UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1301060088;s:18:\"session.timer.last\";i:1301060499;s:17:\"session.timer.now\";i:1301060509;s:22:\"session.client.browser\";s:122:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0C)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:1:\"2\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:10:\"limitstart\";i:0;s:11:\"filter_type\";i:0;}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:7:\"topmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:1:{i:0;i:144;}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:8:\"admin-st\";s:5:\"email\";s:23:\"xxx@xxx.xxx\";s:8:\"password\";s:65:\"12158e85c9065db66a351c614ad2ab80:ObEFLm6lopNmn01LWx7dgDxi9fY8FeHj\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-03-17 07:15:08\";s:13:\"lastvisitDate\";s:19:\"2011-03-25 12:08:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"6f36a95be0485ce70798815b893a6658\";}hikashop|a:1:{s:2:\"li\";b:1;}hikashop_product_data|O:8:\"stdClass\":33:{s:12:\"product_name\";s:12:\"TEST PRODUCT\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:14:\"product0000001\";s:14:\"product_tax_id\";s:0:\"\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:15:\"product_contact\";s:1:\"0\";s:16:\"product_quantity\";i:-1;s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:0:\"\";s:19:\"product_weight_unit\";s:2:\"kg\";s:14:\"product_length\";s:0:\"\";s:13:\"product_width\";s:0:\"\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:0:\"\";s:17:\"product_published\";s:1:\"1\";s:14:\"product_access\";s:3:\"all\";s:28:\"product_group_after_purchase\";s:0:\"\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:0;s:10:\"categories\";a:1:{i:0;i:2;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:3;s:18:\"price_min_quantity\";i:0;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:3;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:0:\"\";s:16:\"product_modified\";i:1301060509;s:15:\"product_created\";i:1301060509;}', `time` = 1301060509
WHERE `session_id` = '41eb3994f60e9d63ce50f90642afba30'

**10 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**

1. **2 × SELECT category_id FROM jos_hikashop_category**
2. **2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions**
3. **1 × SELECT * FROM jos_hikashop_field as a**
4. **1 × SELECT * FROM jos_hikashop_confi**
5. **1 × SELECT template, params FROM jos_template_styles**
6. **1 × SELECT folder AS type, element AS name, params FROM jos_extensions**
7. **1 × SELECT `data` FROM `jos_session`**

**OTHER Tables:**

1. **1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:31;s:19:\"session.timer.start\";i:1301060088;s:18:\"session.timer.last\";i:1301060499;s:17:\"session.timer.now\";i:1301060509;s:22:\"session.client.browser\";s:122:\"Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.16) Gecko/20110319 Firefox/3.6.16 ( .NET CLR 3.5.30729; .NET4.0C)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:1:\"2\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:6:\"search\";s:0:\"\";s:10:\"list_limit\";i:20;s:10:\"limitstart\";i:0;s:11:\"filter_type\";i:0;}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:7:\"topmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:1:{i:0;i:144;}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:8:\"admin-st\";s:5:\"email\";s:23:\"xxx@xxx.xxx\";s:8:\"password\";s:65:\"12158e85c9065db66a351c614ad2ab80:ObEFLm6lopNmn01LWx7dgDxi9fY8FeHj\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-03-17 07:15:08\";s:13:\"lastvisitDate\";s:19:\"2011-03-25 12:08:28\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"6f36a95be0485ce70798815b893a6658\";}hikashop|a:1:{s:2:\"li\";b:1;}hikashop_product_data|O:8:\"stdClass\":33:{s:12:\"product_name\";s:12:\"TEST PRODUCT\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:12:\"product_code\";s:14:\"product0000001\";s:14:\"product_tax_id\";s:0:\"\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:15:\"product_contact\";s:1:\"0\";s:16:\"product_quantity\";i:-1;s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";i:0;s:14:\"product_weight\";s:0:\"\";s:19:\"product_weight_unit\";s:2:\"kg\";s:14:\"product_length\";s:0:\"\";s:13:\"product_width\";s:0:\"\";s:22:\"product_dimension_unit\";s:1:\"m\";s:14:\"product_height\";s:0:\"\";s:17:\"product_published\";s:1:\"1\";s:14:\"product_access\";s:3:\"all\";s:28:\"product_group_after_purchase\";s:0:\"\";s:12:\"product_type\";s:4:\"main\";s:10:\"product_id\";i:0;s:10:\"categories\";a:1:{i:0;i:2;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:6:\"prices\";a:2:{i:0;O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:3;s:18:\"price_min_quantity\";i:0;}s:2:\"##\";O:8:\"stdClass\":3:{s:11:\"price_value\";d:0;s:17:\"price_currency_id\";i:3;s:18:\"price_min_quantity\";i:0;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:0:\"\";s:16:\"product_modified\";i:1301060509;s:15:\"product_created\";i:1301060509;}', `time` = 1301060509**
2. **1 × INSERT IGNORE INTO `jos_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_code`,`product_tax_id`,`product_sale_start`,`product_sale_end`,`product_contact`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_weight`,`product_weight_unit`,`product_length`,`product_width`,`product_dimension_unit`,`product_height`,`product_published`,`product_access`,`product_group_after_purchase`,`product_type`,`product_id`,`product_description`,`product_modified`,`product_created` ) VALUES ( 'TEST PRODUCT','','','','product0000001','','','','0','-1','0','0','','kg','','','m','','1','all','','main','0','','1301060509','1301060509'**
3. **1 × DELETE FROM `jos_session`**

**Parsing errors in language files**

* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/language/en-GB/en-GB.com_hikashop.ini : error(s) in line(s) 1, 1101

**Language Files Loaded**

* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/language/en-GB/en-GB.ini 1
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/language/en-GB/en-GB.lib_joomla.ini 1
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/language/en-GB/en-GB.tpl_bluestork.ini 1
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/language/en-GB/en-GB.com_hikashop.ini
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/components/com_hikashop/language/en-GB/en-GB.com_hikashop.ini
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/language/en-GB/en-GB.com_hikashop.ini 1
* /export/sd201/www/jp/r/e/gmoserver/7/8/sd0177078/shou-ten.com/administrator/language/en-GB/en-GB.plg_system_debug.ini 1

The problem is that you're missing the column product_contact in the table hikashop_product. That column was added in version 1.4.5 of hikashop but you had a problem during the install/update process which prevented hikashop from setting up the structure of your tables.
The simplest solution will be to go in phpmyadmin and edit the table hikashop_config. In it, search for the namekey "version" and set it to "1.4.4". Then, download the latest version of hikashop and install it over your current version. That way, during the install, hikashop will try again to update the structure of your tables and if that succeed the error will disappear.

I was using 1.4.7 and upgraded to 1.4.8 actually.
How do I access phpmyadmin from joomla 1.6? I used a plugin in Joomla 1.5?

phpmyadmin is a software enabling you to manage your database. Every hosting company provides but it's not in joomla. You should ask your hosting company on how to access it.

thank you!! solved!