After Upgrade Error

[atulkhare]

Hi,

after completion of upgradation from 7.0 to 7.1 was fine there was no error
but when i have upgrade 7.1 with 7.2 it is generating error like

"[[ConLib:CategoryGridPage]] The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. "

please let me know what should i do to remove this error..

Regards,
Atul khare

[Katie]

Hello,

Please see the Known Issues page on the help site.

http://help.ablecommerce.com/upgrades/a ... _7.0.2.htm

A patch is available.

[atulkhare]

Hi,

you are correct this patch will resolve the error of this page but these patches are only when we are using sqlserver2000 instead of sqlserver2005..
but i am using sqlserver2005 which is hosted in AquestHosting Hosting site..
even though it is generating error..
when i dawnload these patch so the existing problem is resolved but many other errors are generating like (i am mentioning link please visit)

"http://www.silversentiments.com/Chain-w ... -P228.aspx"

please confirm these patches are for when we use sqlserver2000.
please help me to resolve this issue , our work is totally effecting due to this problem.

Regards,
Atul Khare

[jmestep]

It looks like you missed a line of code to change in a customized page. That code in Able 7.0.2 in a category page is
CommerceBuilder.Reporting.PageView.RegisterCatalogNode(this.CategoryId, CatalogNodeType.Category);

I can't find your code on any of my product pages, but I don't have 7.0.1 active anywhere.

[atulkhare]

Hi,

you are saying that there is any line of code is missing, but i didn't made any changes from my side.as i told you before i am using sqlserver 2005 witch is hosted on aquest hosting
Previously the ERROR was

"[[ConLib:SearchPage]] The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator"

but when i was download the patch and replace the commercebuilder.dll so this error was resolved but another errors are generating Please visit these link

"http://www.silversentiments.com/Chain-w ... -P224.aspx"

And

https://www.silversentiments.com/Checkout/Default.aspx

can you tell me these all problems are related to database ? is it behaving like sql server 2000?


Regards,
Atul Khare

[Katie]

Hello,

Please make sure you complete Step 7 of the post-upgrade instructions.

http://help.ablecommerce.com/upgrades/a ... _7.0.2.htm

Thanks,
Katie

[atulkhare]

Hi,

Thanks a lot for your help..
some error were generating on product pages has been resolve with your help,
but some other errors are still generating, please visit this link

https://www.silversentiments.com/Checkout/Default.aspx

one more question is when i was upgrade my ablecommerc 7.0 to 7.07 on local machin so there was no error that was successfully done , but on server why these error are generating..
is there any problem with database?

Regards
Atul khare

[Katie]

Are you using any custom controls on this page? Part of upgrading is to make sure that you merge any customizations. I haven't seen this error before so it is likely something that you have changed and now is having a problem after upgrading.

[Brewhaus]

I am having the exact same issue. Fortunately I was able to revert relatively easily, but still need to get the upgrade from 7.0 to 7.0.2.

There are no customizations that I can think of to any files aside from our invoices, abandoned baskets, etc. Most of these are already in custom folders.

Things work fine on the home page, but we cannot access our category pages.

Any thoughts?

[Brewhaus]

Incidentally, the exact error that we are receiving is:

[[ConLib:Custom/CategoryGridPage4]] c:\New Folder\Websites\Hot Sauce Depot\ConLib\Custom\CategoryGridPage4.ascx.cs(90): error CS0117: 'CommerceBuilder.Services.AbleCommerceHttpModule' does not contain a definition for 'RegisterCatalogNode'

I assume that we may need to perform step 7 in the Post Upgrade tasks, but where exactly do we make the change that they specify in step 7?

[jmestep]

You will need to change the line with the error
//REGISTER THE PAGEVIEW
CommerceBuilder.Services.AbleCommerceHttpModule.RegisterCatalogNode(this.CategoryId, CatalogNodeType.Category);

to:

//REGISTER THE PAGEVIEW
CommerceBuilder.Reporting.PageView.RegisterCatalogNode(this.CategoryId, CatalogNodeType.Category);

[Brewhaus]

Thanks Judy. Now, will this be just in the CategoryGridPage4.ascx.cs file, or will there be other locations that I also need to do this?

[jmestep]

That depends on whether you are using a customized file or an original Able one. If you are using original Able files in the ConLib folder, those would have been changed by being overwritten in the upgrade.

[Brewhaus]

Thanks. I went through each file in the ConLib/Custom folder and updated where needed (only the one Category file). There were several other customizations that needed to be handled after the upgrade, though, which was time consuming. But, all it running smoothly now with dual sites on 7.0.2!