Characteristics table over 4000 records issue

  • Posts: 567
  • Thank you received: 11
1 year 5 months ago #353093

-- HikaShop version -- : 4.4.5
-- Joomla version -- : 3.9.21
-- PHP version -- : 7.2
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : No error message

Hi

We face a issue here, when the item inside characteristics below 4000, we can edit and delete item with no problem, but when it exceeded 4000 delete working well when click on the delete icon, but after save, the record still reappear in the list

Database shows the record still there

We did tried to upgarde to 4.7.4, but it lead to another problem, the whole list can't be loaded with page not responding issue

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

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 5 months ago #353095

Hi,

I'm sorry but I don't understand what you mean. Are you saying that you have more than 4000 values in 1 characteristic ? Or that the id of your characteristics are above 4000 ? Or something else ?
Are you talking about deleting a characteristic with 4000 values ?
Or are you trying to delete a value from a characteristic with 4000 values ?
It's possible that if you have too many values, your server is refusing the save because of the restrictions configured on your server.
For example, the max_input_vars option of your php.ini can restrict the amount of inputs taken into account:
www.php.net/manual/en/info.configuration.php#ini.max-input-vars
The post_max_size setting of your php.ini can also be a limiting factor:
www.php.net/manual/en/ini.core.php#ini.post-max-size
There is also a similar setting in suhosin:
www.hardened-php.net/suhosin/configurati...uhosin.post.max_vars
So supposing I understand your situation right, you'll have to check with your hosting support what is setup in these settings and what can be increased.

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

  • Posts: 567
  • Thank you received: 11
1 year 4 months ago #353580

nicolas wrote: Hi,

I'm sorry but I don't understand what you mean. Are you saying that you have more than 4000 values in 1 characteristic ? Or that the id of your characteristics are above 4000 ? Or something else ?
Are you talking about deleting a characteristic with 4000 values ?
Or are you trying to delete a value from a characteristic with 4000 values ?
It's possible that if you have too many values, your server is refusing the save because of the restrictions configured on your server.
For example, the max_input_vars option of your php.ini can restrict the amount of inputs taken into account:
www.php.net/manual/en/info.configuration.php#ini.max-input-vars
The post_max_size setting of your php.ini can also be a limiting factor:
www.php.net/manual/en/ini.core.php#ini.post-max-size
There is also a similar setting in suhosin:
www.hardened-php.net/suhosin/configurati...uhosin.post.max_vars
So supposing I understand your situation right, you'll have to check with your hosting support what is setup in these settings and what can be increased.



yes, 4000 values in 1 characteristics, this problem only occurs while upgraded to latest version, older version dont have this problem

doesn't seem related to server

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

  • Posts: 83007
  • Thank you received: 13400
  • MODERATOR
1 year 4 months ago #353583

Hi,

I doubt that the version of HikaShop being used has anything to do with this.
There is nothing in HikaShop which could limit the number of values being saved. Such problems with values above a specific quantity being dismissed is typical of the server blocking the extra values because they are above some maximum value set somewhere.

You say that you don't have this problem with an old version of HikaShop. What is the version of HikaShop where you don't have the problem ? What is the version of Joomla and PHP there ? What is the version of Joomla and PHP on the website where it doesn't work ? Are they on the same server ?

Supposing that the PHP version is different, it means you're using a different PHP configuration. So it's totally possible to have the issue on one website and not on another on the same server if they use different versions of PHP, and thus different php.ini files since the max-input-vars parameter I was talking in my previous message.

Taking all what I wrote above into consideration saying that it's not a server issue because you don't have the issue on another website with an old version of HikaShop is a bit hasty.

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

Time to create page: 0.060 seconds
Powered by Kunena Forum