Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
No post options display for admin posts to forum
Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 8, 2017 - 1:36 pm

Yes - the following are missing or unavailable:

sp-resources/forum-avatar-pool

sp-resources/forum-custom-icons

sp-resources/forum-language/simple-press

sp-resources/forum-language/sp-plugins

sp-resources/forum-language/sp-themes

sp-resources/forum-cache

There was another two folders that were missing, but I went in via FTP and manually created them on the server to resolve the issue. Should I do the same for all these?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 8, 2017 - 3:20 pm

This just gets stranger.

So it looks like the original problem may be that folders can not be automatically created. Then when you activate the uploader plugin it fails to create the folders so also then stops the install and does not create the new db table either. At least that is my best guess.

So as well as creating the new folders you need the real issue then is working out why they can not be created and that will most often come down to permissions on the server. Can you check them? They should be the same as those set up for the wp-content folder of which they are a grand-children.

But you will also need to check the UID/GUID values on those folders to ensure they have the correct ownership. If you do not know how to check this then to be honest the best and easiest way is to ask your hosting support to check them all to ensure that new folders can be both created and written to by the php software.

andy-signature.png
YELLOW
SWORDFISH
Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 9, 2017 - 7:10 am

Permissions are 755 across the board.  The rest is above my head, so I'll check with my host and get back to you.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 9, 2017 - 10:27 am

Someone will be here...

andy-signature.png
YELLOW
SWORDFISH
Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 12, 2017 - 11:42 am

I've confirmed with my host that "the ownership and the directory permissions for dailywritinghabits.com are properly set."

Does that help?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 12, 2017 - 1:25 pm

Well that is, of course, good news - but doesn't explain why the install failed to create the folders you needed. The only other thing that comes to mind would be something like an .htaccess rule that prevents it.

It probably means that you will need to create these manually. By default they are named (under the sp-resources folder):

forum-image-uploads
forum-media-uploads
forum-file-uploads

If we still need to create the missing table manually will you be able to do that with a sql script that you can run form phpmyadmin?

andy-signature.png
YELLOW
SWORDFISH
Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 13, 2017 - 9:54 am

I had already created those folders manually a while back, so they're there, and the error still occurs, so it must be about the tables.

I should be able to do the sql script thing and create it manually...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 13, 2017 - 11:24 am

Weirder and weirder then!

This is the SQL to create the table.

CREATE TABLE `XXX_sfpostattachments` (
 `attachment_id` bigint(20) NOT NULL AUTO_INCREMENT,
 `post_id` bigint(20) NOT NULL,
 `topic_id` bigint(20) NOT NULL,
 `type` varchar(10) NOT NULL,
 `path` varchar(250) NOT NULL,
 `filename` varchar(100) NOT NULL,
 `size` int(11) NOT NULL,
 PRIMARY KEY (`attachment_id`),
 KEY `post_id_idx` (`post_id`),
 KEY `topic_id_idx` (`topic_id`)
);

Of course you do need to change the 'XXX' for your own table prefix (default of course of 'wp_).

andy-signature.png
YELLOW
SWORDFISH
Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 13, 2017 - 11:50 am

And we have lift-off!

Created the table, activated the plugin, and tested an upload. Everything works like a charm now!

Avatar
James Chartrand
Member
sp_UserOfflineSmall Offline
Jun 13, 2017 - 11:55 am

Oddly, though, now all forum permissions have been knocked out, and each forum displays:

Warning - There are no usergroups with members that have permission to use this forum

I've done the 'Add a User Group Permission Set to an Entire Group', giving Members Standard Access, and it tells me usergroup permission sets have been added to the forums... but the warning doesn't go away.

Help?

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: 639
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17342
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10116
Posts: 79581