With DNN running fine. I added the store Admin module to a page and immediately see this message.:

Server Error in '/' Application.

---

The stored procedure 'XXX.dnn_Store_Administration_GetStoreInfo' doesn't exist.

 

I have tried reinstalling the Store module definition. What should I do to fix this  missing SP? Why is it missing? What else is missing? Thank you  in advance for your help.

Thanks Chris, yes, it uses "dnn_". I just looked though the list of Stored Pocedures and do not see either dnn_Store_Administration_GetStoreInfo or Store_Administration_GetStoreInfo.

Hi Mark,

Could you confirm that you do not receive an error message when you install the module? Did you install the Store module for the first time or is it an upgrade?

Every database objects (tables, stored procedure, ..) use the prefix {databaseOwner}{objectQualifier} in the .SqlDataProvider files. This is the "standard" way for being able to use object qualifier. Moreover, I always use the same qualifier (dnn_) with my dnn instances and it works.

Gilles

---

We (team members) are Humans offering their knowledge, their work and their spare time FOR FREE to benefit the community. It would be so particularly appreciated that your messages begin with "Hello" and end with "Thank you" or any other form of politeness. Ask yourself what your reaction would be, if you were approached by me (a total stranger) on the street to ask you something without saying "Hello" nor "Thank you"? After several years of services dedicated to the community, I begin to be tired to read requests without any form of politeness.