Server Crashed - cannot get Able working - need Advice

[wendyc]

We had a server casualty, and I need to get 2 Able 7.0.3 shopping carts back up and running. Luckily, I was able to recover the database and the website files. I've set those up on the same O/S (Windows Server 2003) in the same version of IIS (6.0) and on the same version of SQL (2000). However, the sites will not come up. I also tried following the instructions at help.ablecommerce.com for "How do I change or move an existing installation?". That did not work at all because when I tried to surf to the http://mysite/install/default.aspx file, I received a "file not found" error. I've checked the version of ASP - 2.0 - and I've set up "default.aspx" as a default content page. I do not have any idea how to proceed further.

[dgoranov]

What is the errors you are getting from the installation? Possible reasons:

- If the new install is under a new physical folder location the AbleCommerce license will be required
- make sure the new folder has Read/Write permissions granted for IIS ASP.NET Worker Process
- check the IP binding in IIS and make sure the binding is being set properly

[wendyc]

Thanks for your response. There were actually many issues, and I have resolved some of them. I did not complete a new installation... I just moved the files and the database to the new server. One issue was that the AC license was showing c:\inetpub\wwwroot... and I had the files on D:. Moving the files fixed that. I also had to install Asp.Net 2.0 AJAX Extensions 1.0. That fixed one issue. Now I have a situation where some of the tables are not showing "dbo" as the owner. I'm getting the following error now:
------------------------------------------------------
Server Error in '/' Application.

Invalid object name 'ac_Kits'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ac_Kits'.
------------------------------------------------------
I've been searching online for a way to change the ownership of the tables, and I've found some posts, but they are confusing.

[AbleMods]

I've been searching online for a way to change the ownership of the tables, and I've found some posts, but they are confusing.

I have an article on how to do it here: http://support.ablemods.com/default.asp?W23

The title doesn't apply to your situation, but the steps do.

[wendyc]

Thanks, Joe, your post was very helpful. I wasn't able to use it specifically as it was written since our SQL server for the AC databases is SQL 2000. Apparently, there was a shift in how the owner/schema was handled from 2000 to 2005. What I ended up using was this (in case it helps anyone):
use mydatabasename
EXEC sp_changeobjectowner 'tablenameprefix.ac_Wishlistiteminputs', 'dbo';

I ran that in SQL Query Analyzer once for every table that was showing the "bad" schema. This fixed the issues on one of my databases/shopping carts, but I'm still experiencing an issue with the other one. Don't know if you can help, but when I surf to the website I'm just getting "Service Unavailable". So descriptive...

[wendyc]

I resolved the "Service Unavailable" issue...some of the files in the website directory were read only. I also realized that I needed to install an SSL certificate, so once that was done the Admin login page and backend manager started working. Now there's just one more issue to resolve (that I know of). The error I'm getting is:

[[ConLib:CategoryGridPage4]] (0): error CS1705: Assembly 'AjaxControlToolkit, Version=3.0.20229.20843, Culture=neutral, PublicKeyToken=28f01b0e84b6d53e' uses 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' which has a higher version than referenced assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'

My research indicates that this is because there are multiple files that are pointing to different versions of the same dll. I found a post on this forum viewtopic.php?f=42&t=12168&p=52375&hili ... ly#p52375" from someone who reported the issue in 2009, but there was no resolution posted with it. I'm researching this now, but if anyone has a clue please chime in.

[Katie]

I also had to install Asp.Net 2.0 AJAX Extensions 1.0.

The web.config for Asp.Net 2.0 should be used. In your error, it looks like you might be using version 3.5.

Besides the web.config file, you need to be using the older AjaxControlToolkit.dll and ComponentArt.Web.UI.dll. All 3 files can be found in the \install\Framework\NET20 folder of the original software download.

I'm not sure this will solve the problem, but it seems possible from the error message that there is an Asp.Net version mismatch.

Hope it helps,
Katie

[wendyc]

Thanks, Katie. I brought in the 3 files from the Install\Net20 folder as mentioned at http://help.ablecommerce.com/installati ... mework.htm. Everything seems to be working on one of my shopping carts but not on the other.

[AbleMods]

Everything seems to be working on one of my shopping carts but not on the other.

Still the same error?

[wendyc]

Joe,
I still have the ASP error on some of the pages of one of the carts. I haven't taken any action on Katie's post because as far as I know what she recommended is what I did. It does seem like she's targeted the problem, but I still don't know how to resolve it. I'm using the same set of files for both carts (in terms of the web.config and 2 dlls). They are also both set to use the same version of ASP in IIS.

[AbleMods]

Doesn't sound like permissions on the SQL tables are correct yet.

[wendyc]

Problem solved. Added code to webconfig file, restarted the website and it worked. Here is a link to the page that helped us resolve the issue http://wiki.asp.net/page.aspx/1075/ajax ... n-problem/

[AbleMods]

I actually run into that a lot now when I open a .Net 2.0 AC7 install in Visual Studio 2010. VS2010 won't rebuild the site until you set target framework to .Net 4.0 which then reconfigures the web.config which then breaks the AJAX. it's still very confusing to me.