Responsive Banner Slider PHP exceptions.
- Posted by CCANSW (31) Offline
Thinking aloud, two weeks ago we upgraded PHP 7.2 to PHP 7.4 - I don't recall getting the exceptions on 7.2.
Could that impact?
3 years 10 months ago #13
by CCANSW
Could that impact?
Please Log in or Create an account to join the conversation.
- Posted by CCANSW (31) Offline
I have checked the #_banner_track records and cannot find duplicates, so at least we know the table is robust.
I have al;so confirmed that the standard core Joomla banner module does not throw a similar exception.
As you can see the PRIMARY KEY relies on three fields for uniqueness. Is there something in the code of the Responsive Banner Module that may be processing the primary key differently?
However, the real issue for us now is that since this started we've been experiencing periodic 503 server errors and server stoppages. Given the high frequency of the exceptions we suspected the module as a contributing factor. We're going to disable it for 48 hours as of Friday evening to see what happens.
Cheers
3 years 9 months ago #14
by CCANSW
I have al;so confirmed that the standard core Joomla banner module does not throw a similar exception.
Type Unique Packed Column Cardinality Collation Null Comment
Edit Edit Drop Drop PRIMARY BTREE Yes No track_date 6779552 A No
track_type 10009908 A No
banner_id 71655176 A No
Edit Edit Drop Drop idx_track_date BTREE No No track_date 6810127 A No
Edit Edit Drop Drop idx_track_type BTREE No No track_type 712 A No
Edit Edit Drop Drop idx_banner_id BTREE No No banner_id 7392 A NoAs you can see the PRIMARY KEY relies on three fields for uniqueness. Is there something in the code of the Responsive Banner Module that may be processing the primary key differently?
However, the real issue for us now is that since this started we've been experiencing periodic 503 server errors and server stoppages. Given the high frequency of the exceptions we suspected the module as a contributing factor. We're going to disable it for 48 hours as of Friday evening to see what happens.
Cheers
Please Log in or Create an account to join the conversation.
- Posted by CCANSW (31) Offline
FYI, I have been running a copy of the website on my local server, using PHP 7.2
The warnings about the outdated PHP aside, the exceptions are not occurring.
3 years 9 months ago #15
by CCANSW
The warnings about the outdated PHP aside, the exceptions are not occurring.
Please Log in or Create an account to join the conversation.
- Posted by TemplatePlazza (5261) Offline
Can you try to replace the existing files with these attached files below (but please BACKUP first) and let me know whether the issue persist or not :
modules/mod_responsivebannerslider/helper.php
modules/mod_responsivebannerslider/tmpl/default.php
3 years 9 months ago #16
by TemplatePlazza
modules/mod_responsivebannerslider/helper.php
modules/mod_responsivebannerslider/tmpl/default.php
Please Log in or Create an account to join the conversation.
- Posted by CCANSW (31) Offline
- Posted by CCANSW (31) Offline
Sorry, no luck.
I had disabled the Responsive Banner modules a few hours ago because there was a suggestion that the high frequency of the exceptions was contributing to load & resource issues and crashes we were experiencing with our VPS. This seemed to be correct;
I changed the files as you directed, cleared the CMS cache, and re-enabled the Responsive Banner Modules. The exceptions returned immediately, about one every 30 seconds or so. CPU usage also rose dramatically.
I have disabled the modules again.
Just looking at the issue of the PRIMARY KEY, this was the Message:
Looking at the #_banner_records table, there are no records for "2021-03-04 03:00:59-1-47"
I've gone back on a few of the previous exceptions and am seeing the same, i.e. there is never a record for the one date/ time value cited in the exception message.
That seems very curious.
Finally, checking the logs I see very high mysql server loads when the module is enabled.
Note the above is on our live VPS running PHP 7.4 - I haven't tested on my local copy that's on 7.2.
Let me know if there's anything else I can do to help.
3 years 9 months ago #18
by CCANSW
I had disabled the Responsive Banner modules a few hours ago because there was a suggestion that the high frequency of the exceptions was contributing to load & resource issues and crashes we were experiencing with our VPS. This seemed to be correct;
I changed the files as you directed, cleared the CMS cache, and re-enabled the Responsive Banner Modules. The exceptions returned immediately, about one every 30 seconds or so. CPU usage also rose dramatically.
I have disabled the modules again.
Just looking at the issue of the PRIMARY KEY, this was the Message:
Line: 200
Message: Duplicate entry '2021-03-04 03:00:59-1-47' for key 'PRIMARY'Looking at the #_banner_records table, there are no records for "2021-03-04 03:00:59-1-47"
I've gone back on a few of the previous exceptions and am seeing the same, i.e. there is never a record for the one date/ time value cited in the exception message.
That seems very curious.
Finally, checking the logs I see very high mysql server loads when the module is enabled.
Note the above is on our live VPS running PHP 7.4 - I haven't tested on my local copy that's on 7.2.
Let me know if there's anything else I can do to help.
Please Log in or Create an account to join the conversation.