Mryntu

Multi tool use

What is the difference between 'contrib' and 'non-free' packages repositories?

How to find if SQL server backup is encrypted with TDE without restoring the backup

Airship steam engine room - problems and conflict

Gauss' Posthumous Publications?

Direct Implications Between USA and UK in Event of No-Deal Brexit

Why did early computer designers eschew integers?

Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact

Which acid/base does a strong base/acid react when added to a buffer solution?

Is a distribution that is normal, but highly skewed, considered Gaussian?

What did the word "leisure" mean in late 18th Century usage?

Calculate the Mean mean of two numbers

Could you use a laser beam as a modulated carrier wave for radio signal?

Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?

How exploitable/balanced is this homebrew spell: Spell Permanency?

How can a day be of 24 hours?

"Eavesdropping" vs "Listen in on"

Could a dragon use its wings to swim?

A hang glider, sudden unexpected lift to 25,000 feet altitude, what could do this?

Is it a bad idea to plug the other end of ESD strap to wall ground?

What difference does it make matching a word with/without a trailing whitespace?

How can I replace x-axis labels with pre-determined symbols?

Compensation for working overtime on Saturdays

Upgrading From a 9 Speed Sora Derailleur?

My boss doesn't want me to have a side project

No such entity with customerId

0

I get this error when trying to register an account :

No such entity with customerId = 13818

I think it might be some old custom attribute that is the root of the problem.

How can I clean the customer_eav_table and customer_eav_website tables from all custom attributes ? I would like to clean everything up.

^{Magento 2.2.6}

magento2.2 customer-attribute register

share|improve this question

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I get this error when trying to register an account :

No such entity with customerId = 13818

I think it might be some old custom attribute that is the root of the problem.

How can I clean the customer_eav_table and customer_eav_website tables from all custom attributes ? I would like to clean everything up.

^{Magento 2.2.6}

magento2.2 customer-attribute register

share|improve this question

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I get this error when trying to register an account :

No such entity with customerId = 13818

I think it might be some old custom attribute that is the root of the problem.

How can I clean the customer_eav_table and customer_eav_website tables from all custom attributes ? I would like to clean everything up.

^{Magento 2.2.6}

magento2.2 customer-attribute register

share|improve this question

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

share|improve this question

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

share|improve this question

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

edited Oct 10 '18 at 12:48

PЯINCƏ

8,38931145

asked Oct 10 '18 at 12:21

ski3rski3r

1

asked Oct 10 '18 at 12:21

ski3rski3r

1

1 Answer
1

active

oldest

votes

0

For info, there no customer_eav_table, but customer_eav_attribute instead.

I suggest you to try first this solution.

You ask how to remove customer custom attribute :

app/code/Vendor/Module/Setup/InstallData.php

If you have an existing module, try UpgradeData.php instead of InstallData.php

<?php
namespace VendorModuleSetup;

use MagentoEavSetupEavSetup;
use MagentoEavSetupEavSetupFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface

 private $eavSetupFactory;

 public function __construct(EavSetupFactory $eavSetupFactory) 
 $this->eavSetupFactory = $eavSetupFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);
 $eavSetup->removeAttribute(
 MagentoCustomerModelCustomer::ENTITY,
 'attribute_name'); //Attribute name here
 

share|improve this answer

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! I don't have a custom module. I've migrated customers from magento 1.9 and I think the customer attributes was created with that tool. Now I just want to start over again. Can I truncate customer_eav_attribute and customer_eav_website and Import the default values? If I can, where can I find the sql that creates the default database when setting up magento2?
  
  – ski3r
  Oct 10 '18 at 12:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you migrated from M1 to M2, I'm afraid it creates problems if you truncate these tables. First do some backup, and try magento.stackexchange.com/questions/155922/…
  
  – PЯINCƏ
  Oct 10 '18 at 13:03
  

  
  
  
  

add a comment | 

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f245953%2fno-such-entity-with-customerid%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

For info, there no customer_eav_table, but customer_eav_attribute instead.

I suggest you to try first this solution.

You ask how to remove customer custom attribute :

app/code/Vendor/Module/Setup/InstallData.php

If you have an existing module, try UpgradeData.php instead of InstallData.php

<?php
namespace VendorModuleSetup;

use MagentoEavSetupEavSetup;
use MagentoEavSetupEavSetupFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface

 private $eavSetupFactory;

 public function __construct(EavSetupFactory $eavSetupFactory) 
 $this->eavSetupFactory = $eavSetupFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);
 $eavSetup->removeAttribute(
 MagentoCustomerModelCustomer::ENTITY,
 'attribute_name'); //Attribute name here
 

share|improve this answer

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! I don't have a custom module. I've migrated customers from magento 1.9 and I think the customer attributes was created with that tool. Now I just want to start over again. Can I truncate customer_eav_attribute and customer_eav_website and Import the default values? If I can, where can I find the sql that creates the default database when setting up magento2?
  
  – ski3r
  Oct 10 '18 at 12:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you migrated from M1 to M2, I'm afraid it creates problems if you truncate these tables. First do some backup, and try magento.stackexchange.com/questions/155922/…
  
  – PЯINCƏ
  Oct 10 '18 at 13:03
  

  
  
  
  

add a comment | 

0

For info, there no customer_eav_table, but customer_eav_attribute instead.

I suggest you to try first this solution.

You ask how to remove customer custom attribute :

app/code/Vendor/Module/Setup/InstallData.php

If you have an existing module, try UpgradeData.php instead of InstallData.php

<?php
namespace VendorModuleSetup;

use MagentoEavSetupEavSetup;
use MagentoEavSetupEavSetupFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface

 private $eavSetupFactory;

 public function __construct(EavSetupFactory $eavSetupFactory) 
 $this->eavSetupFactory = $eavSetupFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);
 $eavSetup->removeAttribute(
 MagentoCustomerModelCustomer::ENTITY,
 'attribute_name'); //Attribute name here
 

share|improve this answer

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks! I don't have a custom module. I've migrated customers from magento 1.9 and I think the customer attributes was created with that tool. Now I just want to start over again. Can I truncate customer_eav_attribute and customer_eav_website and Import the default values? If I can, where can I find the sql that creates the default database when setting up magento2?
  
  – ski3r
  Oct 10 '18 at 12:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  If you migrated from M1 to M2, I'm afraid it creates problems if you truncate these tables. First do some backup, and try magento.stackexchange.com/questions/155922/…
  
  – PЯINCƏ
  Oct 10 '18 at 13:03
  

  
  
  
  

add a comment | 

For info, there no customer_eav_table, but customer_eav_attribute instead.

I suggest you to try first this solution.

You ask how to remove customer custom attribute :

app/code/Vendor/Module/Setup/InstallData.php

If you have an existing module, try UpgradeData.php instead of InstallData.php

<?php
namespace VendorModuleSetup;

use MagentoEavSetupEavSetup;
use MagentoEavSetupEavSetupFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface

 private $eavSetupFactory;

 public function __construct(EavSetupFactory $eavSetupFactory) 
 $this->eavSetupFactory = $eavSetupFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);
 $eavSetup->removeAttribute(
 MagentoCustomerModelCustomer::ENTITY,
 'attribute_name'); //Attribute name here
 

share|improve this answer

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

<?php
namespace VendorModuleSetup;

use MagentoEavSetupEavSetup;
use MagentoEavSetupEavSetupFactory;
use MagentoFrameworkSetupInstallDataInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupModuleDataSetupInterface;

class InstallData implements InstallDataInterface

 private $eavSetupFactory;

 public function __construct(EavSetupFactory $eavSetupFactory) 
 $this->eavSetupFactory = $eavSetupFactory;
 

 public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context)
 $eavSetup = $this->eavSetupFactory->create(['setup' => $setup]);
 $eavSetup->removeAttribute(
 MagentoCustomerModelCustomer::ENTITY,
 'attribute_name'); //Attribute name here
 

share|improve this answer

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145

answered Oct 10 '18 at 12:47

PЯINCƏPЯINCƏ

8,38931145