Opera house Sydney image Blur in Googlemap
As some of us might already know, APEC (Asia-Pacific Economic Cooperation) Australia 2007 year will culminate in the Sydney CBD on 8-9 September with the APEC Economic Leaders Meeting (AELM), bringing together the leaders of all major regional economies as well as thousands of delegates, support personnel and the international media, and is one of the most important annual meetings of world leaders.
And this morning i read a news in smh newspaper that the googlemap photo of sydney opera house has been fuzzed out. Not sure though if this is something to do with the APEC. Maybe because of security reason, the image has been fuzzed out to minimise the risk of a terrorist attack during the APEC September summit. I print screen some image from google map so you guys can check the image here as well.
Bag of pooki deal from catchofthedeal
I finally decided to give it a go to find out what can i get in the bag of pooki deal from catchofthedeal website. Bag Pooki is basically a random assortment of 10 objects, goodies and just general stuff from catchoftheday warehouse. I grab this offer for $19.95 with $7.95 delivery fee. I Can’t wait till i find out what kind of stuff inside the bag. I will post it here again once i receive the stuff already from them.
By the way, on 1st of august i also bought this Stripy Music Studio Speaker for $49 from catchoftheday. The reason why i bought this speaker is because it looks very cool and very compact. And from what i read from other user review from other site, the sound quality is good as well, so its time for me to change my old creative speaker at home.
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?