Comments (14)
php
7.0 или выше? Проблема вот тут сессия будет пустой после выполнения предыдущего метода (dbConfig
) StaticSession
если он конечно всё ещё используется, работает как-то неправильно, подробностей не помню, но этого должно быть достаточно для оперативного решения проблемы
from dotplant2.
from dotplant2.
My config:
Fedora release 27 Linux 4.14.8-300.fc27.x86_64
Apache/2.4.29
PHP 7.1.12
mysql Ver 15.1 Distrib 10.2.9-MariaDB
from dotplant2.
from dotplant2.
@Philosoft, спасибо, помогает! Если в методе getDbConfigFromSession подставить свои данные, то установка продолжается, но заканчивается с ошибкой 'SQLSTATE[23000]: Integrity constraint violation':
$ ./installer
installer is running in console
Checking permissions
[ OK ] @app/config/db-local.php
[ OK ] @app/config/web-local.php
[ OK ] @app/config/common-local.php
[ OK ] @app/config/common-configurables.php
[ OK ] @app/config/console-configurables.php
[ OK ] @app/config/web-configurables.php
[ OK ] @app/config/kv-configurables.php
[ OK ] @app/config/aliases.php
Enter language(ie. ru, zh-CN, en) [en]
Enter your database configuration:
-> db_host [localhost]
-> db_name [dotplant]
-> username [root]
-> password [Password]
-> schemaCacheDuration [86400]
-> schemaCache [cache]
Running migrations...
-> username [admin]
-> password Password
-> email [[email protected]]
Exception 'yii\db\IntegrityException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (dotplant.auth_assignment, CONSTRAINT auth_assignment_ibfk_1 FOREIGN KEY (item_name) REFERENCES auth_item (name) ON DELETE CASCADE ON UPDATE CASCADE)
The SQL being executed was: INSERT INTO auth_assignment (item_name, user_id) VALUES ('admin', '1')'
in /var/www/dotplant2/application/vendor/yiisoft/yii2/db/Schema.php:636
Error Info:
Array
(
[0] => 23000
[1] => 1452
[2] => Cannot add or update a child row: a foreign key constraint fails (dotplant.auth_assignment, CONSTRAINT auth_assignment_ibfk_1 FOREIGN KEY (item_name) REFERENCES auth_item (name) ON DELETE CASCADE ON UPDATE CASCADE)
)
Stack trace:
#0 /var/www/dotplant2/application/vendor/yiisoft/yii2/db/Command.php(856): yii\db\Schema->convertException(Object(PDOException), 'INSERT INTO `au...')
#1 /var/www/dotplant2/application/modules/installer/components/InstallerHelper.php(146): yii\db\Command->execute()
#2 /var/www/dotplant2/application/modules/installer/commands/InstallController.php(162): app\modules\installer\components\InstallerHelper::createAdminUser(Object(app\modules\installer\models\AdminUser), Object(yii\db\Connection))
#3 /var/www/dotplant2/application/modules/installer/commands/InstallController.php(139): app\modules\installer\commands\InstallController->adminUser()
#4 /var/www/dotplant2/application/modules/installer/commands/InstallController.php(110): app\modules\installer\commands\InstallController->migration()
#5 /var/www/dotplant2/application/modules/installer/commands/InstallController.php(66): app\modules\installer\commands\InstallController->dbConfig()
#6 /var/www/dotplant2/application/modules/installer/commands/InstallController.php(56): app\modules\installer\commands\InstallController->language()
#7 [internal function]: app\modules\installer\commands\InstallController->actionIndex()
#8 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#9 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)
#10 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Controller.php(128): yii\base\Controller->runAction('index', Array)
#11 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Module.php(523): yii\console\Controller->runAction('index', Array)
#12 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('', Array)
#13 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('', Array)
#14 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request))
#15 /var/www/dotplant2/application/installer(22): yii\base\Application->run()
#16 {main}
from dotplant2.
Базу перед очередной попыткой пробовали чистить? Если нет - попробуйте и заново устанавливайте.
from dotplant2.
@bethrezen, базу удаляю/создаю (drop/create database). Несколько раз проверил.
from dotplant2.
@bethrezen, таблица auth_item пустая. Миграции, заполняющие auth_item, не отработали?
from dotplant2.
@musdevs попробуйте веб-версию установщика
from dotplant2.
@bethrezen веб-версия - это скрипт https://github.com/DevGroup-ru/dotplant2/blob/master/application/web/installer.php ? В документации нигде не нашел информации о нем, только о консольном. Плохо искал?
from dotplant2.
Веб-версия тоже завершается ошибкой:
Exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UNSIGNED NOT NULL,
name
VARCHAR(255) NOT NULL,
description
TEXT DEFAULT NU' at line 5
The SQL being executed was: CREATE TABLE backgroundtasks_task
(
id
INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
action
VARCHAR(255) NOT NULL,
type
enum('EVENT','REPEAT') NOT NULL DEFAULT 'EVENT',
initiator
INT UNSIGNED UNSIGNED NOT NULL,
name
VARCHAR(255) NOT NULL,
description
TEXT DEFAULT NULL,
params
TEXT DEFAULT NULL,
init_event
VARCHAR(255) DEFAULT NULL,
cron_expression
VARCHAR(255) DEFAULT NULL,
status
enum('ACTIVE','STOPPED','RUNNING','FAILED','COMPLETED', 'PROCESS') NOT NULL DEFAULT 'ACTIVE',
ts
TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
fail_counter
TINYINT UNSIGNED NOT NULL DEFAULT'0',
options
TEXT,
KEY name
(name
)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB'
in /var/www/dotplant2/application/vendor/yiisoft/yii2/db/Schema.php:636
Error Info:
Array
(
[0] => 42000
[1] => 1064
[2] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UNSIGNED NOT NULL,
name
VARCHAR(255) NOT NULL,
description
TEXT DEFAULT NU' at line 5
)
Stack trace:
#0 /var/www/dotplant2/application/vendor/yiisoft/yii2/db/Command.php(856): yii\db\Schema->convertException(Object(PDOException), 'CREATE TABLE `b...')
#1 /var/www/dotplant2/application/vendor/yiisoft/yii2/db/Migration.php(288): yii\db\Command->execute()
#2 /var/www/dotplant2/application/migrations/m150531_084444_new_init.php(1026): yii\db\Migration->createTable('{{%backgroundta...', Array, 'CHARACTER SET u...')
#3 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(654): m150531_084444_new_init->up()
#4 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(166): yii\console\controllers\BaseMigrateController->migrateUp('m150531_084444_...')
#5 [internal function]: yii\console\controllers\BaseMigrateController->actionUp(0)
#6 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#7 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Controller.php(156): yii\base\InlineAction->runWithParams(Array)
#8 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Controller.php(128): yii\base\Controller->runAction('up', Array)
#9 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Module.php(523): yii\console\Controller->runAction('up', Array)
#10 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction('migrate/up', Array)
#11 /var/www/dotplant2/application/vendor/yiisoft/yii2/console/Application.php(147): yii\console\Application->runAction('migrate/up', Array)
#12 /var/www/dotplant2/application/vendor/yiisoft/yii2/base/Application.php(380): yii\console\Application->handleRequest(Object(yii\console\Request))
#13 /var/www/dotplant2/application/yii(22): yii\base\Application->run()
#14 {main}
from dotplant2.
Сколько раз не устанавливал и каким только способом не ставил, но с РНР 7.0 и выше работать не хочет, выдает ошибки...По ходу проект заброшен(( А так приложение прекрасное!
from dotplant2.
@gelamac74 таки да, заброшен. Но с php 7 раньше у нас всё работало
from dotplant2.
@gelamac74 таки да, заброшен. Но с php 7 раньше у нас всё работало
Здравствуйте!
Мне все-таки удалось уставновить приложение на PHP7 именно PHP 7.0 и вроде все работает, за исключением всего одной, т.е это не ошибка, а предупреждение “Headers already sent” . Видимо где-то в файле лишний пробел, будет время попробую исправить. Буду тестировать, позже отпишусь.
Headers already sent in /var/www/restaf/public_html/vendor/yiisoft/yii2/web/Response.php on line 414. in /var/www/restaf/public_html/vendor/yiisoft/yii2/web/Response.php:366 Stack trace: #0 /var/www/restaf/public_html/vendor/yiisoft/yii2/web/Response.php(339): yii\web\Response->sendHeaders() #1 /var/www/restaf/public_html/vendor/yiisoft/yii2/web/ErrorHandler.php(135): yii\web\Response->send() #2 /var/www/restaf/public_html/vendor/yiisoft/yii2/base/ErrorHandler.php(262): yii\web\ErrorHandler->renderException(Object(yii\base\ErrorException)) #3 [internal function]: yii\base\ErrorHandler->handleFatalError() #4 {main} thrown in /var/www/restaf/public_html/vendor/yiisoft/yii2/web/Response.php on line 366
from dotplant2.
Related Issues (20)
- How to show product's options HOT 2
- Base table or view not found: HOT 1
- [enh] seo-friendly bold in wysiwyg-editor
- [ui] [enh] implement tabs for backend-category/edit
- dotplant2 installation incomplete HOT 1
- running in windows
- successful installation but the frontend and admin pages not showing properly HOT 7
- lots of installation issue HOT 1
- Не работает загрузка изображений в админ панели HOT 4
- Hello, I'm trying to study the dotplant2 source code, [category_eav] what is the purpose of this table HOT 1
- 111
- migration database HOT 1
- Getting unknown property: yii\console\Application::session HOT 4
- Price filter
- ошибка с composer install / update HOT 1
- Проблема при загрузке фото для товара
- Проблема при установке на php 7.3 HOT 4
- XXE Vulnerability HOT 1
- Опечатка в миграции таблицы backgroundtasks_task
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dotplant2.