Gsyfuy

I am attempting to install Magento 2 on my server. Everything is set up following the guides online but when I go to install the software it stops at 51% and gives me the following error in the console:

[ERROR] PDOException: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`me_magento`.`cms_page`, CONSTRAINT `CMS_PAGE_PAGE_ID_SEQUENCE_CMS_PAGE_SEQUENCE_VALUE` FOREIGN KEY (`page_id`) REFERENCES `sequence_cms_page` (`sequence_value`) ON DELETE CASCADE)

This is followed but other PDO errors. I have tried deleting all tables from the database and installing again but I get the same results. I know there isnt an error with PDO as I use it for all my websites when interacting with MySQL. Any help on how I can get this resolved and get Magento 2 installed would be great.

Thanks!

EDIT:

I tried installing the version without the sample data and I get this error:

[ERROR] LogicException: Unknown module in the requested list: 'Magento_CatalogRuleSampleData' in /public_html/magento/setup/src/Magento/Setup/Model/Installer.php:431

Stack trace:

#0 /public_html/magento/setup/src/Magento/Setup/Model/Installer.php(390): MagentoSetupModelInstaller->readListOfModules(Array, Array, 'enable_modules')

#1 /public_html/magento/setup/src/Magento/Setup/Model/Installer.php(336): MagentoSetupModelInstaller->createModulesConfig(Array, true)

#2 /public_html/magento/setup/src/Magento/Setup/Controller/Install.php(109): MagentoSetupModelInstaller->install(Array)

#3 /public_html/magento/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): MagentoSetupControllerInstall->startAction()

#4 [internal function]: ZendMvcControllerAbstractActionController->onDispatch(Object(ZendMvcMvcEvent))

#5 /public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent))

#6 /public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): ZendEventManagerEventManager->triggerListeners('dispatch', Object(ZendMvcMvcEvent), Object(Closure))

#7 /public_html/magento/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): ZendEventManagerEventManager->trigger('dispatch', Object(ZendMvcMvcEvent), Object(Closure))

#8 /public_html/magento/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): ZendMvcControllerAbstractController->dispatch(Object(ZendHttpPhpEnvironmentRequest), Object(ZendHttpPhpEnvironmentResponse))

#9 [internal function]: ZendMvcDispatchListener->onDispatch(Object(ZendMvcMvcEvent))

#10 /public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(ZendMvcMvcEvent))

#11 /public_html/magento/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): ZendEventManagerEventManager->triggerListeners('dispatch', Object(ZendMvcMvcEvent), Object(Closure))

#12 /public_html/magento/vendor/zendframework/zend-mvc/src/Application.php(314): ZendEventManagerEventManager->trigger('dispatch', Object(ZendMvcMvcEvent), Object(Closure))

#13 /public_html/magento/setup/index.php(31): ZendMvcApplication->run()

#14 {main}

in the console log at 0% so even worse. I can not find the my.cnf file looking in the /ect/ folder so if that is needed to figure out my issue then I will need help finding that.

EDIT 2:

Here is the info in my.cnf:

# The MySQL server

[mysqld]

performance_schema=0

#innodb_force_recovery = 1

port=3306

socket="/tmp/mysql.sock"

key_buffer_size=64M

max_allowed_packet=268435456

bulk_insert_buffer_size=64M

table_open_cache=32768

open_files_limit=65536

sort_buffer_size=8M

 read_buffer_size=2M

read_rnd_buffer_size=4M

myisam_sort_buffer_size=128M

myisam_max_sort_file_size=10G

thread_cache_size=8

myisam-recover-options = DEFAULT

query_cache_size=256M

query_cache_limit=2M

# Try number of CPU's*2 for thread_concurrency

#thread_concurrency=16

max_connections=100

#max_user_connections = 40

max_delayed_threads=0

log-error="/var/log/mysql.error.log"

log-warnings

ft_min_word_len=3

wait_timeout=300

tmp_table_size=512M

max_heap_table_size=512M

table_definition_cache=12000

join_buffer_size=256K

what version of mysql are you using? also post here your my.cnf

it would be helpfull if you can get a magento2 standard .sql dump and try to import it via CLI on your server.

What are your server specs? Those specs are for a heavy duty highend mysql server with at lease 32gb ram...

Just try with a default mariadb or percona ...with zero modification

It happens because MySQL often use MyISAM as default engine for tables. But this engine doesn't support foreign keys.
So, to fix your error you need to execute following query in MySQL:

SET GLOBAL default_storage_engine=INNODB;

Then delete your database and try to install it again.