<p>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.</p>

<p>The database account has all rights.</p>

<p>(This is only a part of the log, but this should do)</p>

<pre><code>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-&gt;execute()
#1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command-&gt;internalExecute('SELECT *\nFROM `...')
#2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command-&gt;queryInternal('fetch', NULL)
#3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command-&gt;queryOne()
#4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query-&gt;one(NULL)
#5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query-&gt;one()
#6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application-&gt;getInfo(true)
#7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application-&gt;getIsInstalled()
#8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites-&gt;_loadAllSites()
#9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites-&gt;setCurrentSite(NULL)
#10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component-&gt;__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-&gt;__construct(Array)
#13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\services\\...', Array, Array)
#15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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-&gt;get('sites', true)
#18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('sites', true)
#19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application-&gt;get('sites')
#20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application-&gt;getSites()
#21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request-&gt;init()
#22 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
#23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Reque...', Array, Array)
#25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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-&gt;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-&gt;get('request', true)
#32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('request', true)
#33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application-&gt;get('request')
#34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application-&gt;getRequest()
#35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application-&gt;_preInit()
#36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application-&gt;init()
#37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject-&gt;__construct(Array)
#38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application-&gt;__construct(Array)
#39 [internal function]: craft\web\Application-&gt;__construct(Array)
#40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Appli...', Array, Array)
#42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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-&gt;convertException(Object(PDOException), 'SELECT *\nFROM `...')
#1 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(1159): yii\db\Command-&gt;internalExecute('SELECT *\nFROM `...')
#2 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Command.php(415): yii\db\Command-&gt;queryInternal('fetch', NULL)
#3 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\db\Query.php(274): yii\db\Command-&gt;queryOne()
#4 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\db\Query.php(168): yii\db\Query-&gt;one(NULL)
#5 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(620): craft\db\Query-&gt;one()
#6 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(286): craft\web\Application-&gt;getInfo(true)
#7 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(1138): craft\web\Application-&gt;getIsInstalled()
#8 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\services\Sites.php(448): craft\services\Sites-&gt;_loadAllSites()
#9 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Component.php(180): craft\services\Sites-&gt;setCurrentSite(NULL)
#10 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(558): yii\base\Component-&gt;__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-&gt;__construct(Array)
#13 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#14 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\services\\...', Array, Array)
#15 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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-&gt;get('sites', true)
#18 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('sites', true)
#19 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1238): craft\web\Application-&gt;get('sites')
#20 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Request.php(185): craft\web\Application-&gt;getSites()
#21 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Request-&gt;init()
#22 [internal function]: yii\base\BaseObject-&gt;__construct(Array)
#23 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#24 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Reque...', Array, Array)
#25 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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-&gt;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-&gt;get('request', true)
#32 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(341): yii\base\Module-&gt;get('request', true)
#33 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\web\Application.php(160): craft\web\Application-&gt;get('request')
#34 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\base\ApplicationTrait.php(1380): yii\web\Application-&gt;getRequest()
#35 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(100): craft\web\Application-&gt;_preInit()
#36 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\BaseObject.php(109): craft\web\Application-&gt;init()
#37 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\base\Application.php(206): yii\base\BaseObject-&gt;__construct(Array)
#38 E:\WAMP\www\craftycoffee\vendor\craftcms\cms\src\web\Application.php(91): yii\base\Application-&gt;__construct(Array)
#39 [internal function]: craft\web\Application-&gt;__construct(Array)
#40 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(400): ReflectionClass-&gt;newInstanceArgs(Array)
#41 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\di\Container.php(159): yii\di\Container-&gt;build('craft\\web\\Appli...', Array, Array)
#42 E:\WAMP\www\craftycoffee\vendor\yiisoft\yii2\BaseYii.php(365): yii\di\Container-&gt;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] =&gt; 42S02
    [1] =&gt; 1146
    [2] =&gt; Table 'craftycoffee.info' doesn't exist
)

</code></pre>

<p>Edit:
I also tried to install it with composer, but it gives me the following error:
<a href="https://i.sstatic.net/M0Hti.jpg" rel="nofollow noreferrer">https://i.sstatic.net/M0Hti.jpg</a></p>

CC BY-SA 4.0
2020-05-05T08:31:22.623Z
Do you have a `craftycoffee` database and does it have an `info` table?
Oli
CC BY-SA 4.0
2020-05-05T09:05:16.920Z
@Oli Yes, it does. However, the info table is empty.
Jens De Muynck
CC BY-SA 4.0
2020-05-05T09:13:35.027Z
Strange... The error suggest the table doesn't even exist. Could you try to give remote access to your user, see here - https://dba.stackexchange.com/a/186309 then try the install again.
Oli
CC BY-SA 4.0
2020-05-05T09:52:29.693Z
I have put the following in my db, but without success: GRANT ALL PRIVILEGES ON *.* TO 'user'@'172.0.0.1';
Jens De Muynck
CC BY-SA 4.0
2020-05-05T10:28:59.317Z
It looks like you are using `localhost` in your connection though and not `172.0.0.1`
Oli
CC BY-SA 4.0
2020-05-05T11:31:06.280Z
So I tried making a new virtual host named "craftycoffee.test" instead of using localhost, and then tried giving my new database the priviliges with "GRANT ALL PRIVILEGES ON . TO 'user'@'craftycoffee.test';" but still no success.
Jens De Muynck
CC BY-SA 4.0
2020-05-05T11:51:12.370Z
Are you re-installing each time?
Oli
CC BY-SA 4.0
2020-05-05T11:57:16.830Z
Yes, but before i reinstall, i have to drop my database because it will not let me install it again otherwise
Jens De Muynck
CC BY-SA 4.0
2020-05-05T11:58:58.080Z
I just noticed that all my tables are being made, but none of them get filled with data, i thought only info was empty... Maybe this clarifies something?
Jens De Muynck
CC BY-SA 4.0
2020-05-05T13:49:46.787Z
Could you have a look here (related to the error you get with composer but could help..) https://stackoverflow.com/a/31276668
Oli
CC BY-SA 4.0
2020-05-05T21:19:08.540Z
@Oli Did you get my support mail back?
Jens De Muynck
<craft3>
MySQL Problem fetching the info row
# MySQL Problem fetching the info row

(Asked by: username_0 on 2020-05-05)

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://i.sstatic.net/M0Hti.jpg

**Tags:** craft3
> **Comments:**
> **username_1**: Do you have a `craftycoffee` database and does it have an `info` table?  
> **username_0**: @Oli Yes, it does. However, the info table is empty.  
> **username_1**: Strange... The error suggest the table doesn't even exist. Could you try to give remote access to your user, see here - https://dba.stackexchange.com/a/186309 then try the install again.  
> **username_0**: I have put the following in my db, but without success: GRANT ALL PRIVILEGES ON *.* TO 'user'@'172.0.0.1';  
> **username_1**: It looks like you are using `localhost` in your connection though and not `172.0.0.1`  
> **username_0**: So I tried making a new virtual host named "craftycoffee.test" instead of using localhost, and then tried giving my new database the priviliges with "GRANT ALL PRIVILEGES ON . TO 'user'@'craftycoffee.test';" but still no success.  
> **username_1**: Are you re-installing each time?  
> **username_0**: Yes, but before i reinstall, i have to drop my database because it will not let me install it again otherwise  
> **username_0**: I just noticed that all my tables are being made, but none of them get filled with data, i thought only info was empty... Maybe this clarifies something?  
> **username_1**: Could you have a look here (related to the error you get with composer but could help..) https://stackoverflow.com/a/31276668  
> **username_0**: @Oli Did you get my support mail back?  

---

## 0 answers

