No releases available for package pear.PHPUnit.de (on Windows)

No releases available for package pear.PHPUnit.de/PHPUnit

You probably get this error when you try to run the following command:

“pear install phpunit/PHPUnit”

If you are getting this error you will need to run the following commands:

pear update-channels

then

pear clear-cache

pear install phpunit/PHPUnit

This is one of the zillion errors you will be getting when trying to install PHPUnit on Windows. Frankly I am wondering if these software are ready for Microsoft Windows.

go-pear.phar does not have a signature (Installing PEAR on Zend Server CE Windows)

1. Navigate to your ZendServer bin/PEAR folder and run the following command:

php -d phar.require_hash=0 go-pear.phar

2.  Select the default options unless you want to change them

3. For Step #12 you want to make sure that you enter the path to your php.exe

(Note:  For some reason manually entering the path to my php.exe did not work, however if i enter “12” it prompts me to navigate to the folder that contains the php.exe and it works that way).

4. That is it.

Increase Photoshop History States (Step Backward)

How many times did the “Step Backward” in Photoshop fails you? You wish you could increase its size so you can go back in time. Well i have some good news for ya;
Photoshop does allow you to increase the history states & cache Size and here are the steps:

Go to Edit -> Preference -> General

Then Click on Performance

then Adjust your History States

And Voila

You can’t specify target table ‘XXX’ for update in FROM clause – MySQL

If you try to run this query below in MySQL

UPDATE XXX
SET count = count + 5000 
WHERE id IN ( SELECT id FROM XXX WHERE id > 2 )  ;

You will get this error message:
“You can’t specify target table ‘XXX’ for update in FROM clause – MySQL …”

MySQL does have an unorthodox way to handle this type of request:

UPDATE XXX
SET count = count +  5000
WHERE id  IN 
(
	SELECT id FROM 
	(
	SELECT id FROM XXX ORDER BY id DESC LIMIT 20 
	) 
	AS Temp_Tbl
)