Error on Configure Store page in admin

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
clarkrb
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Fri Jun 12, 2009 9:46 am

Error on Configure Store page in admin

Post by clarkrb » Fri Jun 12, 2009 12:05 pm

I recently installed 7.0.3 of the shopping cart. When I log in under my super user account and go to Configure > Store, it throws an error every time. When I go to the error log, it shows problem as the following:
An error has occured at http://mydomain.com/Admin/Store/StoreSettings.aspx Exception of type 'System.Web.HttpUnhandledException' was thrown.;

User does not have permission to perform this action.
I can get to all the other pages under Configure, just not this one. I tried setting up another super user account and it has the same problem.

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Error on Configure Store page in admin

Post by Logan Rhodehamel » Fri Jun 12, 2009 12:44 pm

Give me a minute to research. This is likely a bug due to database permissions and our Full Text Search detection code.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Error on Configure Store page in admin

Post by Logan Rhodehamel » Fri Jun 12, 2009 12:56 pm

I have logged bug 8150. It has to be researched further to determine the implications of the limited database permissions you face.

For now, I am attaching a modified AC7.0.3 StoreSettings.aspx.cs file. You can replace your existing file with this one. It will capture the error and allow you to use the Configure -> Store page. You will not be able to enable FTS.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

clarkrb
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Fri Jun 12, 2009 9:46 am

Re: Error on Configure Store page in admin

Post by clarkrb » Fri Jun 12, 2009 1:26 pm

That's some seriously impressive turnaround!

I replaced the .CS file and reloaded the page, but got the same error. I tried touching the web.config and loading from a new browser, but that didn't help. I did a compare between the original and new versions of the files and verified it does have your change.

Not sure if the issue is the code or me at this point

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Error on Configure Store page in admin

Post by Logan Rhodehamel » Fri Jun 12, 2009 1:36 pm

It still seems related to FTS, let me attempt to reproduce the databse permissions condition so that I can test the fix myself. It also might help if you edit the web.config. Find the <customErrors node and turn them off. Then visit my modified page and post the actual error message. That would include a reference to the code that is breaking so I can pinpoint.=
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Error on Configure Store page in admin

Post by Logan Rhodehamel » Fri Jun 12, 2009 2:12 pm

I reproduced the situation. In your case, FTS is installed on the server but not enabled for the database. Your database user does not have permission to enable it. This would probably be a common case in hosted scenarios where FTS is an add on service.

Here is a corrected file that can patch your installation. This allowed my test install to proceed without error.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

clarkrb
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Fri Jun 12, 2009 9:46 am

Re: Error on Configure Store page in admin

Post by clarkrb » Mon Jun 15, 2009 7:42 am

This latest fix did work. Thank you.

gdelorey@mitcs.com
Commander (CMDR)
Commander (CMDR)
Posts: 129
Joined: Thu Oct 19, 2006 5:33 pm

Re: Error on Configure Store page in admin

Post by gdelorey@mitcs.com » Thu Jul 02, 2009 10:19 am

Logan -

I ran into this exact issue just now after upgrading from 7.0.0 to 7.0.3 (and performing all incremental updates and hotfixes afterward). I found that the file you posted, StoreSettings.aspx.cs didn't even exist in my Admin\Store\ folder. I did have the .aspx, just not the .cs file. After I loaded in the provided file, it worked like a charm.

Just thought I'd throw this out there in case it happens to others.

Thanks,

: Greg

Post Reply