SQLSTATE[HY000]: General error: 126 Incorrect key file for table Error in Magento

Hi,

If you face error some thing like “SQLSTATE[HY000]: General error: 126 Incorrect key file for table ‘/var/tmp/#sql_41ac_0.MYI’; try to repair it” error its because of MySQL tmp folder space issue

there is not enough space in /tmp for the temporary table, so this error will through
I fixed this by setting “tmpdir = /home/tmp” (which has lots of space on my host) in my.cnf
just create a folder tmp which has enough space and give tmpdir in my.cnf in my case i used home/tmp where i had enough space for tmp directory but in your case it may change
Enjoy :-)
http://www.magentocommerce.com/boards/viewthread/302400/