Jump to content
Sign in to follow this  
ChrisColeman

MySql Upgrade ...

Recommended Posts

Hi,

      my server keeps telling me to upgrade mySQL .

However there seems to be a particular constraint which has me slightly puzzled ..

Quote

MySQL enables "strict mode" by default as of version 5.7. Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MySQL are compatible before upgrading.

Will this effect me (I guess), and do you know which sqlMode should be chosen. I am a bit concerned about the effects of playing with the sqlMode on a running database, will my databases be corrupted?

Many Thanks ..

Chris.

 

Share this post


Link to post
Share on other sites

When CubeCart starts up to create a page, the database class is instantiated. When this happens, CubeCart sends a command to the database server to switch out of strict mode. See /classes/db/mysqli.class.php, the private function _setup().

CubeCart is not coded to be strict-compliant.

A database server being in strict mode was a problem for CC3/4 and some early versions of CC5, until the function _setup() became part of the database class.

Share this post


Link to post
Share on other sites

Having just gone through updating from 5.6 to 5.7, I asked the same question and had the same concerns.
My update only took about 10 minutes at the most.

As for strict mode, i disabled it anyway , I was also concerned about the implications of the update failing and being stuck between versions.

The following might help.

 

disable strict mode

Backup all MySQL Databases?

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...