#1439 ✓resolved
Peter

British Trolleybus Society - Can't Add Modules

Reported by Peter | October 15th, 2018 @ 09:23 AM | in 2.5.2

At some point in the last month or so, a problem has occurred which has only just been noticed.

It is no longer possible to add new modules to a page. You go through the screen for adding the module, but when you OK back it's not there.

I can send you a login password for user lighthouse - please confirm how to do this securely.

Thanks.
Peter.

Comments and changes to this ticket

  • Peter
  • dleffler
  • dleffler

    dleffler October 23rd, 2018 @ 12:03 PM

    • Milestone set to User issues

    I suspect the server was upgraded to mysql v5.7 and the new default of 'strict' mode prevents creating records. For the fix see http://forums.exponentcms.org/discussion/1556/fix-problems-running-...

  • Peter

    Peter October 23rd, 2018 @ 12:19 PM

    I've escalated this to UK2 2nd line support, still awaiting a response. Peter.

  • dleffler

    dleffler November 15th, 2018 @ 01:44 PM

    • State changed from “new” to “knownissue”
  • Peter

    Peter November 15th, 2018 @ 01:51 PM

    Just to complete the picture from this end: UK2 made the change to strict on MySQL with a PHP update. They are not prepared to revert. As a temporary measure I have moved the database only to my Fasthosts account. Update capabilities are restored, but it runs noticeably slower with the db not in-house at UK2.

  • Peter

    Peter October 29th, 2019 @ 02:48 PM

    Hi Dave. I've not been able to keep tabs on this since a year ago. As we left it, I moved the MySQL database to another platform as the web site host had updated MySQL to enforce Strict. With no access to the actual (shared) server, we've lived with this since - works fine although doing updates is a bit slow!

    Is this an issue that you may have resolved in the last year, is it perhaps in 2.5.1? When will that be available please? I'm still at 2.4.2.

    I am currently handing over to a new Webmaster, so am trying to sort out what he may need to do!!

    Many thanks.
    Peter.

  • Peter

    Peter December 9th, 2019 @ 04:52 PM

    Hi Dave. I appreciate you're busy, but now I've handed over my webmaster duties I am still left with the responsibility of sorting out this issue. At some point in the not-too-distant future I'd really like to get the database moved back to the same provider as Exponent. Right now the database is on my own account at Fasthosts where I can't allow the new webmaster access.

    Please could you let me know if this issue has been resolved in any updates or is it still outstanding? If the latter, when might it be resolved please? It's over a year since the last update.

    Thanks.
    Peter.

  • dleffler

    dleffler December 9th, 2019 @ 05:37 PM

    There have really been not changes in this area of code. I was able to get my shared host provider to change the my.ini setting since many different apps doe NOT work under mysql strict mode

    [mysqld]
    sql_mode = 'NO_ENGINE_SUBSTITUTION'
    
  • Peter

    Peter December 10th, 2019 @ 09:45 AM

    I did try this, but they refused. I can try again, but don't hold your breath! Peter.

  • Peter

    Peter March 5th, 2020 @ 02:08 PM

    Hi Dave. Just looked at the changes in the new release 2.5.x - no mention of this issue so I wondered if there's any plans to fix it in the code please??

    I have been around the houses again pn changing sql_mode without success. I've looked at alternative ISPs but am left with Fasthosts hosting the database and the site at UK2. Nobody wants to change their shared servers. The only way I can potentially get everything back under one roof is to rent a VPS and transfer into that. Because this site is for a charity with limited resources, it is doubtful they will fund the somewhat higher costs.

    I do hope you can plan this in soon.

    Thanks.
    Peter.

  • dleffler

    dleffler March 5th, 2020 @ 05:35 PM

    v2.5.1 doesn't include any fix for MySQL 'strict' mode. It's mostly a set of patches but all the files had the copyright updated to 2020 so was released as a full version.

  • Peter

    Peter March 5th, 2020 @ 05:43 PM

    Yes, I understand that and did say so. My question was, do you have any plans to fix this long-standing problem that puts us at the mercy of inflexible ISPs?

    Thanks.
    Peter.

  • dleffler

    dleffler March 10th, 2020 @ 07:14 PM

    • Milestone changed from User issues to 3.0.0

    I may have a fix. It seems to work locally. It would be 'shipped' as v2.5.1patch1. Not sure if it'd update an existing database, but would likely work to create a new database, then accomplish a restore database using the .eql file backup.

  • dleffler

    dleffler March 10th, 2020 @ 09:49 PM

    I've got another fix which should update an existing db to set/change the Nullable field column.

  • Peter

    Peter March 11th, 2020 @ 09:23 AM

    Sounds hopeful. Thanks. I'll probably need to wait a little while depending when you release. This and next month are the peak times for membership renewals, but then it should quieten down. Peter.

  • dleffler

    dleffler March 12th, 2020 @ 02:30 PM

    • State changed from “knownissue” to “resolved”
    • Milestone changed from 3.0.0 to 2.5.2

    Recent code push now works with MySQL in 'strict' mode

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Bug Tracker for Exponent CMS

Shared Ticket Bins

People watching this ticket

Attachments

Pages