auther Posted January 14, 2014 Share Posted January 14, 2014 Hi, All the while i only had the COD payment option and my website was working fine. Last evening i installed ccavenue payment gateway module for INR. The module was forwarded to me from CCavenue support team. Now, everytime i go checkout and go to payment option, and select COD, the website hangs and returns 500 Internal server error after some time. Ever since, even the admin panel is acting cranky. I raised a ticket with the hosting support, and they suggest that the payment section is using up all the Virtual Memory and there by crashing the website. Any suggestions / advice... Link to comment Share on other sites More sharing options...
El Patron Posted January 14, 2014 Share Posted January 14, 2014 please turn on errors in PrestaShop and reproduce the error to obtain the 'actual' error related to the 500 error. if you need assistance turning on ps errors see here http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/ Link to comment Share on other sites More sharing options...
auther Posted January 15, 2014 Author Share Posted January 15, 2014 Hi, Thank you for your reply. In the error log, i found these, when i tried to reproduce the issue, *ERROR* 2014/01/15 - 23:55:46: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:55:51: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:55:56: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:56:03: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:56:12: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:56:20: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php*ERROR* 2014/01/15 - 23:56:27: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php Link to comment Share on other sites More sharing options...
El Patron Posted January 15, 2014 Share Posted January 15, 2014 from a native 'vanilla' 1.5.6.1 mysql db here is what (yourprefix)_advice mysql table looks like http://screencast.com/t/LruUOw4UvZ What is your PS version? Link to comment Share on other sites More sharing options...
El Patron Posted January 15, 2014 Share Posted January 15, 2014 here is ccavenue module from offical addon's http://addons.prestashop.com/en/payment-methods/7289-ccavenue.html Link to comment Share on other sites More sharing options...
auther Posted January 16, 2014 Author Share Posted January 16, 2014 On 1/15/2014 at 7:19 PM, El Patron said: from a native 'vanilla' 1.5.6.1 mysql db here is what (yourprefix)_advice mysql table looks like http://screencast.com/t/LruUOw4UvZ What is your PS version? its 1.5.4.1 Why pay when i get it for free from CCavenues itself. Could be, that they have designed for 1.5.6 and its not compatible with 1.5.4 !!! Thanks... Link to comment Share on other sites More sharing options...
El Patron Posted January 16, 2014 Share Posted January 16, 2014 sorry you seemed to get hung up on 'paying' and did not respond to your mysql table. compare this one to your shops. I would think there would be no issue if designed for 1.5 shop to work on any 1.5 shop. did you uninstall and see if the issue went away? Link to comment Share on other sites More sharing options...
auther Posted January 16, 2014 Author Share Posted January 16, 2014 (edited) Oops sorry, The table, seems to be missing the following field... ids_tab If i disable the gateway module, the COD module works just fine. If acts funny only when the gateway module is enabled. Many Thanks, Asif P.S: I unsuccessfully tried to attach the image of the table Edited January 16, 2014 by auther (see edit history) Link to comment Share on other sites More sharing options...
auther Posted January 21, 2014 Author Share Posted January 21, 2014 Hi, i receive the following error, *ERROR* 2014/01/21 - 16:22:08: Unknown column 'start_day' in 'field list'<br /><br /><pre>UPDATE `ps_advice` SET `id_advice` = '1',`id_ps_advice` = '1',`id_tab` = '53',`selector` = '#configuration_form',`location` = 'before',`validated` = '1',`start_day` = '0',`stop_day` = '0' WHERE `id_advice` = 1</pre> at line 607 in file classes/db/Db.php I noticed that in that table (ps_advice), the field names is start_date and stop_date instead of start_day and stop_day as per the query.I am not an expert and not comfortable implementing the change.I believe it is best to change the update query, than to change the table.But i am not sure which file is generating this query.How will i be able to identify the file... please help. Thanks, Asif Link to comment Share on other sites More sharing options...
vekia Posted January 21, 2014 Share Posted January 21, 2014 change table, add new columns there instead of renaming actual columns Link to comment Share on other sites More sharing options...
auther Posted January 21, 2014 Author Share Posted January 21, 2014 Hello Vekia, Thank you for your reply. I have now added the 2 new columns as 'start_day' and 'stop_day' I will test and update if this fixed the errors. Warm Regards, Asif Link to comment Share on other sites More sharing options...
auther Posted January 21, 2014 Author Share Posted January 21, 2014 Hi, I now get the following error: *ERROR* 2014/01/21 - 18:12:27: Property Advice->html is empty at line 874 in file classes/ObjectModel.php Link to comment Share on other sites More sharing options...
peanut Posted March 30, 2014 Share Posted March 30, 2014 On 1/14/2014 at 10:17 AM, auther said: Hi, All the while i only had the COD payment option and my website was working fine. Last evening i installed ccavenue payment gateway module for INR. The module was forwarded to me from CCavenue support team. Now, everytime i go checkout and go to payment option, and select COD, the website hangs and returns 500 Internal server error after some time. Ever since, even the admin panel is acting cranky. I raised a ticket with the hosting support, and they suggest that the payment section is using up all the Virtual Memory and there by crashing the website. Any suggestions / advice... Hi Can you please pass the module? CCAvenue doesn't respond when I ask for it. Also did you manage to resolve the errors? Thanks Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts