ERROR AFTER BACKUP...

Well that also might explain why you were having problems with the links after updating to dolphin 7.1.1

You have a 3'rd Party mod.  Modzzz Notes that is somehow integrating with the store.

Your going to need to check with modzzz

OR (`module_id`>=1 AND `module_id`= AND `module`='store' AND

Seems to be missing the parameter (is that the correct term in sql?) after 'module_id'  or is there suppose to be another module_id?  We are saying that we want module_id greater or equal to 1 and module_id equal to some value.  I wonder if that was suppose to be OR (`module_id`>=1 AND `module`='store' AND

I didn't know Modzzz Notes integrated with the store.  I have Modzzz's Notes module on my site.

 You have to add it in the admin section...

After deleting my entire site and re-uploading the backup then clearing cache the error still stuck around thinking there is no way that is possible, I cleared browser cache and now the store is working fine again... $&@)!& cache is such a wonderful cluster &@$& in my terribly troubled mind... 

Don't forget that HostGator upgraded all their dedicated servers with now new IPS and all the wonderful settings that are effected by such a choice... OH joy! 

Well I'm not sure why the links broke to the store but sure need to know why so when the update is done it won't happen again... You are thinking it was the note addition? 

Using a text search programme; I use the one built into PsPad but some have mention others, and search Modzzz's Notes for OR (`module_id`>=1 AND `module_id`= AND `module`='store' AND and see if it does contain that.  If it does, then you can either edit it or contact Modzzz and ask about it.  If it does not show up, then what corrupted the module to change it?  That is what trip the error.  From looking at the code, the second module_id should not be there.  Why would you check to see if module_id is greater or equal to 1 and then check to see if module_id is equal to some value?  I guess Modzzz can tell you.  Anyway, first is to check the code to see if it does or does not contain that text.