deepee Posted August 31, 2009 Share Posted August 31, 2009 Hi I'm currently testing Prestashop and like what I have seen so far.I came across the following problem after placing a test order.I can see two test orders (mine and the default original prestashop order) in my back office> orders.One is wiating for cheque payment and the other is waiting for wire payment.When I click on them they both return the error "myname_presta.ps_order_credit_data' doesn't existAny pointers would be appreciated.ThanksDeepee Link to comment Share on other sites More sharing options...
deepee Posted September 1, 2009 Author Share Posted September 1, 2009 Hi Haven't had a reply to this post and still haven't been able to work through this issue.Just to recap, when I click on an order I get the following:-Table 'myshop_presta.ps_order_credit_data' doesn't exist SELECT * FROM `ps_order_credit_data` WHERE `id_order` = "2"Anyone know what's going on?ThanksDeepee Link to comment Share on other sites More sharing options...
rocky Posted September 2, 2009 Share Posted September 2, 2009 The ps_order_credit_data table doesn't come with the default Prestashop install. It is created by the Offline Credit Card Module. It might be the cause of the problem. Have you tried uninstalling and reinstalling that module? Link to comment Share on other sites More sharing options...
deepee Posted September 2, 2009 Author Share Posted September 2, 2009 Thanks rocky, you nailed it!Once I uninstalled the Offline Credit Card Module I was able to view details for both test orders.I then re-installed the Offline Credit Card Module and it returned the following error:-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ps_`' at line 1show table status like `ps_`However, when I go back to the Back Office >> Payment page, the module shows as installed and the configuration options are available.When I now try to view the two test orders, it returns the original error.Is there anything I can try to fix the offline processing module, as I really need this functionality.Many thanksDeepee Link to comment Share on other sites More sharing options...
deepee Posted September 7, 2009 Author Share Posted September 7, 2009 Can anyone offer any help or suggestions please?I can't do any more with the shop setup until I get this worked out.ThanksDeepee Link to comment Share on other sites More sharing options...
deepee Posted September 9, 2009 Author Share Posted September 9, 2009 Solved by installing the Offline CreditCard + Show Parcels Module here:- http://www.prestashop.com/forums/viewthread/26030/#125298 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