Store Menu is disabled

I have installed the Commerce Kickstart (with Drupal Core) and Its installed successfully. Previously we are able to see the "Store" Menu link in the administrator login. But currently its not showing "Store" Menu. Instead of the Store menu its showing the "Customer Profile" Menu. When i click customer profile it showed the following error message. I am sure that i didn't change any settings / configuration after installation

'Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'FROM
commerce_product commerce_product
ORDER BY unknown ASC
LIMIT 10 OFFSET 0\' at line 1'
in views_plugin_query_default->execute() (line 1386 of /var/www/html/cemeterymemorials/sites/all/modules/views/plugins/views_plugin_query_default.inc)

Could Please any one help me on this to fix this issue.

Posted: Dec 20, 2011


rfay Randy Fay on December 20, 2011

Can you reproduce this on a clean installation? If so, please let us know what version of mysql you're using. If not, you'll probably want to look into what contrib modules you're using, and you may want to undergo a debugging routine where you disable them by batches until you find the culprit.

zmtnman on December 22, 2011

Hi Randy

Just for closure sake... vinothbabuog restored the database with the previous day backup and apparently they have not seen the issue since.

Thanks for your response

vinothbabuog on December 26, 2011

Hi Randy,

Thanks for your response.

I have installed fresh Drupal Commercekickstart and installed the all the custom module which i have installed in our stagging server to reproduct the Bug in my local machine. But I am not able to reproduce the Bug again.

For timebeing, i have restored the database with previous day and its worked fine.