How to reset the Admin Kayako password?

If you forget the password for the Admin CP you will not be able to login. - If you are using a Hosted license, you will need to contact us to reset the password for you. You will need to provide us some proof of identity like your Transaction ID or the Order ID before we can reset the password for you. - If you are using a Leased or an Owned license, you will need to run the following queries at your MySQL prompt : 1. Select title,fullname,username from swstaff sw join swstaffgroup sg on (sw.staffgroupid=sg.staffgroupid); 2. Update swstaff set password=md5('Test') where username='username'; The first query will provide you with a user name, which you will need to specify in the subsequent query and it will reset the password to 'Test'.

PHP Setting

short_open_tag = On || Off display_error = On || Off mysql.connect_timeout = 60 || (240 in my notebook)
extension=php_mbstring.dll
extension=php_mcrypt.dll
extension=php_mssql.dll
extension=php_mysql.dll
extension=php_gd2.dll
extension=php_imap.dll
extension=php_mysqli.dll

update 08/12/2012 (dd/mm/yyyy)
max_execution_time = 60 ; Old value is 30 is not enough for install Magento

Linq and about OrderBy

Linq has OrderBy and OrderByDescending when need multiple order use ThenBy or ThenByDescending

Problem with razor on MVC 3 ?

try this Quick Reference
http://haacked.com/archive/2011/01/06/razor-syntax-quick-reference.aspx
and
http://www.asp.net/webmatrix/tutorials/2-introduction-to-asp-net-web-programming-using-the-razor-syntax

Might&Magic Heroes VI with blank start screen on notebook.

Fix by turn off imeout Detection and Recovery of GPUs with edit reg.
by this ref. from microsoft http://msdn.microsoft.com/en-us/windows/hardware/gg487368
we need to go to

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\GraphicsDrivers

Right click on the GraphicsDrivers and select the add DWORD option. Rename the new item that comes to "tdrLevel" let value to 0 (zero)

Generate Excel file in C#.

2 opensource help a lot for this job.
1 for xls is http://code.google.com/p/excellibrary/
2 for xsls is http://epplus.codeplex.com/

that's all.

SmarterMail – No connection could be made because the target machine actively refused it 127.0.0.1:17001

Today i notice my site don't send notice mail to me.
So i go to my mail control panel and yes this error came to me. - -'

after research i found solution to repair .NET 4.0 Client. here we go.

Windows > Control Panel > Programs > Programs and Features

Uninstall/Change on "Microsoft .NET Framework 4 Client Profile"

Repair on that and reboot.

Anything work again.

ORA-01033: ORACLE initialization or shutdown in progress

Today news system in mot.go.th can't connect correctly
by this error
"ORA-01033: ORACLE initialization or shutdown in progress"

after try to restart database it found another error "ORA-32004: obsolete and/or deprecated parameter(s) specified"
with error in write to log
after search someone said to recovery by delete old log with

RMAN> connect target sys/*******
RMAN> delete archivelog all;
RMAN> crosscheck archivelog all;

so anything fine and can restart database again hope this help someone like me too.

android eclipse don't run my application.

I use eclipse-java-helios-SR2(3.6)
to try my first app and it not run correctly.
I install this by step
1) Eclipse (3.5 up)
2) jdk-6u26-windows-i586.exe (Java JDK)
3) android sdk (installer_r11-windows.exe)

and setting by use http://developer.android.com/sdk/eclipse-adt.html
plugin to eclipse
anything work fine except it run only emulator not my app (???)

try this by step
1. after emulator run just go to kill task adb.exe with task manager.
2. don't close emulator
3. close eclipse
4. run eclipse again
5. run application again
6. should work.

I got this problem in my XP but vista anything work fine.

How can make Visual Studio to support CSS 3.0 Validation

--- Obsolete please see bottom on update ---
This is CSS 3 Intellisense Schema
http://visualstudiogallery.msdn.microsoft.com/7211bcac-091b-4a32-be2d-e797be0db210

And if need more Html 5 support and CSS 3.0 full support install VS2010 SP1.

Update on 2012/11/10 (y/m/d)

After install VS2010 SP1 install this
http://visualstudiogallery.msdn.microsoft.com/a15c3ce9-f58f-42b7-8668-53f6cdc2cd83

Free Online Project manager

Now I open account at Basecamp at http://basecamphq.com/ for vdevhost
and goalkeeper http://basecamphq.com/ for mot project

Tool for Convert video file for Mobile

http://handbrake.fr/downloads.php

My Motorola DEFY can't receive SMS. (TH)

After a bit search I Found this and it work.

Menu > Settings > Wireless& Network > Mobile Network > SMSC Settings

Check on our phone provider.

GSM Advance : +66818110888
One-2-Call : +66818310808
GSM1800 : +66813101800

DTAC & Happy : +66816110400

True : +66891009120

Hope this help.

Remove Windows Live Contact from Windows Mobile 6

Once setup Windows live and use msn with email every email will combine with outlook contact.
- -'

So bad
For fix this go to Windows Live through "Program" and use menu Switch Account in Account Options
After a few Minute this will delete all setting for your msn and after EULA display just reject it.
Wow! anything clean again.

Thanks for this blog for help me a lot.

ref http://www.pctipguys.com/index.php?option=com_content&task=view&id=96&Itemid=36

XmlTextWriter to format out xml with newline and indent.

This is sample from my project to serializer object with utf8.

XmlSerializer xmlFormat = new XmlSerializer( typeof( LeaveObjectItem ) );

string xml = String.Empty;

Encoding utf8EncodingWithNoByteOrderMark = new UTF8Encoding( false );
using (MemoryStream stream = new MemoryStream())
{
XmlTextWriter xtw = new XmlTextWriter( stream, utf8EncodingWithNoByteOrderMark );
xtw.Formatting = Formatting.Indented;
xtw.Indentation = 4;
xmlFormat.Serialize( xtw, ItemToExport );
xml = Encoding.UTF8.GetString( stream.ToArray() );
}

using (StreamWriter outfile =
new StreamWriter( fullpath, false, System.Text.Encoding.UTF8 ))
{
outfile.Write( xml.Replace( ">�<", ">DBNULL<" ) );
}