[Skip to main content](#vessel-content) # Error saving product ## - **[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")** - [![bryantj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1625-bryantj "View bryantj's Profile") Topic Author - [ Offline](/forum/user/1625-bryantj) Less More - Posts: 4 - Thank you received: 0 - - 15 years 7 months ago [\#12103](#12103) by [bryantj](/forum/user/1625-bryantj "View bryantj's Profile") *[Error saving product](/forum/3-bug-report/12103-error-saving-product#12103 "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")* was created by *[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")* 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 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 7 months ago [\#12110](#12110) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12110 "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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")** - [![bryantj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1625-bryantj "View bryantj's Profile") Topic Author - [ Offline](/forum/user/1625-bryantj) Less More - Posts: 4 - Thank you received: 0 - - 15 years 7 months ago - 15 years 7 months ago [\#12115](#12115) by [bryantj](/forum/user/1625-bryantj "View bryantj's Profile") Replied by *[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12115 "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](/smile3.gif ":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](/smile3.gif ":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](/smile3.gif ":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](/smile3.gif ":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](/smile3.gif ":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](/smile3.gif ":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 Last edit: 15 years 7 months ago by [bryantj](/forum/user/1625-bryantj "View bryantj's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 7 months ago - 15 years 7 months ago [\#12117](#12117) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12117 "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")* 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. Last edit: 15 years 7 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")** - [![bryantj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1625-bryantj "View bryantj's Profile") Topic Author - [ Offline](/forum/user/1625-bryantj) Less More - Posts: 4 - Thank you received: 0 - - 15 years 7 months ago [\#12118](#12118) by [bryantj](/forum/user/1625-bryantj "View bryantj's Profile") Replied by *[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12118 "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")* 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? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 15 years 7 months ago [\#12120](#12120) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12120 "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")* 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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")** - [![bryantj's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1625-bryantj "View bryantj's Profile") Topic Author - [ Offline](/forum/user/1625-bryantj) Less More - Posts: 4 - Thank you received: 0 - - 15 years 7 months ago [\#12213](#12213) by [bryantj](/forum/user/1625-bryantj "View bryantj's Profile") Replied by *[bryantj](/forum/user/1625-bryantj "View bryantj's Profile")* on topic *[Re: Error saving product](/forum/3-bug-report/12103-error-saving-product#12213 "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")* thank you!! solved! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC8xMjEwMy1lcnJvci1zYXZpbmctcHJvZHVjdD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.065 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)