Invalid website id requested.

piaoling  2011-05-13 18:38:02

http://www.magentocommerce.com/boards/05/08/viewthread/217279/#t296715

 

I get this error every time I do anything with my products.  I had two stores but then figured out I only needed one. So I went through and set all the products to one store and deleted it.  Now I get this error and it also gives me an error in my indexing.  The Product Flat Data just shows processing.

This is all new to me so I’m learning as I go.

 
 Posted: January 15 2011   |  top 
Magento Community Magento Community
Magento Community
Magento Community
 Turnkeye.comGuru 
Avatar
Total Posts:  706
Joined:  2008-12-20
URL: turnkeye.com
 

Most likely the limit of maximum PHP execution time of your Magento script was reached and reindexing was terminated.
The flag file which indicates that reindexing is still in process is still locked. Flag files located in /var/locks directory.

Try to increase the maximum execution time limit, remove lock files from /var/locks directory the and start reindexing again.

Turnkey Ecommerce Solutions
Magento Design, Magento Development, Magento Hosting
Request Free Quote
Facebook | Blog

 
 Posted: January 15 2011   |  top  |  # 1 
Magento Community Magento Community
Magento Community
Magento Community
 FisherHoneyBeesJr. Member 
Total Posts:  26
Joined:  2009-11-10
 

I did that. I still get the Invalid website ID request.  I get that message also when I add or update a product.  It seems to still update the info in my store but still shows the error at the top of the window.

 
 Posted: January 16 2011   |  top  |  # 2 
Magento Community Magento Community
Magento Community
Magento Community
 Turnkeye.comGuru 
Avatar
Total Posts:  706
Joined:  2008-12-20
URL: turnkeye.com
 

Seems something wrong with the database.
I investigated similar issue recently, it was connected with error in inner database structure (connections between tables).
It took me some heavy debugging.

Turnkey Ecommerce Solutions
Magento Design, Magento Development, Magento Hosting
Request Free Quote
Facebook | Blog

 
 Posted: January 16 2011   |  top  |  # 3 
Magento Community Magento Community
Magento Community
Magento Community
 FisherHoneyBeesJr. Member 
Total Posts:  26
Joined:  2009-11-10
 

Great :(

I’m trying to keep my head above water as it is now with this software.  I have a backup that I used the software to do that is stored online that was before this started happening.  What are the chances of me being able to use that to fix this?

GRRRRRRRRRRRRRRRRRRRRRRRR

 
 Posted: January 16 2011   |  top  |  # 4 
Magento Community Magento Community
Magento Community
Magento Community
 FisherHoneyBeesJr. Member 
Total Posts:  26
Joined:  2009-11-10
 

OK...I’ve gone through my database via the php admin and done a search for anything that had to do with website id and I can’t find anything that is pointing to something other than my one web site.

I’m stumped!!!

Any other pointers on where to look or what I can check?

What am I missing in looking in the tables themselves?

 
 Posted: January 24 2011   |  top  |  # 5 
Magento Community Magento Community
Magento Community
Magento Community
 mediagangSr. Member 
Avatar
Total Posts:  110
Joined:  2008-01-17
Leeds UK
 

I deleted some stores and this caused the

Invalid website id requested

for me.  I fixed by running the database repair tool http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/db-repair-tool

UK Magento Services
Solar Gadget Store : Catering Equipment : Guerrilla Marketing

 
 Posted: March 26 2011   |  top  |  # 6 
Magento Community Magento Community
Magento Community
Magento Community
 mattdev_nzJr. Member 
Total Posts:  11
Joined:  2010-06-22
 

** Do a full backup first and test this in a separate staging environment **

I had same error, database repair didn’t help but it should be tried in first instance

Closer look and in the database / phpmyadmin

Table core_store and core_store_group the deleted website / store entries were still there so deleted those and problem solved

New Zealand based Magento Freelancer - Magento performance tuning for CE - PM to hire me

 
 Posted: 1 month ago

 


For my opinion:

dump the website id directly,and Go to database table core_websites to see wether this website id exist or not,may be it is because magento database is broken.

类别 :  magento(258)  |  浏览(25702)  |  评论(1)
发表评论(评论将通过邮件发给作者):

Email:
userhead
2011-11-01 17:53:58
Thanks