[Skip to main content](#vessel-content) # Profile for cgonline ## [![cgonline's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34948-cgonline "View cgonline's Profile") **[ Offline](/forum/user/34948-cgonline)** - **User Type:** User - **Register Date:** 11 Nov 2014 - **Last login:** 11 years 1 month ago - **Time Zone:** UTC +0:00 - **Local Time:** 19:01 - **Posts:** 12 - **Profile views:** 68 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # cgonline's recent posts (12 messages ) All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year | [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) | |---|---|---|---|---| | [](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213341) | [Unknown column 'order\_subtotal' in 'field list'](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213341 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : All -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : $orderClass = hikashop_get('class.order'); $order = $orderClass->loadFullOrder($order_id, false, false); $orderClass->save($order); Returns: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Hi Im trying to update an order from a system plugin, but it fails with an SQL error: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Newest Hikashop is installed, but no luck. Im using this: How can I update (cancel or confirm) an existing order from a system plugin + send the email notification to the customer codewise?") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 11 years 1 month ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") 11 years 1 month ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:4 Views:1608 | [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 1 month ago | | [](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213253) | [Unknown column 'order\_subtotal' in 'field list'](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213253 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : All -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : $orderClass = hikashop_get('class.order'); $order = $orderClass->loadFullOrder($order_id, false, false); $orderClass->save($order); Returns: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Hi Im trying to update an order from a system plugin, but it fails with an SQL error: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Newest Hikashop is installed, but no luck. Im using this: How can I update (cancel or confirm) an existing order from a system plugin + send the email notification to the customer codewise?") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 11 years 1 month ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") 11 years 1 month ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:4 Views:1608 | [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 1 month ago | | [](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213212) | [Unknown column 'order\_subtotal' in 'field list'](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213212 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 3.4.3 -- PHP version -- : All -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : $orderClass = hikashop_get('class.order'); $order = $orderClass->loadFullOrder($order_id, false, false); $orderClass->save($order); Returns: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Hi Im trying to update an order from a system plugin, but it fails with an SQL error: Unknown column 'order_subtotal' in 'field list' SQL=UPDATE `oklpt_hikashop_order` SET ... Newest Hikashop is installed, but no luck. Im using this: How can I update (cancel or confirm) an existing order from a system plugin + send the email notification to the customer codewise?") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 11 years 1 month ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") 11 years 1 month ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:4 Views:1608 | [Last Post](/forum/31-development/879086-unknown-column-order-subtotal-in-field-list#213345 "Hi, Yes ; it's the same kind, but we are not using JTable objects (it is not available in Joomla 1.5). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 1 month ago | | [](/forum/4-how-to/878539-how-could-i-get-the-price-of-the-product-in-php#211938) | [How could I get the price of the product in php?](/forum/4-how-to/878539-how-could-i-get-the-price-of-the-product-in-php#211938 "-- HikaShop version -- : 2.5.0 -- Joomla version -- : 5.4.3 -- PHP version -- : 5.6.3 I am try to modify search results so they can output the price of the products. I am using this code to get the product by its id: But I don't get the price of the product. Yes, I can get it from the database but may be there are any ways to do it by your methods from the class?") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 11 years 2 months ago, by [progreccor](/forum/user/4816-progreccor "View progreccor's Profile") [Last Post](/forum/4-how-to/878539-how-could-i-get-the-price-of-the-product-in-php#211941 "Hi, That code works fine, so you must be missing something in what you have before and/or after it.") 11 years 2 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:2137 | [Last Post](/forum/4-how-to/878539-how-could-i-get-the-price-of-the-product-in-php#211941 "Hi, That code works fine, so you must be missing something in what you have before and/or after it.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 2 months ago | | [](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186542) | [Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186542 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 11 years 10 months ago, by [Bower](/forum/user/31321-bower "View Bower's Profile") [Last Post](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186556 "Hi, I am sorry but I can't reproduce your issue using HikaShop 2.3.5 with the option "Generate variants automatically" configure to "yes" (Main > Advanced settings). Regards,") 11 years 9 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:10 Views:1469 | [Last Post](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186556 "Hi, I am sorry but I can't reproduce your issue using HikaShop 2.3.5 with the option "Generate variants automatically" configure to "yes" (Main > Advanced settings). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 9 months ago | | [](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186435) | [Database processes slowing server down](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186435 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.2.4 -- PHP version -- : 5.3.3 -- Browser(s) name and version -- : Firefox -- Error-message(debug-mod must be tuned on) -- : 504 Gateway Time-out nginx Hi I keep getting 504 Gateway Time out errors while working on the site and this was the response I got from my Hosting Service Provider There is currently a large amount of disk usage on the server being consumed by the MySQL service. There are currently some huge processes trying to go through; The process I was trying to acheive was to move a product into a different category and add it to a couple more. Not something I thought was out of the ordinary or used a vast amount of resources to process. Are the time out errors being generated by hikashop or could there be another reason?") Category: [General Talk about HikaShop](/forum/2-general-talk-about-hikashop "Suggest your feature requests and ideas for HikaShop") Topic started 11 years 10 months ago, by [Bower](/forum/user/31321-bower "View Bower's Profile") [Last Post](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186556 "Hi, I am sorry but I can't reproduce your issue using HikaShop 2.3.5 with the option "Generate variants automatically" configure to "yes" (Main > Advanced settings). Regards,") 11 years 9 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile") | Replies:10 Views:1469 | [Last Post](/forum/2-general-talk-about-hikashop/873726-database-processes-slowing-server-down#186556 "Hi, I am sorry but I can't reproduce your issue using HikaShop 2.3.5 with the option "Generate variants automatically" configure to "yes" (Main > Advanced settings). Regards,") by [Jerome](/forum/user/80-jerome "View Jerome's Profile") 11 years 9 months ago | | [](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185784) | [How to Create / Duplicate an order through API?](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185784 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5 -- Browser(s) name and version -- : XXX -- Error-message(debug-mod must be tuned on) -- : Hi Hi Im trying to figure out a way to convert a product into a recurring payment, but cannot find out how to create/duplicate a whole order. There is plenty of examples to interact with an order, but that part is already in place. So, How to create a new or duplicate an existing (whole) order through HS API?") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 11 years 9 months ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185794 "Hi, Yes, the call to save will trigger the normal HikaShop plugins/events. For a direct link which handles the canonical URLs, you want to use: The best though would be to have a $product_object coming from the database with all the product data as the object attributes, like we do in HikaShop since hikashop_contentLink expect an object, not an array.") 11 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1073 | [Last Post](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185794 "Hi, Yes, the call to save will trigger the normal HikaShop plugins/events. For a direct link which handles the canonical URLs, you want to use: The best though would be to have a $product_object coming from the database with all the product data as the object attributes, like we do in HikaShop since hikashop_contentLink expect an object, not an array.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 9 months ago | | [](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185564) | [How to Create / Duplicate an order through API?](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185564 "-- HikaShop version -- : 2.3.5 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5 -- Browser(s) name and version -- : XXX -- Error-message(debug-mod must be tuned on) -- : Hi Hi Im trying to figure out a way to convert a product into a recurring payment, but cannot find out how to create/duplicate a whole order. There is plenty of examples to interact with an order, but that part is already in place. So, How to create a new or duplicate an existing (whole) order through HS API?") Category: [Development](/forum/31-development "If you are developping a plugin for Hikashop or customizing our component, this is the board to be.") Topic started 11 years 9 months ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185794 "Hi, Yes, the call to save will trigger the normal HikaShop plugins/events. For a direct link which handles the canonical URLs, you want to use: The best though would be to have a $product_object coming from the database with all the product data as the object attributes, like we do in HikaShop since hikashop_contentLink expect an object, not an array.") 11 years 9 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:3 Views:1073 | [Last Post](/forum/31-development/874067-how-to-create-duplicate-an-order-through-api#185794 "Hi, Yes, the call to save will trigger the normal HikaShop plugins/events. For a direct link which handles the canonical URLs, you want to use: The best though would be to have a $product_object coming from the database with all the product data as the object attributes, like we do in HikaShop since hikashop_contentLink expect an object, not an array.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 11 years 9 months ago | | [](/forum/26-product-category-display/873421-wrong-product-is-shown#182630) | [Wrong product is shown](/forum/26-product-category-display/873421-wrong-product-is-shown#182630 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.8 -- Browser(s) name and version -- : Chrome/Ie/Firefox (latest) -- Error-message(debug-mod must be tuned on) -- : Wrong product is shown When going to one specific product page, the wrong product is shown. Titles are almost identical, but not the same. Example: Url1: /lines/nylon/hunter-freestyle-retriever-line.html Url2: /lines/nylon/hunter-freestyle-retriever-reflect-line.html The product of url2 shows in both cases (even on the wrong canonical url which are different in DB). How can I fix that so the right product shows instead?") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 11 years 10 months ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/26-product-category-display/873421-wrong-product-is-shown#182641 "Hi, The mass actions don't call the save function of the product class, so the aliases will not be added automatically. What can be done is create a little function which will just call the save function to save the products in a foreach. Or, you can export the products, fill the product alias column in the csv file an import it back.") 11 years 10 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:5 Views:639 | [Last Post](/forum/26-product-category-display/873421-wrong-product-is-shown#182641 "Hi, The mass actions don't call the save function of the product class, so the aliases will not be added automatically. What can be done is create a little function which will just call the save function to save the products in a foreach. Or, you can export the products, fill the product alias column in the csv file an import it back.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 11 years 10 months ago | | [](/forum/26-product-category-display/873421-wrong-product-is-shown#182265) | [Wrong product is shown](/forum/26-product-category-display/873421-wrong-product-is-shown#182265 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.8 -- Browser(s) name and version -- : Chrome/Ie/Firefox (latest) -- Error-message(debug-mod must be tuned on) -- : Wrong product is shown When going to one specific product page, the wrong product is shown. Titles are almost identical, but not the same. Example: Url1: /lines/nylon/hunter-freestyle-retriever-line.html Url2: /lines/nylon/hunter-freestyle-retriever-reflect-line.html The product of url2 shows in both cases (even on the wrong canonical url which are different in DB). How can I fix that so the right product shows instead?") Category: [Product & Category Display](/forum/26-product-category-display "Questions about product and category display. You can't find how to make Hikashop looks incredible? The answer is here!") Topic started 11 years 10 months ago, by [cgonline](/forum/user/34948-cgonline "View cgonline's Profile") [Last Post](/forum/26-product-category-display/873421-wrong-product-is-shown#182641 "Hi, The mass actions don't call the save function of the product class, so the aliases will not be added automatically. What can be done is create a little function which will just call the save function to save the products in a foreach. Or, you can export the products, fill the product alias column in the csv file an import it back.") 11 years 10 months ago by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") | Replies:5 Views:639 | [Last Post](/forum/26-product-category-display/873421-wrong-product-is-shown#182641 "Hi, The mass actions don't call the save function of the product class, so the aliases will not be added automatically. What can be done is create a little function which will just call the save function to save the products in a foreach. Or, you can export the products, fill the product alias column in the csv file an import it back.") by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") 11 years 10 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.163 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)