Mysql - OnlineSupport4u

Mysql

A DNS entry for “rexxxxxxl.com” already exists

By Prasad Naik

January 29, 2025

The User had removed his addon domain from cPanel. However while adding back there was wrror coming up “A DNS entry for “rexxxxxxl.com” already exists” T The issue is likely due to leftover DNS configurations from removed domains. Running the /scripts/cleandns script should correct the issue. Running command /scripts/cleandns fixed the issue 🙂

Mysql

Disk not visible while installing windows OS ?

By Prasad Naik

December 4, 2024

For those using virtualizor on Virtualizor software If you face issues while installing windows and dont see disk Go to edit VPS Select Disk Select Disk driver set to none Which you can see in below image and reboot VPS Disk will be visible

Mysql

WHM logging out repetedly

By Prasad Naik

December 3, 2024

If you are getting logged out repetedly from WHM Go to Home /Server Configuration /Tweak Settings From there in security section check on Cookie IP validation By defaut its set to strict. Enable loose option and save. This should fix this issue

Mysql

ERROR 1292 (22007): Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘date’ at row 87103

By Prasad Naik

November 25, 2024

We got error while altering a table in mysql The issue was due to strict mode enabled in Mysql You can check if mysql strict mode is checked using below command # mysql mysql> SELECT @@sql_mode; If you see statement +———————————————————————————————————————–+| @@sql_mode |+———————————————————————————————————————–+| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |+———————————————————————————————————————–+1 row in set (0.01 sec) To disabled it open fie […]

Mysql

Error: GPG check FAILED

By Prasad Naik

November 23, 2024

Getting error Error: GPG check FAILED while installing any package on alma linux 8 ? While installing a package got an error [root@secure ~]# yum install tracerouteLast metadata expiration check: 0:43:24 ago on Saturday 23 November 2024 10:15:46 AM EST. Dependencies resolved. Package Architecture Version Repository Size Installing:traceroute x86_64 3:2.1.0-8.el8 baseos 66 k Transaction Summary […]

Mysql

WordPress Error : Missing a temporary folder

By Prasad Naik

October 7, 2024

You may get an error while uploading images in wordpress with error The error message said – Missing a temporary folder The solution to this issue is Open wp-config.php in server Search for WP_TEMP_DIR in wp-config and check the path Usually its wp-content/Temp Check if this folders exists using ls -al /home/username /public_html/wp-content/Temp If folder […]

Mysql

upcp on cPanel failed

By Prasad Naik

September 4, 2024

while running upcp on cpanel server it stopped with error Running /usr/local/cpanel/scripts/updatenow --upcp --log=/var/cpanel/updatelogs/update.486871.726225288.1718207292.log --force failed, exited with code 1 (signal = 0) On checking logs in /var/cpanel/updatelogs/update.486871.726225288.1718207292.log We see the error [2024-09-04 13:06:20 -0400] * FATAL: Test install failed: error: Failed dependencies:[2024-09-04 13:06:20 -0400] libonig.so.5()(64bit) is needed by (installed) alt-php-internal-mbstring-8.2.14-2.el8.x86_64[2024-09-04 13:06:20 -0400] oniguruma is […]

Mysql

Opencart Broken page CSS images missing

By Prasad Naik

September 4, 2024

We had this issue with one of our customer Where the opencard was showing broekn site with no images loading and only skeleton page showing up The issue was due to issue in opencart config.php / HTTPdefine(‘HTTP_SERVER’, ‘http where http needs to be changed to https for website to work properly Once changed the website […]

Mysql

Virtualizor Panel not opening Softacalous

By Prasad Naik

August 27, 2024

First check status of virtualizor ps aux | grep virtualizor If nothing is showing up in results Check using command systemctl status virtualizor If still now working use command service virtualizor restart Stopping php-fpm: php-fpm is stoppedStopping nginx: nginx is stoppedStopping php-fpm: php-fpm is stoppedStopping nginx: nginx is stoppedERROR! MySQL server PID file could not […]

Mysql

The public_html folder permission keeps getting reverted in cPanel

By Prasad Naik

July 26, 2024

The ownership keeps getting changed to user.nobody in cpanel automatically. on debugging this issue it was found that cpanel has a new feature which was causing this in Home /Server Configuration /Enable File Protect Disabling it fixed the issue of permission changing automatically Tweak Settings Updating “Enable File Protect” from “On” to “Off”.“Enable File Protect” […]

Mysql

cPanel PHP 8.3 does not install Ioncube

By Prasad Naik

July 11, 2024

cpanel latest version which does not include ioncube loader in php 8.3 due to check softacolous does not work Fix of this issue is to install iocoube loader for PHP 8.3 Below are the steps to be executed wget -O /usr/local/cpanel/3rdparty/php/unversioned/ioncube/ioncube_loader_lin_8.3.so https://files.virtualizor.com/ioncube/64/ioncube_loader_lin_8.3.so Check version of Ioncube using below command /usr/local/cpanel/3rdparty/bin/php –versionPHP 8.3.8 (cli) (built: Jun […]

Mysql

Child failed to make LIVEAPI connection to cPanel.

By Prasad Naik

July 11, 2024

Softacalous on cpanel was giving error or ioncube loader Even disabling and reenabling ioncobe from tweak setting didnt fix the issue Script error: the ionCube Loader for PHP needs to be installed. The ionCube Loader is the industry standard PHP extension for running protected PHP code, and can usually be added easily to a PHP […]