WordPress enable force SSL over wp-config.php

You will need to edit domain name using the following and append it into your wp-config.php file

define('WP_SITEURL', 'https://www.example.com');
define('WP_HOME', 'https://www.example.com');
define('FORCE_SSL_ADMIN', true);
define('FORCE_SSL_LOGIN', true);
if( isset($_SERVER['HTTP_CF_VISITOR']) && strpos($_SERVER['HTTP_CF_VISITOR'], 'https') )
$_SERVER['HTTPS']='on';
Read the rest

WordPress wp-config.php settings

Allow uploading not registered files

define('ALLOW_UNFILTERED_UPLOADS', true);

Disable All Updates

define( 'AUTOMATIC_UPDATER_DISABLED', true );

To enable automatic updates

define( 'WP_AUTO_UPDATE_CORE', true );

WP_SITEURL

define( 'WP_SITEURL', 'http://example.com/wordpress' );

WP_HOME

define( 'WP_HOME', 'http://example.com/wordpress' );

Disable the cron entirely by setting DISABLE_WP_CRON to true.Read the rest

Move out WordPress installation from public_html/ folder

cd your public_html/ and create OLD_WP/ folder

mkdir OLD_WP/

This will move WordPress' files/folders into the OLD_WP/ folder

mv wp-* index.php .htaccess robots.txt *.sql license.txt readme.html sitemap.xml xmlrpc.php error_log cgi-bin -t OLD_WP/

Then move it to level up

mv OLD_WP/ ../
Read the rest

How to find WordPress admin users over mysql command line

How to show WordPress admin user using mysql command prompt

select * from wp_users u INNER JOIN wp_usermeta m ON m.user_id = u.ID where meta_value like '%administrator%';

or

SELECT u.ID, u.user_login, u.user_nicename, u.user_email FROM wp_users u INNER JOIN wp_usermeta m ON m.user_id
Read the rest

WordPress how to disable default wp-cron.php behavior

By default WordPress runs its wp-cron.php too frequiently, so to change it:

Update wp-config.php with the following line:

define('DISABLE_WP_CRON', true);

Setup manual cron job for wp-cron.php

Enter user’s crontab

crontab -lu USERNAME

And append command to run cron every 12 hours

0 */12 * * * cd /home/USERNAME/public_html; php -q wp-cron.php
Read the rest

How to show a real multisite WordPress super admin users via MySQL command line

For multisite WordPress version run the following commands:

mysql
use database_name;
SELECT * FROM wp_sitemeta where meta_key='site_admins';

This will also allow you to know which users can access plugins for management… Read the rest

How to fix “PayPal Instant Payment Notification (IPN) messages”

Your got message with the following text:

###

Please check your server that handles PayPal Instant Payment Notification (IPN) messages. Messages sent to the following URL(s) are not being received:
 

http://yourdomain.com/url


If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf.… Read the rest

How to recreate WordPress table

The error's output like the following:

Error    : Table 'XXXX_wrdp1.wp_comments' doesn't exist

mysql DATABASE_NAME;
DROP TABLE IF EXISTS wp_comments;
CREATE TABLE wp_comments (
comment_ID bigint(20) unsigned NOT NULL auto_increment,
comment_post_ID int(11) NOT NULL default '0',
comment_author tinytext NOT NULL,
comment_author_email varchar(100) NOT NULL default '',
comment_author_url varchar(200) NOT NULL default '',
comment_author_IP varchar(100) NOT NULL default '',
comment_date datetime NOT NULL default '0000-00-00 00:00:00',
comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00',
comment_content text NOT NULL,
comment_karma int(11) NOT NULL default '0',
comment_approved varchar(20) NOT NULL default '1',
comment_agent varchar(255) NOT NULL default '',
comment_type varchar(20) NOT NULL default '',
comment_parent bigint(20) NOT NULL default '0',
user_id bigint(20) NOT NULL default '0',
PRIMARY KEY (comment_ID),
KEY comment_approved (comment_approved),
KEY comment_post_ID (comment_post_ID),
KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
KEY comment_date_gmt (comment_date_gmt)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

You may know about WordPress table's structure here:

http://codex.wordpress.org/Database_Description#Table:_wp_comments… Read the rest