prestashop 1.7.6.3 backoffice 500 error after backup restore

[Adrian CROITORU]

Hi,

I'm using Prestashop 1.7.6.3 version

I just made a full website backup(database+files backup) then I tried to restore, the steps I followed are below:

1.Disabled Smarty Cache and Combine Compress and Cache

2.Deleted Cache folder within Var folder

3.Files backup, by fully backup the entire public_html folder

4.Database backup by exporting it from phpMyAdmin

5. I deleted all files and folders within webhost and then deleted the database 

6.Create a new database with the same credentials: database name, database username, password etc , actually identically with the one to which I made backup.

7.I uploaded the public_html folder containing full files backup

8.I navigated to folder APP->CONFIG->parameters.php and I assured that is containing the database name and password credentials etc.

9.I opened my website and it works absolutely perfect but when accessing the website backoffice ex: www.mywebsite/admin , I got the error "HTTP ERROR 500"

 

I write you here in hoping  that someone has already encountered the same issue and maybe you could help me fixing it.

I just cannot figure out where could the problem be, as long as I just made database and folder backup, and then restored them on the same website folder and the same database name.

Thank you very much

[dinesh badrukhiya]

Enable the error reporting and share the error report.

To enable debug mode:

Navigate to  config directory and open defines.inc.php file and find the following code:

define('_PS_MODE_DEV_', false);

Edit the code:

define('_PS_MODE_DEV_', true);

[Adrian CROITORU]

Hi,

Thanks for your quick replay,

You can access the website here: www.digitalkeys.ro

and the backoffice here: www.digitalkeys.ro/cyberax , to see the errors.

Thanks again

 

[Adrian CROITORU]

On 2/2/2020 at 11:32 AM, dinesh badrukhiya said:

Enable the error reporting and share the error report.

To enable debug mode:

Navigate to  config directory and open defines.inc.php file and find the following code:

define('_PS_MODE_DEV_', false);

Edit the code:

define('_PS_MODE_DEV_', true);

(1/1) ContextErrorException

Warning: PDO::query(): MySQL server has gone away

in DbPDO.php line 156

at DbPDOCore->_query('SELECT id_tab, class_name FROM `ps_tab`')in Db.php line 376

at DbCore->query('SELECT id_tab, class_name FROM `ps_tab`')in Db.php line 613

at DbCore->executeS('SELECT id_tab, class_name FROM `ps_tab`', true, false)in Tab.php line 320

at TabCore::getIdFromClassName('admin')in AdminController.php line 462

at AdminControllerCore->__construct()in LegacyContext.php line 85

at LegacyContext->getContext()in UserLocaleListener.php line 39

at UserLocaleListener->__construct(object(LegacyContext))in appDevDebugProjectContainer.php line 2384

at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()in appDevDebugProjectContainer.php line 2871

at appDevDebugProjectContainer->Container7ubdt49\{closure}()in EventDispatcher.php line 229

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 262

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127

at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68

at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200

at Kernel->handle(object(Request), 1, false)in index.php line 86

[irvingvd]

have some problems with you data base make sure you have access 

 

Thanks

Irving

[dinesh badrukhiya]

It's seems like something wrong with data base or might it be crashed. Can you make a copy of your shop in the different environment? Test if it has the same issues.

[Adrian CROITORU]

Hi,

Thanks for your replay.

 

Could be the fact that in my web host settings, is selected as default PHP 7.2 version? (picture attached)

Thank you

[Adrian CROITORU]

Hi,

I tried several times to repeat backup, and I got the same errors:

(1/1) ContextErrorException

Warning: PDO::query(): MySQL server has gone away

in DbPDO.php line 156

at DbPDOCore->_query('SELECT id_tab, class_name FROM `ps_tab`')in Db.php line 376

at DbCore->query('SELECT id_tab, class_name FROM `ps_tab`')in Db.php line 613

at DbCore->executeS('SELECT id_tab, class_name FROM `ps_tab`', true, false)in Tab.php line 320

at TabCore::getIdFromClassName('admin')in AdminController.php line 462

at AdminControllerCore->__construct()in LegacyContext.php line 85

at LegacyContext->getContext()in UserLocaleListener.php line 39

at UserLocaleListener->__construct(object(LegacyContext))in appDevDebugProjectContainer.php line 2384

at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()in appDevDebugProjectContainer.php line 2871

at appDevDebugProjectContainer->Container7ubdt49\{closure}()in EventDispatcher.php line 229

at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61

at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128

at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 262

at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137

at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127

at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68

at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200

at Kernel->handle(object(Request), 1, false)in index.php line 86

 

 

I just don't understand what's wrong with Prestashop? Is there someone who backed his website without any kind of issues?

Because it seems that there is no way to backup a Prestashop website wihtout problems 😐

Thanks