Dev {Tricks}

You are here: Home / Archives for Server and Hosting / Web Control Panel / WHM

by

MySQL: Error Code: 1118

  • #1118 – Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.
  • Change limit for “Mysql Row size too large”
  • Row size too large 8126 Changing some columns
  • 1118 Row size too large

The error was: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

  • Solution
  • Login to phpMyAdmin with root previllege
  • Go to Variables
  • Then edit Innodb Strict Mode as follows 
    innodb_strict_mode = 0

 

by

How To Create a New User and Grant Permissions in MySQL

Access MariaDB Server

mysql -u root -p

Create new database

CREATE DATABASE bdhostidb;

Check whether the database created

SHOW DATABASES;




GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;

by

How to Clean the YUM Cache in CentOS

We need to clean the YUM cache to reclaim the disk space used or to fix some errors due to corrupted metadata files.

  • Clean all the cached packages from the enabled repository cache directory. 
    yum clean packages
  • Delete package headers. 
    yum clean headers
  • Delete metadata for each enabled repository. 
    yum clean metadata
  • Clean database cache

yum clean dbcache
  • Clean expire cache

yum clean expire-cache
  • Clean all cached information. 
    yum clean all

Done!

by

How to Install Zip/Unzip

How to Install Zip/Unzip in Debian/Ubuntu/Mint

apt install zip
apt install unzip

How to Install Zip/Unzip in RedHa/CentOS/Fedora

dnf install zip
dnf install unzip

How to Install Zip/Unzip in Arch/Manjaro Linux

pacman -S zip
pacman -S unzip

How to Install Zip/Unzip in OpenSUSE

zypper install zip
zypper install unzip

 

by

Missing vmail Folders .Sent, .Trash, .Drafts, .Junk, and Other

  • Missing Sent, Trash, Drafts, Junk, and Other Folders

Solution: Check whether the dot files are hidden. Make the dot files to show.

Horde

  • Click on the Folder Actions option.
  • Choose the Rebuild Folder List option.
  • Then choose the Show All Mailboxes option.

Roundcube

  • Go to Settings.
  • Click Folders.
  • Re-subscribe to each folder by clicking the check box.

Windows Mail

  • Click IMAP Folders.
  • In the Show/Hide IMAP Folders dialog box, select a folder.
  • Click Show.

Thunderbird

  • In the Folder pane, look for IMAP mail and right-click on it.
  • Go to Settings, click on Server Settings, then select Advanced.
  • Remove the checkmark on Show only Subscribed folders.
  • Click OK.

Microsoft Outlook Express

  • Under Folders on the left side of the screen, select the inbox for your email (NOT the one under Local Folders).
  • Click the Tools menu, then select IMAP Folders.
  • Select the desired folder(s).
  • Click Show.
  • Click OK.