Did you import a data base to your local setup?
Please check following http://magento.stackexchange.com/a/60962/3895 it may help you.
Did you check any template or code used for the Home page? It may help you to find the issue.
Actually i moved my magento store from one server to another server. I already import database from older server. Due to this i am getting same error for various tables and collections
There seems some problem with database. Could you try to re import the database and check again?
Or you may try solution provided by Fabian at following link http://magento.stackexchange.com/a/84144/3895
Try to take database dump using SSH and for import also use SSH commands.
I import database, while importing database it display a warning 'Your execution is not completed, you can resume import ' on phpmyadmin. So as per error i want to ask is there any way to increase import execution time limit on mysql server, Or i should breakdown the database file and import a bunch of tables separately.
If you are using xampp on localhost try following.
1) Go to command prompt
2) mysql -u <username> -p <databasename> < C:\Users\username\Desktop\DB.sql
then press enter and provide the password for the mysql.
It will start a import process for you. You can modify the command on the Linux server like following
mysql -u <username> -h <host ip address> -p <databasename> < /var/www/DB.sql
Note: replace /var/www/DB.sql with the actual path of DB dump file.
Check core_store, core_website and core_store_group tables.
SELECT * FROM core_store WHERE code='admin';
SELECT * FROM core_store_group WHERE name='Default'; SELECT * FROM core_website WHERE code='admin';
There is a possibility that in these tables Admin is created as 1 for id. It should be 0 in all cases.
UPDATE `core_store` SET store_id = 0 WHERE code='admin';
UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
UPDATE `core_website` SET website_id = 0 WHERE code='admin';
In another case, you might have 0 for id but there can be multiple rows inserted with the same value.
Delete such duplicate rows from core_store, core_website and core_store_group tables and the issue will be solved.