Website won't allow anyone to log in

[mjrbradley66]

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><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002)</b></font>]<br />[<font color=000000><b></b></font>]</font><p>
</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><font face=arial size=2 color=000099><b>Last Error --</b> [<font color=000000><b>Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (2002)</b></font>]<br />[<font color=000000><b></b></font>]</font><p>
</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]

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]

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]

 @servetas I have sent you a message

@ProAvia 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]

Hopefully Servetas can easily fix it for you.

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

[Strider]

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]

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]

Hi everyone,

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

Thank you everyone for your help!