Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreErrors and Missing Procedure on 4.7 and Store 2.01Errors and Missing Procedure on 4.7 and Store 2.01
Previous
 
Next
New Post
11/15/2007 3:58 PM
 

I get the following errors on the store modules after upgrading my DNN 4.5 to 4.7 and upgrading the store to 2.01.

On the Store Admin moduke I get:

The stored procedure 'dbo.Store_Administration_GetTaxRates' doesn't exist.  I checked SQL and it's is indeed not installed.

On the Store Catalog I get:

Store settings are not defined.
DotNetNuke.Services.Exceptions.ModuleLoadException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object. at DotNetNuke.Modules.Store.WebControls.Catalog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Any ideas?

 



Steven Webster
Manager, Community Platform
F5 Networks, DevCentral
 
New Post
11/15/2007 4:13 PM
 

Just a little more info.  I search through the SQL providers and it looks like this procedure was installed in 01.00.00 SQL Data Provider then altered in 02.00.00.  When I try and run the original create statement in SQL from the 01.00.00 provider I get the following error:

Msg 207, Level 16, State 1, Procedure Store_Administration_GetTaxRates, Line 5
Invalid column name 'DefaultTaxRates'.
Msg 207, Level 16, State 1, Procedure Store_Administration_UpdateTaxRates, Line 0
Invalid column name 'DefaultTaxRates'.

Seems like this is a little deeper than I thought.  Any ideas appreciated



Steven Webster
Manager, Community Platform
F5 Networks, DevCentral
 
New Post
11/16/2007 9:58 AM
 

Hi Steven,

The second message is normal, it's because you do not have defined the Store setings. But you can't because the first error!

If you do not have important data inside the Store, you can try to uninstall the module. Normaly, Store 02.01.00 deleted all tables and stored procedures with the prefix name "Store_". Then, reinstall the module.

I have tested the module with all DNN versions from 4.1.0 to 4.7.0, for me 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.
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreErrors and Missing Procedure on 4.7 and Store 2.01Errors and Missing Procedure on 4.7 and Store 2.01


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out