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
Importer says "Sorry, you are not allowed to access this page."
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 10, 2017 - 3:29 pm

Will do - thanks for your help with this.

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Mar 11, 2017 - 1:11 am

all else failing, might be worth removing the plugin and then try uploading again in case something went south during the upload...

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 11, 2017 - 10:58 am

Tried that several times.... thanks though. Still investigating.

Digging into the database, would any of these be affecting me and do they look correct? Or anything else in the database you think I should maybe look at? 

INSERT INTO `wp_sfpermissions` (`permission_id`, `forum_id`, `usergroup_id`, `permission_role`) VALUES
(1, 1, 1, 4),
(2, 1, 2, 4),
(3, 1, 3, 5),
(4, 2, 1, 2),
(5, 2, 2, 4),
(6, 2, 3, 5),
(7, 3, 1, 2),
(8, 3, 2, 4),
(9, 3, 3, 5),
(10, 4, 1, 1),
(11, 4, 2, 4),
(12, 4, 3, 6);

Thanks again for the help!

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 11, 2017 - 11:48 am

I don't know what this means, if anything... 

If I try to access the spimport-setup.php file directly, not through admin.php, like this:

mysite.com/wp-content/plugins/sp-import/admin/spimport-setup.php

I get an "HTTP ERROR 500" saying this page isn't working.

If I try to - directly - access any other url in the SF menu the same way, I get:

"Access denied - you cannot directly call this file"

Does that mean anything? Just grasping at straws now 🙂 But sometimes that provides hints. 

Ran the wp debugger again and logged everything, still no errors there related to spimport-setup.php or any other FS files.

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 11, 2017 - 12:24 pm

Sadly no. And as the admin you are not subject to the same permissions as a user in any case.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 11, 2017 - 12:33 pm

The 500 status is because it is trying to make calls to functions it is no longer tied to so it actually ends quite quickly in a php fatal error. You will see that if you look in your servers error log.

I do have one other thought.

You said you set file/folder permissions to 777. Somer servers are set - in our experience - to fail at 777 because it is just too open. But - I also note you did that after it failed to load the first time around.

However - there are two more security permissions that are set on Unix based files and folders called GUID and UID. These control ownership. I.e., does a file belong to the system (like the root user) so can not be called and opened by a simple user. It is rare but we have encountered users whose servers have coughed at the wrong time and set either the UID/GUID or both incorrectly. If this has happened then WP would not be able to open them.

It is not recommended to change these if you do not know what you are doing but you should be able to look at them. A decent ftp client will usually allow you to view the full permissions. GUID and UID should basically be the same as the parent wp-content folder.

If in any doubt I would ask your host to take a look.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 11, 2017 - 1:11 pm

I thought the wp debugger would tell me this, but apparently not. In the php error log I find: 

 

[Sat Mar 11 11:38:39.935078 2017] [fcgid:warn] [pid 24542] [client 2601:347:100:a340:3d63:6a93:b554:dc47:22282] mod_fcgid: stderr: PHP Notice: Use of undefined constant SPI_DIR - assumed 'SPI_DIR' in /home/(mysite)/public_html/wp-content/plugins/sp-import/admin/spimport-setup.php on line 9

[Sat Mar 11 11:38:39.935131 2017] [fcgid:warn] [pid 24542] [client 2601:347:100:a340:3d63:6a93:b554:dc47:22282] mod_fcgid: stderr: PHP Warning: include_once(SPI_DIRadmin/spimport-support.php): failed to open stream: No such file or directory in /home/(mysite)/public_html/wp-content/plugins/sp-import/admin/spimport-setup.php on line 9

[Sat Mar 11 11:38:39.935135 2017] [fcgid:warn] [pid 24542] [client 2601:347:100:a340:3d63:6a93:b554:dc47:22282] mod_fcgid: stderr: PHP Warning: include_once(): Failed opening 'SPI_DIRadmin/spimport-support.php' for inclusion (include_path='.:/usr/share/pear:/usr/share/php') in /home/(mysite)/public_html/wp-content/plugins/sp-import/admin/spimport-setup.php on line 9

[Sat Mar 11 11:38:39.935152 2017] [fcgid:warn] [pid 24542] [client 2601:347:100:a340:3d63:6a93:b554:dc47:22282] mod_fcgid: stderr: PHP Fatal error: Call to undefined function spi_header() in /home/(mysite)/public_html/wp-content/plugins/sp-import/admin/spimport-setup.php on line 15

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Mar 11, 2017 - 2:49 pm

Like I said in post #16. Ends in a php fatal error...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 11, 2017 - 5:32 pm

I checked ownership and it's consistent with other plugins. 

I changed: 

include_once(SPI_DIR.'admin/spimport-support.php');

to: 

include_once("spimport-support.php");

and now it finds the spimport-support.php file. 

Still get a fatal-error here though: 

PHP Fatal error: Call to a member function get_var() on a non-object in /home/(mysite)/public_html/wp-content/plugins/sp-import/admin/spimport-support.php on line 45 

I wonder if it's not connecting to wpdb for some reason?

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Mar 11, 2017 - 5:34 pm

Y'all are going to be sick of me before I even get started here 🙂  This has confounded me though! 

***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626