0

since yesterday i have been trying to setup Craft CMS for the first time, but the installation fails and tells me to check the logs.

The database account has all rights.

(This is only a part of the log, but this should do)

2020-05-05 07:25:50 [-][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
2020-05-05 07:25:50 [-][-][-][profile begin][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
2020-05-05 07:25:50 [-][-][-][profile end][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;port=3306;dbname=craftycoffee
2020-05-05 07:25:53 [-][-][-][info][yii\db\Command::query] SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1
2020-05-05 07:25:53 [-][-][-][profile begin][yii\db\Command::query] SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1
2020-05-05 07:25:53 [-][-][-][profile end][yii\db\Command::query] SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1
2020-05-05 07:25:53 [-][-][-][error][craft\base\ApplicationTrait::getIsInstalled] There was a problem fetching the info row: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
The SQL being executed was: SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1
2020-05-05 07:25:53 [-][-][-][error][yii\db\Exception] PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php:1293
Stack trace:
#0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1293): PDOStatement->execute()
#1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command->internalExecute('SELECT *\nFROM `...')
#2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command->queryInternal('fetch', NULL)
#3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command->queryOne()
#4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query->one(NULL)
#5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query->one()
#6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application->getInfo(true)
#7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application->getIsInstalled()
#8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites->_loadAllSites()
#9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites->setCurrentSite(NULL)
#10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component->__set('currentSite', NULL)
#11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
#12 [internal function]: yii\base\BaseObject->__construct(Array)
#13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\services\\...', Array, Array)
#15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\services\\...', Array, Array)
#16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
#17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('sites', true)
#18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('sites', true)
#19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application->get('sites')
#20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application->getSites()
#21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request->init()
#22 [internal function]: yii\base\BaseObject->__construct(Array)
#23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Reque...', Array, Array)
#25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Reque...', Array, Array)
#26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
#27 [internal function]: {closure}()
#28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
#29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container->invoke(Object(Closure), Array)
#30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
#31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('request', true)
#32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('request', true)
#33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application->get('request')
#34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application->getRequest()
#35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application->_preInit()
#36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application->init()
#37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject->__construct(Array)
#38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application->__construct(Array)
#39 [internal function]: craft\web\Application->__construct(Array)
#40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Appli...', Array, Array)
#42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Appli...', Array, Array)
#43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
#44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
#45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
#46 {main}

Next yii\db\Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'craftycoffee.info' doesn't exist
The SQL being executed was: SELECT *
FROM `info`
WHERE `id`=1
LIMIT 1 in E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Schema.php:674
Stack trace:
#0 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1298): yii\db\Schema->convertException(Object(PDOException), 'SELECT *\nFROM `...')
#1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command->internalExecute('SELECT *\nFROM `...')
#2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command->queryInternal('fetch', NULL)
#3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command->queryOne()
#4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query->one(NULL)
#5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query->one()
#6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application->getInfo(true)
#7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application->getIsInstalled()
#8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites->_loadAllSites()
#9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites->setCurrentSite(NULL)
#10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component->__set('currentSite', NULL)
#11 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(107): yii\BaseYii::configure(Object(craft\services\Sites), Array)
#12 [internal function]: yii\base\BaseObject->__construct(Array)
#13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\services\\...', Array, Array)
#15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\services\\...', Array, Array)
#16 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Array)
#17 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('sites', true)
#18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('sites', true)
#19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application->get('sites')
#20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application->getSites()
#21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request->init()
#22 [internal function]: yii\base\BaseObject->__construct(Array)
#23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Reque...', Array, Array)
#25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Reque...', Array, Array)
#26 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\config\app.web.php(13): yii\BaseYii::createObject(Array)
#27 [internal function]: {closure}()
#28 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(524): call_user_func_array(Object(Closure), Array)
#29 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(349): yii\di\Container->invoke(Object(Closure), Array)
#30 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\ServiceLocator.php(137): yii\BaseYii::createObject(Object(Closure))
#31 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Module.php(742): yii\di\ServiceLocator->get('request', true)
#32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module->get('request', true)
#33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application->get('request')
#34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application->getRequest()
#35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application->_preInit()
#36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application->init()
#37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject->__construct(Array)
#38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application->__construct(Array)
#39 [internal function]: craft\web\Application->__construct(Array)
#40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass->newInstanceArgs(Array)
#41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container->build('craft\\web\\Appli...', Array, Array)
#42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container->get('craft\\web\\Appli...', Array, Array)
#43 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\bootstrap.php(245): yii\BaseYii::createObject(Array)
#44 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\bootstrap\web.php(51): require('E:\\WAMP\\www\\cra...')
#45 E:\WAMP\www\craftycoffee\web\index.php(20): require('E:\\WAMP\\www\\cra...')
#46 {main}
Additional Information:
Array
(
    [0] => 42S02
    [1] => 1146
    [2] => Table 'craftycoffee.info' doesn't exist
)

Edit: I also tried to install it with composer, but it gives me the following error: https://imgur.com/a/4nTxSMu

  • Do you have a craftycoffee database and does it have an info table? – Oli May 5 at 8:31
  • @Oli Yes, it does. However, the info table is empty. – Jens De Muynck May 5 at 9:05
  • Strange... The error suggest the table doesn't even exist. Could you try to give remote access to your user, see here - dba.stackexchange.com/a/186309 then try the install again. – Oli May 5 at 9:13
  • I have put the following in my db, but without success: GRANT ALL PRIVILEGES ON . TO 'user'@'172.0.0.1'; – Jens De Muynck May 5 at 9:52
  • It looks like you are using localhost in your connection though and not 172.0.0.1 – Oli May 5 at 10:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.