Tag: How-To

How to fix: Drupal “user warning: Unknown column…” error

Exact error message: … user warning: Unknown column ‘page’ in ‘where clause’ query: [function_name] /* [username] : [function_name] */ SELECT n.nid FROM node n WHERE n.type = page AND n.status = 1 ORDER BY n.created DESC LIMIT 0, 5 in /home/user/public_html/path/to.module on line 294. … Th query in question: $result = db_query(‘SELECT n.nid FROM {node} n WHERE n.type = %s…

Read More »

Uninstall Hellgate London without HGL_x86.msi

This game (Hellgate London) ask for HGL_x86.msi (which is located in game CD) when uninstalling. Well, if you don’t have the CD in hand, you could just click the cancel button when it ask for HGL_x86.msi file. The uninstaller will still uninstall the game. This is the first time I found a game which ask for game CD when uninstalling,…

Read More »

How to fix buffer_get_ret: trying to get more bytes 4 than in buffer

I got this error after adding new user to the system (CentOS). The user key is generated using PuTTY Key Generator (PuTTYgen for short). Exact error (in /var/log/secure): … Apr 3 08:57:13 hostname sshd[28041]: error: buffer_get_ret: trying to get more bytes 4 than in buffer 0 Apr 3 08:57:13 hostname sshd[28041]: fatal: buffer_get_int: buffer error Apr 3 08:58:23 hostname sshd[29722]:…

Read More »

How to: Play Perfect World International using proxy server

Perfect World International (PWI) is an MMORPG developed by Beijing Perfect World. It has been released in several different areas in different versions already. The Malaysian version has now been released worldwide in an English-language format. Perfect World International opened its teaser site on July 15, 2008 and launched its closed beta August 19, 2008. The open beta began on…

Read More »

How to: create SSH tunnel with PuTTY

Why do we want to do this? Because we do not want people to sniff / logging our activity. So, we would want to encrypt what we are sending and receiving over the net. This is the most easy and cheap way to set up proxy using SSH connection, provided you already have SSH access to a server / host….

Read More »

How to fix buggy Venus VT-12 CDMA USB modem driver

Venus VT-12 is a CDMA USB wireless modem. Modem specifications: [*] CDMA 2000 1x with RUIM, 800 MHz Frequency band. [*] Using Qualcomm Chipset. [*] Up to 230.4 Kbps (average 60-100 Kbps). [*] Compatible with USB 1.0/1.1/2.0 Symtoms: [*]Random disconnect. [*]Once disconnected, unable to reconnect again until the computer restarted. [*]Sometimes, error about svchost pop’d up. Fix: [*]Unplug the USB…

Read More »