Magento Too many tables error bulk updating productsTables indexes - too little or too manyReindex catalog categories url issueGetting SQLSTATE[HY000]: General errorEAV Attributes Install script - VS - eav_attribute_label table (For Select Attributes)Base table or view not found custom databaseToo many connections errorError in admin panel: MySQL server has gone awaySQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoForce DB Schema UpdateCan't run CRON PDOException Magento 1.9.3.8
A variation to the phrase "hanging over my shoulders"
How to get directions in deep space?
Why is the Sun approximated as a black body at ~ 5800 K?
Which Article Helped Get Rid of Technobabble in RPGs?
Why should universal income be universal?
Change the color of a single dot in `ddot` symbol
Is this toilet slogan correct usage of the English language?
Review your own paper in Mathematics
Why Shazam when there is already Superman?
How to convince somebody that he is fit for something else, but not this job?
What kind of floor tile is this?
Will number of steps recorded on FitBit/any fitness tracker add up distance in PokemonGo?
Delete multiple columns using awk or sed
Is there a way to have vectors outlined in a Vector Plot?
US tourist/student visa
What does "Scientists rise up against statistical significance" mean? (Comment in Nature)
A Trivial Diagnosis
Which was the first story featuring espers?
PTIJ: Why is Haman obsessed with Bose?
I found an audio circuit and I built it just fine, but I find it a bit too quiet. How do I amplify the output so that it is a bit louder?
How many arrows is an archer expected to fire by the end of the Tyranny of Dragons pair of adventures?
What is the difference between lands and mana?
What is going on with gets(stdin) on the site coderbyte?
Is there a nicer/politer/more positive alternative for "negates"?
Magento Too many tables error bulk updating products
Tables indexes - too little or too manyReindex catalog categories url issueGetting SQLSTATE[HY000]: General errorEAV Attributes Install script - VS - eav_attribute_label table (For Select Attributes)Base table or view not found custom databaseToo many connections errorError in admin panel: MySQL server has gone awaySQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoForce DB Schema UpdateCan't run CRON PDOException Magento 1.9.3.8
This morning while selecting and enabling some one hundred products in magento i got this mysql too many table
error
Below is the snippet from the log file
a:5:{i:0;s:92:"SQLSTATE[HY000]: General error: 1116 Too many tables;
MySQL can only use 61 tables in a join";i:1;s:5786:"
#0 /var/www/html/dev.mysite.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
Zend_Db_Statement_Pdo->_execute(Array)
Gone through this mysql thread, http://forums.mysql.com/read.php?10,94448,94505#msg-94505
which says the eav db model is flawed..
It also says, if i do increase the 61 table limit also, the eav model will eventually exceed this.
I'm afraid Is magento eav model not flawless? or is it because i'm having too many custom attributes ? (150+ custom attributes and sets )
I'm pointless how to deal with this.
Looking for some help
Thanks
magento-1.9 database mysql eav custom-attributes
bumped to the homepage by Community♦ yesterday
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 |
This morning while selecting and enabling some one hundred products in magento i got this mysql too many table
error
Below is the snippet from the log file
a:5:{i:0;s:92:"SQLSTATE[HY000]: General error: 1116 Too many tables;
MySQL can only use 61 tables in a join";i:1;s:5786:"
#0 /var/www/html/dev.mysite.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
Zend_Db_Statement_Pdo->_execute(Array)
Gone through this mysql thread, http://forums.mysql.com/read.php?10,94448,94505#msg-94505
which says the eav db model is flawed..
It also says, if i do increase the 61 table limit also, the eav model will eventually exceed this.
I'm afraid Is magento eav model not flawless? or is it because i'm having too many custom attributes ? (150+ custom attributes and sets )
I'm pointless how to deal with this.
Looking for some help
Thanks
magento-1.9 database mysql eav custom-attributes
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29
add a comment |
This morning while selecting and enabling some one hundred products in magento i got this mysql too many table
error
Below is the snippet from the log file
a:5:{i:0;s:92:"SQLSTATE[HY000]: General error: 1116 Too many tables;
MySQL can only use 61 tables in a join";i:1;s:5786:"
#0 /var/www/html/dev.mysite.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
Zend_Db_Statement_Pdo->_execute(Array)
Gone through this mysql thread, http://forums.mysql.com/read.php?10,94448,94505#msg-94505
which says the eav db model is flawed..
It also says, if i do increase the 61 table limit also, the eav model will eventually exceed this.
I'm afraid Is magento eav model not flawless? or is it because i'm having too many custom attributes ? (150+ custom attributes and sets )
I'm pointless how to deal with this.
Looking for some help
Thanks
magento-1.9 database mysql eav custom-attributes
This morning while selecting and enabling some one hundred products in magento i got this mysql too many table
error
Below is the snippet from the log file
a:5:{i:0;s:92:"SQLSTATE[HY000]: General error: 1116 Too many tables;
MySQL can only use 61 tables in a join";i:1;s:5786:"
#0 /var/www/html/dev.mysite.com/lib/Varien/Db/Statement/Pdo/Mysql.php(110):
Zend_Db_Statement_Pdo->_execute(Array)
Gone through this mysql thread, http://forums.mysql.com/read.php?10,94448,94505#msg-94505
which says the eav db model is flawed..
It also says, if i do increase the 61 table limit also, the eav model will eventually exceed this.
I'm afraid Is magento eav model not flawless? or is it because i'm having too many custom attributes ? (150+ custom attributes and sets )
I'm pointless how to deal with this.
Looking for some help
Thanks
magento-1.9 database mysql eav custom-attributes
magento-1.9 database mysql eav custom-attributes
edited Sep 1 '14 at 9:01
echoashu
asked Sep 1 '14 at 8:38
echoashuechoashu
266626
266626
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ yesterday
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29
add a comment |
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29
add a comment |
1 Answer
1
active
oldest
votes
You should use walk()
method of core Iterator class for updating products in bulk. Refer to Working with Large Magento Collections.
add a comment |
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f34249%2fmagento-too-many-tables-error-bulk-updating-products%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You should use walk()
method of core Iterator class for updating products in bulk. Refer to Working with Large Magento Collections.
add a comment |
You should use walk()
method of core Iterator class for updating products in bulk. Refer to Working with Large Magento Collections.
add a comment |
You should use walk()
method of core Iterator class for updating products in bulk. Refer to Working with Large Magento Collections.
You should use walk()
method of core Iterator class for updating products in bulk. Refer to Working with Large Magento Collections.
answered Jan 15 '18 at 11:32
Jehangir WahidJehangir Wahid
63
63
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f34249%2fmagento-too-many-tables-error-bulk-updating-products%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Magmi is a better tool to achieve bulk update for products . found later
– echoashu
Jul 21 '16 at 6:29