CCGI Webspace PHP version
FIXED- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: CCGI Webspace PHP version
09-03-2020 10:05 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I tried to change the PHP version using PHP Manager in Control Panel.
Now I get "Not Found [CFN #0005]" when I try to connect.
I can see via Filezilla that all files are intact.
Looking through previous posts, in one from 2017 a staff member provided a fix.
However another post from January suggests it would be a DIY effort.
Can anyone tell me what I need to do to fix this?
Thanks
David
Fixed! Go to the fix.
Re: CCGI Webspace PHP version
09-03-2020 10:09 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Providing the URL/web address that you're having problems with would help. My first suggestion would be to check for any hidden .htaccess files you might have. Try renaming them temporarily and see if your site springs back to life.
Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵
Re: CCGI Webspace PHP version
on 09-03-2020 11:36 PM - last edited on 10-03-2020 7:10 PM by Mav
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Hi Bob,
thanks for the quick reply.
I had previously tried changing .htaccess files to .htaccessold but made no difference.
This time I changed to old.htaccess.
Now I get a massive text file beginning "PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'ccgidbroad379174'@'91.136.11.87' for table 'wt_module' in /services/webpages/util/c/c/ccgi.[Removed].plus.com/public/webtrees/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117..etc"
Looks like a database poblem, but is it due to changing PHP version or a Webtrees issue?
The url is [Removed]
David
Re: CCGI Webspace PHP version
10-03-2020 12:39 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Sorry that doesn’t provide much help but best I can do now
Re: CCGI Webspace PHP version
11-03-2020 10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks spraxyt it's given me something to look for.
Sorry for the delayed reply I've been reading up on php.ini.
I found there's a text editor in Control Panel that will create a php.ini but it's not as simple as copying text from .htaccess file.
The offending .htaccess file contains the following text:-
# Fix date error problem
php_value date.timezone 'Europe/London'
php_value display_errors 1
php_value error_reporting 32767
# for PHP-CGI
AddHandler php-cgi .php
Action php-cgi /cgi-bin/php-cgi
# for php and securewebexchange
<IfDefine SSL>
AddHandler php-cgi .php
Action php-cgi https://secure50.securewebsession.eu/ccgi.username.plus.com/cgi-bin/php-cgi
</IfDefine>
This was given to me many years ago and like spraxyt I can't remember the details.
Can anyone rewrite this for use in a php.ini file?
Thanks
David
Re: CCGI Webspace PHP version
12-03-2020 3:28 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
This might offer a clue...
REFERENCES command denied to user...
It seems the script requires that the database user has REFERENCES priviledges and I'm not cetain that's available in the hosting environment:-
Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵
Re: CCGI Webspace PHP version
12-03-2020 4:32 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I feel changing PHP version using PHP Manager is not helpful in our hosting environment, but have nothing to prove that.
Re: CCGI Webspace PHP version
12-03-2020 5:17 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Thanks guys, I would be happy with a reset if its possible.
David
Re: CCGI Webspace PHP version
12-03-2020 7:00 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
Not sure if this is relevant to an old installation but seems worth a mention. https://community.plus.net/t5/Everything-else/Installing-Wordpress-on-PlusNet-Revisited/td-p/1700245... This used standard PHP.
Re: CCGI Webspace PHP version
12-03-2020 8:45 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I'm not sure I understand how that would help, but granted this isn't my area of expertise.
Unless I'm mistaken, there aren't any .htaccess files (renamed or otherwise) that are contributing to what's currently being seen.
PHP executes on the customer's webspace, there's just something with this webtrees installation that isn't playing ball.
Wouldn't we still have the priviledges issue irresepctive of PHP handler?
Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵
Re: CCGI Webspace PHP version
12-03-2020 9:16 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
That's the post that led me here. In it you ask if PHP Manager was used to change anything.
In my case the answer is yes.
If reverting means going back to standard PHP then try it, even if it means I have to re-instal Webtrees.
David
.
Re: CCGI Webspace PHP version
13-03-2020 11:20 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
I think Plusnet background support would be needed to achieve this. But it’s beyond my out of date skills. So stuck.
Re: CCGI Webspace PHP version
15-03-2020 10:04 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@bobpullen I've discussed this with a Webtrees developer.
He agrees its a REFERENCES permission problem and suggests someone needs to grant permission.
e.g. by running this command.
GRANT REFERENCES ON < database name>.* TO <username>;
However I must have had this permission before the PHP change.
Could it be contained in the .htaccess file I renamed?
David
Re: CCGI Webspace PHP version
16-03-2020 9:24 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@bobpullen and @spraxyt
More info from Webtrees guy.
Please ignore comment about previous permission and .htaccess.
I didn't tell you I also updated webtrees from version 1.7 to 2.0.
It turns out vesion 1.7 did not use REFERENCES but version 2.0 does.
If I can't get permission for version 2.0 I'll revert to version 1.7.
David
Re: CCGI Webspace PHP version
16-03-2020 4:59 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Report to Moderator
@spark43, I've asked the question of our hosting partner (ref: 5167292).
Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Plusnet Community
- :
- Forum
- :
- Help with my Plusnet services
- :
- Everything else
- :
- Re: CCGI Webspace PHP version