Harrison Posted December 19, 2006 Share Posted December 19, 2006 Hello all, I wanted to add a free account order but that billing cycle isn't listed on the "Add order" form in the admin area. After adding the order I changed the account to free but the order payment status is still Incomplete. Where in the SQL database can I change it to Paid? I've checked the tblOrder but there isn't a payment status field. Thanks. 0 Quote Link to comment Share on other sites More sharing options...
MACscr Posted December 19, 2006 Share Posted December 19, 2006 actually tblorders does have a status field. 0 Quote Link to comment Share on other sites More sharing options...
Harrison Posted December 19, 2006 Author Share Posted December 19, 2006 Not a payment status field though. 0 Quote Link to comment Share on other sites More sharing options...
webresellers Posted December 19, 2006 Share Posted December 19, 2006 Try the tblinvoices table.... there is a STATUS field in there. This should mark the invoice as paid. 0 Quote Link to comment Share on other sites More sharing options...
Harrison Posted December 19, 2006 Author Share Posted December 19, 2006 No invoice was created because the payment was £0 EDIT: I just changed the first payment amount to £1 and marked the newly created invoice as paid, then edited both the invoice and first payment amount back to £0 and it worked 0 Quote Link to comment Share on other sites More sharing options...
DataHosts Posted December 19, 2006 Share Posted December 19, 2006 Nice work Harrison... 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.