Viewing 10 posts - 1 through 10 (of 10 total)
Author
Posts
  • #13572

    My web host upgraded mySQL to 8.0. When I logged back into my site, I couldn’t.
    PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘SQL_CACHE’ in ‘field list’ in /home/ftprbc/mydomain/library/KT/DBStatement.php:87 Stack trace: #0 /home/ftprbc/mydomain/library/KT/DBStatement.php(87): PDOStatement->execute() #1 /home/ftprbc/mydomain/library/KT/DBStatement.php(137): KT_DBStatement->__call(‘execute’, Array) #2 /home/ftprbc/mydomain/library/KT/Site.php(39): KT_DBStatement->fetchAssoc() #3 /home/ftprbc/mydomain/includes/db_schema/db_schema_0_1.php(30): KT_Site::preference(‘KT_SCHEMA_VERSI…’, 1) #4 /home/ftprbc/mydomain/library/KT/DB.php(253): require(‘/home/ftprbc/al…’) #5 /home/ftprbc/mydomain/includes/session.php(277): KT_DB::updateSchema(‘/home/ftprbc/al…’, ‘KT_SCHEMA_VERSI…’, 42) #6 /home/ftprbc/mydomain/index.php(25): require(‘/home/ftprbc/al…’) #7 {main}

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13573

    It’s disappointing that any web host should upgrade your database without warning like that.

    Currently kiwitrees is not compatible with MySQL 8. I wasn’t planning on changing that before mid- 2022 as there are other priorities.

    I can investigate fixing the SQL_CACHE issue as that does not negatively impact any other sites, but I cannot yet tell you what other issues might arise even once that is fixed.

    I will try to release a 3.3.10 version of kiwitrees during November with the SQL_CACHE Included.

    There is no earlier or simple fix I can offer you. Hopefully your web host can offer a service that uses MySQL 5

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #13574

    They did give notice. I didn’t think to contact you first. Will email them for assistance in the interim.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13575

    If it helps when talking to them, this is the official page from Oracle, developers of MySQL, confirming the end of life for version 5.7 is not until October 2023

    https://endoflife.software/applications/databases/mysql

    Nigel
    My personal kiwitrees site is www.our-families.info
  • #13576

    I’m in the queue for the mySQL support team but in the meantime, inquired about the upgrade per your information. One year in advance is a bold step to take.
    Oh well, I have a season of a TV-show to binge-watch in the meantime.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13577

    Good temporary news. Dreamhost found a server that’s last in the queue for upgrading so will move all mySQL databases there. That said, it too will be graded by end of year. No options.

    Asked for as much notice as possible so I can find out where you’re at with making kitwiTrees compatible. Quite a predicament. “November” seemed so far off when they sent notice. Should have emailed you immediately and now I’m paying the price.

    I have my Reunion offline version that I’m working with. It’s not 100% in sync but doesn’t matter for what I’m doing. For most of the records I’ve recorded the record number (yup, that number you “hate”) so will be easily able to update each record.

    They’re to notify me when the move is done.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13578

    The move is done. Not sure if there are particular items I should test to make sure all is well but had no problems with login to all four. (only 3 of 4 are in my signature)

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13579

    Dreamhost replied that move is complete. As mentioned, I’m on borrowed time, literally. They will give ONE WEEK notice before upgrading to mySQL 8 which is sent before year end.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13581

    URGENT
    Dreamhost just sent notice that on November 16 they’ll be upgrading mySQL on the servers my sites on on. That will make them inaccessible unless kiwitrees supports version 8.

    Any headway?

    I gather if I put up the “out of order” page it won’t display?

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

  • #13600

    Whew. Just got bit more time. The notice I got for Nov 16 was for mySQL on my other domain that does have an old install of my databases. Still working to ready my active ones to temp directory and do install of test.

    -----
    [updated: 06 Aug 2021]
    MacOS: 10.15.7  (Catalina)
    Safari   14.0.3;  Firefox 9.0.2
    PHP 7.4.5 FastCGI

    Alter-Drukarsh connections... 3.3.9 <private>
    The Royals 3.3.9

    The Gerrer Rebbes 3.3.9

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.