[Skip to main content](#vessel-content) # Error 1064 after saving a characteristic ## - **[JasonV](/forum/user/34561-jasonv "View JasonV's Profile")** - [![JasonV's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34561-jasonv "View JasonV's Profile") Topic Author - [ Offline](/forum/user/34561-jasonv) Less More - Posts: 10 - Thank you received: 0 - - 11 years 9 months ago [\#187987](#187987) by [JasonV](/forum/user/34561-jasonv "View JasonV's Profile") *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#187987 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* was created by *[JasonV](/forum/user/34561-jasonv "View JasonV's Profile")* -- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS c_product_code, p.product_id, 1422022486, 1422022486, 0, 0, product_name, p' at line 1 SQL=INSERT IGNORE INTO rwos3_hikashop_product (product_code, product_parent_id, product_created, product_modified, product_hit, product_last_seen_date, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout, screensize, os, bluetooth, ram, public, genre) SELECT CONCAT(p.product_code, '_', ) AS c_product_code, p.product_id, 1422022486, 1422022486, 0, 0, product_name, product_description, product_quantity, product_published, product_sale_start, product_sale_end, product_delay_id, product_tax_id, product_type, product_vendor_id, product_manufacturer_id, product_url, product_weight, product_keywords, product_weight_unit, product_meta_description, product_dimension_unit, product_width, product_length, product_height, product_max_per_order, product_access, product_group_after_purchase, product_min_per_order, product_contact, product_display_quantity_field, product_sales, product_waitlist, product_layout, product_average_score, product_total_vote, product_page_title, product_alias, product_price_percentage, product_msrp, product_canonical, product_warehouse_id, product_quantity_layout, screensize, os, bluetooth, ram, public, genre FROM rwos3_hikashop_product AS p, WHERE p.product_id IN (383,388,382,389,390,391) AND () Hi, Hope you can assist. I've been adding characteristics to my Hikashop products with no problem however after adding and saving a new characteristic I received the above error message (1064). Now on the front end product page I have a rogue "Select an Option" box in my characteristics field (Currently under the SSD option). Would you be able to assist me with removing this? This is only resident on this particular product page that i've noticed, maybe a bug? is there a way to remove? Let me k now if you need any further info. Many thanks in advance, Jason Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 9 months ago - 11 years 9 months ago [\#188071](#188071) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#188071 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* I suppose that you're using the 2.3.5 version of HikaShop ? In that case, replace the file administrator/components/com_hikashop/classes/product.php with the one in the archive and that should fix the problem. We'll also add the fix in next version of HikaShop. Last edit: 11 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")** - [![Cynthia-V's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") - [ Offline](/forum/user/36823-cynthia-v) Less More - Posts: 22 - Thank you received: 2 - - 11 years 6 months ago [\#197988](#197988) by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") Replied by *[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#197988 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* I get the same error when I made a new custom field, open an existing product, enter a value and save the product. I use version 2.4.0 business edition (downloaded yesterday). This is the error upon save: '1064 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 'WHERE p.product_id IN (8,9,10,11)' at line 1 SQL=INSERT IGNORE INTO rdjla_hikashop_product ' When I open the product again, enter a value and save it again, the error is gone. I uploaded the product.php file you provided here as a download, but now the backend of the custom fields is messed up. Please help. [ ![hikashop-backend-new-customfield.png](/forum/attachment/23661) ](/forum/attachment/23661 "...ustomfield.png") - [ ![hikashop-backend-new-customfield.png](/forum/attachment/23661) ](/forum/attachment/23661 "...ustomfield.png") [ ](/forum/attachment/23661?download=1 "...ustomfield.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")** - [![Cynthia-V's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") - [ Offline](/forum/user/36823-cynthia-v) Less More - Posts: 22 - Thank you received: 2 - - 11 years 6 months ago [\#198034](#198034) by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") Replied by *[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#198034 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* I reinstalled the business edition, so the backend is o.k. again. But the error comes back every time I save a product. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198040](#198040) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#198040 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* Hi, The error you got is different and if you're using the latest HikaShop package, the product file provided by Nicolas is not useful. Please provide us details about your current configuration (hikashop version number, joomla version number). About your screenshot, you got a PHP fatal error, you should check your PHP error log or set temporally the "error reporting level" to "maximum" in your Joomla global configuration in order to see the error message. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")** - [![Cynthia-V's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") - [ Offline](/forum/user/36823-cynthia-v) Less More - Posts: 22 - Thank you received: 2 - - 11 years 6 months ago [\#198179](#198179) by [Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile") Replied by *[Cynthia-V](/forum/user/36823-cynthia-v "View Cynthia-V's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#198179 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* Configuration details: Hikashop Business 2.4.0, Joomla 3.3.1, PHP 5.3.28, MySQL 5.5.39 I've set error reporting on maximum. Tried to recreate the problem by adding a new custom field and use it in an existing product, and now the product saves correctly. Bizarre ???? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#198181](#198181) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error 1064 after saving a characteristic](/forum/26-product-category-display/874486-error-1064-after-saving-a-characteristic#198181 "-- Error-message(debug-mod must be tuned on) -- : 1064 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 ') AS...")* Hi, We will perform some tests ; if you manage to reproduce the issue, please let us know. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI2LXByb2R1Y3QtY2F0ZWdvcnktZGlzcGxheS84NzQ0ODYtZXJyb3ItMTA2NC1hZnRlci1zYXZpbmctYS1jaGFyYWN0ZXJpc3RpYz90bXBsPW1hcmtkb3du) 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.258 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)