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 forums.ablecommerce.com. Please use your AbleCommerce username and password to Login. Forums Registration.



Go to last post Go to first unread
AbleMods Joe Payne  
#1 Posted : Monday, January 7, 2019 10:58:36 AM(UTC)
AbleMods Joe Payne

Rank: Newbie

Groups: Developers, Registered, HelpDesk
Joined: 11/7/2018(UTC)
Posts: 4

I'm unable to install b4510 in my hosting environment. The SQL scripts blow up badly. It looks like certain SQL script commands are hard-coded to the dbo schema.

For example, ac_Layouts never gets populated properly because some of the SQL inserts are hardcoded to the dbo schema. Here is example text copied from the install page 1:


INSERT [dbo].[ac_Layouts] ([LayoutId], [DisplayName], [Description], [FilePath], [IsGenerated], [LayoutTypeId]) VALUES (10, N'Store Header Menubar', N'Layout for Store Header Menubar board', N'~/Views/Shared/Boards/StoreHeaderMenubar.cshtml', 0, 2)

This happens in several other tables too. The install is unusable after the scripts finish.


Joe Payne, AbleMods LLC

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. Forums Registration.

#2 Posted : Monday, February 4, 2019 1:38:13 PM(UTC)

Rank: Newbie

Groups: Administrators, Developers, Registered, HelpDesk, System
Joined: 10/18/2018(UTC)
Posts: 7

Hello Joe,

I'm not sure how to replicate this issue and we've never run into it. How are you setting up your database, which results in them not being prefixed by dbo?

#3 Posted : Tuesday, February 5, 2019 8:20:22 AM(UTC)

Rank: Member

Groups: Developers, Registered, HelpDesk, System
Joined: 10/29/2018(UTC)
Posts: 17

Hi Joe,

The SQL scripts are fixed now. I can send them over if you like.

#4 Posted : Thursday, February 7, 2019 5:22:19 AM(UTC)

Rank: Member

Groups: HelpDesk, Developers
Joined: 11/7/2018(UTC)
Posts: 13

Thanks for fixing that. In the past, I have occasionally run across a site where the tables were not dbo so it would have been a problem with them.
Users browsing this topic
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.