Skip to main content

Error saving

More
11 years 5 months ago - 11 years 5 months ago #199966 by Joomill
Error saving was created by Joomill
-- 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
Code:
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: 11 years 5 months ago by Jerome. Reason: [code] is nice

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

More
11 years 5 months ago #199994 by nicolas
Replied by nicolas on topic Error saving
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.

More
11 years 5 months ago - 11 years 5 months ago #200035 by Joomill
Replied by Joomill on topic Error saving
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: 11 years 5 months ago by Joomill.

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

More
11 years 5 months ago #200040 by Joomill
Replied by Joomill on topic Error saving
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.160 seconds
Powered by Kunena Forum