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.
Welp, goodbye Movable type… Hello wordpress. A couple interesting issues with imports to note, the stock mt-import works like crap, however, the rss import saved it somewhat. I’m going to start the migration of the old content over shortly. So if you were looking for the old content, sit tight, or email me if you need something soon.
Welp, slowly but surely I am building up my studio. Check out the pics in the DAW Gallery. Basic config now is: Cubase SX Various VST Instruments POD XT (although I have used my vetta) Parker Nitefly 77' Strat My…
