If you are getting this error, chances are your PHP install is missing the zip extension.
A couple lines below the error message you should see the following sentence.

The following file extensions are supported: tar tgz gz bz2.

If the keyword “zip” is missing from that list then you are indeed missing this component.

Here are the steps to install it.

pecl install zip

Add this to your php.ini

extension=zip.so

Restart your webserver

When you upload an image to the content of a Drupal 7 site. Drupal 7 adds the full path of the image to the actual content. If you are using Drupal 7 check the following table:
field_data_body
inspect the body_value column and you will notice that full relative path of the image within the body of the Drupal content.

That goes without saying that any images/assets added to the content will be broken, if you move your site from one directory to another or from a subdirectory to the root of the site.

Here is the mysql fix:
Run the following query to replace the path within the body_value column:

Example 1

Moving from subdirectory “/drupal7_test/” to “/”

update field_data_body set body_value=REPLACE(body_value, '/drupal7_test', '') where 1=1;

Example 2

Moving from subdirectory “/drupal7_test/” to “/drupal7_live/”

update field_data_body set body_value=REPLACE(body_value, '/drupal7_test', '/drupal7_live') where 1=1;