[Skip to main content](#vessel-content) # Profile for darren ## [![darren's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/14044-darren "View darren's Profile") **[ Offline](/forum/user/14044-darren)** - **User Type:** User - **Register Date:** 27 Feb 2013 - **Last login:** 10 years 5 months ago - **Time Zone:** UTC +8:00 - **Local Time:** 00:09 - **Posts:** 7 - **Profile views:** 44 - **Gender:** Unknown - **Birthdate:** Unknown - Posts # darren's recent posts (7 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/25-install-update/869179-error-1064#161690) | [Error 1064](/forum/25-install-update/869179-error-1064#161690 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 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 '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 4 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") 12 years 4 months ago by [darren](/forum/user/14044-darren "View darren's Profile") | Replies:4 Views:598 | [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") by [darren](/forum/user/14044-darren "View darren's Profile") 12 years 4 months ago | | [](/forum/25-install-update/869179-error-1064#161352) | [Error 1064](/forum/25-install-update/869179-error-1064#161352 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 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 '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 4 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") 12 years 4 months ago by [darren](/forum/user/14044-darren "View darren's Profile") | Replies:4 Views:598 | [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") by [darren](/forum/user/14044-darren "View darren's Profile") 12 years 4 months ago | | [](/forum/25-install-update/869179-error-1064#161281) | [Error 1064](/forum/25-install-update/869179-error-1064#161281 "-- url of the page with the problem -- : http://http://fermoy.com.au/administrator/index.php?option=com_hikashop -- HikaShop version -- : 2.3.1 -- Joomla version -- : 3.3.1 -- PHP version -- : 5.4.24 -- Browser(s) name and version -- : Google Chrome 35.0.1916.153 m -- Error-message(debug-mod must be tuned on) -- : Error_message 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 '> 1400572800 AND 1400572800 AND P BY prod.order_product_name ORDER BY Total DESC LIMIT 7 I know this has been passed around a few times before and i believe i have read every post relating to this however i cannot find an answer that directly relates to my issue. I have just completed an upgrade from Joomla 2.5 to 3. and the problem has surfaced since then. Can you assist me in this matter? Please see below for Call Stack on Database Query Call Stack JROOT/administrator/components/com_hikashop/classes/widget.php:1643 JROOT/administrator/components/com_hikashop/classes/widget.php:675 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:83 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:22 JROOT/administrator/components/com_hikashop/views/dashboard/view.html.php:16 JROOT/libraries/legacy/controller/legacy.php:685 JROOT/administrator/components/com_hikashop/helpers/helper.php:1396 JROOT/administrator/components/com_hikashop/helpers/helper.php:1136 JROOT/libraries/legacy/controller/legacy.php:722 JROOT/administrator/components/com_hikashop/helpers/helper.php:1384 JROOT/administrator/components/com_hikashop/hikashop.php:54 JROOT/libraries/cms/component/helper.php:352 JROOT/libraries/cms/component/helper.php:332 JROOT/libraries/cms/application/administrator.php:98 JROOT/libraries/cms/application/administrator.php:159 JROOT/libraries/cms/application/cms.php:245 JROOT/administrator/index.php:42") Category: [Install & Update](/forum/25-install-update "Having an installation or update issue? You will probably find some help here.") Topic started 12 years 4 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") 12 years 4 months ago by [darren](/forum/user/14044-darren "View darren's Profile") | Replies:4 Views:598 | [Last Post](/forum/25-install-update/869179-error-1064#161690 "Works a treat. Thank you very much.") by [darren](/forum/user/14044-darren "View darren's Profile") 12 years 4 months ago | | [](/forum/27-checkout/861034-redirection-to-paypal-not-working#118507) | [Redirection to PayPal not working](/forum/27-checkout/861034-redirection-to-paypal-not-working#118507 "-- url of the page with the problem -- : fermoy.com.au -- HikaShop version -- : 2.1.3 -- Joomla version -- : 2.5.11 -- PHP version -- : 5.4.15 -- Browser(s) name and version -- : firefox -- Error-message(debug-mod must be tuned on) -- : Error_message I could do with some advice on how to handle the challenge I am having with the fermoy.com.au website. My clients customers are trying to order online and after leaving the checkout instead of being redirected to PayPal for payment they receive a message saying their order has been created. I have since tried to order and have not had any problem however when i check the order there are over 15 orders created and no PayPal confirmation. Can you offer any ideas Regards Darren") Category: [Checkout](/forum/27-checkout "Everything about the checkout process in Hikashop") Topic started 13 years 2 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/27-checkout/861034-redirection-to-paypal-not-working#118511 "Hi, I think that you should firstly update your Hikashop version and test it again.") 13 years 2 months ago by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") | Replies:1 Views:415 | [Last Post](/forum/27-checkout/861034-redirection-to-paypal-not-working#118511 "Hi, I think that you should firstly update your Hikashop version and test it again.") by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") 13 years 2 months ago | | [](/forum/4-how-to/84750-product-import-csv#112628) | [Product Import CSV](/forum/4-how-to/84750-product-import-csv#112628 "Hi All Forgive me if I have missed doc's relating to this. I am establishing a site that will link to another when a customer clicks on a product. I will need to import the links via a csv file (initially manually and then using a Cron Task). My first challenge is how to format Hikashop to accept csv headings that are not consistent with the current format i.e. CSV lists - name, whereas Hikashop requires product_name. I understand i could change the headings manually to make this work however this is not going to work if i set up a Cron Task. Is there a way i can format this in custom fields maybe??? Not sure where to start so any help would be greatly appreciated. Regards Darren") 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 13 years 3 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/4-how-to/84750-product-import-csv#112688 "Hi Darren, About the column name it will require to change the Hikashop behavior. It's quite a big modification since you have to modify the import.php in administrator/com_hikashop/helpers, I'm not sure it's the best solution. About the clickable images you will also have to edit Hikahop layout, go in Display>Views and edit listing_img of product to do your modification and add the link on the image.") 13 years 3 months ago by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") | Replies:3 Views:675 | [Last Post](/forum/4-how-to/84750-product-import-csv#112688 "Hi Darren, About the column name it will require to change the Hikashop behavior. It's quite a big modification since you have to modify the import.php in administrator/com_hikashop/helpers, I'm not sure it's the best solution. About the clickable images you will also have to edit Hikahop layout, go in Display>Views and edit listing_img of product to do your modification and add the link on the image.") by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") 13 years 3 months ago | | [](/forum/4-how-to/84750-product-import-csv#112603) | [Product Import CSV](/forum/4-how-to/84750-product-import-csv#112603 "Hi All Forgive me if I have missed doc's relating to this. I am establishing a site that will link to another when a customer clicks on a product. I will need to import the links via a csv file (initially manually and then using a Cron Task). My first challenge is how to format Hikashop to accept csv headings that are not consistent with the current format i.e. CSV lists - name, whereas Hikashop requires product_name. I understand i could change the headings manually to make this work however this is not going to work if i set up a Cron Task. Is there a way i can format this in custom fields maybe??? Not sure where to start so any help would be greatly appreciated. Regards Darren") 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 13 years 3 months ago, by [darren](/forum/user/14044-darren "View darren's Profile") [Last Post](/forum/4-how-to/84750-product-import-csv#112688 "Hi Darren, About the column name it will require to change the Hikashop behavior. It's quite a big modification since you have to modify the import.php in administrator/com_hikashop/helpers, I'm not sure it's the best solution. About the clickable images you will also have to edit Hikahop layout, go in Display>Views and edit listing_img of product to do your modification and add the link on the image.") 13 years 3 months ago by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") | Replies:3 Views:675 | [Last Post](/forum/4-how-to/84750-product-import-csv#112688 "Hi Darren, About the column name it will require to change the Hikashop behavior. It's quite a big modification since you have to modify the import.php in administrator/com_hikashop/helpers, I'm not sure it's the best solution. About the clickable images you will also have to edit Hikahop layout, go in Display>Views and edit listing_img of product to do your modification and add the link on the image.") by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") 13 years 3 months ago | | [](/forum/4-how-to/76291-reports#101317) | [reports](/forum/4-how-to/76291-reports#101317 "Hi, Is there any way to display reports on the front end? I have a customer who needs a login area showing a hidden menu that would be able to display all the information already displayed in the reports in the administration backend. Is this possible? Many thanks, Derek") 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 13 years 11 months ago, by [Goldingarts](/forum/user/6413-goldingarts "View Goldingarts's Profile") [Last Post](/forum/4-how-to/76291-reports#101556 "Hi, There is no option yet to display reports on the frontend. It is on our todo list to add reports on the frontend via HikaMarket in the future but it won't be before several months at least as we have other priorities in the short term for HikaMarket.") 13 years 6 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:5 Views:465 | [Last Post](/forum/4-how-to/76291-reports#101556 "Hi, There is no option yet to display reports on the frontend. It is on our todo list to add reports on the frontend via HikaMarket in the future but it won't be before several months at least as we have other priorities in the short term for HikaMarket.") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 13 years 6 months ago | [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.066 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)