[Resolved] Need a little help with upgrade

[nootkan]

Been a while since I upgraded my visio list and I am forced to now as I cannot log into it. Seeing a few errors in my logs so I decided to try and upgrade to see if that resolves my issues. Just signed up to get the latest version.

I have version 1.2 on cloud linux centos 7.9 with php 5.6, mysql 5.7.

Went to the install docs and I am a little confused as to how to continue. Walking my way through the steps for each version starting with 1.3 but at 1.6 it says php7.2 is required but on your system requirements page it says it is compatible with PHP from 5.2.6 and up.

Should I continue with the upgrade steps?

 

[Mark]

Hey There, long time! PHP 7.2 is recommended because 5.6 reached end of life a couple years ago. VisioList will still function fine with 5.6 though so you are good to proceed with the update. Since you are upgrading from such an old version, its probably a good idea to remove or disable all plugins before running the updater and then re-add them.

Take a backup of the files and database first so if anythign goes bad you can always roll back easily.

If you need any help, do not hesitate to shoot me a PM with login details and I will ensure everything goes smooth for you.

 

[nootkan]

Hi Mark, yes its been awhile for sure. I'll keep on with the upgrade but I cannot login for some reason or see my topsite page either so I'll remove the plugins via ftp. Let you know how it goes.

 

[nootkan]

Hi Mark, I had to delete everything and do a fresh install. After taking care of issues identified in the initial setup like ffmpeg, shell_exe etc I put in my database information and clicked install only to receive this error message:

Fatal error: Database error in "/home/username/public_html/topsites/install/index.php" on line 1413

BLOB, TEXT, GEOMETRY or JSON column 'description' can't have a default value in /home/username/public_html/topsites/sources/sql/mysql.php on line 98

Does this have something to do with php 5.6?

Went to phpmyadmin and see this in the database:

 

[Mark]

that is a bug in the installer on server running MySQL in strict mode.


Empty your existing database from the incomplete install:

Then open install/index.php

find:

  `description` TEXT default '',

Replace with:

  `description` TEXT,

Re-run the installer and you should be all set.

let me know
Mark

 

[nootkan]

Actually I went into my etc/mycn file and disabled strict mode there and got it to work a few minutes ago. Should I do it your way instead? I do have phpsuexe and suphp installed on the server.

 

[Mark]

Either way will work just fine

 

[cajkan]

I'm running on PHP 8 works really nice thanks to @Basti