BATCH BULK MASS DELETE REMOVE UNUSED EMPTY TAGS MYSQL PHPMYADMIN WORDPRESS

Run this in your phpMyadmin or anywhere you can execute sql

DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );

This will effectively remove them from everywhere the admin can see but they still exist in the relationship table

DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);

Remember you need to change the ‘wp_’ to your prefix. Sorry no plugin, perhaps when I have time.

SOLUTION BY portlandparanormal

HOW TO INSTALL GD LIBRARY PHP 5 UBUNTU SSH PUTTY

Here is the steps for Ubuntu Server 8.04.1 and PHP5. Like Djamu said it will install a GD pre-compiled working version. It is a complete bundled (forked) GD libraries:

1. If not already done removing your current GD package and its configurations.
sudo apt-get --purge remove

2. Adding 2 lines to your file /etc/apt/sources.lst

deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all</DIV>

3. Updating your current apt-get list
apt-get update

4. Installing working GD package.
apt-get install php5-gd

It will complain about non-authenticated sources, just ignore, it will also update some additional php libs.

When prompt select keep_current modified php.ini

5. Restarting Apache
/etc/init.d/apache2 restart

Enjoy

Google Chrome Windows 7 64 flash video problem how to solution

1 Download the Flash player xpi for Windows.

2 Add a .zip extension to the file. It should now be: flashplayer-win.xpi.zip or use 7zip for direct extract

3 Extract the contents and copy two files “flashplayer.xpt” and “NPSWF32.dll” 

over to

4 C:\Users\User\AppData\Local\Google\Chrome\Application\Plugins

(if plugins folder doesn’t exit create manually)

 C:\Documents and Settings\user\Local Settings\Application Data\Google\Chrome\Application\Plugins in XP

making sure to change ‘user’ to your Windows login name.

You can avoid having to unhide hidden files in Windows Explorer simply by copying and pasting the directory path provided above into the path bar.

5 Restart browser

you should be done now

BEST DEFAULT FLASH VIDEO SIZES FOR PLAYER LIST TABLE

Table 1 – 4:3 Aspect Ratio Sizes

Best (16)	Better (8)	Good (4)
640 x 480	608 x 456	624 x 468
576 x 432	544 x 408	592 x 444
512 x 384	480 x 360	560 x 420
448 x 336	416 x 312	528 x 396
384 x 288	352 x 264	496 x 372
320 x 240	288 x 216	464 x 348
256 x 192	224 x 168	432 x 324
192 x 144	160 x 120	400 x 300
128 x 96		368 x 276
		336 x 252
		304 x 228
		272 x 204
		240 x 180
		208 x 156
		176 x 132
		144 x 108
		112 x 84

Table 2 – 16:9 Aspect Ratio Sizes

Best (16)	Better (8)	Good (4)
1280 x 720	1152 x 648	1216 x 684
1024 x 576	896 x 504	1088 x 612
768 x 432	640 x 360	960 x 540
512 x 288	384 x 216	832 x 468
256 x 144	128 x 72	704 x 396
		576 x 324
		448 x 252
		320 x 180
		192 x 108