Mass Action error

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #249783

-- HikaShop version -- : 2.6.3
-- Joomla version -- : 3.6.2
-- PHP version -- : 5.4.24
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : none

Hi, I use Mass Action on a daily basis and now this morning I cannot get in to any of my saved actions? when I click on the links to get in to the actions it just goes to what is shown in jpg 2?



Attachments:

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

  • Posts: 11932
  • Thank you received: 1646
  • MODERATOR
2 years 6 months ago #249792

Hello,

Firstly, can you download the last Hikashop version through our website, install it and test it again ?

If you're still having that issue, note that a blank page only means that an error occurred but can't be displayed because the Joomla debug mode and Error reporting are disabled, can you :
- Activate the Joomla debug mode ("Administration->Global configuration->System->Debug System/Language")
- Set the "error reporting" option of the Joomla configuration to "maximum"
- Test it again so that you can see if it display an error message which will help you to understand from what your issue is coming.

Thank you.

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #249878

Hiya, This is the error I am getting,
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2 bytes) in /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php on line 464

I have now found that no system emails are being sent as well?

Last edit: 2 years 6 months ago by mohairbears. Reason: more information

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #249896

Hi,

1. This error indicates that it reached the maximum allowed memory and the processing was terminated.
So it could be a lot of things.
If you create a new mass action, do you get the same error ?
If you disable the mass action plugins via the Joomla plugins manager, which one is causing the issue ?
Do you have a lot of products ? A lot of orders ? A lot of something else on your website ?

2. You can check on whether HikaShop sends emails or not via the menu Customers>Emails history. If you see the emails there but you don't receive them, then it means that the problem is with the email server. You'll have to contact your hosting company or server administrator.

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #249972

Hi Nicolas,

I have sorted the email error.

It's the 'order' plugin that is causing the issue, as this is the one I use the most for reports, changing orders status etc. it is causing a big headache.

Obviously I cannot create a new action without the plugin enabled and I get the same error when trying to create a new action with the plugin enabled?

Yes I do have 1,000 of products, orders, variants etc.

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #249980

Hi,

Add temporarily the code:
if(memory_get_usage()>1300000000){
var_dump(debug_backtrace());
exit;
}
Before the line 464 of the file /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php :
return mysql_fetch_object($cursor ? $cursor : $this->cursor, $class);

That should then display debug data of the problem when you get it which will help us understand why it does that.

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250099

Hi, It is now displaying this
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 93 bytes) in /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php on line 470

which refers to this line of code

return mysql_fetch_object($cursor ? $cursor : $this->cursor, $class);

thanks

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #250100

Hi,

Ah, I had put a 0 too much in my code.
Try again with that code instead:

if(memory_get_usage()>130000000){
var_dump(debug_backtrace());
exit;
}

Last edit: 2 years 6 months ago by Jerome. Reason: [code] is nice

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250136

HI I now get this error;
Parse error: syntax error, unexpected 'protected' (T_PROTECTED) in /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php on line 484

which is this line;

mysql_free_result($cursor ? $cursor : $this->cursor);

thanks

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #250141

Hi,

Then try again with that code instead:

if(memory_get_usage()>100000000){
var_dump(debug_backtrace());
exit;
}

Last edit: 2 years 6 months ago by Jerome. Reason: [code] is nice

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250250

Hi Getting this error
Parse error: syntax error, unexpected 'try' (T_TRY) in /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php on line 464

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #250280

Hi,

So what do you have around that line in that file ?

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250377

Hi, I now cannot get in to Global Configuration to run it again? I am getting a similar error to the mass action. Everything else is working ok??

Attachments:

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 6 months ago #250424

Hi,

Then you might have made a mistake when modifying that file. Try reverting to the default file of Joomla.

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250448

Hi,
I did do that but it will still not work? downloaded Joomla and uploaded the file.

I have found a note about the error yesterday and it referred to line 478;

mysql_free_result($cursor ? $cursor : $this->cursor);

again mentioning T-Try

Also reinstalled Joomla and Hikashop and still the same?

Last edit: 2 years 6 months ago by mohairbears. Reason: additional info

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

  • Posts: 23351
  • Thank you received: 3627
  • MODERATOR
2 years 6 months ago #250455

Hi,

I'm sorry but I don't understand your message.

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: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250496

mysql.php as its the only file we have been discussing in this thread.

Nicolas is aware of this thread

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 6 months ago #250583

Hi Nicolas,
I have solved the Global error I had made a copy of the original sql file and it appears not to like having a copy in the same folder.

Right see the2 screen dumps sql_1 shows the last code you supplied entered on line 464, this just give a blank screen but as you can see in sql_2 I removed the } and it now give this error;
Parse error: syntax error, unexpected 'protected' (T_PROTECTED) in /home/mohairbe/public_html/libraries/joomla/database/driver/mysql.php on line 480

Line 480 is visible in sql_2






thanks

Attachments:

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

  • Posts: 65130
  • Thank you received: 9460
  • MODERATOR
2 years 5 months ago #250553

Hi,

Well, the thing is that this error doesn't mean that it comes from HikaShop, especially if you have the problem on other things than HikaShop.
So reinstalling HikaShop won't help.
No, this error means that too much memory is being used and thus it can come from nearly anything. Like another plugin/extension loading a lot of data from MySQL.
If the problem is only in the mass actions interface, then there is a high chance that it's something linked to the data in the database of HikaShop or/and how the mass action is configured and maybe there is something to improve on our end for that.
But if you have a similar problem on the global configuration page of Joomla, then the problem is probably not in HikaShop. It must be linked to a system plugin. You can try disabling them one after the other and see which one is causing the problem like that.

Now about your issue in the mysql file ; please be sure to copy paste the entire code we gave you.
Because you missed the final closing bracket. So it generate your PHP issue.

Last edit: 2 years 6 months ago by Jerome.

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

  • Posts: 411
  • Thank you received: 3
  • Hikashop Business
2 years 5 months ago #250621

Hi,
As I said above the Global issue has been resolved and was caused by creating a 'copy' of mysql.php and calling it 'mysql_copy.php' by deleting this file the global is ok again, now the only issue I have is with mass actions and the 'orders plugin'
The closing bracket was there but it looks like I have used the same screen dump twice, with he closing bracket there all I get is a 'blank page'

The only way to get an error message is to remove the closing bracket.

I have not linked anything to the data and I can only assume as I have a high volume of orders that this si somehow causing the problem? I cannot really delete and orders and they are there for customers history.

thanks

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

Time to create page: 0.116 seconds
Powered by Kunena Forum