DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = ‘revision’
Delete WordPress old Revisions using SQL Query Read More »
This is the dirty and fast way to convert XML file to Array. $array = json_decode(json_encode((array)simplexml_load_string($xml)),1);
Quick way to convert XML to Array in PHP Read More »
The varnish load so much of different version in my wordpress, so I would like to remove all the ver from the source. 53.76 RxURL /wp-content/themes/responsivepro/core/js/responsive-modernizr.js?ver=2.6.1 51.22 RxURL /wp-content/themes/responsivepro/core/js/responsive-scripts.js?ver=1.2.4 16.12 RxURL /wp-includes/js/jquery/jquery.js?ver=1.10.2 15.70 RxURL /wp-includes/js/jquery/jquery-migrate.min.js?ver=1.2.1 15.59 RxURL /wp-content/themes/responsivepro/core/css/style.css?ver=1.9.3.4 15.59 RxURL /wp-content/themes/responsivepro/pro/lib/css/style.css?ver=1.0 15.58 RxURL /wp-content/plugins/RadControl/js/adclk.js?ver=2013-06-21 15.56 RxURL /wp-content/themes/responsivepro/style.css?ver=1.9.3.4 15.56 RxURL /wp-content/plugins/jetpack/modules/widgets/wid Solution to solve Add this
Remove ver version number for JS and CSS in WordPress Read More »
PHP message: PHP Fatal error: Class ‘WP_List_Table’ not found in You may see this error in WordPress while disabled some plugin, because they plugin is need to use the WP_List_Table class from the WordPress. Solving the problem Add this to any of your activated plugin the it will load the class if it is not
PHP message: PHP Fatal error: Class ‘WP_List_Table’ not found in Read More »
SSL read: error:00000000:lib(0):func(0):reason(0), errno 0 Error in WordPress, because of the SSL You may try to upgrade the SSL of your server if not, you can disable the HTTPS in the config file of your wp-config.php Disable HTTPS in WordPress Config add line to your wordpress wp-config.php [php] define( ‘JETPACK_CLIENT__HTTPS’, ‘NEVER’ ); [/php]
SSL read: error:00000000:lib(0):func(0):reason(0), errno 0 Read More »
Error in CentOS configure: error: Missing required libcurl dev >= 7.18.2 [root@ns4007603 cgminer]# yum install libcurl Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile base: centos.mirror.nexicom.net epel: ftp.osuosl.org extras: centos.mirror.nexicom.net updates: centos.mirror.nexicom.net Setting up Install Process Package libcurl-7.19.7-37.el6_4.x86_64 already installed and latest version Nothing to do You have the newer version of libcurl, but
configure: error: Missing required libcurl dev >= 7.18.2 Read More »
Error in CentOS [code lang="bash"] configure.ac:94: error: possibly undefined macro: AC_DEFINE If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. configure.ac:125: error: possibly undefined macro: AC_MSG_ERROR autoreconf: /usr/bin/autoconf failed with exit status: 1 Configuring… configure: error: cannot find install-sh or install.sh in "." "./.." "./../.." [/code] Solved [code lang="bash"] yum
configure.ac:94: error: possibly undefined macro: AC_DEFINE Read More »
Error in CentOS [root@ns4007603 cgminer]# ./autogen.sh configure.ac:39: error: possibly undefined macro: AC_PROG_LIBTOOL If this token and others are legitimate, please use m4_pattern_allow. See the Autoconf documentation. autoreconf: /usr/bin/autoconf failed with exit status: 1 Configuring… ./autogen.sh: line 10: /root/cgminer/configure: No such file or directory Solve yum install libtool
configure.ac:39: error: possibly undefined macro: AC_PROG_LIBTOOL Read More »
Error: org.macports.fetch for port sqlite3 returned: fetch failed Please see the log file for port sqlite3 for details: /opt/local/var/macports/logs/_opt_local_var_macports_sources_rsync.macports.org_release_tarballs_ports_databases_sqlite3/sqlite3/main.log Error: Unable to upgrade port: 1 To report a bug, follow the instructions in the guide: http://guide.macports.org/#project.tickets Solve port -v fetch caml-sqlite3
Error: org.macports.fetch for port sqlite3 returned: fetch failed Read More »
sh-3.2# port selfupdate —> Updating MacPorts base sources using rsync MacPorts base version 2.1.3 installed, MacPorts base version 2.2.1 downloaded. —> Updating the ports tree —> MacPorts base is outdated, installing new version 2.2.1 Installing new MacPorts release in /opt/local as root:admin; permissions 0755; Tcl-Package in /Library/Tcl Error: /opt/local/bin/port: port selfupdate failed: Error installing new
