logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
2 Pages<12
Error on product tabs
Options
Go to last post Go to first unread
Previous Topic Next Topic
judy at Web2Market  
#21 Posted : Monday, November 16, 2020 6:38:33 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
In both cases, it was TinyInt. They were both old databases, I think one or both started out as AC7. Hopefully, you will have more people upgrading old sites and they might run into this issue.
Back to top
judy at Web2Market  
#22 Posted : Tuesday, November 17, 2020 5:53:03 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
It was smallint and I must have said tinyint from looking at the CatalogNodeTypeId

I checked into an AC 10152 install and in AbleCommerce.sql, code is:
create table "ac_CatalogNodes" (
"CategoryId" int not null,
"CatalogNodeId" int not null,
"CatalogNodeTypeId" tinyint not null,
"OrderBy" smallint default 0 not null) ON 'PRIMARY'

In AbleCommerce2000.sql, code is:
create table "ac_CatalogNodes" (
"CategoryId" int not null,
"CatalogNodeId" int not null,
"CatalogNodeTypeId" tinyint not null,
"OrderBy" smallint default 0 not null) ON 'PRIMARY'



Back to top
Users browsing this topic
Guest (10)
2 Pages<12
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.078 seconds.