Digin
May 14, 2022, 9:38am
1
To be completed by the original poster:
CMS Version
2.3.9
Installation Method
Custom install (shared hosting)
Operating System
php 7.4
Issue
I try to upgrade from 2.3.9 to 3.1.2 using the following command starting from the base folder of xibo
vendor/bin/phinx migrate -c phinx.php
The result is:
Phinx by CakePHP - https://phinx.org. 0.9.2
using config file ./phinx.php
using config parser php
using migration paths
-/home/xxxxxxx/public_html/xibo/db/migrations
warning no environment specified, defaulting to: production
using adapter mysql
using database xxxxxxx_xibo-v20
All Done. Took 0.0124s
But Xibo is still on verion 2.3.9
Did I forgot something?
Hi!
Take a look in this topics, im pretty sure that will help you:
basically you need:
PHP 7.2
pay attention to all php.ini configuration requirements reported by Xibo
Delete the 1.8.11 files, keeping only the ‘web/settings.php’ file (that is your database connection)
Paste the new CMS V2.3 files into the old CMS files folder
Configure the folder ‘vendor/bin’ according to the topic below:
Open CMD in administrator mode, and run the command:
'php vendor/bin/phinx migrate -c phinx.php'
You have migrated to version 2.3, now do the same process, updating …
If the error persists, you may need to follow these steps:
Hi,
Ironically I ran into this too - root cause for me was the aouth_clients table being latin1 instead of utf8.
I think this would solve it
ALTER TABLE `aouth_clients` CHARACTER SET utf8 COLLATE utf8_general_ci
Edit: bug created for this here:
Thanks,
Dan
Hi Dan and Natasha!
Thank’s again for the answer!
For me it was also necessary to update the Collation of the Columns to utf8_general_ci
ALTER TABLE `oauth_clients`
CHANGE COLUMN `id` `id` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
CHANGE COLUMN `secret` `secret` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ,
CHANGE COLUMN `name` `name` VARCHAR(254) CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' NOT NULL ;
But it works for me.
Thank you!
Digin
May 15, 2022, 10:49am
3
Hi, thanks for your reply. I will try this.
system
Closed
August 14, 2022, 4:49pm
4
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.