Installation, Configuration, & Upgrades  :: 
MySQL 3.23 -- PostNuke or Drupal?
 Top

  • tcochran
    tcochran
    Softmore
    • rank: Softmore
    • registered: July 2003
    • last visit: 31.03.08
    • Posts: 89
    Posted: 06.12.2006, 20:32
    I have a client who wants a new site installed on a server which is still running MySQL 3.23. The host acknowledges that this is old software, but says it still works well. The latest version of Drupal runs fine there, as does PostNuke 0.762. From what I read in the forums, neither upgrade to 0.764 nor new PostNuke install can be done with that version of MySQL, right? If the hosting company will not switch to > MySQL 4.0, then am I stuck changing to Drupal?

    --
    Terry Cochran

    Boomernet - WashtenawWeb
  • larsneo
    larsneo
    Software Foundation
    • rank: Software Foundation
    • registered: December 1969
    • last visit: 14.12.08
    • Posts: 4482
    Posted: 06.12.2006, 21:49

    Quote

    If the hosting company will not switch to > MySQL 4.0, then am I stuck changing to Drupal?

    at least you can't run PostNuke on this type of outdated DB-server, sorry.

    Quote

    The host acknowledges that this is old software, but says it still works well.

    maybe http://www.planetmysql.org/kaj/?p=56 convinces the host to update - especially since even mysql dropped support for 3.x databases. btw: mysql 4.1 (the minimum requirement) is available since 2004-10-23 icon_rolleyes

    --
    regards from germany
    ..::[Zikula Application Framework]::.. ..::[SEO-Blog]::.. ..::[CMS Sicherheit]::..
  • tcochran
    tcochran
    Softmore
    • rank: Softmore
    • registered: July 2003
    • last visit: 31.03.08
    • Posts: 89
    Posted: 07.12.2006, 00:57
    Understood. It just seems strange that you would use a simple maintenance release as the vehicle to bar thousands of servers around the world from being able to use the latest PostNuke code -- many website owners can not directly control what version of MySQL their hosts make available to them. Was the new requirement for > MySQL 4.0 needed fot the security fixes in PostNuke 0.763 or 0.764?

    --
    Terry Cochran

    Boomernet - WashtenawWeb
  • Simon
    Simon
    Steering Committee
    • rank: Steering Committee
    • registered: December 2002
    • Posts: 13427
    Posted: 07.12.2006, 03:12
    The new requirement of MySQL 4.1 represents the evolving PostNuke codebase - modifications made to the code over the course of the .76 release have meant that incompatibilities with MySQL 3.x have been introduced, therefore necessitating the increase in version requirement. Since MySQL 3.x is now very out of date and no longer supported by MySQL themselves we do not see this as a problem.

    If your host does not upgrade MySQL then they are probably not a host you will want to stay with long term. The older the version of software you are running the more likely it is to be insecure and the more likely applications you want to use will no longer work on your system. There are already a number of popular open source PHP5 only scripts, but if your host can't be bothered to upgrade PHP either then you'll be left behind there too.

    Often your host is able to move you to a server with a newer version of MySQL on it if you ask. If not, I would recommend a new host.

    --
    Regards,
    Simon

    itbegins.co.uk - Zikula Consulting

    Please read the Support Guide
  • tcochran
    tcochran
    Softmore
    • rank: Softmore
    • registered: July 2003
    • last visit: 31.03.08
    • Posts: 89
    Posted: 13.12.2006, 04:41
    UPDATE: The good news is that after almost a week of frequent conversations, the hosting company DID upgrade the server to include MySQL 4.1 -- even though they first said that was not possible AND this is not something they routinely offer. So if you currently do not have at least MySQL 4.1 on your server, keep asking for it. As Simon said above, the host will often comply with this type of change, if you ask (persistently).

    The bad news, however, is that there were 6 PostNuke sites on that server. 2 transferred perfectly, 3 have minor errors now which need to be debugged, and 1 refuses to display at all -- Blank Page on screen, blank source code in browser, etc.

    So the moral of the story is that upgrading will certainly be worthwhile in the long run -- but be prepared for a variety of unintended consequences, as each website will likely react differently. Only upgrade your version of MySQL when you have time to monitor your site(s) and track down the new errors, one by one.

    --
    Terry Cochran

    Boomernet - WashtenawWeb
  • AGlossop
    Helper
    • rank: Helper
    • registered: March 2004
    • last visit: 13.03.07
    • Posts: 164
    Posted: 18.02.2007, 22:46

    HammerHead

    If your host does not upgrade MySQL then they are probably not a host you will want to stay with long term.


    I'm using Webfusion, a part of Pipex. Their servers use MySQL 3.23 :( It's a big job to move a dozen websites onto new servers, so I'm stuck.

    I understand why it's happened, but surely it would have made sense to 1) tell people (NOTHIN in the release info - 0.764, 2) make the change for .8, instead of 0.7xx

    http://www.webfusion…argest_web_host.php



    edited by: AGlossop, Feb 18, 2007 - 05:58 PM

Users online

This list is based on the users active over the last 60 minutes.