Category: Web-Hosting

Categories
Web-Hosting Website www

Disadvantages of WordPress as a CMS

Disadvantages of WordPress as a CMS – Really ?

The most common disadvantage mentioned by users who opt for Joomla or another CMS, is the inability to change the source code to really customize it, without causing multiple problems with configuration. Because WordPress was not originally intended to be a general CMS, the source code is not nearly as flexible. It cannot produce a truly customized site via custom source code changes. Users argue that plug-in additions enable a great deal of features with customized options, but plug-ins do not provide nearly the application richness and multi-level functionality that a flexible CMS source code does.

Along the same line, adding too many plug-ins on a WP CMS causes problems. More than a few dozen plug-ins for those that attempt to create a customized experience, are much more likely to slow down the system, cause errors and bugs, and overwhelm the WP system.

Essentially, the appeal of WordPress CMS is its user-friendly, SEO-friendly simplicity. When users attempt to bury it underneath 50 different plug-ins just to obtain a certain level of functionality and application depth, this is when WordPress ceases to be the best option. Much like the simpler shopping cart platform and plug-ins that best serve small to medium business websites, the same applies to WordPress. If a business or service website needs multi-level usability – news feeds, forums, community areas, social networking, or portals, such as those often used by corporate or education sites – then WordPress is not the best choice, because it cannot support these complexities.

Categories
MySQL Setup Web-Hosting

WHMCS database error – Mix of collations utf8_unicode_ci

Mix of collations utf8_unicode_ci

Oops!
Something went wrong and we couldn’t process your request.
Please go back to the previous page and try again.
If the problem persists, please contact us.

Back to Homepage

For additional assistance, please reference the WHMCS TroubleShooting Guide »

PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation ‘like’ in /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php:331
Stack trace:
#0 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(331): PDO->prepare(‘select * from `…’)
#1 /home/xxx/public_html/whmcs/vendor/illuminate/database/Connection.php(664): Illuminate\Database\Connection->Illuminate\Database\{closure}(‘select * from `…’, Array)

Today encountered this error after upgrading MySQL and WHMCS as well. As this is the error related to collations, you will get suggestions to update tables and all ! Developer’s job !
However, a simple temporary fix to this is update your configuration file by commenting $mysql_charset = ‘utf8’; line.

You are done !

Categories
cPanel Security Setup Web-Hosting WHM

Remove ClamAV in cPanel WHM?

In few steps you will be able to disable or remove ClamAV virus scanner.
Login to you WHM.
Go to Home »Service Configuration »Service Manager.
Look for ClamAV Scanner.
Deselect a service to disable it.
Save and you are Done.

Categories
Scripts SSH www

Linux replace command all files with sed shell command

Replace word in all files with sed via linux shell command

To replace string design/nashik to designing/india on the same file textNashik.html
Use the following linux command with the syntax.
sed -i s:design/nashik:designing/india:g textNashik.html

Another Example:
sed -i s:twitter.com/webservices:twitter.com/dnswspl:g home/*.html

Replacing phrase in all files including directories and subdirectories using sed and find

find . -type f -exec sed -i ‘s:ecommerce.html:ecommerce-shopping-cart.html:g’ *.html {} \;

NOTE: ‘:’ used as a substitue for ‘/’ as / is used in search and replace.

Related: Linux Command, Shell Command, Sed Command, Replace Text, Linux Replace

Categories
cPanel PHP Scripts SSH Web-Hosting

Execute PHP script from cron or command-line

Execute PHP script from cron or command-line

One of the method for running PHP scripts from a cron job is run the script using php from the crontab. You will need to call the php script from your crontab as given below.
To execute somescript.php every 1 hour you will need to edit and add below given line in your crontab file:
00 * * * * /usr/local/bin/php /home/someuser/somescript.php

If you are looking for command-line interpreter, then it can be done with the following command. It shows how to run a script using the PHP command-line interpreter:

/usr/local/bin/php -q /home/someuser/public_html/somescript.php
The -q option is for quiet mode, to prevent headers being displayed.

Make a note of code in your PHP script, it may only run correctly if called from a mentioned path. For example, if the script uses relative paths to include files, it will only run if it is called from the specified directory. The following command shows how to run a PHP script from a specific path:

cd /home/username/public_html/; /usr/local/bin/php -q script.php

Related: Dedicated Server, Virtual Server, Web Server Hosting