Detailed Customer View Not Formatting

[ceffylau]

When I go to customers using the drop-down menu and then click on a customer name to view all the customer details, like address, phone number, etc. I get a non-formatted page. The data comes through, but all the CSS and graphical stuff is gone. All the BO "stuff" is gone. At the bottom of the page it says "Fatal error" but I can't find where the broken link is. 

 

I even updated my shop from 1.6.0.9 to 1.6.0.14 to see if running the upgrade would fix the issue, and it didn't. 

 

Anyone have any ideas what is going on? or which file(s) I should be looking for to fix it. I'm not an advanced developer, so I don't completely understand how all the files in Prestashop work, so I'm lost.

 

Here's an image of what I see when viewing customer details: http://www.clipular.com/c/4901106216861696.png?k=KKyfCEmY6zu17bXEIZiFNdWNUQ0

[NemoPS]

Try enabling error reporting as you read in my signature, see if it gives you more than fatal error at the end

[ceffylau]

Sorry for the slow reply, been a busy week. That did give me more info. I haven't had a chance to decipher it yet I'm guessing it might have something to do with the Wishlist Module?

 

[PrestaShopDatabaseException]

Unknown column 'w.default' in 'field list'
 

            SELECT w.`id_wishlist`, w.`name`, w.`token`, w.`date_add`, w.`date_upd`, w.`counter`, w.`default`
            FROM `ps_wishlist` w
            WHERE `id_customer` = 62
            AND id_shop = 1
            ORDER BY w.`name` ASC
at line 646 in file classes/db/Db.php

 

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

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642.         }
643.         elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644.         {
645.             if ($sql)
646.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647.             throw new PrestaShopDatabaseException($this->getMsgError());
648.         }
649.     }
650.
651.     /**

• DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 516 - classes/db/Db.php] - [1 Arguments]
• DbCore->executeS - [line 203 - modules/blockwishlist/WishList.php] - [1 Arguments]
• WishList::getByIdCustomer - [line 323 - modules/blockwishlist/blockwishlist.php] - [1 Arguments]
• BlockWishList->hookAdminCustomers - [line 512 - classes/Hook.php] - [1 Arguments]
• HookCore::exec - [line 194 - config/smarty.config.inc.php] - [3 Arguments]
• smartyHook - [line - ] - [2 Arguments]
• call_user_func_array - [line 247 - config/smarty.config.inc.php] - [2 Arguments]
• SmartyLazyRegister->__call - [line 843 - cache/smarty/compile/74/c6/6a/74c66a4de849eca59aa4af8a121fbe51c7190b1b.file.view.tpl.php] - [2 Arguments]
• SmartyLazyRegister->smartyHook - [line 843 - cache/smarty/compile/74/c6/6a/74c66a4de849eca59aa4af8a121fbe51c7190b1b.file.view.tpl.php] - [2 Arguments]
• content_54fa92f62d3ad9_02332853 - [line 188 - tools/smarty/sysplugins/smarty_internal_templatebase.php] - [1 Arguments]
• Smarty_Internal_TemplateBase->fetch - [line 114 - classes/helper/Helper.php]
• HelperCore->generate - [line 59 - classes/helper/HelperView.php]
• HelperViewCore->generateView - [line 2154 - classes/controller/AdminController.php]
• AdminControllerCore->renderView - [line 831 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->renderView - [line 1839 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 191 - controllers/admin/AdminCustomersController.php]
• AdminCustomersControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

[ceffylau]

If I disable the BlockWishlist module it solves the issue....I would like to keep the module, any ideas on how to fix it?

[NemoPS]

In the database, ps_wishlist table, add that column. It should be a tinyInt, if I recall correctly

[comprausa]

Had the same problem

Adding the 'defalut' column to table ps_wishlist solved it.

Thanks!