Magento Reindexing doesn't work

Posted by Dgent on Stack Overflow See other posts from Stack Overflow or by Dgent
Published on 2012-11-04T16:58:32Z Indexed on 2012/11/04 16:59 UTC
Read the original article Hit count: 162

Filed under:

magento

|

reindex

I recently created around 700 attributes through script, all attributes look fine at backend. But when I reindex, I get following error:

exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.additional_information_s' in 'field list'' in /lib/Zend/Db/Statement/Pdo.php:228

Note: this attribtue exist in Database (eav_attribtue) table.

I would highly appreciate suggestion.

Looking forward to heat from you geeks.

Thanks

© Stack Overflow or respective owner

Related posts about magento

Can't view order in magento

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've been setting up a fresh magento 1.4.0.1 install, working great so far. I did some test orders just to see. Everything works fine, but when I click on "view order" under "my orders", I get a bunch of error messages: There has been an error processing your request Notice: iconv_substr() … >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Developers: Is Magento really -that- good?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are looking at Magento as a possible commerce solution, but we are reading more bad than good on the free product. However Magento sells itself as the best thing ever, so I am confused on its actual value. Thought I'd ask the pros here. Can any seasoned developer here explain the difficulties… >>> More
Loading Magento child html outside of Magento

as seen on Stack Overflow - Search for 'Stack Overflow'
I am loading Magento blocks outside of Magento for certain parts of my site. I can do this successfully with something similar the following. require_once $docRoot.'/app/Mage.php'; umask(0); Mage::app('default'); ... $layout = Mage::getSingleton('core/layout'); $block = $layout->createBlock('Mage_Page_Block_Html_Header'); $block->setTemplate('page/html/header… >>> More

Related posts about reindex

c#/.NET SQLite -- REINDEX not working?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I'm trying to reindex a table in a simple database that I created using SQLite.NET and VS2008. I need to reindex tables after every DELETE command and here is the code snippet I have written (it does not work): SQLiteCommand currentCommand; String tempString = "REINDEX tf_questions"; //String… >>> More
Rebuild the index with REINDEX [closed]

as seen on Server Fault - Search for 'Server Fault'
WARNING: index "pk_alarmid" contains 1363436 row versions, but table contains 26 row versions HINT: Rebuild the index with REINDEX. WARNING: index "alarm_uei_idx" contains 1363434 row versions, but table contains 26 row versions HINT: Rebuild the index with REINDEX. WARNING: index "alarm_nodeid_idx"… >>> More
Force google to reindex

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I changed the structure of my urls. The pages are indexed by google and have the following structure http://mypage.com/myfolder/page.apsx The new structure is http://mypage.com/page.aspx Now all urls that google knows are wrong. How can I tell google to reindex and that the structure has changed… >>> More
Force google to reindex [migrated]

as seen on Server Fault - Search for 'Server Fault'
I changed the structure of my urls. The pages are indexed by google and have the following structure http://mypage.com/myfolder/page.apsx The new structure is http://mypage.com/page.aspx Now all urls that google knows are wrong. How can I tell google to reindex and that the structure has changed… >>> More
Sunspot_Rails Rake Aborted When Running Reindex

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm getting the following output after running rake sunspot:reindex. I'm a novice at Rails. I want to add sunspot_rails to my project to add search functionality (with the hope of deploying the project with Heroku). I'm using Rails 3. I followed the instructions here: https://github.com/outoftime/sunspot/blob/master/sunspot_rails/README… >>> More