Ttdfjt

Complaints from (junior) developers against solution architects: how can we show the benefits of our work and improve relationships?

Patio gate not at right angle to the house

Did Vladimir Lenin have a cat?

Efficiently finding furthest two nodes in a graph

Are all French verb conjugation tenses and moods practical and efficient?

My employer is refusing to give me the pay that was advertised after an internal job move

Should I put my name first, or last in the team members list

Should I intervene when a colleague in a different department makes students run laps as part of their grade?

why there is no “error” term in survival analysis?

Why are subdominants unstable?

"DDoouubbllee ssppeeaakk!!"

Do professors like answering questions from non-students/private citizens?

Best Ergonomic Design for a handheld ranged weapon

Why does calling cout.operator<<(const char*) print the address instead of the character string?

Three Dots in Center Page

Rampant sharing of authorship among colleagues in the name of "collaboration". Is not taking part in it a death knell for a future in academia?

Is there a word or phrase that means 'works but not for the reason we expect it to'?

Why does the Rust compiler not optimize code assuming that two mutable references cannot alias?

What are the closest international airports in different countries?

How to efficiently shred a lot of cabbage?

How to prevent a single-element caster from being useless against immune foes?

Can living where Earth magnetic ore is abundant provide any protection?

How to foreshadow to avoid a 'deus ex machina'-construction

Unknown indication below upper stave

Base table or view not found: 1146 Table SQLSTATE[42S02]: doesn't exist

Magento 2 Database table not creatingMagento 2 Error: Base table or view not found: 1146 Table 'dbname.catalog_category_flat_store_1' doesn't existSQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.design_config_grid_flat' doesn't existError when editing products on Magento 2Magento 2 Integration test can't run - store_website doesn't existMagento2 Form Component Base Table not foundSQLSTATE[42S02]: Base table or view not found: 1146 Table 'magento2.catalog_product_entity_integer' doesn't existDatabase not updated with moduleDatabase rollback error in Magento 2.3Base table or view not exist

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

2

error: "Base table or view not found: 1146 Table"

when i run a collection query in my magento 2 application i get the above message.

The problem is that the table does indeed exist. however magento 2 appears to add the name of my 'database' to the main table name.This is why the query is unable to locate the table.

If i am correct, it means that i need to remove the automatic creation of a table prefix by magento

This is the collection query:

$accountTypesCollection = $this->_modelConstantAccounttypes->create();
 $accountTypesCollection 
 ->addFieldToFilter('brandId', 'barclays')
 ->addFieldToFilter('brandId', array('eq'=>'barclays'))
 ->addFieldToFilter('suppress', array('nlike' => '1'));
 $accountTypesCollection->addAttributeToSort('priority');

echo $accountTypesCollection->getSelect(); 

This is the full print out of the select query:

SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

when i run this query directly into mysqlAdmin it returns the correct values.

so, i am unclear why magento adds the name of the database to the query.

this is the full error :

Base table or view not found: 1146 Table 'magentotwo.constants_account_types' doesn't exist, query was: SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

this is my database config file:

/<Magento Install Dir>/app/etc/env.php

 'db' => 
 array (
 'table_prefix' => '',
 'connection' => 
 array (
 'default' => 
 array (
 'host' => 'localhost',
 'dbname' => 'magentotwo',
 'username' => 'root',
 'password' => '',
 'active' => '1',
 ),
 ),
 ),

you can see that the table prefix column is left blank.

magento2

share|improve this question

edited Aug 20 '18 at 13:53

theSeeker

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  According to the error table constants_account_types is not available.
  
  – Sukumar Gorai
  Aug 20 '18 at 13:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the table does indeed exist. i am able to run the query direct in mydqlAdmin
  
  – theSeeker
  Aug 20 '18 at 13:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It happens when you create the table without prefix( while your DB tables have prefix), try with a prefix you have used for your DB creation time. Magento adding that prefix to your new table that doesn't have prefix.that's the issue.
  
  – Mahmood Rehman
  Jul 22 at 4:21
  

  
  
  
  

add a comment | 

2

error: "Base table or view not found: 1146 Table"

when i run a collection query in my magento 2 application i get the above message.

The problem is that the table does indeed exist. however magento 2 appears to add the name of my 'database' to the main table name.This is why the query is unable to locate the table.

If i am correct, it means that i need to remove the automatic creation of a table prefix by magento

This is the collection query:

$accountTypesCollection = $this->_modelConstantAccounttypes->create();
 $accountTypesCollection 
 ->addFieldToFilter('brandId', 'barclays')
 ->addFieldToFilter('brandId', array('eq'=>'barclays'))
 ->addFieldToFilter('suppress', array('nlike' => '1'));
 $accountTypesCollection->addAttributeToSort('priority');

echo $accountTypesCollection->getSelect(); 

This is the full print out of the select query:

SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

when i run this query directly into mysqlAdmin it returns the correct values.

so, i am unclear why magento adds the name of the database to the query.

this is the full error :

Base table or view not found: 1146 Table 'magentotwo.constants_account_types' doesn't exist, query was: SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

this is my database config file:

/<Magento Install Dir>/app/etc/env.php

 'db' => 
 array (
 'table_prefix' => '',
 'connection' => 
 array (
 'default' => 
 array (
 'host' => 'localhost',
 'dbname' => 'magentotwo',
 'username' => 'root',
 'password' => '',
 'active' => '1',
 ),
 ),
 ),

you can see that the table prefix column is left blank.

magento2

share|improve this question

edited Aug 20 '18 at 13:53

theSeeker

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  According to the error table constants_account_types is not available.
  
  – Sukumar Gorai
  Aug 20 '18 at 13:24
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the table does indeed exist. i am able to run the query direct in mydqlAdmin
  
  – theSeeker
  Aug 20 '18 at 13:41
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It happens when you create the table without prefix( while your DB tables have prefix), try with a prefix you have used for your DB creation time. Magento adding that prefix to your new table that doesn't have prefix.that's the issue.
  
  – Mahmood Rehman
  Jul 22 at 4:21
  

  
  
  
  

add a comment | 

error: "Base table or view not found: 1146 Table"

when i run a collection query in my magento 2 application i get the above message.

The problem is that the table does indeed exist. however magento 2 appears to add the name of my 'database' to the main table name.This is why the query is unable to locate the table.

If i am correct, it means that i need to remove the automatic creation of a table prefix by magento

This is the collection query:

$accountTypesCollection = $this->_modelConstantAccounttypes->create();
 $accountTypesCollection 
 ->addFieldToFilter('brandId', 'barclays')
 ->addFieldToFilter('brandId', array('eq'=>'barclays'))
 ->addFieldToFilter('suppress', array('nlike' => '1'));
 $accountTypesCollection->addAttributeToSort('priority');

echo $accountTypesCollection->getSelect(); 

This is the full print out of the select query:

SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

when i run this query directly into mysqlAdmin it returns the correct values.

so, i am unclear why magento adds the name of the database to the query.

this is the full error :

Base table or view not found: 1146 Table 'magentotwo.constants_account_types' doesn't exist, query was: SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

this is my database config file:

/<Magento Install Dir>/app/etc/env.php

 'db' => 
 array (
 'table_prefix' => '',
 'connection' => 
 array (
 'default' => 
 array (
 'host' => 'localhost',
 'dbname' => 'magentotwo',
 'username' => 'root',
 'password' => '',
 'active' => '1',
 ),
 ),
 ),

you can see that the table prefix column is left blank.

magento2

share|improve this question

edited Aug 20 '18 at 13:53

theSeeker

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

error: "Base table or view not found: 1146 Table"

$accountTypesCollection = $this->_modelConstantAccounttypes->create();
 $accountTypesCollection 
 ->addFieldToFilter('brandId', 'barclays')
 ->addFieldToFilter('brandId', array('eq'=>'barclays'))
 ->addFieldToFilter('suppress', array('nlike' => '1'));
 $accountTypesCollection->addAttributeToSort('priority');

echo $accountTypesCollection->getSelect(); 

SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

Base table or view not found: 1146 Table 'magentotwo.constants_account_types' doesn't exist, query was: SELECT `main_table`.* FROM `constants_account_types` AS `main_table` WHERE (`brandId` = 'barclays') AND (`brandId` = 'barclays') AND (`suppress` NOT LIKE '1') ORDER BY priority ASC

/<Magento Install Dir>/app/etc/env.php

 'db' => 
 array (
 'table_prefix' => '',
 'connection' => 
 array (
 'default' => 
 array (
 'host' => 'localhost',
 'dbname' => 'magentotwo',
 'username' => 'root',
 'password' => '',
 'active' => '1',
 ),
 ),
 ),

share|improve this question

edited Aug 20 '18 at 13:53

theSeeker

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

share|improve this question

edited Aug 20 '18 at 13:53

theSeeker

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

asked Aug 20 '18 at 13:18

theSeekertheSeeker

11988 bronze badges

1 Answer
1

active

oldest

votes

0

The constants_account_types table does not exist in magentotwo DataBase so either table not created or wrong DataBase configured in Magento.

share|improve this answer

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the table does exist. so it has to be the wrong Database configuration. How do you think i would go about debugging this
  
  – theSeeker
  Aug 20 '18 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check dbname in app/etc/env.php file.
  
  – kunj
  Aug 20 '18 at 13:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  done. i have edited my original question to show that this is empty-- so, there is no reason why magento should be prefixing the query names with the name of my database table
  
  – theSeeker
  Aug 20 '18 at 14:01
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  so do you have correct DB and that table is exist in that DB, right?
  
  – kunj
  Aug 20 '18 at 14:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes.the database is correclty configured and the table does indeed exist. i beleive the error is caused beucase magento is incorrectly prefixing my table names with the word : magentotwo
  
  – theSeeker
  Aug 20 '18 at 14:13
  

  
  
  
  

 | 
show 2 more comments

Your Answer

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%2f238951%2fbase-table-or-view-not-found-1146-table-sqlstate42s02-doesnt-exist%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

The constants_account_types table does not exist in magentotwo DataBase so either table not created or wrong DataBase configured in Magento.

share|improve this answer

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the table does exist. so it has to be the wrong Database configuration. How do you think i would go about debugging this
  
  – theSeeker
  Aug 20 '18 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check dbname in app/etc/env.php file.
  
  – kunj
  Aug 20 '18 at 13:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  done. i have edited my original question to show that this is empty-- so, there is no reason why magento should be prefixing the query names with the name of my database table
  
  – theSeeker
  Aug 20 '18 at 14:01
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  so do you have correct DB and that table is exist in that DB, right?
  
  – kunj
  Aug 20 '18 at 14:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes.the database is correclty configured and the table does indeed exist. i beleive the error is caused beucase magento is incorrectly prefixing my table names with the word : magentotwo
  
  – theSeeker
  Aug 20 '18 at 14:13
  

  
  
  
  

 | 
show 2 more comments

0

The constants_account_types table does not exist in magentotwo DataBase so either table not created or wrong DataBase configured in Magento.

share|improve this answer

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  the table does exist. so it has to be the wrong Database configuration. How do you think i would go about debugging this
  
  – theSeeker
  Aug 20 '18 at 13:37
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  check dbname in app/etc/env.php file.
  
  – kunj
  Aug 20 '18 at 13:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  done. i have edited my original question to show that this is empty-- so, there is no reason why magento should be prefixing the query names with the name of my database table
  
  – theSeeker
  Aug 20 '18 at 14:01
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  so do you have correct DB and that table is exist in that DB, right?
  
  – kunj
  Aug 20 '18 at 14:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes.the database is correclty configured and the table does indeed exist. i beleive the error is caused beucase magento is incorrectly prefixing my table names with the word : magentotwo
  
  – theSeeker
  Aug 20 '18 at 14:13
  

  
  
  
  

 | 
show 2 more comments

The constants_account_types table does not exist in magentotwo DataBase so either table not created or wrong DataBase configured in Magento.

share|improve this answer

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

share|improve this answer

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges

answered Aug 20 '18 at 13:30

kunjkunj

2,69222 gold badges55 silver badges2323 bronze badges