WebGuru’s Blog about Digital Life

Resolved a "STOP 0xC000021A" error on the Windows XP machine

WebGuru — Sun, 08 Aug 2010 04:05:33 +0000

The machine of my friend’s all of sudden started to hung up before the Windows logon screen. Later it went into a loop of continuously rebooting. I came in with safe mode and disable the auto reboot upon error feature, then I saw the famous death blue screen with the following error message every time: [...]

How to trouble shoot SharePoint with “critical error”

WebGuru — Wed, 04 Aug 2010 19:14:44 +0000

These days the MOSS site went down a couple time, every time there was the following error messages: page has encountered a critical error. Contact your system administrator if this problem persists. At first, we could reboot the database and application servers to let the problem go away. But rebooting is not the good choice. [...]

Resolve Access Denied Error while creating new article page in SharePoint MOSS 2007

WebGuru — Fri, 30 Jul 2010 22:22:03 +0000

A user with Full Control permission on the top site could not create an article page. The error message was Access Denied. I tried different ways to resolve this issue, include put her Full Control permission directly on the top site and Page library, but still had the same issue. Then I assign Full Control, [...]

How to change the Domain name URL for the SharePoint site

WebGuru — Thu, 29 Jul 2010 21:49:13 +0000

We just launched a new Intranet web site powered by the SharePoint 2007 (MOSS 2007). Everything works fine except the URL. By default, the SharePoint services uses the computer name of the server. But we need a nice name like “http://intranet” as the new site name. We created a new DNS record named “Intranet” and [...]

How to correctly import no-English (UTF-8) characters from MySql4 into MySql 5.0 with mysqldump

WebGuru — Sun, 02 May 2010 04:50:56 +0000

I tried to upgrade my WordPress to 2.9.2 but I had to upgrade my database MySql first since WordPress 2.9.2 requires higher MySQL version. Just like I usually did with the database backup routine, I used “mysqldump” command to export data from MySQL 4.0 and then used “mysql” to import data into MySql 5.0. Everything [...]

How to display SharePoint list from another site

WebGuru — Thu, 01 Apr 2010 21:29:42 +0000

There is no a straight way to add SharePoint list from another site to the web part page. Recently I found out a simple way to do so from Path to SharePoint blog. 1), Create a new Content Editor Web part on the page you are working on. 2), Paste the following code in the [...]

How to refresh a SharePoint page automatically in 60 seconds

WebGuru — Wed, 31 Mar 2010 17:25:43 +0000

As I indicated in my previous post, I need to set up a SharePoint page with some frequently-updated lists. And I need this SharePoint page to be refreshed automatically every minute. Here are some methods I tried. Method #1: Use Javascript in Content Editor Web part. A simple Javascript can refresh the web page automatically. [...]

How to add weather and traffic information to SharePoint page

WebGuru — Tue, 30 Mar 2010 16:47:00 +0000

Recently I added some weather and traffic information to one of our SharePoint page, and would like to share the process here. Of course, you will have to select the right web service based on your location. I use Georgia state here as the example. Normally to add external information to the SharePoint page, you [...]

How to open SharePoint link list item in a new window

WebGuru — Mon, 29 Mar 2010 15:11:00 +0000

In SharePoint 2007 (WSS 3.0), you can put any URLs in the Links List. But when you click any of these links, they will be opened in the same browser window instead of in a new window. I checked the Internet, and found a couple of ways to open the links list in a new [...]

Post emails onto SharePoint list

WebGuru — Fri, 26 Mar 2010 20:38:00 +0000

Challenge: We are using a service called Roam Secure Alert Network to notify subscribers about any news needs immediate attentions. These alerts can be posted through Web, Email and SMS. And the subscriber can receive alerts with emails, phone text messages. Recently we need an internal SharePoint web page to be developed to show all [...]

Issues with creating Database Connections to Oracle in SharePoint Designer 2007 (Resolved)

WebGuru — Wed, 17 Mar 2010 20:07:00 +0000

Challenges: I tried to connect to Oracle database in SharePoint (MOSS 2007). But got the following error when I tried to create a Database connections in Designer 2007. 1), Use custom connection string; 2), Select Microsoft .NET Framework Data Provider for Oracle as the Provider Name; 3) Post the below as the Connection String: Password=<passwd>;User [...]

How to pass InfoPath form fields to SharePoint workflow but hide from Document Library item properties

WebGuru — Mon, 08 Mar 2010 22:11:40 +0000

Challenge: Create a form in InfoPath 2007 and implement a SharePoint Workflow to it for approval processes. In each step, a Status field in the InfoPat form should be updated automatically according to the change of workflow task status. So a different view in the InfoPath can be opened based on the Status field in [...]

Be aware: New Law in GA which can cause you $500 fine

WebGuru — Thu, 04 Mar 2010 04:00:21 +0000

A few days ago, got an email forwarded by co-worker regarding a new law effective in Georgia. Its name is Move-Over Law, which says drivers must move-over for emergency vehicles stopped on the side of the highway. The law is meant to keep officers AND traffic violators safe from crashes with passing cars. Here is [...]

How to fix non working “Edit this task” button of SharePoint workflow notice in Outlook and InfoPath 2007

WebGuru — Mon, 01 Mar 2010 14:13:45 +0000

Challenge: Set up a workflow for the InfoPath form in the MOSS 2007 and the workflow worked fine. The approval notice had been sent to the next person’s mailbox, but the Edit this task button on the toolbar of Outlook 2007 did not work. When you click it, nothing happened. You can click the infopath [...]

How to remove XP Internet Security 2010 malware rogues

WebGuru — Thu, 25 Feb 2010 16:56:49 +0000

Today got a call from a friend and was told that her computer might be virus infection since a new anti-virus software always prompted up and warned her everything. And this new anti-virus is named “XP Internet Security 2010″, but she said she never installed it before. Now she was scared since too many viruses [...]