IeM Posted March 12, 2014 Share Posted March 12, 2014 (edited) Hi, Version 1.5.6.1 I need to set which groups are serviced by which payment methods but the Admin->Modules->Payment (AdminPayment) page refuses to load. It is displaying as all white. As far as I know form checking files it has not been overriden. I tried disabling all of the payment methods but it still will not load. I have cleared the cache. I can not find any other pages that will not load. Any suggestions as to what to do now other than set up another fresh install? If not, can anyone tell me where the the group-payment preferences are stored so that I can manually set them? Thanks Edited March 12, 2014 by IeM (see edit history) Link to comment Share on other sites More sharing options...
NemoPS Posted March 12, 2014 Share Posted March 12, 2014 Have you tried enabled error reporting as described in my signature? still blank page? Link to comment Share on other sites More sharing options...
IeM Posted March 12, 2014 Author Share Posted March 12, 2014 Hi Nemo1, Thanks for reply. The error shown is: [PrestaShopDatabaseException]Unknown column 'a.start_day' 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` = 64 AND ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (12 >= a.`start_day` AND 12 <= a.`stop_day`))) There is a start_date and a stop_date in the advice DB table but I do not know why the SQL would be incorrect or where is is assembled. Does this provide light to you? Thanks Link to comment Share on other sites More sharing options...
NemoPS Posted March 12, 2014 Share Posted March 12, 2014 that column should exist for the ps_advice table. Can you check it in your db and make a screenshot? Link to comment Share on other sites More sharing options...
IeM Posted March 12, 2014 Author Share Posted March 12, 2014 Hi, The columns are not there but there are two other column that look like they may be for the same purpose. See attached. Link to comment Share on other sites More sharing options...
IeM Posted March 12, 2014 Author Share Posted March 12, 2014 I changed the DB table columns to see what would happen. The next problem is (well do not know why the table was wrong):Fatal error: Cannot redeclare class MCAPI in /home/......................./modules/minicmailchimp/MCAPI.class.php on line 3 Link to comment Share on other sites More sharing options...
IeM Posted March 12, 2014 Author Share Posted March 12, 2014 After disabling minicmailchimp and changing the database table it works fine. Bit of a worry about the table being incorrect. I hope that it is not changed again. Anyway, thanks Nemo1 for putting me on the right track. Link to comment Share on other sites More sharing options...
Recommended Posts