Website won't allow anyone to log in

mjrbradley66 · February 17, 2020, 5:39pm

Hi,

My website was working absolutely fine until two weeks ago when all of a sudden I got a number of errors which has resulted in preventing any users from getting on their account. " You need to be logged in to access this feature". New pilots can still register but no current pilots can access their account. I will attach some pictures below. I contacted my hosting company and they said it isn’t a server issue but a PHP issue. The error log seems to suggest line 101:

[02-Feb-2020 03:54:23 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/sunflyvi/public_html/lib/skins/ocean_blue/frontpage_main.php on line 99
[02-Feb-2020 10:14:30 UTC] PHP Warning: mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/sunflyvi/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 101
[02-Feb-2020 10:14:31 UTC] PHP Fatal error: Uncaught <blockquote>Last Error – [Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) (2002)] []
</blockquote><hr noshade color=dddddd size=1>
thrown in /home/sunflyvi/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 106
[02-Feb-2020 10:14:43 UTC] PHP Warning: mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/sunflyvi/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 101
[02-Feb-2020 10:14:43 UTC] PHP Fatal error: Uncaught <blockquote>Last Error – [Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) (2002)] []
</blockquote><hr noshade color=dddddd size=1>
thrown in /home/sunflyvi/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 106

If anyone has any suggestions on how to sort this, then that would be gratefully appreciated.

Thanks

Matthew

servetas · February 17, 2020, 5:52pm

It looks like a database issue to me. Can you send me your login details to check them out cause I do not know if it is easy to troubleshoot it through a public forum.

ProAvia · February 17, 2020, 8:01pm

What version of phpVMS are you using?

What version of PHP?

What version of MySQL or MariaDB?

About 2 weeks ago, did you happen to change the skin or anything else on the site?

mjrbradley66 · February 17, 2020, 10:31pm

I have sent you a message

I believe I am using version 5 of PHP not sure about the others if I am honest. I hadn’t made any changes to site within months of it happening that could have caused it.

Thanks for your help

ProAvia · February 18, 2020, 2:57am

Hopefully Servetas can easily fix it for you.

Let us know what the issue was - it may help someone in the future.

Strider · February 22, 2020, 10:19pm

You may need to do a restore on your db, it may have gotten corrupted maybe by a bad update, or an incomplete update. If you are on a VPS or dedicated you can do that in cpanel yourself, if on shared hosting, you will need to contact your host about doing a db restore or reboot.

nabeel · February 23, 2020, 3:53pm

I think you need to contact your host, the message " Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/sunflyvi/public_html/core/classes/ezdb/ezdb_mysqli.class.php on line 101" does not look like it can be fixed by someone other than your host

mjrbradley66 · February 24, 2020, 10:46am

Hi everyone,

was right, it is now working having repaired the database on Cpanel.

Thank you everyone for your help!