Unable to access FO or BO, exeption log shows error progression (1.6.1.24)

[David S Johnston]

Hi All,

 

I have a problem that maybe one of you can help me with. If I try to access the front end of my website, I get the maintenance message. If I try to enter the back office  I am prompted for my UN & PW, but then I get a screen that only shows the penguin.

I have made sure that maintenance mode is not enabled, and I have enabled debug mode. When I look at the exeption logs, I see the following:

 

on 5th of Nov:

*ERROR* 	2021/11/05 - 21:48:39: Link to database cannot be established:SQLSTATE[HY000] [2002] Connection refused at line 102 in file classes/db/DbPDO.php
*ERROR* 	2021/11/05 - 21:48:39: Link to database cannot be established:SQLSTATE[HY000] [2002] No such file or directory at line 102 in file classes/db/DbPDO.php
*ERROR* 	2021/11/05 - 21:48:39: Link to database cannot be established:SQLSTATE[HY000] [2006] MySQL server has gone away at line 102 in file classes/db/DbPDO.php
*ERROR* 	2021/11/05 - 21:48:39: Link to database cannot be established:SQLSTATE[HY000] [2002] No such file or directory at line 102 in file classes/db/DbPDO.php
*ERROR* 	2021/11/05 - 21:48:39: Link to database cannot be established:SQLSTATE[HY000] [2002] No such file or directory at line 102 in file classes/db/DbPDO.php

This continues until:

*ERROR* 	2021/11/05 - 21:48:48: Link to database cannot be established:SQLSTATE[HY000] [2002] No such file or directory at line 102 in file classes/db/DbPDO.php
*ERROR* 	2021/11/05 - 22:32:38: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:32:39: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:36:11: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:38:51: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:38:52: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:39:14: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:39:15: Shop not found at line 404 in file classes/shop/Shop.php
*ERROR* 	2021/11/05 - 22:44:05: Shop not found at line 404 in file classes/shop/Shop.php

I cannot find an awful lot of info about this error. All i can say is that it literately happened from one moment to another. I have not tried to update or anything.

If I use phpmyadmin to access the database, I can log on with the credentials provided in settings.inc.php.

 

Does ANYONE have any help here? I am at a loss as where to continue looking. The only thing I can think of at the moment is to try to upgrade to 1.7, but I have no idea how to do that without access to the back Office.

 

regards,

Dave.

 

Edited November 8, 2021 by David S Johnston (see edit history)

[JBW]

There was once a DB connection error and now it seems some data is missing. Better check with your hosting company what wrong wrong on their side.

[David S Johnston]

JBW, I appreciate the response, but could you elaborate just a little? what exactly should i be asking my hosting company?

 

Thanks,

Dave.

[David S Johnston]

Turns out the Database was intact after all. I pulled up a backup and imported it, but I had the same issue. So I folowed the following steps:

• Installed PS1.6.1.5 on a sub domain
• Installed 1-click update
• updated to 1.6.1.24
• imported my backup DB, and everything was working (i.e. all my data was accessible)
• dumped the tables, and imported the suspected corrupt database, and whadda you know, everything was working.

after that it was just a case of dragging over my theme, css, modules and the rest of the stuff that makes a website tick.

So all in all there must have been a corrupted file somewhere, but the shop was back up and running within a coupe of hours, so obviously I'm a happy camper!

 

 

Edited November 10, 2021 by David S Johnston (see edit history)