patuga Posted March 22, 2013 Share Posted March 22, 2013 Hi everyone, been using prestashop for a while and recently i've upgraded to version 1.5.3.1 now i'm getting an error with paypal everytime someone makes a payment. The payment goes through, but it's still anoying... the error is: Fatal error: Uncaught Unknown column 'id_invoice' in 'field list'<br /><br /><pre> INSERT INTO `ps_paypal_order` (`id_order`, `id_transaction`, `id_invoice`, `currency`, `total_paid`, `shipping`, `capture`, `payment_date`, `payment_method`, `payment_status`) VALUES (742, '0TA333349D601735X', '', 'EUR', '3.5', '0', '0', '2013-03-19T17:49:08Z', '1', 'Completed')</pre> thrown in /home/coldzero/public_html/classes/db/Db.php on line 605 when the payment is done, the only message code i get is "payment accepted" instead of the log i used to get with PS 1.4 when i use test mode i get another error: PayPal response: TIMESTAMP -> 2013-03-21T17:50:52Z L_ERRORCODE0 -> 10002 L_SHORTMESSAGE0 -> Security error L_LONGMESSAGE0 -> Security header is not valid L_SEVERITYCODE0 -> Error even though this part i'm not entirely sure i'm doing properly... i've also tried removing the module from the server and re-installing it again. i also requested new credentinals on paypal but it still not working could this be theme related? can anyone help me with this, please? Link to comment Share on other sites More sharing options...
NemoPS Posted March 23, 2013 Share Posted March 23, 2013 It seems that your table is missing a column, try adding id_invoice as a new column in that table (ps_paypal_order), make it a 12 length integer Fabio Link to comment Share on other sites More sharing options...
patuga Posted March 26, 2013 Author Share Posted March 26, 2013 Hi Nemo1, tahnks for the reply. i'm not a very advanced user, so in which file should i try to add this? Link to comment Share on other sites More sharing options...
NemoPS Posted March 26, 2013 Share Posted March 26, 2013 This might be a problem, you have to login to phpmyadmn to do it, but you should better ask someone if you're new to it, as you can mess the database by doing something wrong Link to comment Share on other sites More sharing options...
patuga Posted March 30, 2013 Author Share Posted March 30, 2013 ok, i'll pass that information allong hope i fix this Link to comment Share on other sites More sharing options...
brim Posted November 18, 2013 Share Posted November 18, 2013 Where in the table should the field id_invoice be inserted? What should the field order be? Thanks. Has anyone tried this? Link to comment Share on other sites More sharing options...
NemoPS Posted November 19, 2013 Share Posted November 19, 2013 The order is not important, adding the column will be enough Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now