Friday, June 14, 2013

Change Base URL in Magento cannot change back, SQL edit

Try to change my Magento store URL today, at first I thought it works, but after that found out that it goes missing, not so much as missing content, more to having a page without any CSS design at all. Some people said they got '404' error popping up.

It left me panic stricken for a while, but after that did the following;

1. Go to MyPHPadmin and my magento store database and locate the following 'core_config_data' just like this video

2. Change the secure BASE_URL and BASE_URL here to your desired base url
3. Go back to your Cpanel (or other web hosting manager you have) login via FTP can also do the trick,go to your magento folder and clear all the file in var/cache and var/session also temp. Clear your computer cache too, sometimes your browser is a bit slow in re-caching.
4. This should work, if not try login-in into your Magento admin panel via the design-less page, find the index management and clear your index there.

Hopefully this work for other people facing the same problem as me.

Wednesday, May 29, 2013

Magento SQLSTATE[HY000] : General error

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

I ran into this problem on one of my Magento Commerce site, tried all the solution like clearing var and tmp files but the problem still exist. This happen three times and the only solution is to contact my shared hosting company and tell them to solve the issue by clearing 'their' disk space. There really is nothing you can do on your side of things if your site is hosted on some shared hosting server.

Of course of your site is running on different server package then you might one to try the other solution given here by other users like increasing your disk space limit.

Part of the inhumanity of the computer is that, once it is competently programmed and working smoothly, it is completely honest. -Isaac Asimov 



Sunday, February 17, 2013

Stop Digi Caller Tunes

Not always the smarter choice to have a caller tune on your phone that sucks RM3 every month. Therefore last week I decided to terminat the service. I tried to scour the Digi website for information but surprise...surprise, it seems they will wax lyrical about how to get a caller tunes but mums the word on how to actually get off it.

However I tried to stop it using the "SMS STOP" thing, "STOP" didn't work but it gave me a list of other keyword that can be use and I'm off the blassted thing. Pretty simple actually. Just type "CT OFF" without the quotation mark and send it to 2000. It will remove the caller tune subcription immediately.

*Updated 3.3.2016
Someone update the process to this.. (thank you anynomous)

You send CT OFF to 20000 you get a reply from 2000310001 saying your content list....title of song followed by a number. This is the content ID.

You are supposed to send CT STOP followed by space content ID back to 20000, then it's ok.

e.g:
Received: RM0.00. Your content ID list:
1.Break The Rules..-1803286
To unsubscribe, send CT STOP to 20000.


Replied to 20000:
CT STOP 1803286

Sunday, January 20, 2013

Catatan siput

“Nikmat itu kadang-kadang tidak disedari, hanya apabila ia telah hilang barulah manusia benar-benar terasa.” kata-kata Pujangga~ 

Hampir setahun rasanya tiada catatan peribadi di sini. Bukan lupa cuma malas dan sibuk yang menjadi-jadi. Ada juga nukilan yang dicatat cuma tidak di laman ini. Nukilan peribadi di atas buku nota, luahan hati supaya tak perlu jumpa pakar psikologi. Menulis merupakan terapi. (Tak tipu, ini kata pakar)

Sahaja catatan ini dibuat dalam Bahasa Melayu. Nak asah balik otak dan tajamkan minda macam dulu-dulu, pabila boleh menguntum ayat berbatu-batu. Mungkin boleh tulis buku ;-P

Tahun ini genap usia ke-30 tahun, syukur ke hadrat Ilahi aku masih sihat dan mampu berdiri sendiri. Bukan apa, terkadang melihat remaja yang muda belia menerima imbasan CT (aku kerja hospital sekarang ni), ada yang hampir pasti tiada harapan setelah motor bertemu lori, diserang kanser dan macam-macam lagi. Terasa amat besarnya kurniaan sihat itu yang kadang-kadang kita ambil mudah sekali. Nikmat bernafas, makan, minum, berdiri. Itu semua tak mungkin boleh dibeli, Biarlah wang berjuta, berbillion sekalipun, ia memang tak mungkin diganti.

Walaupun usia menginjak 30 tahun tapi jujur perkembangan psikologi aku perlahan. Bila teringat zaman-zaman sekolah hingga universiti, baru perasan, lembap sunggu aku ni bila masuk bab kematangan. Orang ke bulan, aku masih menghitung jalan. Bila terfikir, pasti saja ada kawan-kawanku yang anggap aku ini sedikit dungu, lebih-lebih bab hati dan perasaan. Bukan dungu sebenarnya tapi perlahan. Siput babi berjalan...
Faktanya IQ dan EQ itu tidak sama, sebab itu ada yang sampai tahap PhD tetapi tiada kepintaran jalanan.

Perlahan-lahan siput babi tetap akan sampai ke destinasi jika tidak diberi garam supaya mati.

Separuh 2013 ini akan aku habiskan untuk mengutip pengalaman dalam bidang yang aku punya sijil terbentang. Separuh tahun lagi untuk mencari kerjaya baru, mungkin dalam bidang yang aku tahu dan mungkin kembali ke dunia perniagaan. Kalau ada rezeki, kerjaya makan gaji hanya untuk kumpul modal untuk timba pengalaman  Apabila modal sudah cukup, aku ingin punya perniagaan sendiri. Lebih puas dan lebih menyerokkan.

Sampai bila nak jadi kuli ?

Matlamat peribadi yang satu lagi itu kerja Ilahi. Mama dah bising-bising, kerana janjiku ketika usiaku menjejak 30 akan aku serius dan yakin untuk menyandang gelaran itu. Siput babi la katakan.

Akan aku usahakan yang terbaikdan berdoa ia menjadi. Doa, usaha dan tawakkal. akhirannya nanti tetap milik Pencipta sekian alam.


Akal tengah malam "Orang Islam makan siput babi tak?" Adakah kerana terdapat perkataan 'babi" makan ia tidak dimakan?

Nilai manusia adalah semahal nilai matlamatnya - kata pujangga

Saturday, January 19, 2013

Insanity day 7

After 7 of Insanity, some parts are still screaming but I had to stop it for while after being hit German measles. It's like having gout, my joints are painful to move but I was lucky not to be hit by fever, just itchy rashes and joints pain.

Overall after 7 days of insanity I find some movement is easier it's great for toning muscles. Running burns fat, but not necessarily tone your body since you don't really use your upper body much, but Insanity make sure that I move from head to toe.

Will continue with it after my body is back to normal.

Wednesday, January 09, 2013

Insanity

It's a new year, new age and a new referendum (although most of the time this will only lasted about 5 minutes into the new year but what the heck... just keep trying)

To start off the new year, I decided to try the ’60 Days Insanity workout’. I’m fairly in good shape, I jog about 4 times a week, row for 15 minutes at the gym, did the whole 10k run thing and I watch what I eat, but after a while, I realized I’m just not burning calories as much as I wanted.  My body became adapted with my jogging workout therefore nothing changes. 


Not helping matter was that Navy cruise thing during Christmas. Those Navies surely knows how to cook and seeing how the weight scale seems to goes into an upward trend rather than downward...scary time (I’m vain about my weight). It is certainly time to change my workout style.

I glide around Youtube for new workout regime and came across Insanity and decided to challenge myself with it because it only takes about one hour a day. I mean how hard can it be? It’s only for 60 days.

So starting on the 7th, I start my first day of training. It is called the Fitness Test. I thought I was going to glide through it, jumping jacks, jumping, and stationary running, all fairly simple right? I was WRONG. The first day had me gasping and that was only the FITNESS TEST and lasted for 25 minutes including stretching. I was still sweating even after taking a bath afterward.

Glutton for punishment, yesterday I completed the Plyometric circuit training but that was a tough one. I was on the floor halfway through, dripping sweat all over my yoga mat. After 40 minutes my muscles was screaming murder.

Today my whole body ache all over but I feel good. I decided to write about it just to keep track so I won’t lose the determination to finish this ‘Insanity’. By keeping track I know I’m making progress and not stopping it halfway.

Day 3 here I come.