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

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\":3:{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\":3:{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

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?

thank you!! solved!