Friday, January 09, 2009 | Register | Login 
Minimize
 Module Support Forums
 
 Forum Forum metaPost Forums metaPost Forums Providers - Ven... Providers - Ven... Some issues I found Some issues I found
Previous Previous
 
Next Next
New Post
 11/19/2008 9:07 AM
Don Worthley
201 posts
9th Level Poster


Re: Some issues I found
 
Mike,

Wow, this post is full of helpful details and I can tell you've spent a ton of time dealing with this issue.  I can assure you that we'll get to the bottom of it. I'm working on something else today, so it may be a few days before I am able to find the issue and come up with a fix, but here's something you can try in the mean time. 

In metaPost, there's a way to associate an image that you add in your post as the article image.  This was designed so that you don't have to go fiddling around in the file system from the web site to associate an article image.  Just add an image to your post, I usually put mine at the top of the post and set the alt tag of the image to ai, for article image.  When you publish, this image should be used as the article image and it should be removed from the post.  If you wanted the same image in the post, you would copy it again and leave the alt attribute set to something other than ai. 

HTH and I'll try to get a workaround to the file and folder issues you've documented so well.

Thanks,

Don

PS, could you email me your contact information in case I need to get in touch while working on this issue.  Feel free to email me at don at itcrossing and then dot com.  Thanks!
 
New Post
 12/8/2008 5:29 PM
Don Worthley
201 posts
9th Level Poster


Re: Some issues I found
 
Modified By Don Worthley  on 12/8/2008 7:37:01 PM
Hi Mike,

This is just a repeat of the email I sent earlier today for those reading the thread in the forums. 

I’ve researched this and I think I’ve found the issue.  It looks like I need to set permissions on the folders when they are created.  Of course, this won’t address the permissions issues for files that were already created in order to do this, we’ll have to execute a few scripts.  Be sure to back your database up before you execute the following scripts, since the second script will update the permissions table.

 

First, start by retrieving the AdministratorRoleId for your current portal by executing the following script:

 

SELECT PortalName, AdministratorRoleId from {databaseOwner}{objectQualifier}Portals

 

Remember the AdministratorRoleId for use below.

 

Next copy the following script and change the ??? to equal the AdministratorRoleId you recorded above.  Additionally, change the lines that contain the string ‘images/%’ to be more specific if you want to update the permissions only for a subset of folders created by WLW.  The following script will allow read access to everyone and read and write access to the Administrator role for your portal.

 

--***** Begin Script *****

 

DECLARE @AdministratorRoleID int

SELECT @AdministratorRoleID =  ???

 

 

INSERT INTO {databaseOwner}{objectQualifier}FolderPermission

                      (FolderID, PermissionID, AllowAccess, RoleID)

SELECT     f.FolderID, 5 AS PermissionID, 1 AS AllowAccess, -1 AS RoldID

FROM         {databaseOwner}{objectQualifier}Folders AS f LEFT OUTER JOIN

                      {databaseOwner}{objectQualifier}FolderPermission AS fp ON f.FolderID

 

= fp.FolderID AND fp.RoleID = -1

WHERE     (fp.FolderID IS NULL) AND (f.FolderPath LIKE 'images/%')

 

 

INSERT INTO {databaseOwner}{objectQualifier}FolderPermission

                      (FolderID, PermissionID, AllowAccess, RoleID)

SELECT     f.FolderID, 5 AS PermissionID, 1 AS AllowAccess, @AdministratorRoleID AS RoldID

FROM         {databaseOwner}{objectQualifier}Folders AS f LEFT OUTER JOIN

                      {databaseOwner}{objectQualifier}FolderPermission AS fp ON f.FolderID

 

= fp.FolderID AND fp.PermissionID = 5 AND fp.RoleID = @AdministratorRoleID

WHERE     (fp.FolderID IS NULL) AND (f.FolderPath LIKE 'images/%')

 

INSERT INTO {databaseOwner}{objectQualifier}FolderPermission

                      (FolderID, PermissionID, AllowAccess, RoleID)

SELECT     f.FolderID, 6 AS PermissionID, 1 AS AllowAccess, @AdministratorRoleID AS RoldID

FROM         {databaseOwner}{objectQualifier}Folders AS f LEFT OUTER JOIN

                      {databaseOwner}{objectQualifier}FolderPermission AS fp ON f.FolderID

 

= fp.FolderID AND fp.PermissionID = 6 AND fp.RoleID = @AdministratorRoleID

WHERE     (fp.FolderID IS NULL) AND (f.FolderPath LIKE 'images/%')

 

--***** Begin Script *****

HTH,

Don

 
New Post
 12/8/2008 5:30 PM
Don Worthley
201 posts
9th Level Poster


Re: Some issues I found
 
I should have also noted that there is an update that will fix this issue moving forward that will be coming out soon in the 1.2.8 release, which is just a bug fix release.

Don
 
Previous Previous
 
Next Next
 Forum Forum metaPost Forums metaPost Forums Providers - Ven... Providers - Ven... Some issues I found Some issues I found
 Print