E72 firmware upgrade 0.51.018 problem (No Sms tone and vibration) Solution

Upgrade my Nokia E72 to new firmware upgrade 0.51.018, because i didn't care to read before upgrading, im having an issue, sms receive without tone alert and vibration, after several Hard reset and head banging to the wall, i come with solution below :

1. Install PC Suite

1.1 Export SMS as CSV file or u can drag and drop all sms in a folder

1.2 Export MMS as MMS file by drag and drop

1.3 Export Contact as CSV

2. Open Folder Using Explorer (Basicly copy and paste whatever folder that u want)

2.1 Copy and Paste Image Folder

2.2 Copy and Paste Music Folder

2.3 Copy and Paste Video Folder

3. Format my SD Card using Phone

4. Enter *#7370# to Hard Reset

5. Done everything and test sms yourself and receive tone and vibrate

6. Manually restore every backup that u done

7. Test smsing urself again

8. Yes i know phone setting is diffrent and application need to be install one by one, but hey atleast u manage to restore your contact,sms,mms and few more folder with all function running

p/s: sms can only be restore to My Folder, incase u want to restore to inbox, do it by selecting them via phone

Hope this help

Previous Month Query

We always encounter this issue, how to query previous month data in sql statement
and as always we will get an easy idea, just subtract 1 from current date

example :
month(curdate())- 1

yes this is one easy way to do it, but we will encounter 1 big problem with this statement,current date month is January 2010 and the statement result for the previous month will be 0, that means your query will query month = 0 and your query will give you a null result

solution :
use interval in your query

month(curdate() - interval 1 month)
by using interval the query result is 12 when the current date month is January

this solution also apply to previous year
year(curdate() - interval 1 year)

interval unit available is
FRAC_SECOND (microseconds), SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR

this is just the basic of it, how to implement it to your query its up to you
but hey this is just my opinion, if there is any other better way please respond in comment area ^^