Items filtered by date: December 2015

This is aholding page for links realted to the Sage Development Kit (SDK)

• Sage 50 Software Development Kit (SDK) Official Forum
• Sage Data Objects - a 3rd party website with some really useful SDO examples and code. It is no longer updated.

When you migrate someones email profile you move their PST file and setup their profile on the target machine. When you do this all the email and calendar items are moved but the email AutoComplete is not moved.

The email auto cache is where someone starts typing in an email and outlook auto fills the email or gives you a dropdown list. This cached list is stored in a NK2 file. This file needs to be migrated as well as the PST to maintain the drop down list.

If this list is not migrated the client can be left to use outlook normally and the list will populate over time and normal operation.

• How to migrate NK2 Auto complete cache “suggested contacts” from Microsoft Outlook
• How to import .nk2 files into Outlook 2010

Windows 7 comes with a great feature called HomeGroup that makes sharing between windows 7 machines very easy.

Unfortunately, HomeGroup feature is not compatible with Windows XP and Vista. In this guide, you’ll learn how to enable file sharing between Windows 7 and Windows XP.

• How to Enable File Sharing between Windows 7 and Windows XP

Other Solutions

• Make sure there is a matching username and password on both PCs
• Check for any 3rd Party firewalls. these are renowned for causing connection issues.

Links

• Getting Access is Denied when accessing Windows 7 share from Windows XP - not tried the registry entry in the second post
• How to Disable “HomeGroup” Feature in Windows 7?
• How To Disable or Enable the Homegroup Feature in Windows 7
• How to Enable File Sharing between Windows 7 and Windows XP
• Share a Printer from XP to Windows 7
• Share Files and Printers between Windows 7 and XP
• Sharing files and printers with different versions of Windows
• Windows XP cannot print to Windows 7 shared printer
• File Sharing - Between XP and W7 (and vice versa) - Windows 7 Help Forums
• windows 7 - How to access shared folder without giving username and password - Stack Overflow

Microsoft Outlook - (i have already done an article for this check)

• em Client (emClinet)
  - looks almost identical to microsoft outlook
  - It has a calender built in
  - it is limited to one email account though on the free version
  - Importing from outlook is very easy (simple wizard)
• Thunderbird
  - no inbuilt calendar, but you can add one on and import outlook calendar events
  - you can import from outlook
  - signatures is a bit flaky
  - completely free and updated often

These are some articles on other Outlook alternative

• 3 Best Free Alternatives To Microsoft Outlook
• FreeOutlookAlternatives.com - Helping you choose the best e-mail client

Microsoft Office

• Libre Office
• Open Office

Security Software

• Microsoft Security Essentials
• Comodo Firewall (you can either have antivirus or firewall installed not both)
• Comodo Antivirus
• Comodo Antispam (basic, uses local lists and passcodes only)
• Comodo Backup
• Rapport - get this from your bank (or natwest)
   
• AVG
• Panada Antivirus
• Avast

Other Softwares

• peazip - unzipping and zipping - it does everything
• xampp - local webserver
• RSSOwl
• RSS Bandit
• filezilla
• KeePass and last Pass - password amangers - check which is best

There are a few things to go through to help you understand MySQL collations before you will understand what collation you should use.

The difference between utf8_general_ci and utf8_unicode_ci

To know the difference between utf8_general_ci and utf8_unicode_ci we need to break down the collation's name.

1. UTF8 - this is the character set to be used. Computer using different languages reference characters with different ascii/binary references such as latin1. UTF8 is a character set which try to cover all characters in one set.
2. This question should be "What is the difference between general_ci and unicode_ci?"
   The difference is the algorithm MySQL uses to search (and interact i think) with the database. general_ci is less resource intensive but not as good as unicode_ci. Because of the power of modern webservers performance is no longer a concern so unicode should be used.

So this means that:

• utf8_general_ci collation uses the UTF8 character set with the general search algorithm with good performance and lower quality results
• utf8_unicode_ci collation uses the UTF8 character set with the unicode search algorithm with lower performance and better quality results

Where possible select utf8_unicode_ci (see notes below)

The difference between UTF8MB4 and UTF8

The correct implementation of all UTF8 characters requires 4 bytes per character but for some reason PHP/MySQL implemented UTF8 using only 3 Bytes and they called this UTF8. It has taken until recent times for servers to fully support this and CMS platforms to catch up, they now call this UTF8MB4 and it is fully backwards compatible with UTF8.

Using UTF8MB4 allows you to use all UTF8 characters including emojis and some international characters and store these in the MySQL database.

So this means that:

• utf8_unicode_ci collation uses the UTF8 character set with a 3 byte storage limiting the UTF8 characters that can be used
• utf8mb4_unicode_ci collation uses the full UTF8MB4 with a 4 byte character allowing the full use of all UTF8 characters
• UTF8 Tables and Databases can be upgraded to UTF8MB with no data loss. The reverse will cause data loss.
• Better international language support because more characters can be used in one collation
• Allows the use of native emoji characters
• UTF8 and UT8MB4 are not language specific

Where are collations used?

We must know that there are several places to use a collation and they are all set seperately.

1. Server Connection Collation - There connection between PHP and MySQL daemon
2. Default Collation - The databases has a default collation
   
3. Table Collation - Tables in the database can have a specific collation set which does not have to be the default collation.

Have you heard the expression "A chain is only as storng as its weakest link", the journey of data from PHP to a MySQL database is not different. So what do I mean? As you can see above there are several places where you can set collations, each of these collations need to be able to support the data you are sending it.

When a UT8MB4 character is sent to the database if any of the steps/collations in the chain are set to UTF8 only, the the character will be trunctacted (the last byte cut off) and a different character will be stored. If you send a UTF8 character down a chain that all supports UTF8MB4 then no data loss will occur because UTF8MB4 is backawards compatible with UTF8.

What Collation should I use?

So now if we take what we have learned and summarise here:

• unicode_ci give better results that general_ci and performance is no longer an issue
• UTF8 Databases and Tables can be upgraded to UTF8MB4 without data loss
• UTF8MB4 is backwards compatible with UTF8
• UTF8MB4 is a correct implementation of UTF8 and allows use of all UTF8 characters
• Most webservers now fully support UTF8MB4
• Most popular CMS are now pushing UTF8MB4
• UTF8MB4 has better international language and allows you to use emoji
• the whole data chain (PHP --> MySQL Database) needs to support the collation you are using

Which means you should ideally use the following:

1. Server Connection Collation - utf8mb4_unicode_ci
2. Default Collation - utf8mb4_unicode_ci
3. Table Collation- utf8mb4_unicode_ci (when needed)

In Summary

You will be using the UTF8MB4 collation for the whole chain which fully supports all UTF8 characters (3 and 4 byte) and is backwards compatible with UTF8 (3 byte) allowing all languages to be used. The unicode_ci search algorithm is used for better results as the performance hit is not longer noticable.

Links

• UTF-8: General? Bin? Unicode?
• What's the difference between utf8_general_ci and utf8_unicode_ci?
• Difference between MySQL collation “utf-8-general-ci” and “utf-8-unicode-ci”?
• Difference between utf8 general ci and utf8 bin

Does not turn on or do anything when power button is pressed

• this is most likely the power regulator has been blown, checked with multimeter to see if the power gets past the FETs and regualtor as per tutorial
• see if the laptop powers on with the battery and/or the mains
• clear bios sometimes works

when power button is pressed the fan powers up and lights turn on. they either follow a pattern of a laptop reseting or they stay on as you would expect normally and the hdd powers up but nothing on screen either internal or external

• this is most likely a faulty graphics chip and the solution is to reflow. sometimes it can be the chipset chip but this is rare unless there is not dedicated graphics chip in which case it is the chipset chip
• this can also be caused by a dodgy bios, clear bios

I can't create an empty text document. I right-clicked on my desktop, pointed on New and then I can't see the 'New Text Document' option. I was able to make empty text documents a few weeks ago, but now I can't because the option is lost from the menu. I guess some software modified it.

This fault can be caused by different routes

The following links are from Windows 7 - 'New Text Document' missing?

Solution 1

Search on the thread for 'How repair a missing New Text Document in the Context Menu for Windows 7'

this is a post which basically gets you to install a registry file to restore the damaged section of the registry

Solution 2

I had the same problem with "Text Document" missing from the New menu. In my case, the Default value in HKEY_CLASSES_ROOT\.txt had been changed. All I had to do to fix the problem was to change the Default value back to txtfile

I know in XP that changing the file associations under HKEY_CURRENT_USER was optional, but I guess in Windows 7 it's mandatory.

The following link is from 'Windows 7 | Context Menu | new text file Missing?'

Solution 3

There is a registry file on this thread which might be the same as from seven forums

Related Articles

• How to Add Shortcuts to the Windows 7 Context Menu with Icons
• How to Remove and Restore the Default Windows 7 "New" Context Menu Items
• How to Add / Remove Items from “New” in Windows Context Menu?

I tried to install SP1 on a customer's Vista laptop today. It took about 2 hours then eventually a black screen appeared and it started working through 95,583 files until it reached 3790/95583 and stuck, where it remains now.

The white writing is as follows..

!! (4) !! 3790/95583 (wdf01000.sys)

The screen flickers as if trying to move on but can't get beyond this point.

I have tried restarting using last known good config but the same thing happens.

I have also tried the repair option of system restore but that ran for about 4 hours without anything happening.

Is there anything I can try or would it be easier to backup and reinstall from scratch?

I have fixed the problem by simply copying another copy of wdf01000.sys from the winxs folder to c:\windows\system32\drivers and the service pack installation carried on normally after that and Windows booted with everything working..

If you have access to phpMyAdmin, simply log in to the WHMCS database and run one the following commands using the SQL tab.

You need to replace www.yourdomain.com/whmcs/ with the correct URL to your installation, including trailing slash. You should then be able to access WHMCS again.

This is is to change url and disable SSL

UPDATE `tblconfiguration` SET value='http://www.yourdomain.com/whmcs/' WHERE setting='SystemURL';
UPDATE `tblconfiguration` SET value='' WHERE setting='SystemSSLURL';

This code changes both the nomal url and the SSL url

UPDATE `tblconfiguration` SET value='http://www.yourdomain.com/whmcs/' WHERE setting='SystemURL';
UPDATE `tblconfiguration` SET value='https://www.yourdomain.com/whmcs/' WHERE setting='SystemSSLURL'; 

Moving from Microsoft Outlook to Mozilla Thunderbird can be a little bit tricky. You have to migrate the calendar, address book and messages separately. These obviously have to be exported from outlook and then imported to Thunderbird.

Messages

• Moving messages from Thunderbird to Outlook Express and Outlook - An Old method
• Outlook Alternatives: Moving from Outlook to Thunderbird
• From Outlook to Thunderbird and Back Again
• Switching to Thunderbird - includes migrating messages

Address Book

• Thunderbird - Importing Outlook Emails and Addressbooks

Calendar

• Calendar Project - Home of Lightning and Sunbird®
• Exporting Outlook 2010 Calendar
• How do I import Outlook calendar items into Thunderbird calendar?
• Importing Calendar From Microsoft Outlook To Mozilla Lightning
• Mozilla Sunbird: Import Your Outlook Calendar Appointments

Other

• How to Export and Archive Your Emails in Thunderbird
• MozBackup - Backup tool for Firefox and Thunderbird
• Mozilla Thunderbird: Collection of Tips, Tools and Tutorials
• mozillaZine Forums - Official Sunbird and Sunshine Forum
• Thunderbird Signatures
• mozillaZine Signatures - Thunderbird