Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Adlago Posted April 22, 2020 Posted April 22, 2020 1 minute ago, Dean_ said: His latest update to the forums was IPB 3.4.7. Like we all said it looks like a MySQL error, if you can get the host to downgrade you I think you’ll be back up in no time. IPB 3.4.x with a PHP higher than 5.6 create a driver error.
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 8 minutes ago, Adlago said: You should have an option in the PHP in cPanel - you now see the latest update for your account, but your server should have older versions as well - search for something like Manage PHP and switch to a lower version. You can try and add this line to your htaccess file AddType application/x-httpd-php56 .php Well, now I looked at another page with server information from cpanel and it says: PHP Version 5.4.45 MySQL version 5.5.62-cll But in phpMyAdmin it said php version 7.2.7 and mySQL 5.5.62 But MissB says the error message is specifik about mySQL, but even the hosting company said it was 5.5.62, when I talked to them.
Dean_ Posted April 22, 2020 Posted April 22, 2020 1 minute ago, Adlago said: IPB 3.4.x with a PHP higher than 5.6 create a driver error. Totally agree. Which I think you said before anyway.
Adlago Posted April 22, 2020 Posted April 22, 2020 4 minutes ago, Majbritt_merged said: Well, now I looked at another page with server information from cpanel and it says: PHP Version 5.4.45 MySQL version 5.5.62-cll But in phpMyAdmin it said php version 7.2.7 and mySQL 5.5.62 But MissB says the error message is specifik about mySQL, but even the hosting company said it was 5.5.62, when I talked to them. Check the htaccess file - there may be a rule in this file that causes the driver error
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 5 minutes ago, Adlago said: Check the htaccess file - there may be a rule in this file that causes the driver error How do I do that?
Adlago Posted April 22, 2020 Posted April 22, 2020 2 minutes ago, Majbritt_merged said: How do I do that? Share the contents of this file here / or attach it / for advice
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 1 minute ago, Adlago said: Share the contents of this file here / or attach it / for advice I must admit, I have no idea what the htaccess file is and where to find it. But on the other hand, I did find the place in cpanel where I could change php versions and it's 5.4 and I can change it to 5.6, but it doesn't help on the problem.
Adlago Posted April 22, 2020 Posted April 22, 2020 2 minutes ago, Majbritt_merged said: I must admit, I have no idea what the htaccess file is and where to find it. But on the other hand, I did find the place in cpanel where I could change php versions and it's 5.4 and I can change it to 5.6, but it doesn't help on the problem. This file is located in the root directory of your forum. Exact name .htaccess
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 (edited) RewriteEngine on RewriteCond %{HTTP_REFERER} !^$ RewriteCond %{HTTP_REFERER} !^http://himstedtheaven.com/.*$ [NC] RewriteCond %{HTTP_REFERER} !^http://himstedtheaven.com$ [NC] RewriteCond %{HTTP_REFERER} !^http://www.himstedtheaven.com/.*$ [NC] RewriteCond %{HTTP_REFERER} !^http://www.himstedtheaven.com$ [NC] RewriteCond %{HTTP_REFERER} !^http://himstedtheaven.net/.*$ [NC] RewriteCond %{HTTP_REFERER} !^http://himstedtheaven.net$ [NC] RewriteCond %{HTTP_REFERER} !^http://www.himstedtheaven.net/.*$ [NC] RewriteCond %{HTTP_REFERER} !^http://www.himstedtheaven.net$ [NC] RewriteRule .*\.(jpg|jpeg|gif|png|bmp)$ - [F,NC] <Files birdtrap.cgi> order allow,deny allow from all </Files> ErrorDocument 400 /errors/birdtrap.cgi?400 ErrorDocument 401 /errors/birdtrap.cgi?401 ErrorDocument 403 /errors/birdtrap.cgi?403 ErrorDocument 404 /errors/birdtrap.cgi?404 ErrorDocument 500 /errors/birdtrap.cgi?500 deny from 68.4.204.157 RewriteEngine On RewriteCond %{HTTP_USER_AGENT} ^BlackWidow [OR] RewriteCond %{HTTP_USER_AGENT} ^Bot\ mailto:craftbot@yahoo.com [OR] RewriteCond %{HTTP_USER_AGENT} ^ChinaClaw [OR] RewriteCond %{HTTP_USER_AGENT} ^Custo [OR] RewriteCond %{HTTP_USER_AGENT} ^DISCo [OR] RewriteCond %{HTTP_USER_AGENT} ^Download\ Demon [OR] RewriteCond %{HTTP_USER_AGENT} ^eCatch [OR] RewriteCond %{HTTP_USER_AGENT} ^EirGrabber [OR] RewriteCond %{HTTP_USER_AGENT} ^EmailSiphon [OR] RewriteCond %{HTTP_USER_AGENT} ^EmailWolf [OR] RewriteCond %{HTTP_USER_AGENT} ^Express\ WebPictures [OR] RewriteCond %{HTTP_USER_AGENT} ^ExtractorPro [OR] RewriteCond %{HTTP_USER_AGENT} ^EyeNetIE [OR] RewriteCond %{HTTP_USER_AGENT} ^FlashGet [OR] RewriteCond %{HTTP_USER_AGENT} ^GetRight [OR] RewriteCond %{HTTP_USER_AGENT} ^GetWeb! [OR] RewriteCond %{HTTP_USER_AGENT} ^Go!Zilla [OR] RewriteCond %{HTTP_USER_AGENT} ^Go-Ahead-Got-It [OR] RewriteCond %{HTTP_USER_AGENT} ^GrabNet [OR] RewriteCond %{HTTP_USER_AGENT} ^Grafula [OR] RewriteCond %{HTTP_USER_AGENT} ^HMView [OR] RewriteCond %{HTTP_USER_AGENT} HTTrack [NC,OR] RewriteCond %{HTTP_USER_AGENT} ^Image\ Stripper [OR] RewriteCond %{HTTP_USER_AGENT} ^Image\ Sucker [OR] RewriteCond %{HTTP_USER_AGENT} Indy\ Library [NC,OR] RewriteCond %{HTTP_USER_AGENT} ^InterGET [OR] RewriteCond %{HTTP_USER_AGENT} ^Internet\ Ninja [OR] RewriteCond %{HTTP_USER_AGENT} ^JetCar [OR] RewriteCond %{HTTP_USER_AGENT} ^JOC\ Web\ Spider [OR] RewriteCond %{HTTP_USER_AGENT} ^larbin [OR] RewriteCond %{HTTP_USER_AGENT} ^LeechFTP [OR] RewriteCond %{HTTP_USER_AGENT} ^Mass\ Downloader [OR] RewriteCond %{HTTP_USER_AGENT} ^MIDown\ tool [OR] RewriteCond %{HTTP_USER_AGENT} ^Mister\ PiX [OR] RewriteCond %{HTTP_USER_AGENT} ^Navroad [OR] RewriteCond %{HTTP_USER_AGENT} ^NearSite [OR] RewriteCond %{HTTP_USER_AGENT} ^NetAnts [OR] RewriteCond %{HTTP_USER_AGENT} ^NetSpider [OR] RewriteCond %{HTTP_USER_AGENT} ^Net\ Vampire [OR] RewriteCond %{HTTP_USER_AGENT} ^NetZIP [OR] RewriteCond %{HTTP_USER_AGENT} ^Octopus [OR] RewriteCond %{HTTP_USER_AGENT} ^Offline\ Explorer [OR] RewriteCond %{HTTP_USER_AGENT} ^Offline\ Navigator [OR] RewriteCond %{HTTP_USER_AGENT} ^PageGrabber [OR] RewriteCond %{HTTP_USER_AGENT} ^Papa\ Foto [OR] RewriteCond %{HTTP_USER_AGENT} ^pavuk [OR] RewriteCond %{HTTP_USER_AGENT} ^pcBrowser [OR] RewriteCond %{HTTP_USER_AGENT} ^RealDownload [OR] RewriteCond %{HTTP_USER_AGENT} ^ReGet [OR] RewriteCond %{HTTP_USER_AGENT} ^SiteSnagger [OR] RewriteCond %{HTTP_USER_AGENT} ^SmartDownload [OR] RewriteCond %{HTTP_USER_AGENT} ^SuperBot [OR] RewriteCond %{HTTP_USER_AGENT} ^SuperHTTP [OR] RewriteCond %{HTTP_USER_AGENT} ^Surfbot [OR] RewriteCond %{HTTP_USER_AGENT} ^tAkeOut [OR] RewriteCond %{HTTP_USER_AGENT} ^Teleport\ Pro [OR] RewriteCond %{HTTP_USER_AGENT} ^VoidEYE [OR] RewriteCond %{HTTP_USER_AGENT} ^Web\ Image\ Collector [OR] RewriteCond %{HTTP_USER_AGENT} ^Web\ Sucker [OR] RewriteCond %{HTTP_USER_AGENT} ^WebAuto [OR] RewriteCond %{HTTP_USER_AGENT} ^WebCopier [OR] RewriteCond %{HTTP_USER_AGENT} ^WebFetch [OR] RewriteCond %{HTTP_USER_AGENT} ^WebGo\ IS [OR] RewriteCond %{HTTP_USER_AGENT} ^WebLeacher [OR] RewriteCond %{HTTP_USER_AGENT} ^WebReaper [OR] RewriteCond %{HTTP_USER_AGENT} ^WebSauger [OR] RewriteCond %{HTTP_USER_AGENT} ^Website\ eXtractor [OR] RewriteCond %{HTTP_USER_AGENT} ^Website\ Quester [OR] RewriteCond %{HTTP_USER_AGENT} ^WebStripper [OR] RewriteCond %{HTTP_USER_AGENT} ^WebWhacker [OR] RewriteCond %{HTTP_USER_AGENT} ^WebZIP [OR] RewriteCond %{HTTP_USER_AGENT} ^Wget [OR] RewriteCond %{HTTP_USER_AGENT} ^Widow [OR] RewriteCond %{HTTP_USER_AGENT} ^WWWOFFLE [OR] RewriteCond %{HTTP_USER_AGENT} ^Xaldon\ WebSpider [OR] RewriteCond %{HTTP_USER_AGENT} ^Zeus RewriteRule ^.* - [F,L] # php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php54” package as the default “PHP” programming language. <IfModule mime_module> AddHandler application/x-httpd-ea-php54 .php .php5 .phtml </IfModule> # php -- END cPanel-generated handler, do not edit Edited April 22, 2020 by Majbritt_merged
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 18 minutes ago, Adlago said: This file is located in the root directory of your forum. Exact name .htaccess I have copied the file now.
Adlago Posted April 22, 2020 Posted April 22, 2020 8 minutes ago, Majbritt_merged said: I have copied the file now. Try this <Files 403.shtml> order allow,deny allow from all </Files> <IfModule mod_rewrite.c> Options -MultiViews RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteRule \.(jpeg|jpg|gif|png)$ /public/404.php [NC,L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> deny from 68.4.204.157 # php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php54” package as the default “PHP” programming language. <IfModule mime_module> AddHandler application/x-httpd-ea-php54 .php .php5 .phtml </IfModule> # php -- END cPanel-generated handler, do not edit
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 2 minutes ago, Adlago said: Try this <Files 403.shtml> order allow,deny allow from all </Files> <IfModule mod_rewrite.c> Options -MultiViews RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteRule \.(jpeg|jpg|gif|png)$ /public/404.php [NC,L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> deny from 68.4.204.157 # php -- BEGIN cPanel-generated handler, do not edit # Set the “ea-php54” package as the default “PHP” programming language. <IfModule mime_module> AddHandler application/x-httpd-ea-php54 .php .php5 .phtml </IfModule> # php -- END cPanel-generated handler, do not edit What do I do? Replace the file with a file with that info? I just don't want to do something wrong and mess even more up.
Adlago Posted April 22, 2020 Posted April 22, 2020 2 minutes ago, Majbritt_merged said: What do I do? Replace the file with a file with that info? I just don't want to do something wrong and mess even more up. Save the original file to your computer. Save this content that I uploaded above as a .htaccess file. Replace the file in the root directory with the new file.
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 6 minutes ago, Adlago said: Save the original file to your computer. Save this content that I uploaded above as a .htaccess file. Replace the file in the root directory with the new file. I did that now and unfortunately that didn't help. Now it says another error when you "go back to index" than it did before. Now it's 500 Internal Server Error. Before it was error 404. I changed the file back to the original.
Majbritt_merged Posted April 22, 2020 Author Posted April 22, 2020 Thanks so much for the help so far. It's getting late here in Denmark, so I'm off to bed. I know several of you say mySQL error, but the server seems to be in version 5.5.62, so if it's not the incorrect version, what can it be then?
Majbritt_merged Posted April 26, 2020 Author Posted April 26, 2020 I'm updating this topic again. My hosting company won't help, because it's not a managed server, and I can't have the site moved to a managed server, because it's too big and I need access to the forum, before I can downsize. So it's a bad circle and I'm stuck. But Miss_B was kind and looked into what error message it is and it appears to be mysql related, so I need to learn mysql, so I can figure it out. I looked up some tutorials but I'm a bit confused about how many programs I need to download when I have the server already. When I go to cpanel, I have three places to go for mysql, which are: MySQL Databases, MySQL Database Wizard and Remote MySQL The error message is: The server requested authentication method unknown to the client. And I can google and people suggest running a specific query, but how do I do that and with what program? I can't find anything in those three programs that that says "run query". It's mostly about creating databases and users. So what programs do I need to download to my own computer to hopefully run queries? I hope I make sense.
Dean_ Posted April 26, 2020 Posted April 26, 2020 (edited) My next suggestion would be to download the whole site and run it in wamp localhost to see if you can get it running. But I’m afraid of suggesting such a thing if you’re not sure on how it all works or how to do it. Just like MissB I’m happy to have a quick look on cPanel and just check everything is correct and that it matches up. Though I’m not sure how much more I’d be able to do if MissB has gone through everything, but offer is there. Edited April 26, 2020 by Dean_ Miss_B 1
Miss_B Posted April 26, 2020 Posted April 26, 2020 @Majbritt_mergedcontacted me and I am taking another look now. The forum in question belongs to an older version of Ipb and it is not compatible with the php version in her server. There is also a mysql issue as well. I am working on fixing those issues now. Dean_ 1
Dean_ Posted April 26, 2020 Posted April 26, 2020 Hope it works out. I’d move host, never known hosting company to be so unhelpful. Don’t continue to give them your money. If you could move host and ask them if they’d be willing to support 5.4 briefly while you get the forum up. I would highly recommend upgrading to the latest IPB software and then the host can change php 7.2/7.3+ and you’ll be on your way.
Miss_B Posted April 27, 2020 Posted April 27, 2020 I am very happy to say that I managed to fix the errors and get the forum backup and running error free. Dean_, bfarber, Square Wheels and 1 other 4
Majbritt_merged Posted April 27, 2020 Author Posted April 27, 2020 Yes, it's wonderful. Thanks so much. I have written Invision now to ask them to update the forum, so I hope it can be done soon. Miss_B, Square Wheels and Dean_ 3
Miss_B Posted April 27, 2020 Posted April 27, 2020 1 hour ago, Majbritt_merged said: Yes, it's wonderful. Thanks so much. I have written Invision now to ask them to update the forum, so I hope it can be done soon. You are very welcome. I am glad to have been of help. Dean_ 1
Recommended Posts