How to Fix SQL CRC Error?

 

 

Can be check through the following basic commands:

Step 1: The root cause of the CRC error is an I/O subsystem issue, it is necessory to fix the storage issues by run the CHKDSK command to fix the cyclic redundancy check error in SQL.

Run the CHKDSK utility on the disk where database stored with the /F parameter. Below is a screenshot of the command to check and fix the F: drive:

Step 2: A complete disk de-fragmentation is recommended after the “chkdsk” is completed with a successful repair of any errors.

These are the basic disk repair commands,

hope your issue will be resolved.

Cheer...!!!

Read More

install php imagick php7.4

 

 How to install php imagick on php7.4?

 

 First you check, is imagick is install on the server or not, have few method to check it.

1. using command line, (connect the server using ssh), after successful connection, type command:

# php -m|grep imagick

2. using web, for this create a file info.php and paste this code to check which php extensions are installed.

vi info.php and paste this code there. 

<?php
phpinfo( );
?>

 save this file, then browse it. like https://your-website.com/info.php

and search imagick, you will show look like this :

if not installed, then very simple to install using this command.

 # yum install php74-php-pecl-imagick

 after that restart apache

# apachectl restart

it works...

If want to check php version installed on your server, Check using this command:

# sudo  yum  list  installed  | grep  php

You will see the list of php versions, installed on your server/pc.

 

Cheers!..

Read More