Pligg Modules

I tried to install another template for oscommerce and tried to customise it for australian currency, then i found several problem again. So i decide to write down some of the problem i got and how to solve it, Hopefully it might be useful for you guys who have problem in installing oscommerce as well.

Problem: Currency problem
Description: The problem i had is , once i changed the USD to other currency , in this case i want to change to australian dollar (AUD), the price in oscommerce product will become 0.
Solution : Open the file in /includes/languages/english.php , then find this code:
define(’LANGUAGE_CURRENCY’, ‘USD’);
You should change this to your currency, for example if i want to change to AUD, then i will change the code to :
define(’LANGUAGE_CURRENCY’, ‘AUD’);

Problem : 1054 - Unknown column ‘p.products_id’ in ‘on clause’
Description : this problem usually happened when you click on some category and also on the search function.
Solution : Please click here for the solution