Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Upload Attachment button missing
Avatar
Victoria Pike
Member
Free Members
sp_UserOfflineSmall Offline
Jan 12, 2013 - 6:08 am

The install of Simple:press was done in November and I re-installed the plugin yesterday. I haven't recently upgraded and I don't think I've tested the functionality before so can't be sure it was ever working. My guess is it wasn't.

Regarding creating a topic as an administrator - this was working and now isn't. The only thing I changed was the odd permission option but nothing that I could see would affect something so basic.

There are 46 rows in wp_sfauths, 2 of which have a value of 1 and 44 of which have a value of 0.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 12, 2013 - 12:17 pm

This all sounds more or less what I would expect it to be. So all very confusing.
Could you by any chance make a screenshot of one of the permission sets and attach it here for us to look at. I would like to see what you do have and what is not there so we can try and work out any common denominator there might be?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Victoria Pike
Member
Free Members
sp_UserOfflineSmall Offline
Jan 12, 2013 - 1:11 pm

Image Enlarger

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Jan 12, 2013 - 3:22 pm

so 46 rows...  I only count about 40 in the image...  all should be listed...  so can you look at the db again...

in the auth_name column, are any called upload_image, upload_media, or upload_files?

Avatar
Victoria Pike
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2013 - 4:56 am

Hmmm - this looks suspicious....I ran the following query and the auth_cat ids are different:

Image Enlarger

 

I then looked in the sf_authcats table and auth_cat_id 8 doesn't exist. I'm guessing this is the problem!

Image Enlarger

So, If I updated auth_cat in the sfauths to 15 where it is currently 8 and auth_name is like 'upload%' I'm hoping it would fix it without corrupting anything else? Please confirm.

I haven't touched the base tables at any point so I'm a bit concerned it has got into this state. Any ideas?

Thanks, Vicky.

 

 

 

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 14, 2013 - 6:22 am

The answer is yes and no. It should make things work so yes. But no in that there may be other things lurking that are also incorrect.

A small group of users experienced permission corruption when upgrading from a V4 version. Despite hours of testing we have never been able to track down the actual cause. One user even sent us a pre-upgraded database for us to try with which, typically, failed to corrupt when we tried it. We apologise if you too have been hit by this but that data you showed does appear this might be the case.

There are two ways to fix this. You can clean up the database manually as you suggest and if the corruption is minor that would be fairly easy. Or - to be sure and safe - you could reset your permissions (from the Permissions admin menu). The problem here is that it resets them back to our 'out-of-the-box' defaults so you have to re-apply any adjustments you may have made and also re-assign them to the forums. This doesn't usually take as long as it sounds and is the safest method of course.

Again apologies you have been hit by this problem.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Victoria Pike
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2013 - 6:25 am

I think I will reset the permissions as I also have the problem with Admin not being able to post so hopefully that will also fix this. I'll let you know how I go.

Thanks,

Vicky.

 

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 14, 2013 - 8:09 am

I think that is the wisest course.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Victoria Pike
Member
Free Members
sp_UserOfflineSmall Offline
Jan 14, 2013 - 1:16 pm

??????

I've reset permissions and now all I get on Standard Access is:

 

Image Enlarger

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jan 14, 2013 - 2:08 pm

Well that is unexpected and most curious indeed.
Are there any errors reported in the Toolbox > Error Log related to SQL, database or the permissions tables in particular?

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625