Upgrading to xibo v2, unable to do database migrations


#1

Hello,
my Xibo installation is running on XAMP 7.3 (Windows Server) and I want to upgrade to version 2.0.0.

When I run command “php vendor/bin/phinx migrate” I get this error:

PHP Warning: require(C:\xampp\htdocs\xibo\vendor\bin/…/app/phinx.php): failed
to open stream: No such file or directory in C:\xampp\htdocs\xibo\vendor\bin\phi
nx on line 27

Warning: require(C:\xampp\htdocs\xibo\vendor\bin/…/app/phinx.php): failed to op
en stream: No such file or directory in C:\xampp\htdocs\xibo\vendor\bin\phinx on
line 27
PHP Fatal error: require(): Failed opening required ‘C:\xampp\htdocs\xibo\vendo
r\bin/…/app/phinx.php’ (include_path=‘C:\xampp\php\PEAR’) in C:\xampp\htdocs\xi
bo\vendor\bin\phinx on line 27

Fatal error: require(): Failed opening required ‘C:\xampp\htdocs\xibo\vendor\bin
/…/app/phinx.php’ (include_path=‘C:\xampp\php\PEAR’) in C:\xampp\htdocs\xibo\ve
ndor\bin\phinx on line 27

I run this command in xibo root directory, please see attached image.

If I run this command in xibo\web\install folder, I get this error:

Could not open input file: vendor/bin/phinx

Primjedba%202019-03-20%20125234

What I am doing wrong?


Xibo Upgrade to 2.0.1 Database Migration
#2

The correct comand is

php vendor/bin/phinx migrate -c phinx.php

That should be run in the root of the install directory (where you find the vendor folder, and phinx.php)


#3

I have tried that now, but get the same error.
Please see attached image:
Primjedba%202019-03-21%20094036


#4

What version of PHP are you using?


#5

I’m running PHP version 7.3.0.


#6

Apparently on Windows you need to:

Download https://raw.githubusercontent.com/cakephp/phinx/master/bin/phinx.bat and save it in to the vendor\bin folder.

Then run instead

vendor\bin\phinx migrate -c phinx.php

Note also that you should not have the whole CMS source tree inside your htdocs folder. Hopefully you’ve set your webserver web root to be just the web folder inside the Xibo code.

We’ve not tested with PHP 7.3 yet so you may encounter issues in that regard too.


Upgrading to xibo v2 temporarily off-line
#7

That didn’t work, but I have succefully solved it.

Here is how:

  1. Copy folder “app” from “vendor\robmorgan\phinx” to “vendor\bin”

  2. Copy folder “src” from “vendor\robmorgan\phinx” to “vendor\bin\app”

  3. In folder “vendor\bin” using Notepad edit file “phinx”:
    change line
    $app = require DIR . ‘/…/app/phinx.php’;

    to

    $app = require DIR . ‘/app/phinx.php’;

  4. In folder “vendor\bin\app” using Notepad edit file “phinx.php”:
    change line
    $autoloader = require DIR . ‘/…/src/composer_autoloader.php’;

    to

    $autoloader = require DIR . ‘/src/composer_autoloader.php’;

  5. Run this command: php vendor\bin\phinx migrate -c phinx.php

Couple of seconds later, migration is complete and I can login to my Xibo.

Now Xibo 2.0.0 is running with PHP 7.3 :slight_smile: