[Skip to main content](#vessel-content) # Product or category creation end with error ## - **[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")** - [![Yovtchevsky's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") Topic Author - [ Offline](/forum/user/31563-yovtchevsky) Less More - Posts: 3 - Thank you received: 0 - - 12 years 7 months ago [\#147468](#147468) by [Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") *[Product or category creation end with error](/forum/32-content-creation/866475-product-or-category-creation-end-with-error#147468 "-- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril")* was created by *[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")* -- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2NDc1LXByb2R1Y3Qtb3ItY2F0ZWdvcnktY3JlYXRpb24tZW5kLXdpdGgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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) - 12 years 7 months ago [\#147471](#147471) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Product or category creation end with error](/forum/32-content-creation/866475-product-or-category-creation-end-with-error#147471 "-- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril")* Hi, Can you please provide a screenshot of your error ? HikaShop does not do any SQL query on the table "templates_menu". If you can set the PHP error reporting to "maximum" in your Joomla global configuration. It can display you more details during the error. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2NDc1LXByb2R1Y3Qtb3ItY2F0ZWdvcnktY3JlYXRpb24tZW5kLXdpdGgtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")** - [![Yovtchevsky's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") Topic Author - [ Offline](/forum/user/31563-yovtchevsky) Less More - Posts: 3 - Thank you received: 0 - - 12 years 7 months ago - 12 years 7 months ago [\#147574](#147574) by [Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") Replied by *[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")* on topic *[Product or category creation end with error](/forum/32-content-creation/866475-product-or-category-creation-end-with-error#147574 "-- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril")* Hi Jerome, Now i'm trying to setup brand new joomla + hikashop installation to see what will happend. If problem persist - i can send you admin password to help me to investigate the problem. As additional information i can tell You that during exection of code, i can see for a parth of second that some parts of something like menu is displayed in the left of page, and after that the error is showing. No mather how deep i set debug level in server onfiguration tab of joomla - no additional info is displayed. As attachment is screenshot of error page [ ![h62674f2.jpg](/forum/attachment/15888) ](/forum/attachment/15888 "h62674f2.jpg") On the new installation of joomla and hikashop everything is OK. On the old one, i have uninstalled all 3d party extensions but the problem persist. The problem is only when creating hikashop product or category.... Everything other in hikashop running well. Regardas Kiril - [ ![h62674f2.jpg](/forum/attachment/15888) ](/forum/attachment/15888 "h62674f2.jpg") [ ](/forum/attachment/15888?download=1 "h62674f2.jpg") Last edit: 12 years 7 months ago by [Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2NDc1LXByb2R1Y3Qtb3ItY2F0ZWdvcnktY3JlYXRpb24tZW5kLXdpdGgtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")** - [![Yovtchevsky's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") Topic Author - [ Offline](/forum/user/31563-yovtchevsky) Less More - Posts: 3 - Thank you received: 0 - - 12 years 7 months ago [\#147587](#147587) by [Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile") Replied by *[Yovtchevsky](/forum/user/31563-yovtchevsky "View Yovtchevsky's Profile")* on topic *[Product or category creation end with error](/forum/32-content-creation/866475-product-or-category-creation-end-with-error#147587 "-- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril")* The problem i solved (but not investigated fully)... Starting with using database with new installation - product creation done. After that - copying major folders (main joomla folders) folder by folder from good installation to bad one and checking on every step. Found that problem is in plugins folder. Continuing investigation with subfolders in plugins folder, i'm finding that problem is in editors folder. I have archive of bad folder, but i don't have time, to investigate where in editors subfolders is difference. May be later will try to find the exact solution. Regards Kiril Yovtchevsky Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2NDc1LXByb2R1Y3Qtb3ItY2F0ZWdvcnktY3JlYXRpb24tZW5kLXdpdGgtZXJyb3I/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 7 months ago [\#147614](#147614) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Product or category creation end with error](/forum/32-content-creation/866475-product-or-category-creation-end-with-error#147614 "-- HikaShop version -- Starter 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- Mozilla 27.0.1 and Internet Explorer 11 -- Error-message(debug-mod must be tuned on) -- SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 When creating product or category, reseived error " SQL=SELECT template FROM jos_templates_menu WHERE client_id = 0 AND menuid = 0 " The instalation is fresh. No products or categoryes are added. Trying few times - same result. Uninstalled HikaShop, removed SQL datrabases and reinstalled again - received same error. Joomla debuging is turned on, but i have no idea what code is executed during error. In Joomla debug console, previous SQL query was: SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.field_table='product' AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) ORDER BY a.`field_ordering` ASC Any ideas?! Best regards Kiril")* Ok, so it was probably coming from one of your plugins, thanks for your feedback ![:)](/media/kunena/emoticons/8.png ":)"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMyLWNvbnRlbnQtY3JlYXRpb24vODY2NDc1LXByb2R1Y3Qtb3ItY2F0ZWdvcnktY3JlYXRpb24tZW5kLXdpdGgtZXJyb3I/dG1wbD1tYXJrZG93bg==) 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.230 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)