BV Commerce Forum
»
BV Commerce Support
»
General Support
»
ISSUE SP3-03: Plugin tab may be missing from admin after upgrade from SP2 store
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
A bug has been reported with SP3 where the plugin tab is missing from the admin interface after upgrading from SP2.
Please help us track down this bug by supplying the following information if you are experiencing the issue. Please include ONLY information about this specific bug. We will post other threads about other reported bugs.
1) What version(s) of BV Commerce 5 has your store used? For example: 5.01->SP1->SP2->SP3
2) Did you install any beta versions of SP3 before the final version? If so, did you install only beta 1, beta 2 or both
3) Please list the steps required to duplicate the bug and what you expect the behavior of the software to be.
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
SP2 to SP3
No installations of betas on the live site. We had one for a few hours, but the files and db were replaced from clean copies.
|
|
|
|
|
|
Rank: Member
Joined: 4/30/2007(UTC)
Posts: 383
|
I just copied the folder with the same permissions for the BV Froogle Feed. I renamed it to Feed and dropped it into the BVAdmin folder. I can run the feed.
|
|
|
|
|
|
Rank: Member
Joined: 6/26/2006(UTC)
Posts: 351
|
1) 5.01->SP1->SP2->SP3
2) Did you install any beta versions of SP3 before the final version? If so, did you install only beta 1, beta 2 or both - No, not on live store
3) Please list the steps required to duplicate the bug and what you expect the behavior of the software to be - Log in and I do not see the Plugins tab |
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Ran SP2 to SP3 on exisiting SP2 site that had all the hotfixes manually installed. Site was originally created from SP2. |
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
In the database table, bvc_RolePermissions, the entry for Plug-ins-View is missing on those sites updated from SP2 to SP3, but not on new SP3 sites.
In the file Datascript.sql in the SP2 to SP3 update, there is this line:
-- Delete 1 row from [dbo].[bvc_RolePermission]
DELETE FROM [dbo].[bvc_RolePermission] WHERE [bvin]='403F3109-1A6D-48D6-8753-91EA59A8A318'
this corresponds to the plug-in entry that was deleted. |
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Running the line in a query window taken from the PopulateDate.sql file:
INSERT INTO [dbo].[bvc_RolePermission] ([bvin], [Name], [SystemPermission], [LastUpdated]) VALUES ('403F3109-1A6D-48D6-8753-91EA59A8A318', N'Plug-ins - View', 1, '10/4/2007 12:00:00 AM')
will restore the tab. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Chris,
You are correct but I would advise against running the SQL scripts that you are posting. We are working on a patch SQL file that will break when it encounters your one-off fixes.
The issue has been traced to an incorrect SQL script included with the SP2 to SP3 patch. The data script included was actually the rollback script. It does no harm to your database but it also fails to correctly install the required new table rows for SP3.
Again, we are working on a SQL script to correct this error and others and will be posting it tomorrow. I appreciate the awesome help from the community but I would advise against running one-off SQL scripts and instead wait for the official hot fix from BV.
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
No problem. Just trying to point out the issues so you can fix them.
Note to all: Use what I've posted for all recent fixes at your own risk.
Update: The entry in the table added by the above SQL can be just as easily deleted prior to runing the final fixes. |
|
|
|
|
|
|
Rank: Member
Joined: 3/15/2007(UTC)
Posts: 126
|
Just to stay on track with everyone else reporting this problem. I experience the issue when I installed SP3 on a store with SP3 Beta 2 installed and on stores running SP2 upgrading to SP3 finale. I will watch for the hot fix. Thanks. |
|
|
|
|
|
|
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.