Paper jam in HP LaserJet 3050 series (3052)

This is difficult. Normally when a paper stuck / jam in LaserJet 3050 series (my case is 3052), we can open the printer lid, take out the toner cartridge and pull the paper out. Close the lid and can print again. 

 

In case, i cannot see any paper jam/stuck after take out the toner cartridge but i know it's jam inside there. I've tried to turn off the printer for one minute and turn on again. I can hear the warming up sound is different from usual but when i try to check to see any paper stuck inside there, i can't find any. The paper is hidden inside some where. BIG ISSUE.

Finally, i found something. I followed the instruction below and try to clean the paper path.

It's work. The paper successfully pull out by the printer.

For those who not understand what is all-in-one control panel, please refer to photo below

 

This save my time and money with no need to send to repair.

This is the paper that cause me a lots of trouble.

How to block facebook apps / games request

It's very annoying that the friends send the same facebook app request again and again.This article shows how to block same facebook apps or facebook game request in future.

Click on App Center

In App Center, click on Requests

Click on "X" on the app that you wish to block

Click on Block xxxxxx

Done.

Check on video below to have better understanding.

The bulk load failed. The column is too long in the data file for row 1, column x. Verify that the field terminator and row terminator are specified correctly.

Hit error below when try to execute bulk insert script

Msg 4866, Level 16, State 1, Line 3
The bulk load failed. The column is too long in the data file for row 1, column 6. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 3
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 3
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

(0 row(s) affected)

Script that hit error:

CREATE TABLE GeoIPCountryWhois2
(
[startIp] [nvarchar](50) NULL,
[endIp] [nvarchar](50) NULL,
[startIpNum] [nvarchar](50) NULL,
[endIpNum] [nvarchar](50) NULL,
[CountryCode] [nvarchar](50) NULL,
[Country] [nvarchar](150) NULL
) ON [PRIMARY]
GO


BULK INSERT GeoIPCountryWhois2
FROM 'C:\GeoIPCountryWhois.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '/n'

)
GO
--Check the content of the table.
SELECT *
FROM GeoIPCountryWhois2
GO

Fix:

CREATE TABLE GeoIPCountryWhois2
(
[startIp] [nvarchar](50) NULL,
[endIp] [nvarchar](50) NULL,
[startIpNum] [nvarchar](50) NULL,
[endIpNum] [nvarchar](50) NULL,
[CountryCode] [nvarchar](50) NULL,
[Country] [nvarchar](150) NULL
) ON [PRIMARY]
GO


BULK INSERT GeoIPCountryWhois2
FROM 'C:\GeoIPCountryWhois.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '0x0a'
)
GO
--Check the content of the table.
SELECT *
FROM GeoIPCountryWhois2
GO

Mars power bank 3000 mAh review

Recently bought a external battery charger for my Samsung mobile phone called Mars Power Bank 3000 mAh.

Since the instruction or manual behind the box written in Chinese, i will share this in English so that more people can understand how it's work.

The description is rather brief as below:

• Please read the instruction behind this box before using this.
• This product suitable to use in most smart phone and digital camera.
• Please recharge this product at least once if didn't use for a period of 3 months.
• During the charging process, you can feel slight heat which is normal.  
• Please make sure this product in dry condition. Please do not clear this product with chemical cleanser.

For: Fix for various mobile and devices

Capacity: 3000 mAh

Input: DC 5V -1000mAh (Max)

Output: DC 5V -1000 mAh (Max)

Mentioned in the box, this device support most of the mobile phone brand like Apple, Samsung, Nokia and etc. 

It's very flexible where user can change the adapter to suit the different needs.

Adapters that come with this external battery

For my case, i recharge this external charger with my USB adapter. 

How we know that it's fully charged? There is a LED light indicator. When you start to charge the power bank, the LED is in Red color. Once fully charged, it will turn to Blue. It will takes about 2-3 hours.

Once it's fully charge, you can use it to charge you smart phone and it should work like charm. It will takes 2-3 hours to get the handphone battery fully charge. I'm using Samsung Galaxy S2

Is it safe? Mentioned in the Box, it's certified by CE. I guess it's safe.

The virtual machine could not start - VMware Workstation

Hit error below when try to start windows 7 in my VMware workstation

The virtual machine could not start. Make sure VMware Workstation is installed correctly and you have rights to run the software and to access all directories it uses, including directories in which the software is installed, directories containing the virtual disk and configuration files, and directories for temporary files.

How to solve it?

Restart your computer or stop VMware services that is running and delete all of the .lck folders and also the .vmem file in the vm guest directory. Guest directory is where your install the virtual machine. For my case, i install my virtual machine in "C:\Documents and Settings\user\My Documents\My Virtual Machines\Windows 7 - Base"

Now i'm able to start my VM. Thanks to suggestion http://darktraining.com/vmware/66/

MYSQL Error 1053: The service did not respond to the start or control request in a timely fashion

I'm running mysql in windows server 2003 and was running well all the while. Today, my colleague execute some script and cause mysql hang. So, we have decided to restart the server. After restart the server, window service show that mysql in starting status after 20 minutes. So, i have decided to kill the process in task manager and start the service manually.

Then i hit error message  "Error 1053: The service did not respond to the start or control request in a timely fashion" and fail to start mysql. I've tried to restart windows server again but it doesn't work. I'm not sure what is the reason. What i decided to do is take out the database my colleague work with previous and try to restart mysql service again. Where is mysql data file store? The location can be found in my.ini file.In my case, my file is stored in "C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1". I cut the paste the database out of the folder and restart mysql. It's work!!

Hope this experience can share with friend who hit the similar scenario. For friends who face the same error, maybe this link might helps http://support.microsoft.com/kb/886695

"Licensing for this product has stopped working" when launch Adobe CS 4 Dreamviewer

Facing error message below when try to launch Adobe CS4 product, in my case, i try to open Dreamweaver.


This product has has encountered a problem which requires that you restart your computer before it can be launched.
If you continue to see this message after restarting your computer, please contact either your IT adminstrator or Adobe technical support for helps, and mention the error code shown at the bottom of this screen.
Error: 148.3

How I Fix it in my XP Pro

1. Click on Start 
2. Click on Run 
3. Enter: Services.msc 
4. Click on OK button
5. A Services windows will be displayed
6. Go to find  FLEXnet Licensing Services
7. Double-click on FLEXnet Licensing Services 
8. Change the Startup type: Automatic 
9. In Service Status, click on Start button to start the service
10. Click on Apply button
11. Click on OK button to close the Services window
12. Done

facebook - Invalid URL The requested URL "/", is invalid. Reference #

I can access to facebook using samsung galaxy SII without problem but when try to access to facebook this morning using my laptop, i hit error

Invalid URL

The requested URL "/", is invalid.Reference #9.3e556acb.1337250952.21c9cc69

some suggest that delete browser cache will helps but i hit the above error in google chrome, mozilla firefox and IE8.

You can try 2 ways.

1. Try to flushdns in your computer first.
2. Click on Start
3. Click on Run
4. Type cmd and click on OK button
5. In the command prompt windows, type ipconfig /flushdns and hit enter button.
6. Try to browse the website again.

Not problem not solved, try This

1. Go to folder "C:\Windows\System32\drivers\etc"
2. Open hosts file with notepad .
3. Copy below and paste in hosts file
   69.171.228.74 www.facebook.com
   69.171.228.74 https://www.facebook.com
4. Click on save to save the hosts file
5. Close the browser 
6. Open and access to facebook again.
7. Problem solved.

An error occurred with the POP3 mail server. Mail server mail.xxxx.com responded - Thunderbird 10

My email client Thunderbird 10 working 100% good before today but this morning when i try to retrieve emal from my mail server, i receive error message
"An error occurred with the POP3 mail server. Mail server mail.xxxx.com responded"





I'm very sure that my mail server working fine because i can download my email using my Sumsung Galaxy SII. There must be something wrong with my laptop.

Finally, i found out that the root cause come from the antivirus that i'm using. I'm using avast! antivirus free edition. There is a feature call Mail Shield which will scan inbound and outbound email. Once i disable this feature, it's working back to normal.

Hope this sharing helps.

How to view Mysql Stored Procedure in PhpMyAdmin

How to view Mysql Stored Procedure in PhpMyAdmin?

1. In PhpMyAdmin, select the correct Database on the left hand panel
2. You can see all the database tables in the right hand panel
3. Scroll down the right hand panel until the end, you will see Routines
4. Click on Routines
   
   
5. Once click on Routines, all the Stored Procedure will be displayed on screen
   
   

Mysql very slow for certain schema

I have a database/schema name inventorysoftware and have a .net windows application running on this schema. The issue is, the application run very slow on this schema (like each click need to wait about 30 seconds). I have about 40 others schema running in my development machine with windows XP Pro.

I have tried to google around the issue but can't find any similar problem. One thing i need to mention here is i have about 15 schema with name inventorysoftware_ddmmyy where dd=day, mm=month, yy= year. You know, developer like to keep the backup schema for testing. After the application deployed to customer, i decided to clean my 15 schema with name inventorysoftware_ddmmyy .

After i have deleted the schema, my application move very fast. I found the root cause for the slowness. Lesson learn, don't use the schema starting with the same name. It will kill you.