29.11.2023 17:45
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Configurable product broken
Hey
I am sorry to report that the main product I am using configurable product for seems to be broken.
Here is what happened:
I added a group, and when I saved I got a 500 error and after reloading about half the groups and products in these groups were lost from the configurable product.
When I now try to add them again, they get lost again, but no server 500 error. I can add products and groups, but when I save, sometimes they are saved, and after the next save, some of them are gone. Even when I open the product in another browser, some products or groups are gone.
Any ideas?
Will send you a pm with credentials...
Thanks
Rolf
|
|
30.11.2023 08:50
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25942
|
Aw: Configurable product broken
I think the problem is in the php settings
https://www.{YourWebsite.xxx}/administrator/index.php?option=com_admin&view=sysinfo
max_input_vars: 1000
------
set (Your hosting configuration)
max_input_vars: 10000 or more
|
|
30.11.2023 12:39
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Hey
Thanks, changed it to 10.000 but still the same issue.
Thanks
Rolf
|
|
30.11.2023 20:00
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25942
|
Aw: Configurable product broken
1 product - 1 Ajax request
many requests and your server gives a database connection error
Problem in your server.
Последнее изменение: 30.11.2023 20:01
|
|
30.11.2023 20:45
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Hey
Strange it worked for years. I have used it since more than two years. Also nothing in the server logs. Where did you see the database connection error? What should I ask the support of my webhoster?
Thanks
Rolf.
|
|
01.12.2023 08:04
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25942
|
Aw: Configurable product broken
1. enable debug mode
2. open product
/administrator/index.php?option=com_jshopping&controller=products&task=edit&product_id=146
3. Example firefox
click F12
See console XHR (ajax request)
error: mysqli object is not fully initialized
see privat msg.
|
|
06.12.2023 08:25
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Hey
Spoke to the provider and of course they blamed the add on :-).
But I have been digging a bit deeper and found this in the error.logs everytime I change the product:
2023-12-04T17:01:36+00:00 CRITICAL 162.55.97.171 error Uncaught Throwable of type mysqli_sql_exception thrown with message "User web73_2 already has more than 'max_user_connections' active connections". Stack trace: #0 [ROOT]/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(310): mysqli->real_connect('localhost', 'web73_2', '9TdwKkIcitPB8RD...', NULL, 3306, NULL, 0)
#1 [ROOT]/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php(233): Joomla\Database\Mysqli\MysqliDriver->connect()
#2 [internal function]: Joomla\Session\Handler\DatabaseHandler->open('[TMP]', '264e8196c6dca37...')
#3 [ROOT]/libraries/vendor/joomla/session/src/Storage/NativeStorage.php(478): session_start()
#4 [ROOT]/libraries/src/Session/Storage/JoomlaStorage.php(295): Joomla\Session\Storage\NativeStorage->start()
#5 [ROOT]/libraries/vendor/joomla/session/src/Session.php(406): Joomla\CMS\Session\Storage\JoomlaStorage->start()
#6 [ROOT]/libraries/vendor/joomla/session/src/Session.php(333): Joomla\Session\Session->start()
#7 [ROOT]/libraries/src/Session/Session.php(194): Joomla\Session\Session->has('user')
#8 [ROOT]/libraries/src/Factory.php(372): Joomla\CMS\Session\Session->get('user')
#9 [ROOT]/libraries/src/Application/SiteApplication.php(562): Joomla\CMS\Factory::getUser()
#10 [ROOT]/libraries/src/Application/SiteApplication.php(226): Joomla\CMS\Application\SiteApplication->initialiseApp()
#11 [ROOT]/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\SiteApplication->doExecute()
#12 [ROOT]/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#13 [ROOT]/index.php(32): require_once('/home/www/bodhr...')
#14 {main}
So it looks like the max user connections are the problem. Again I spoke to the provider and they said the max user connection is fixed to 15. (Unless I get a managed server...., which is not what I want).
The issue could be something like described here?
https://support.hostinger.com/en/articles/1583511-how-to-fix-the-user-already-has-more-than-max-user-connections-error?cmdf=max+user+connections+webhosting
Your script creates connections without properly closing them when they are no longer needed, or
Your website is very active and has many users online at the same time
Since the traffic isn't that busy and it only happens when I save the configured product, I would think it is the first issue.
Thanks a lot
Rolf
Последнее изменение: 06.12.2023 08:44
|
|
06.12.2023 09:55
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25942
|
Aw: Configurable product broken
Later we will optimize the addon.
|
|
06.12.2023 11:16
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Thank you!
Any estimated time of arrival?
Cheers
Rolf
|
|
09.12.2023 12:06
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Сообщения: 25942
|
Aw: Configurable product broken
New version
Configurable product 2.8.0
|
|
09.12.2023 17:31
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Thanks!
Will try asap.
Cheers
Rolf
|
|
11.12.2023 13:17
|
|
Dingens
Name: Rolf Wagels
28.03.2012
Сообщения: 694
|
Aw: Configurable product broken
Hey
Mighty! Works great so far, a lot quicker, more stable and no more issues.
Thanks a lot!
Cheers
Rolf
|
|