How to change database encoding

Sometimes when you transfer sites from one hosting to another, or when you install a site through your hosting interface (or when you install it via FTP) you can have encoding conflicts. And to sort this problem out you may need to change encoding in some tables in your database. There are a lot of very complicated and time consuming methods but what about changing database encoding easily?

There is one solution for changing the encoding for all database tables at once. The script is written by a web development company called Phoca and you can download the script and read step by step procedure here: How to change collation in database.

If you enjoyed this post, make sure you subscribe to my RSS feed!

A free remote PHP helpdesk.

Loads of people who run online business understand that is is obligatory to have a remote help desk in order to sort their customers’ questions and problems quick and efficiently.

The owners of various on-line businesses, caring about customer support issues and effective business conducting, businessmen who take care about customer support improvement, work amount reduction and money/time saving are sure to appreciate PHP Help desk Software called HECK. This software will help to structure customer support tickets, based on departments and urgency criteria, reduce the support request amount due to inserted knowledge base and save time and money due to the software security and usage simplicity.
Just to set this software advantages. User can send new support tickets, annex files, get in-depth information from clients with customer fields’ help, fight spam, offer the customers to use related knowledge base article before submitting the support ticket, see and assess customer support answers, notify about customer support personnel via e-mail, use options of knowledge base display and search, using the customer interface. Knowledge base provides big amount of information, categories and sub categories, user-friendly search engine, the option to post attachments to articles, to see the amount of views, the option to display recently posted and the most popular articles, the possibilities of articles assessment and many other functions. Web site admins obtain such options as: unlimited amount of accounts, the possibility of access limitation for certain personnel, support tickets search, tickets’ transfer to designated personnel, knowledge base structuring based on categories and articles, of personnel accounts control and replies samples, support desk alignments, profiles and signatures changes, support tickets automated close and lot of others. The work with software is alleged by the presence of video lessons describing how this software works, so future customers should have no problems with its quick implementation into their activity.
Using such software the owners of on-line businesses can increase the profitability of their activities, set their business to new level corresponding modern needs.

Apart from that this helpdesk is absolutely free!
Enjoy! :)

If you enjoyed this post, make sure you subscribe to my RSS feed!

How to add fields to Joomla registration form and translate them to your language

Today I needed to add field to Joomla registration form and translate them to Russian language.  The video gives you step-by-step instruction how do add fields.  However, there is one important thing to remember: if you have your own Joomla theme installed, you have to change registration form (default.php) in another folder.  The form then is in /templates/YOURTHEME/html/com_user/register/.

After the fields are added, you need to translate them to your language.  The file with translation lies in language/YOURLANGUAGE/com_user.ini. You have to add the names of the fields to the file. Please note, that the name should be written in capitals. For example  NAME=translation to your language.

Enjoy! :)

If you enjoyed this post, make sure you subscribe to my RSS feed!

Virtuemart. The “Buy” button doesn’t work.

Recently I’ve come across the following problem: there is one occasion when the “Buy” button doesn’t work in the shops made on Joomla + Virtuemart. At the beginning I thought that this is a problem with inactive cookies but I was wrong.

The problem is connected to the prefix “www” and settings in the admin panel. If the domain in admin panel is www.yourdomain.com, then if a user enters your domain without “www” he/she is not able to buy anything as the “Buy” button doesn’t work. And vice versa.

How to solve this problem?

There are two ways: via .htaccess file and via VirtueMart.cfg.php.

The second way is easier.

Find a file  VirtueMart.cfg.php (administrator/components/com_virtuemart/virtuemart.cfg.php)

Find a code:

define( ‘URL’, “www.site.ru/” );
define( ‘SECUREURL’, “www.site.ru/” );

and choose it to:

define( ‘URL’, $mosConfig_live_site.$app );
define( ‘SECUREURL’, $mosConfig_live_site.$app );

Everything should be sorted now.

If you enjoyed this post, make sure you subscribe to my RSS feed!

Optimizing your website.

If you don’t have a website, then you are not in business – said one Russian multimillionaire Oleg Tinkov. I can also ad that if you are not on Google, you are not in the Internet. So how to make your web-site visible for the public? How to be number 1 on Google for your niche? There is a special technique called search engine optimization (or SEO) which was developed to achieve a high ranking in search engines results.

If you have a spare time, you may want to learn basic tricks for optimizing your web page. For example link building and text optimization. But from my point of view it is better to leave it for professionals.

There are dozens of people who offer help in search engine optimization, but how to understand who is really good in that?

One of the very successful companies that work on this market is a company called “First In Search”. They are based in the USA. If you check their web-site you will see that they were awarded twice for best achieved results in pay per click management and search engine optimization. They are also SEO certified company which proves that they know what they are doing.

By the way, they also have some useful SEO tips published on their website. Have a look here: search engine optimization phoenix.

If you enjoyed this post, make sure you subscribe to my RSS feed!

FTP error: 501 Please CLNT first

FTP error 501 Please CLNT first can occur if you use Firefox FTP console (FireFTP). As far as I understood, this happens with Windows based servers. If someone has uploaded a new files using the same login and pass, you won’t be able to see them. All you have to do in order to refresh FTP is to click “Connect”, click “OK” on the pop up error window and then click “Abort” near “Disconnect” button.  This should help.

If you enjoyed this post, make sure you subscribe to my RSS feed!