Export Full hikashop

Im updating my webpage form j 2.5 to 3.0 and as it has a lot of errors in updating i would like to export the whole hikashop to the new page, is there any way to do it so i can have user, orders and products?

I´ve tried to update a 2.5 version and everything went ok except for hikashop wich gives me this error
SQL=SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity FROM beadr_hikashop_order_product AS prod LEFT JOIN beadr_hikashop_order AS a on a.order_id=prod.order_id WHERE > 1356543212 AND < 1388079212 GROUP BY prod.order_product_name ORDER BY Total DESC LIMIT 7

Also the cart display in system configuration does not work
I upload debug errors
if i fix this i think im done.

I also tried to create a new installation of joomla 3.2, install hikashop, delete the tables in mysql and after export from joomla 2.5 database the hikashop fields, import them, but same error is displaying. The version of both hikashop is last one 2.2.3. The displaying of hikashop in backend is also broken and the main page of hikashop in wich the graphics are does not display at all.

Hi,

This is apparently an issue with the wdigets that you have setup on your HikaShop dashboard.
I'm not sure why, but the simplest is to just disable them via the menu Orders->Reports. You can always re configure them, or recreate new ones via that same menu.

ok disabling the orders reports it at least aloww me to go to dashboard but the interface in completely broken, take a look

It seems that you have an issue with the CSS of HikaShop.
Please make sure that you're using the "default" CSS file for the backend of HikaShop in the configuration page of HikaShop and that you clear your browser's cache and it should display fine.

ok it seems that after uploading the old sql set the css to none instead of default, now works, the only thing that fails is the old order reports, i´ll create new ones and think it wold be fixed, thanks