After Server Change 500 Error Page

  • Posts: 59
  • Thank you received: 2
11 years 10 months ago #82449

Hello,

we change our Shop to the Live Server - but when we log in and change to HikaShop
we become the following error message:

500 SQL=SELECT SUM(prod.order_product_price*prod.order_product_quantity) as Total, a.order_currency_id FROM ke7jp_hikashop_order AS a LEFT JOIN ke7jp_hikashop_order_product AS prod ON a.order_id=prod.order_id WHERE a.order_type='sale' AND a.order_created > 1353171895 AND a.order_created < 1355763895

the shop is running, Joomla is running, front and backend is running - only the control center of hika shop is not running !

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 10 months ago #82453

Hi,

Please use HikaMysqli from this post : www.hikashop.com/en/forum/2-general-talk...p-20-beta.html#72321
This database drive would give you the real mysql error.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 59
  • Thank you received: 2
11 years 10 months ago #82456

Hi Jerome,

but i use the newest Business Version - so is it really neccessary to put in this patch
that you post ? On my not live local server everythink is fine - just on the live server
i became this error. And everythink is working - just the controll center doesn´t work.

if you say - YES do it - i will do it...

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 10 months ago #82458

Hi,

You can copy/past the SQL request in your PHPMyAdmin and see the result error.
I think there is a problem in a widget and I am sure that we can fix it for your website and the control panel would work correctly.
Having the sql error would help us to understand the problem.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 59
  • Thank you received: 2
11 years 10 months ago #82459

Hi Jerome,

ok - mySQL response:

#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Please Log in or Create an account to join the conversation.

  • Posts: 26152
  • Thank you received: 4027
  • MODERATOR
11 years 10 months ago #82495

Hi,

Can you edit the file administrator/com_hikashop/classes/widget.php
You would found the line:

    $select.='SUM('.$theSum.') as Total, a.order_currency_id';
    break;
  default:
    break;
}
Please add the line, like this:
    $select.='SUM('.$theSum.') as Total, a.order_currency_id';
    if(empty($groupby)) $groupby = array();
    $groupby[] = 'a.order_currency_id';
    break;
  default:
    break;
}
I think it should fix your problem.

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: MikeB

Please Log in or Create an account to join the conversation.

  • Posts: 59
  • Thank you received: 2
11 years 10 months ago #82507

that´s it ! now it works also on the live system !

Thanks a lot !

Please Log in or Create an account to join the conversation.

Time to create page: 0.069 seconds
Powered by Kunena Forum