Nice way to quickly cleanout Gallery2 spam comments.
>
mysql> delete ce, e, co from g2_ChildEntity ce, g2_Entity e, g2_Comment co where ce.g_id=e.g_id and e.g_id=co.g_id and e.g_entityType=’GalleryComment’ and (co.g_comment like ‘%[url=http://%’)
-> ;
Query OK, 930651 rows affected (1 min 5.68 sec)
mysql>
Upgraded to the latest wordpress. Nice to a simple, and working upgrade for once.
Nice php site for rpms (under rhel or centos):
http://phprpms.sourceforge.net/mssql
Duing the server migration, I needed to get php-mssql working. Once again, cake under CentOS.
Grab this rpm:
Install freetds from yum, and you are ready to go.
Redhat Enterprise Linux 4 sucks. At least the x86_64 version. php gives gd and mysql errors. up2date is as miserable as getting kicked in the groin for an hour straight.
Grab these:
[root@wintermute upgrade]# ls -l total 824 -r--r--r-- 1 root root 20091 Jul 26 20:33 centos-release-4-3.2.x86_64.rpm -r--r--r-- 1 root root 3592 Jul 26 20:33 centos-yumconf-4-4.5.noarch.rpm -r--r--r-- 1 root root 81569 Jul 26 20:33 python-elementtree-1.2.6-4.x86_64.rpm -r--r--r-- 1 root root 38989 Jul 26 20:34 python-sqlite-1.1.6-1.x86_64.rpm -r--r--r-- 1 root root 93760 Jul 26 20:34 python-urlgrabber-2.9.6-2.noarch.rpm -r--r--r-- 1 root root 189951 Jul 26 20:34 sqlite-3.2.2-1.x86_64.rpm -r--r--r-- 1 root root 392645 Jul 26 20:34 yum-2.4.2-2.centos4.noarch.rpm [root@wintermute upgrade]#
rpm –import RPM-GPG-KEY-centos4
rpm -e -–nodeps redhat-release
rpm -Uvh *.rpm
then
yum upgrade
Works beautifully. yum is the far superior tool. Courtesy to Fixlinux for the instructions
