Error 1064

-- 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 < 1404187980 GROUP BY prod.order_product_name ORDER BY Total D' at line 1 SQL=SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity FROM mmp_pl7vu_hikashop_order_product AS prod LEFT JOIN mmp_pl7vu_hikashop_order AS a on a.order_id=prod.order_id WHERE > 1400572800 AND < 1404187980 GROUP 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

Hello,
Firstly can you download again the last Hikashop through our website, install it through your new joomla 3 and test it again ?
Thanks.

Hi Mohamed
I had already done that a couple of times prior to this post. Just tried again but error still exists.
Darren

Works a treat.

Thank you very much.