Error message during install magento 2.3

[hicham_ait zidane]

Hi all,

I want to install Magento 2.3, but during the process I get the following error message.

how to fixe it please ?

Thanks,

Installing database schema:
Schema creation/updates:
[ERROR] PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'marocnetfdwrknet.mnv2_m23_cache' doesn't exist in /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/marocnetfd/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#3 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW CREATE TAB...', Array)
#5 /home/marocnetfd/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(541): Zend_Db_Adapter_Pdo_Abstract->query('SHOW CREATE TAB...', Array)
#6 /home/marocnetfd/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(615): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SHOW CREATE TAB...', Array)
#7 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php(174): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SHOW CREATE TAB...')
#8 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php(158): Magento\Framework\Setup\Declaration\Schema\Db\MySQL\DbSchemaReader->getCreateTableSql('mnv2_m23_cache', 'default')
#9 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php(144): Magento\Framework\Setup\Declaration\Schema\Db\MySQL\DbSchemaReader->readReferences('mnv2_m23_cache', 'default')
#10 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php(127): Magento\Framework\Setup\Declaration\Schema\Db\SchemaBuilder->processReferenceKeys(Array, Object(Magento\Framework\Setup\Declaration\Schema\Dto\Schema))
#11 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/SchemaConfig.php(66): Magento\Framework\Setup\Declaration\Schema\Db\SchemaBuilder->build(Object(Magento\Framework\Setup\Declaration\Schema\Dto\Schema))
#12 /home/marocnetfd/www/setup/src/Magento/Setup/Model/DeclarationInstaller.php(58): Magento\Framework\Setup\Declaration\Schema\SchemaConfig->getDbConfig()
#13 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(808): Magento\Setup\Model\DeclarationInstaller->installSchema(Array)
#14 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(830): Magento\Setup\Model\Installer->declarativeInstallSchema(Array)
#15 [internal function]: Magento\Setup\Model\Installer->installSchema(Array)
#16 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(367): call_user_func_array(Array, Array)
#17 /home/marocnetfd/www/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#18 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(84): Magento\Setup\Controller\Install->startAction()
#19 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#21 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#23 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/DispatchListener.php(118): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#24 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#25 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#26 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#27 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Application.php(340): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#28 /home/marocnetfd/www/setup/index.php(39): Zend\Mvc\Application->run()
#29 {main}

Next Zend_Db_Statement_Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'marocnetfdwrknet.mnv2_m23_cache' doesn't exist, query was: SHOW CREATE TABLE mnv2_m23_cache in /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /home/marocnetfd/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/marocnetfd/www/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW CREATE TAB...', Array)
#4 /home/marocnetfd/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(541): Zend_Db_Adapter_Pdo_Abstract->query('SHOW CREATE TAB...', Array)
#5 /home/marocnetfd/www/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(615): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SHOW CREATE TAB...', Array)
#6 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php(174): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SHOW CREATE TAB...')
#7 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/MySQL/DbSchemaReader.php(158): Magento\Framework\Setup\Declaration\Schema\Db\MySQL\DbSchemaReader->getCreateTableSql('mnv2_m23_cache', 'default')
#8 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php(144): Magento\Framework\Setup\Declaration\Schema\Db\MySQL\DbSchemaReader->readReferences('mnv2_m23_cache', 'default')
#9 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/Db/SchemaBuilder.php(127): Magento\Framework\Setup\Declaration\Schema\Db\SchemaBuilder->processReferenceKeys(Array, Object(Magento\Framework\Setup\Declaration\Schema\Dto\Schema))
#10 /home/marocnetfd/www/vendor/magento/framework/Setup/Declaration/Schema/SchemaConfig.php(66): Magento\Framework\Setup\Declaration\Schema\Db\SchemaBuilder->build(Object(Magento\Framework\Setup\Declaration\Schema\Dto\Schema))
#11 /home/marocnetfd/www/setup/src/Magento/Setup/Model/DeclarationInstaller.php(58): Magento\Framework\Setup\Declaration\Schema\SchemaConfig->getDbConfig()
#12 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(808): Magento\Setup\Model\DeclarationInstaller->installSchema(Array)
#13 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(830): Magento\Setup\Model\Installer->declarativeInstallSchema(Array)
#14 [internal function]: Magento\Setup\Model\Installer->installSchema(Array)
#15 /home/marocnetfd/www/setup/src/Magento/Setup/Model/Installer.php(367): call_user_func_array(Array, Array)
#16 /home/marocnetfd/www/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#17 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(84): Magento\Setup\Controller\Install->startAction()
#18 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#19 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#20 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#22 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/DispatchListener.php(118): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#23 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#24 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#25 /home/marocnetfd/www/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#26 /home/marocnetfd/www/vendor/zendframework/zend-mvc/src/Application.php(340): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#27 /home/marocnetfd/www/setup/index.php(39): Zend\Mvc\Application->run()
#28 {main}

[Larry_Ruiz]

First reaction is - incorrect PHP and apache settings.

2.3 works on PHP 7.2

see this post: https://community.magento.com/t5/Installing-Magento-2-x/Magento-2-3-quot-Magento-supports-PHP-7-0-2-...

[Vadim Justus]

If you're using redis; run 'redis-cli flushall' and retry. This issue appears often in combination with valet+, since every instance is configured with same redis DBs...

[Stuart M]

Looks like something failed during the schema creation thus the table/view is not available.
Please check the following things:

1. Make sure you meet all the correct requirements for Magento 2.3 for MySQL and PHP specifically. -> https://devdocs.magento.com/guides/v2.3/install-gde/system-requirements-tech.html
2. Create a new database.
3. Create a new user and make sure the new user has full access to the new database.

[hicham_ait zidane]

Dear Macfarlane,

is there anyway to create tables manually please ? beacause il think my server respect the requirments of Magento 2.3,

PHP 7.1.14

MySQL 5.6.4

Thanks

Hicham

[hicham_ait zidane]

Any news please !????