[Solved] WP importing succeseeded but I get error 500

[devashraf]

Hello,

I imported a wordpress installation.

Proscedures I did:

1- Uploading directory using FTP. The directory is "/award-sci.helioho.st/mag".

2- Noting database credentials in "wp-config.php".

3- Importing the database using PHPMyAdmin.

    A. Created "devashraf_wp603".

    B. Applied the same credentials, but I was forced to change only the second part (Exp. "prizesci.org_wp603" to "devashraf_wp603").

    C. Applied the new namings back to "wp-config.php".

    D. Checked localhost (mariadb). I`m not sure if this is the case, though. (MariDB or Postgre).

    E. Imported the dump, checked "re-creare the database".

    F. Changed the URLs to the new ones, manually, one by one in each record.

4- After that I did a sucessful softaculous import.

However, when I visit this url "https://award-sci.helioho.st/mag/wp-admin/" I get a "500 Internal server error".

 

Any help shall be very much appreciated.

[MoneyBroz]

What does the error logs say?

[devashraf]

 

2024-12-27 13:17:15	Error	156.208.155.84	500	GET /mag/wp-admin/ HTTP/1.0			1.22 K	Apache SSL/TLS access
2024-12-27 13:18:00	Warning	156.208.155.84		mod_fcgid: read data timeout in 45 seconds, referer: https://johnny.heliohost.org/				Apache error
2024-12-27 13:18:00	Error	156.208.155.84		End of script output before headers: index.php, referer: https://johnny.heliohost.org/				Apache error
2024-12-27 13:18:02	Error	156.208.155.84	404	GET /favicon.ico HTTP/1.0			910	Apache SSL/TLS access
2024-12-27 13:28:57	Error	156.208.155.84		3417883#0: *230480 upstream timed out (110: Connection timed out) while connecting to upstream				nginx error

[devashraf]

Quote

mod_fcgid: read data timeout in 45 seconds, referer:

 

Seems that  max_execution_time and FastCGI timeout need resetting to 120.

 

The settings are read-only in Plesk.

In addition, I can`t locate .htaccess, php.ini or .user.ini in the file manager.

 

Quote

3417883#0: *230480 upstream timed out (110: Connection timed out) while connecting to upstream

In addition, proxy_read_timeout needs setting to 3600.

 

The settings are read-only in Plesk. In addition, I can`t locate the files.

 

Quote

End of script output before headers: index.php, referer: https://johnny.heliohost.org/

I don`t think I`ll inject CGI code into a WP page.

In addition, the main "index.php" is created by SiteJet builder. I will not edit it either.

.......................................................................................................................................

As all (or most) of the above-mentioedn problems are caused by Apache, is is better disabling Apache (by disabling proxy mode under NGINX settings) ?

 

 

Edited December 27, 2024 by devashraf

[wolstech]

Those limits you mention are intentionally set low to prevent people from causing high load and are not adjustable.

WP is the #1 cause of load related issues and suspensions on our service. If WP is so bloated that it can't generate a page in 45 seconds, the browser on the other end is likely long gone anyway by the time it finishes. The usual cause is an excessive number of extensions. I'm not even sure this would run on Morty since I think the limits there are the same (though the server itself is much faster, so it may be able to finish within the limit over there).

It would definitely run on a VPS, but you'd have to be willing to deal with maintaining a linux box to go that route. We can put a control panel like Hestia on it for free though so you have a web interface for the essentials.

 

 

[devashraf]

I`ll see.. I may order a 1 month of VPS to try it.
Softaculous is a must-have in the control panel that shall be available there. Is it available?

I considered a light wordpress fork at Softaculous, but it doesn`t support most addons.
If it is for me, I can setup a database-less blog, But The Prize Scientific Society has to use specific scripts to comply with industry standards. (Wordpress, Open Journal System, etc...) instead of their alternatives. So, we have to stick with Wordpress, as its fork doesn`t support required addons..

 

I was an RHCE, but now I am a tensorflow developer, I may be able to remember the commands etc, if I have to use the VPS.

[KazVee]

I'm not sure if Softaculous could be installed on the VPS, so this is something for the root admins to comment on. If it is possible, you'd likely need to cover the licensing costs for it though, since that won't be included in the VPS pricing. 

Hestia control panel, which is free, has a "one-click install" option for WordPress that I found quite straightforward though. The steps involved are documented here, if you want to have a look while you consider your decision: https://wiki.helionet.org/tutorials/vps/wordpress-hestia 

[wolstech]

No it's not. A VPS comes as a bare linux box, you have to install everything yourself, including the actual web server. If you want, Krydos can install a control panel for you (Hestia, which is free). Plesk can technically be put on a VPS too, but it adds like $15/month to the VPS cost because it needs a license, and that does not include Softaculous, which is a separate product with its own license.

A Morty account might be worth trying first since the server is much faster and it has the same software as Johnny. If you want to do that, you can move to Morty from the dashboard. https://heliohost.org/dashboard/move/ 

Edited December 27, 2024 by wolstech
Morty link

[devashraf]

Thank you for your replies. I`ll move to Morty and give it a try.
 

I found that my account is suspended for disk space. I`ll have to move to Tommy first, a bigger disk space plan, then to Morty.. am I right?

 

ٍShall I be able to move back to Tommy if wordpress problem persists?

Edited December 29, 2024 by devashraf

[wolstech]

If there's something you'd rather delete, I can simply delete it for you and remove the disk space suspension. Then you can just move straight to morty.

And yes, you can move back to Tommy if you decide not to stay on Morty. If you ask to move it's $1, or if you allow your balance to run out on prepay Morty, it should happen automatically.

[devashraf]

Thank you.
I`ll do the move, without removing any files.
The card shall be ready for internet payment on 1st January. So, I`ll wait till this date.
 

[devashraf]

Sorry for the delay. The bank was too slow processing some work.
I managed to move to Morty, however, the Egyptian authoriities block your payment processor (PayPal), so, the payment failed.
I used the card payment option, but it didn`t work. The bank confirmed to me that paypal payment gateway is banned as well, not just "paypal.com".
The solution is HelioHost adding an additional payment gateway, or the Egyptioan authorities allowing Paypal (if one of these ever happen in the future).

I request an admin deleting all files under "https://award-sci.helioho.st/mag/" and the asscoiated database "devashraf_wp603", so that the current suspension caused by the space which exceeded its limit gets fixed. I`ll have to use HelioHost services within the limit until something changes.

* I`m not willing to use the virtual cards such as DixiPay etc... I can`t use them either.
  In addition, I have bad expericens with scammy paypal brokers etc..

Edited Thursday at 11:59 AM by devashraf
multiple edits

[KazVee]

I've escalated this request so a root admin can delete the files and database you mentioned to get you back under the account limit again. Once they've done so, they'll update this thread to let you know.

[wolstech]

Unfortunately if Paypal and Crypto are not available, we currently cannot offer paid services in your country (we have this issue with a few other countries too, notably India, which does work but requires jumping through a bunch of hoops to pay due to their weird banking regulations). There has been some discussion around us using Stripe as another payment processor so we can take credit cards without using Paypal, but that's still in its early stages and there's no estimate as to when (if ever) that will be available.

The contents of ~/award-sci.helioho.st/mag have been deleted, database devashraf_wp603 has been dropped, and you've been unsuspended.