Shop shows blank screen after version update

[Muna89]

I updated my prestashop version to 1.5.6.1 using the 1-click upgrade, but then the shop showed a white blank page. I tried the rollback, but still no change. Please tell me what to do to fix this glitch.

 

This is my shop's URL:

http://modywear.com/index.php?

[vekia]

if you see blank screen - turn on error reporting

then instead of blank page you will see full error code

 

[Muna89]

Ok, thank you. I now have a page showing me the errors, but how do I fix all those errors such as the following?

 

 

 

 

 

 

at line 613 in file classes/db/Db.php

 

607.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**

 

 

[vekia]

this is the only one message you see? maybe something more appears there?

[Muna89]

No, all the following appears:

 

 

[PrestaShopDatabaseException]

Unknown column 'a.hide' in 'where clause'


SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`
FROM `ps_advice` a

            LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`
            LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice`
WHERE (
            a.`validated` = 1 AND
            a.`hide` = 0 AND
            al.`id_lang` = 1 AND
            at.`id_tab` = 1 AND
            ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (15 >= a.`start_day` AND 15 <= a.`stop_day`)))

at line 613 in file classes/db/Db.php
607.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**
DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
307.         if ($sql instanceof DbQuery)
308.             $sql = $sql->build();
309.
310.         $this->result = $this->_query($sql);
311.         if (_PS_DEBUG_SQL_)
312.             $this->displayError($sql);
313.         return $this->result;
314.     }
315.
316.     /**
317.      * Execute an INSERT query
DbCore->query - [line 488 - classes/db/Db.php] - [1 Arguments]
482.         {
483.             $this->last_cached = true;
484.             return $result;
485.         }
486.
487.         $this->result = $this->query($sql);
488.         if (!$this->result)
489.             return false;
490.
491.         $this->last_cached = false;
492.         if (!$array)
Argument [0]
SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`
FROM `ps_advice` a

            LEFT JOIN `ps_advice_lang` al ON al.`id_advice` = a.`id_advice`
            LEFT JOIN `ps_tab_advice` at ON at.`id_advice` = a.`id_advice`
WHERE (
            a.`validated` = 1 AND
            a.`hide` = 0 AND
            al.`id_lang` = 1 AND
            at.`id_tab` = 1 AND
            ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (15 >= a.`start_day` AND 15 <= a.`stop_day`)))

DbCore->executeS - [line 96 - modules/gamification/classes/Advice.php] - [1 Arguments]
Advice::getValidatedByIdTab - [line 145 - modules/gamification/gamification.php] - [1 Arguments]
Gamification->hookDisplayBackOfficeHeader - [line 473 - classes/Hook.php] - [1 Arguments]
HookCore::exec - [line 1869 - classes/controller/AdminController.php] - [2 Arguments]
1863.             'token' => $this->token,
1864.             'stock_management' => (int)Configuration::get('PS_STOCK_MANAGEMENT')
1865.         ));
1866.         
1867.         if ($this->display_header)
1868.             $this->context->smarty->assign('displayBackOfficeHeader', Hook::exec('displayBackOfficeHeader', array()));
1869.         
1870.         $this->context->smarty->assign(
1871.             array(
1872.                 'displayBackOfficeTop' => Hook::exec('displayBackOfficeTop', array()),
1873.                 'submit_form_ajax' => (int)Tools::getValue('submitFormAjax')
AdminControllerCore->init - [line 150 - classes/controller/Controller.php] - [0 Argument]
144.     /**
145.      * Start controller process (this method shouldn't be overriden !)
146.      */
147.     public function run()
148.     {
149.         $this->init();
150.         if ($this->checkAccess())
151.         {
152.             // setMedia MUST be called before postProcess
153.             if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className)))
154.                 $this->setMedia();
ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
342.             // Execute hook dispatcher
343.             if (isset($params_hook_action_dispatcher))
344.                 Hook::exec('actionDispatcher', $params_hook_action_dispatcher);
345.
346.             // Running controller
347.             $controller->run();
348.         }
349.         catch (PrestaShopException $e)
350.         {
351.             $e->displayMessage();
352.         }
DispatcherCore->dispatch - [line 53 - Minga/index.php] - [0 Argument]

[nino88]

try disabling the cache, and delete the file /cache/class_index.php

[vekia]

add "hide" column to ps_advice table in your database

after that this error should disappear