Order this month stay the same

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314544

Hello and thanks for all your efforts,
here you go what happen when i turn the legacy on please see all attachments , thanks








Thanks again for your help , i tired everything possible to fix this issue and let you in, but the sucuri company that hired by owner if this place make it difficult and as i told i just took over this website, we are not main guys work on it, thanks for all your effort to help me, thanks again

Attachments:

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
4 years 10 months ago #314549

Hi,

Thanks for the screenshots. Here is what I can say based on them:
- With the "dashboard legacy" setting turned off, you're using the new dashboard. You get 26.64$ there with only one order.
So I suppose that it is working properly. Looking at the orders listing on your screenshot, the ones I can see are all with the status "created" and thus are ignored by default by the statistics system as only "confirmed" orders are taken into account.
As I said in my previous message, only the orders with their status enabled in the column "statistics" of the System>Order statuses menu will be taken into account. So maybe you want to go there and enable the "created" status under the "statistics" column if you want these orders to be taken into account.

- With the "dashboard legacy" setting turned on, you're using the old dashboard. I can see that you have a MySQL error there. It looks like a bug of the old dashboard based on how one of your widget is configured.
Try to change the line:
if(!empty($fieldtype)) {
to:
if(!empty($fieldtype) && strpos($fieldtype,',') !== 0) {
in the file administrator/components/com_hikashop/classes/widget.php and that should help.

The following user(s) said Thank You: affaf1952

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314559

Hello Phill and thanks for all efforts, I started working in the fix, where is statistics, would you please send me a screenshot

Attachments:

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314561

after i did the fix of legacy if(!empty($fieldtype)) {
to:
if(!empty($fieldtype) && strpos($fieldtype,',') !== 0) {


this is happen


would you advise on this

Attachments:

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314568

Hello Phill, i just arrived my office and went over the orders, you will see all these orders actually confirmed and paid
see the screenshot,t hanks


Thanks

Attachments:

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
4 years 10 months ago #314564

Hi,

As I said, you need to go in the menu System>Order statuses. There, you'll see the statistics column I'm talking about:
monosnap.com/file/BdJ3hxUQl5tIhVdg4v0ReSg5ztXPaL
And as you can see in your last screenshot, all the orders have the status "created" which isn't taken into account for statistics by default. So you need to enable the "created" status under the "statistics" column as explained above to get the stats you want.

Regarding the error messages you have with the legacy dashboard, it indicates that some users have been deleted even though they are recorded in HikaShop and thus when it tries to load their information, the Joomla library displays that error.

I would recommend you to run a MySQL query in your database like this:

UPDATE #__hikashop_user SET user_cms_id = 0 WHERE user_cms_id IN(1196, 1178, 1172, 1151, 1625);
That will unlink the users in HikaShop and the messages won't popup.

Last edit: 4 years 10 months ago by nicolas.
The following user(s) said Thank You: affaf1952

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314579

First of all i want to thank you because the statistics issue solved , and that was the trick, for the MySQL Run Query i have never done it before but im willing to do it, thanks, I will do some research how to do and follow your steps, thanks

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314580

I ran the Line you sent me
and this is what happen
Static analysis:

1 errors were found during analysis.

An expression was expected. (near "" at position 0)
SQL query:

UPDATE #__hikashop_user SET user_cms_id = 0 WHERE user_cms_id IN(1196, 1178, 1172, 1151, 1625);

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
4 years 10 months ago #314621

Hi,

Make sure that you replace #__ by the table prefix of your website:
docs.joomla.org/Database_Table_Prefix

The following user(s) said Thank You: affaf1952

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

  • Posts: 193
  • Thank you received: 11
  • Hikashop Business
4 years 10 months ago #314633

It works perfect, thanks

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

Time to create page: 0.112 seconds
Powered by Kunena Forum