trailshopguy Posted June 10, 2005 Share Posted June 10, 2005 Hi I have a problem with my OSCommerce store that I could use help with. While I was away for a few days, someone else in the office was left with the job of pulling some SQL queries off of our phpAdmin MySQL interface. They've now told me that they tried experimenting with a couple of variants to the queries! I don't know what they might have done, or even if that is the definite cause of the problem, but this morning our store seems to have lost its payment module options. We ran only two enabled - Secpay and cheque/money order, but now there are no options at all showing in the payment modules admin interface and any attempted purchases on the store result in the payment options page coming up with no checkbox options available. Any advice on the best way of fixing this? Are the payment modules contained in a database table somewhere? I've been looking at the structure of our database and backups of it, but can't find a 'payment modules' table or any sign of where the information might be stored. If possible (if this is the right approach) I'd like to just upload the relevant data to the existing database rather than install a back up to avoid losing transactions since the back up was made. Any advice gratefully received, thanks! Link to comment Share on other sites More sharing options...
millhouse Posted June 10, 2005 Share Posted June 10, 2005 If its not just the modules you are missing then can you not just reload the relevant folder from your backup? Link to comment Share on other sites More sharing options...
trailshopguy Posted June 10, 2005 Author Share Posted June 10, 2005 The files seem to be in place, but not being registered in the ordering process. If it's a file issue rather than a datbase issue though, I might try a full file reinstall from the back ups though. Link to comment Share on other sites More sharing options...
trailshopguy Posted June 10, 2005 Author Share Posted June 10, 2005 Nope - I've reinstalled every php file from back up, but the problem is still the same. The problem is occuring when the customer gets to checkout_payment.php, where they should be given an option of payment methods. Instead it just says Payment Method This is currently the only payment method available to use on this order. With no payment options being shown. The admin panel for payment modules is showing no modules installed, but all the module files are present in the 'include/modules/payment/' folder. Help! Link to comment Share on other sites More sharing options...
trailshopguy Posted June 10, 2005 Author Share Posted June 10, 2005 OK - solved it. Just to close off the thread, in case this is ever of future use to anyone :blink: : It was the configuration_values of MODULE_PAYMENT_INSTALLED and MODULE_ORDER_TOTAL_INSTALLED which had been accidentally deleted in the configuration table. Cause unknown, but some over enthusiastic SQL experiments are the likely culprit. I reset them as per our last back up and everything is OK again. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.