Skidoo
April 8, 2019, 3:45pm
1
After initiating my Xibo 2.0.1 CMS fresh installation on Windows Server 2012r2 I received this error message and the dump:
#0 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Db\Adapter\PdoAdapter.php(134): PDO->exec(’\nINSERT INTO s...') #1 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Db\Adapter\AdapterWrapper.php(171): Phinx\Db\Adapter\PdoAdapter->execute('\nINSERT INTO
s…’) #2 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Migration\AbstractMigration.php(221): Phinx\Db\Adapter\AdapterWrapper->execute(’\nINSERT INTO s...') #3 C:\PHP_FILES\db\migrations\20180130073838_install_migration.php(1131): Phinx\Migration\AbstractMigration->execute('\nINSERT INTO
s…’) #4 C:\PHP_FILES\db\migrations\20180130073838_install_migration.php(57): InstallMigration->addData() #5 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Migration\Manager\Environment.php(127): InstallMigration->up() #6 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Migration\Manager.php(375): Phinx\Migration\Manager\Environment->executeMigration(Object(InstallMigration), ‘up’) #7 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Migration\Manager.php(351): Phinx\Migration\Manager->executeMigration(‘production’, Object(InstallMigration), ‘up’) #8 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Console\Command\Migrate.php(115): Phinx\Migration\Manager->migrate(‘production’, NULL) #9 C:\PHP_FILES\vendor\symfony\console\Command\Command.php(264): Phinx\Console\Command\Migrate->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\StreamOutput)) #10 C:\PHP_FILES\vendor\symfony\console\Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\StreamOutput)) #11 C:\PHP_FILES\vendor\symfony\console\Application.php(228): Symfony\Component\Console\Application->doRunCommand(Object(Phinx\Console\Command\Migrate), Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\StreamOutput)) #12 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Console\PhinxApplication.php(86): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\StreamOutput)) #13 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Wrapper\TextWrapper.php(243): Phinx\Console\PhinxApplication->doRun(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\StreamOutput)) #14 C:\PHP_FILES\vendor\robmorgan\phinx\src\Phinx\Wrapper\TextWrapper.php(129): Phinx\Wrapper\TextWrapper->executeRun(Array) #15 C:\PHP_FILES\lib\Helper\Install.php(221): Phinx\Wrapper\TextWrapper->getMigrate() #16 C:\PHP_FILES\lib\routes-install.php(51): Xibo\Helper\Install->Step3(Object(Xibo\Storage\PdoStorageService)) #17 [internal function]: {closure}(‘3’) #18 C:\PHP_FILES\vendor\slim\slim\Slim\Route.php(468): call_user_func_array(Object(Closure), Array) #19 C:\PHP_FILES\vendor\slim\slim\Slim\Slim.php(1355): Slim\Route->dispatch() #20 C:\PHP_FILES\vendor\slim\slim\Slim\Middleware\Flash.php(85): Slim\Slim->call() #21 C:\PHP_FILES\vendor\slim\slim\Slim\Middleware\MethodOverride.php(92): Slim\Middleware\Flash->call() #22 C:\PHP_FILES\vendor\slim\slim\Slim\Slim.php(1300): Slim\Middleware\MethodOverride->call() #23 C:\PHP_FILES\web\install\index.php(134): Slim\Slim->run() #24 {main}
Anyone have a suggestion that could resolve this issue?
Andre
alex
April 8, 2019, 4:57pm
2
What version of MySQL are you using please?
Skidoo
April 8, 2019, 7:39pm
3
I am using MySQL Version 5.6.35.0 on IIS 8 and PHP 5.6.
The fresh Xibo installation is 2.0.1 (the latest release).
Andre
Skidoo
April 8, 2019, 7:48pm
4
This was what I had in the install_log file:
[2019-04-08 11:43:21] INSTALL.INFO: Installer Step 1 [] {“uid”:“7c2affc”,“method”:“GET”,“route”:"/"}
[2019-04-08 11:46:00] INSTALL.INFO: Installer Step 1 [] {“uid”:“cf96565”,“method”:“GET”,“route”:"/"}
[2019-04-08 11:46:03] INSTALL.INFO: Installer Step 2 [] {“uid”:“af5c1a1”,“method”:“GET”,“route”:"/2"}
[2019-04-08 11:46:59] INSTALL.INFO: Installer Step 3 [] {“uid”:“72aca02”,“method”:“POST”,“route”:"/3"}
[2019-04-08 11:46:59] INSTALL.INFO: Setting unlimited max execution time. [] {“uid”:“72aca02”,“method”:“POST”,“route”:"/3"}
alex
April 9, 2019, 1:24pm
5
I can replicate this locally with MySQL 5.7 but not with 5.6.
I’ve logged an issue for it here:
The fix that is developed for that may work to resolve this for you. I’m not 100% sure since on 5.6 it works OK for me as it stands.
Skidoo
April 9, 2019, 1:46pm
6
When will release 2.0.2 be released with this bug fix?
Nanno
April 10, 2019, 4:57pm
7
I have the same error.
I use Ubuntu 18.04.1
I think the problem is with mysql version:
mysql Ver 14.14 Distrib 5.7.25
Skidoo
April 10, 2019, 5:30pm
8
After removing MySQL 5.6 and installing 5.7, I still encountered the same error message.
Skidoo
April 12, 2019, 3:23pm
9
Since I was not getting much help from the community I decided to dig into this error a bit more in a hope it will isolate the issue. So I started with a fresh PHP installation and found in code in the “migration.php” file that created the tables that were causing me errors.
->addColumn(‘title’, ‘string’, [‘limit’ => 50])
Changed this to read
->addColumn(‘title’, ‘string’, [‘limit’ => 255])
and
->addColumn(‘installName’, ‘string’, [‘limit’ => 254])
Change it to read
->addColumn(‘installName’, ‘string’, [‘limit’ => 254, ‘default’ => null, ‘null’ => true])
This actually solved the error messages I was getting and completed the installation. However, I am now get a message when its at the login:
Unexpected Error, please contact support.
I am hoping this might help point to the source that folks are having with SQL.
Andre
Skidoo
April 12, 2019, 3:24pm
10
The migration.php file is located under the “db” directory
Skidoo
April 12, 2019, 7:31pm
11
Can someone confirm if the new version of Xibo has the following columns under “setting”?
SettingID
Setting
Value
UserSee
UserChange
After reviewing the bugs in the latest code release 2.0.1 and earlier, I would not recommend that anyone use it on a Windows custom build without first manually applying all the patches to the script files. After I manually fixed all their known bugs, the installation of Xibo was flawless. I wish they just added the code changes to their release and avoid others from experiencing all these issues.
Link to patches that fixed Xibo 2.0.1
I should note that I did not make changes to the docker-compose-MySQL-5.7.yml file since Docker is not used in my installation.
Also, for those migrating from an earlier release of Xibo, you might need to make these changes for the migration to work.
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\v…