Solution for Price become 0 in Oscommerce
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
1064 Error in Oscommerce Shopping Cart
I just tried to install oscommerce Shopping Cart, and has been playing around with some cool template. But since yesterday i found some error which is looks like a common error which is cause by mysql version.
This is the error message i got when i tried to click on reviews section in admin page:
1064 - 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 ‘-20, 20′ at line 1
select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20
This error also occur in the special.php page inside admin section. After search on google, finally i found a way to fix it: Here is how to fix this problem:
Find split_page_results.php page inside the admin/includes/classes folder. Open the file then just under this code:
$offset = ($max_rows_per_page * ($current_page_number - 1));
Add this code:
if ($offset < 0)
{
$offset = 0 ;
}
By adding above code , now i able to view the reviews and special page in admin section.
My first order from Amazon.com
I just made my first books order from amazon.com. These are the books i ordered just now:
- The Tipping Point: How Little Things Can Make a Big Difference, By: Malcolm Gladwell (Author) us$8.97
- The 4-Hour Workweek: Escape 9-5, Live Anywhere, and Join the New Rich
By: Timothy Ferriss (Author)us$11.97 - The Neatest Little Guide to Stock Market Investing (Revised Edition) (Neatest Little Guide to Stock Market Investing)By: Jason Kelly (Author)us$10.2
- What Got You Here Won’t Get You There: How Successful People Become Even More Successful , By: Marshall Goldsmith (Author), Mark Reiter (Author) us$16.29
The reason why i ordered it from amazon.com , and didn’t buy it from local bookstore is because if i purchase more than 3 books, then it will end up much cheaper than if i buy it from local bookshop such as borders bookshop. the other reason is some books are sometimes not available yet in local bookshop. For example : “The 4 hour workweek: Escape 9-5 live anywhere”, in local bookshop , it is sell for around aus$45. at amazon.com it only cost us$11.97 , which is around aus$14 which is much cheaper. The only downside is i have to wait a bit longer for the delivery. which they said gonna takes 12-20 days. I don’t mind though because i’m not rushing to get the books anyway.
Here is the shipping rate for shipping the book to australia using standard international shipping: per shipment fee $6.99 + ($4.99 x how many book you purchase).
Actually i tried to pay using paypal since i still got some us$ in my paypal account and i dont want to withdraw it first to australian $ because the rate is not really good currently. Unfortunately, amazon do not take any payment by paypal. So i have to pay by my credit card. Anybody know what is the reason why amazon don’t accept payment by paypal?