error message

Hi there,
 
I’ve got an error message as belows;  (p.s. It occurred while I was importing ../sql/ub_craft_v2.sql to my database.  Theme:Craft for magento 2)
 
SQL 查詢:

— Constraints for table `eav_attribute`

ALTER TABLE `eav_attribute` ADD CONSTRAINT `FK_EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY ( `entity_type_id` ) REFERENCES `eav_entity_type` ( `entity_type_id` ) ON DELETE CASCADE ON UPDATE CASCADE ;

MySQL 返回:文件
#1452 -- Cannot add or update a child row: a foreign key constraint fails (`apexever_jmcraft201`.`#sql-eba_297aee`, CONSTRAINT `FK_EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `eav_entity_type` (`entity_type_i)
 
Please tell me how to solve it.  I would like you to tell me how to do rather than you just solve it.
I’m grateful for your help as soon as possible.
 
Regards,
 
Ken
Apexever
 

  1. Profile photo of Ken HsiehKen Hsieh 30.00 $tone January 16, 2015
    Thank you very much. It works.
  2. Profile photo of Ken HsiehKen Hsieh 30.00 $tone January 16, 2015
    I've got another error message as followings; (p.s. while I was installing Craft for magento 2) Installation is incomplete. Check the console log for errors before trying again.Starting Magento installation: File permissions check... Enabling Maintenance Mode... Installing deployment configuration... Installing database schema: Schema creation/updates: Module 'Magento_Core': [ERROR] exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'apexever'@'ns447.websitewelcome.com' (using password: YES)' in /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=192....', 'apexever', '0096505304', Array) #1 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(335): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(460): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #4 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8;', Array) #5 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(436): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8;', Array) #6 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Type/Db/Pdo/Mysql.php(78): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SET NAMES utf8;') #7 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Module/ConnectionFactory.php(62): Magento\Framework\Model\Resource\Type\Db\Pdo\Mysql->getConnection(Object(Magento\Framework\DB\Logger\Null)) #8 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/App/Resource.php(122): Magento\Setup\Module\ConnectionFactory->create(Array) #9 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(297): Magento\Framework\App\Resource->getConnection('core_write') #10 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(327): Magento\Framework\Model\Resource\Db\AbstractDb->_getConnection('write') #11 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(312): Magento\Framework\Model\Resource\Db\AbstractDb->_getWriteAdapter() #12 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Module/Resource.php(98): Magento\Framework\Model\Resource\Db\AbstractDb->_getReadAdapter() #13 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Module/SetupModule.php(162): Magento\Framework\Module\Resource->getDbVersion('core_setup') #14 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Model/Installer.php(526): Magento\Setup\Module\SetupModule->applyUpdates() #15 [internal function]: Magento\Setup\Model\Installer->installSchema() #16 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Model/Installer.php(291): call_user_func_array(Array, Array) #17 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Controller/Install/StartController.php(92): Magento\Setup\Model\Installer->install(Array) #18 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractActionController.php(83): Magento\Setup\Controller\Install\StartController->indexAction() #19 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #20 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #21 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #22 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #23 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/DispatchListener.php(114): 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/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #26 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #27 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #28 /home/apexever/public_html/apexever/jmcraft201/setup/index.php(48): Zend\Mvc\Application->run() #29 {main} Next exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[28000] [1045] Access denied for user 'apexever'@'ns447.websitewelcome.com' (using password: YES)' in /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144 Stack trace: #0 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(335): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(460): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect() #3 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8;', Array) #4 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(436): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8;', Array) #5 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Type/Db/Pdo/Mysql.php(78): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SET NAMES utf8;') #6/home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Module/ConnectionFactory.php(62): Magento\Framework\Model\Resource\Type\Db\Pdo\Mysql->getConnection(Object(Magento\Framework\DB\Logger\Null)) #7 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/App/Resource.php(122): Magento\Setup\Module\ConnectionFactory->create(Array) #8 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(297): Magento\Framework\App\Resource->getConnection('core_write') #9 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(327): Magento\Framework\Model\Resource\Db\AbstractDb->_getConnection('write') #10 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Model/Resource/Db/AbstractDb.php(312): Magento\Framework\Model\Resource\Db\AbstractDb->_getWriteAdapter() #11 /home/apexever/public_html/apexever/jmcraft201/lib/internal/Magento/Framework/Module/Resource.php(98): Magento\Framework\Model\Resource\Db\AbstractDb->_getReadAdapter() #12 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Module/SetupModule.php(162): Magento\Framework\Module\Resource->getDbVersion('core_setup') #13 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Model/Installer.php(526): Magento\Setup\Module\SetupModule->applyUpdates() #14 [internal function]: Magento\Setup\Model\Installer->installSchema() #15 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Model/Installer.php(291): call_user_func_array(Array, Array) #16 /home/apexever/public_html/apexever/jmcraft201/setup/module/Magento/Setup/src/Controller/Install/StartController.php(92): Magento\Setup\Model\Installer->install(Array) #17 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractActionController.php(83): Magento\Setup\Controller\Install\StartController->indexAction() #18 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent)) #19 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #20 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #21 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #22 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/DispatchListener.php(114): 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/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(468): call_user_func(Array, Object(Zend\Mvc\MvcEvent)) #25 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(207): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #26 /home/apexever/public_html/apexever/jmcraft201/setup/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(313): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure)) #27 /home/apexever/public_html/apexever/jmcraft201/setup/index.php(48): Zend\Mvc\Application->run() #28 {main} You'll be highly appreciated if you can tell me how to solve it.Looking forward to hearing from you soon.Sincerely,KenApexever
  3. Profile photo of Ken HsiehKen Hsieh 30.00 $tone January 21, 2015
    Hi Mall,Thanks for your reply.Please see the picture at http://www.apexever.com/apexever/Privileges.png. I've made full of privileges before I've asked you.Could you please recheck for me how to solve it?Awaiting for your reply.Regards,KenApexever
  4. Profile photo of Ken HsiehKen Hsieh 30.00 $tone January 28, 2015
    Hi Man,

    Thanks for reply.I've followed your advice to insall and it was showing 'Success" as the picture at http://www.apexever.com/apexever/q&a/success.png.

    I've got two problems as followings:
    1. I've got an 'error 404 page not found' after clicking 'Launch magento admin' button.
    2. It redirected to 'http://10.0.0.159/magento2/?SID=de6199a7852676a1623b67fd0719fa09' after visiting my store at http://www.apexever.com/apexever/jmcraft201.
    I have no idea why it was occurred. Please tell me how to do.

    Your prompt reply will be highly appreciated.

    Best regards,

    Ken
    Apexever
  5. Profile photo of Ken HsiehKen Hsieh 30.00 $tone January 30, 2015
    Hi Mall,

    Thanks for your reply.

    I've added '/' as you said. I reinstalled Theme:Craft for magento 2, and then I've got 'Success' as before.(see picture at http://www.apexever.com/apexever/q&a/success_1.png)

    I've got two errors as followings:
    1. I've got into logging page as the picture at http://www.apexever.com/apexever/q&a/admin.png after clicking 'Launch magento admin' button. It took me more than 1 minute, then, it redirected to http://10.0.0.159/magento2/admin/admin/auth/forgotpassword/?SID=0f5bad74238b1a31dd4508f8c65d18362 after I've logged in.

    2. It redirected to http://10.0.0.159/magento2/?SID=8200be9acd800c9b3aea9ad25f172894' after visiting my store at http://www.apexever.com/apexever/jmcraft201/.Do you have any solution?

    Waiting for you.

    Sincerely,

    Ken
    Apexever

5 answers

Profile photo of Mall Staff 184060.00 $tone January 16, 2015
Public

Hi Ken Hsieh,
To solve the issue:
+ You can open the file at /sql/ub_craft_v2.sql and add below query to the beginning of file:

SET FOREIGN_KEY_CHECKS=0;

+ Please empty the Database before you import the file.sql at /sql/ub_craft_v2.sql
 

#1
Profile photo of Mall Staff 184060.00 $tone January 21, 2015
Public

Hi Ken,

Module ‘Magento_Core’: [ERROR] exception ‘PDOException’ with message ‘SQLSTATE[28000] [1045] Access denied for user ‘apexever’@’ns447.websitewelcome.com’ (using password: YES)’

To solve that issue, you need to re-check the Database connection information & Database User Privileges of User with name of ‘apexever’. Database user ‘apexever’ need have full of privileges.
 

#2
Profile photo of Man 410.00 $tone January 23, 2015
Public

Hi Ken,
I see the database user named ‘apexever_apex‘ in http://www.apexever.com/apexever/Privileges.png
The database was raised error with name of: ‘apexever‘ , you should re-check the Database user which you used when install Magento2 via wizard install.

#3
Profile photo of Mall Staff 184060.00 $tone January 29, 2015
Public

Hi Ken,

Thanks for reply.I’ve followed your advice to insall and it was showing ‘Success” as the picture at http://www.apexever.com/apexever/q&a/success.png.
I’ve got two problems as followings:
1. I’ve got an ‘error 404 page not found’ after clicking ‘Launch magento admin’ button.
2. It redirected to ‘http://10.0.0.159/magento2/?SID=de6199a7852676a1623b67fd0719fa09’ after visiting my store a thttp://www.apexever.com/apexever/jmcraft201.
I have no idea why it was occurred. Please tell me how to do.

I see you have wrong setting the Store Address in step 2 (Web Configuration) the Store Address have to contain “/” at end.
You can do bellow steps to re-install the Magento2:

  1. Step 1: Delete the file at \app\etc\config.php
  2. Step 2: Delete all folders in \var\
  3. Step 3: Delete all folders in \pub\static\
  4. Re-install the Magento2 via Wizard install. Note setting correct Store Url in step 2.

 

#4
Profile photo of Mall Staff 184060.00 $tone February 2, 2015
Public

Hi Ken,
Where did you download the data sample for crafts2 theme?
As you see our theme & data sample working fine at http://crafts.magento2.demo.ubertheme.com/
You should empty the Database used for this site and try import the ub_crafts_v2.sql in downloaded package from bellow links:
http://www.ubertheme.com/magento-themes/crafts-magento-2-theme/
or 
https://github.com/ubertheme/crafts-magento-2-theme
And you can do bellow steps to re-install the Magento2:

  1. Step 1: Delete the file at \app\etc\config.php
  2. Step 2: Delete all folders in \var\
  3. Step 3: Delete all folders in \pub\static\
  4. Re-install the Magento2 via Wizard install. Note setting correct Store Url in step 2.
  5. Reindex data: Open SSH window and go to \dev\shell folder and type & run command line: php indexer.php reindexall

Give it a try & let me know how it goes.

#5

Please login or Register to Submit Answer

Written By

Comments