Error saving

  • Posts: 200
  • Thank you received: 9
  • Hikashop Multisite
8 years 11 months ago #199966

-- HikaShop version -- : HikaShop Business: 2.4.0
-- Joomla version -- : 3.4.1
-- PHP version -- : 5.5.17
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : Error
Error Saving

When i would like to add a product i see "Error saving"
I have enabled debug and log message added below.
The product-category is empty after saving. I can send you the login when you need.

Thanks in advance!
Jeroen

DEBUG - databasequery
SELECT extension_id AS id, element AS "option", params, enabled FROM smrt2_extensions WHERE `type` = 'library' AND `element` = 'joomla'

DEBUG - databasequery
UPDATE `smrt2_extensions` SET `params` = '{\"mediaversion\":\"35efc94ba952809c98ef823738fc4d40\"}' WHERE `type` = 'library' AND `element` = 'joomla'

DEBUG - databasequery
SELECT template, s.params FROM smrt2_template_styles as s LEFT JOIN smrt2_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

DEBUG - databasequery
SELECT * FROM smrt2_hikashop_config

WARNING - deprecated
JRequest is deprecated.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JApplication is deprecated.

DEBUG - databasequery
SELECT b.* FROM smrt2_hikashop_category AS a LEFT JOIN smrt2_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (2) GROUP BY b.category_id ORDER BY b.category_left

DEBUG - databasequery
SELECT a.id FROM smrt2_user_usergroup_map AS map LEFT JOIN smrt2_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 645

DEBUG - databasequery
SELECT * FROM smrt2_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_backend` = 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

DEBUG - databasequery
SELECT * FROM smrt2_hikashop_massaction WHERE massaction_published=1 && massaction_triggers!=''

WARNING - deprecated
JDatabase::query() is deprecated, use JDatabaseDriver::execute() instead.

DEBUG - databasequery
INSERT IGNORE INTO `smrt2_hikashop_product` ( `product_name`,`product_url`,`product_meta_description`,`product_keywords`,`product_page_title`,`product_alias`,`product_canonical`,`product_code`,`product_tax_id`,`product_manufacturer_id`,`product_layout`,`product_quantity_layout`,`product_quantity`,`product_min_per_order`,`product_max_per_order`,`product_sale_start`,`product_sale_end`,`product_msrp`,`product_warehouse_id`,`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_description`,`product_modified`,`product_created` ) VALUES ( 'test','','','','','test','','test','38','0','','','-1','0','0','','','','','','kg','','','m','','1','all','','main','','1430039174','1430039174' )

DEBUG - databasequery
SELECT product_id FROM smrt2_hikashop_product WHERE product_code = 'test' LIMIT 1

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JFactory::getEditor is deprecated. Use JEditor directly.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

DEBUG - databasequery
SELECT * FROM smrt2_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

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

WARNING - deprecated
JViewLegacy::assignRef is deprecated. Use native PHP syntax.

DEBUG - databasequery
SELECT * FROM smrt2_wf_profiles WHERE published = 1 ORDER BY ordering ASC

DEBUG - databasequery
SHOW FULL COLUMNS FROM `smrt2_extensions`

DEBUG - databasequery
SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'component' AND element = 'com_hikashop'

DEBUG - databasequery
SELECT * FROM smrt2_extensions WHERE `extension_id` = '10014'

DEBUG - databasequery
SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'plugin' AND folder = 'editors' AND element = 'jce'

DEBUG - databasequery
SELECT * FROM smrt2_extensions WHERE `extension_id` = '10135'

DEBUG - databasequery
SELECT `extension_id` FROM `smrt2_extensions` WHERE type = 'component' AND element = 'com_jce'

DEBUG - databasequery
SELECT * FROM smrt2_extensions WHERE `extension_id` = '10134'

DEBUG - databasequery
SELECT id, template FROM smrt2_template_styles WHERE client_id = 0 AND home = '1'

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

DEBUG - databasequery
SELECT DISTINCT a.id AS value, a.path, a.title AS text, a.level, a.published, a.lft FROM smrt2_tags AS a LEFT JOIN `smrt2_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

DEBUG - databasequery
SELECT category_id FROM smrt2_hikashop_category WHERE category_parent_id=0 LIMIT 1

DEBUG - databasequery
SELECT a.category_name,a.category_id,a.category_namekey FROM smrt2_hikashop_category AS a WHERE a.category_type = 'tax' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC

DEBUG - databasequery
SELECT category_id FROM smrt2_hikashop_category WHERE category_parent_id=0 LIMIT 1

DEBUG - databasequery
SELECT a.category_name,a.category_id,a.category_namekey FROM smrt2_hikashop_category AS a WHERE a.category_type = 'manufacturer' AND a.category_parent_id!=1 ORDER BY a.category_ordering ASC

WARNING - deprecated
JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead.

WARNING - deprecated
JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead.

WARNING - deprecated
JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead.

WARNING - deprecated
JHtmlSelect::optgroup() is deprecated, use JHtmlSelect::groupedList() instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

DEBUG - databasequery
SELECT * FROM smrt2_hikashop_currency WHERE currency_id IN (1)

WARNING - deprecated
JFactory::getACL is deprecated. Use JAccess directly.

DEBUG - databasequery
SELECT a.*, a.title as text, a.id as value FROM smrt2_usergroups AS a ORDER BY a.lft ASC

WARNING - deprecated
JFactory::getACL is deprecated. Use JAccess directly.

DEBUG - databasequery
SELECT a.*, a.title as text, a.id as value FROM smrt2_usergroups AS a ORDER BY a.lft ASC

DEBUG - databasequery
SELECT * FROM smrt2_hikashop_currency WHERE currency_published=1 OR currency_id IN ('1','1')

DEBUG - databasequery
SELECT b.*, a.*, c.currency_symbol FROM smrt2_hikashop_shipping AS a LEFT JOIN smrt2_hikashop_shipping_price AS b ON a.shipping_id = b.shipping_id AND b.shipping_price_ref_id = 0 INNER JOIN smrt2_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\"%' 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

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

DEBUG - databasequery
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM smrt2_modules AS m LEFT JOIN smrt2_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN smrt2_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 <= '2015-04-26 09:06:14') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2015-04-26 09:06:14') 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

WARNING - deprecated
JSubMenuHelper::getEntries() is deprecated. Use JHtmlSidebar::getEntries() instead.

WARNING - deprecated
JSubMenuHelper::getFilters() is deprecated. Use JHtmlSidebar::getFilters() instead.

WARNING - deprecated
JSubMenuHelper::getAction() is deprecated. Use JHtmlSidebar::getAction() instead.

DEBUG - databasequery
SELECT COUNT(*) FROM smrt2_messages WHERE state = 0 AND user_id_to = 645

DEBUG - databasequery
SELECT COUNT(session_id) FROM smrt2_session WHERE guest = 0 AND client_id = 1

DEBUG - databasequery
SELECT COUNT(session_id) FROM smrt2_session WHERE guest = 0 AND client_id = 0

WARNING - deprecated
JButton is deprecated. Use JToolbarButton instead.

DEBUG - databasequery
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element FROM smrt2_menu AS m LEFT JOIN smrt2_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

WARNING - deprecated
This method is typehinted to be an array in \Joomla\Utilities\ArrayHelper::toString.

WARNING - deprecated
JResponse is deprecated.

DEBUG - databasequery
UPDATE `smrt2_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:23;s:19:\"session.timer.start\";i:1430037924;s:18:\"session.timer.last\";i:1430039167;s:17:\"session.timer.now\";i:1430039174;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (Windows NT 6.3; WOW64; rv:37.0) Gecko/20100101 Firefox/37.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":28:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"645\";s:4:\"name\";s:10:\"Super User\";s:8:\"username\";s:7:\"Joomill\";s:5:\"email\";s:15:\"info@joomill.nl\";s:8:\"password\";s:60:\"$2y$10$rrHceO0XIOaO0frNQq.XquOvaHwiOHTGfPBviQ43bft4OvyhirF6m\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2015-04-17 13:11:36\";s:13:\"lastvisitDate\";s:19:\"2015-04-26 07:39:15\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:0:\"\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"a368232f4345ac7f3a625c68e9ca66cf\";}__wf|a:1:{s:13:\"session.token\";s:32:\"f208c8951e8fac89f36d362711279cf8\";}hikashop_product_data|O:8:\"stdClass\":40:{s:12:\"product_name\";s:4:\"test\";s:11:\"product_url\";s:0:\"\";s:24:\"product_meta_description\";s:0:\"\";s:16:\"product_keywords\";s:0:\"\";s:18:\"product_page_title\";s:0:\"\";s:13:\"product_alias\";s:4:\"test\";s:17:\"product_canonical\";s:0:\"\";s:12:\"product_code\";s:4:\"test\";s:14:\"product_tax_id\";s:2:\"38\";s:23:\"product_manufacturer_id\";s:1:\"0\";s:14:\"product_layout\";s:0:\"\";s:23:\"product_quantity_layout\";s:0:\"\";s:16:\"product_quantity\";s:9:\"Unlimited\";s:21:\"product_min_per_order\";s:1:\"0\";s:21:\"product_max_per_order\";s:9:\"Unlimited\";s:18:\"product_sale_start\";s:0:\"\";s:16:\"product_sale_end\";s:0:\"\";s:12:\"product_msrp\";s:0:\"\";s:20:\"product_warehouse_id\";s: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:\"categories\";a:2:{i:2;i:2;i:0;N;}s:7:\"related\";a:0:{}s:7:\"options\";a:0:{}s:6:\"images\";a:0:{}s:5:\"files\";a:0:{}s:11:\"imagesorder\";a:0:{}s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":4:{s:11:\"price_value\";i:0;s:20:\"price_value_with_tax\";i:0;s:17:\"price_currency_id\";s:1:\"1\";s:18:\"price_min_quantity\";i:1;}}s:18:\"oldCharacteristics\";a:0:{}s:19:\"product_description\";s:0:\"\";s:16:\"product_modified\";i:1430039174;s:15:\"product_created\";i:1430039174;}' , `time` = '1430039174' WHERE `session_id` = 'jdu3ahcnk0j1aur4c49nst0u24'

WARNING - deprecated
JError::getErrors() is deprecated.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

WARNING - deprecated
JHtml::getJSObject is deprecated. Use json_encode instead.

Last edit: 8 years 11 months ago by Jerome. Reason: [code] is nice

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

  • Posts: 81515
  • Thank you received: 13069
  • MODERATOR
8 years 11 months ago #199994

Hi,

Click on the "check database" button of the HikaShop configuration and see if that helps.
Also, make sure that you provide a product code and that it is unique before saving your new product.

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

  • Posts: 200
  • Thank you received: 9
  • Hikashop Multisite
8 years 11 months ago #200035

Hi Nicolas,

Thanks for your answer.

The Check database says everything is ok.
And even with a unique code, the product is not being saved.

I found another error, maybe it has something to do with:
When i click the export button:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,,,,,,,)' at line 1 SQL=SELECT * FROM smrt2_hikashop_product_related AS a WHERE a.product_id IN (,,,,,,,,,,,,,,,,,,,,,,,)

Do you have other sugesstions what i can do?
Kind regards

Last edit: 8 years 11 months ago by Joomill.

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

  • Posts: 200
  • Thank you received: 9
  • Hikashop Multisite
8 years 11 months ago #200040

I Found the problem:

In the table _hikashop_product all columns a INT3 and the Auto Increment was missing.
I changed it to the values from another Hikashop installation and now everything works again..

Thanks and this thread can be closed.
Jeroen

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

Time to create page: 0.073 seconds
Powered by Kunena Forum