问题描述
尝试在Magento商店中创建新帐户时收到此错误.
I'm receiving this error when I attempt to create a new account on my Magento store.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ca.sort_order' in 'order clause'
/home/user/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
/home/user/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
/home/user/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
/home/user/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
/home/user/public_html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
/home/user/public_html/lib/Varien/Data/Collection/Db.php(783): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
/home/user/public_html/lib/Varien/Data/Collection/Db.php(696): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
/home/user/public_html/lib/Varien/Data/Collection/Db.php(617): Varien_Data_Collection_Db->getData()
/home/user/public_html/lib/Varien/Data/Collection.php(729): Varien_Data_Collection_Db->load()
/home/user/public_html/app/code/core/Mage/Customer/Model/Form.php(222): Varien_Data_Collection->getIterator()
/home/user/public_html/app/code/core/Mage/Customer/Model/Form.php(320): Mage_Customer_Model_Form->getAttributes()
/home/user/public_html/app/code/core/Mage/Customer/controllers/AccountController.php(262): Mage_Customer_Model_Form->extractData(Object(Mage_Core_Controller_Request_Http))
/home/user/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Customer_AccountController->createPostAction()
/home/user/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(253): Mage_Core_Controller_Varien_Action->dispatch('createpost')
/home/user/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
/home/user/public_html/app/code/core/Mage/Core/Model/App.php(340): Mage_Core_Controller_Varien_Front->dispatch()
/home/user/public_html/app/Mage.php(627): Mage_Core_Model_App->run(Array)
/home/user/public_html/index.php(80): Mage::run('', 'store')
{main}
一些背景信息:我使用的是为1.4.x构建的模板，但目前使用的是1.5.0.1稳定版.
Some background info: I'm using a template that was built for 1.4.x but I'm currently using version 1.5.0.1 stable.
我尝试了在此处找到的SQL修复程序: http://www.magentocommerce.com /boards/viewthread/214185/#top ，但是它不起作用.有什么想法吗?
I attempted the SQL fixes found here: http://www.magentocommerce.com/boards/viewthread/214185/#top but it did not work. Any ideas?
已删除错误，因为它们不相关
推荐答案
问题是我的数据库严重损坏.我怀疑是从购买的Magento模板上传示例数据时，还是将网站从一台服务器迁移到新服务器时，都可能出现了问题.
The problem was that I had a seriously defective database. I suspect the problem might have arisen either when uploading sample data from a purchased Magento template or when I was migrating my website from one server to a new one.
我通过运行Magento的数据库修复工具对其进行了修复，该工具可在以下链接中找到: http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool
I fixed it by running Magento's database repair tool which can be found at the following link: http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool
弹出的错误有很多Added missing foreign key(s)和两个Added missing fields.有关弹出的错误的完整报告，请转到以下堆栈溢出问题:
The errors that popped up were a lot of Added missing foreign key(s) and two Added missing fields. For a full report on the errors that popped up, go to the following Stack Overflow question:
这篇关于Magento-注册错误-1054'order子句'中的未知列'ca.sort_order'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！