Recent activity
Recent activity (0)
My /usr is using 98%, is it possible to install in another partition?
----------------For cPanel----------------/usr is required for installer to download, extract files, and then move them to /var/cpanel/rvglobalsoft/rvsitebuilder (for cPanel server). You need to have at least 2.0 GB space available. If /usr is running out of space, you can solve it by creating symbolic link from /usr/local/cpanel/whostmgr/docroot/cgi/rvsitebuilderinstaller to other partition.Let's say you want to move rvsitebuilderinstaller files to /home. You need SSH to the server as root and run these commands. cd /usr/local/cpanel/whostmgr/docroot/cgi/mv rvsitebuilderinstaller /home/ It will take 10 - 30 minutes depend on your server performance. Please wait and don't stop it while moving files. After successfully move files, run this command. cd /usr/local/cpanel/whostmgr/docroot/cgi/ln -s /home/rvsitebuilderinstaller /usr is also required to install RVsitebuilder PEAR library. You still need to have at least 200 MB disk space. ------------------------For DirectAdmin------------------------RVsitebuilder will be installed on /usr/local/rvglobalsoft/rvsitebuilder. You need to have at least 2.0 GB space available. If /usr is running out of space, you can solve it by creating symbolic link from /usr/local/rvglobalsoft/rvsitebuilder to other partition. Let's say you want to move RVsitebuilder files to /home. You need SSH to the server as root and run these commands. cd /usr/local/rvglobalsoftmv rvsitebuilder /home/ It will take 10 - 30 minutes depend on your server performance. Please wait and don't stop it while moving files. After successfully move files, run this command. cd /usr/local/rvglobalsoftln -s /home/rvsitebuilde
MySQL strict mode function, breaks RVsitebuilder program
Once you run RVsitebuilder installation completely, but the RVsitebuilder setup puts the following error.ErrorMESSAGE: MDB2 Error: no such fieldTYPE: PEARDEBUG INFO: _doQuery: [Error message: Could not execute statement] [Last executed query: SELECT charset_id FROM rvs_usr WHERE rvs_usr_id = '56adab617be6e653284799feff39b78a' ] [Native code: 1054] [Native message: Unknown column 'charset_id' in 'field list'] CODE: -19RVsitebuilder doesn't support MySQL Strict Mode On, and your server has MySQL Strict Mode "On". Please disable MySQL Strict Mode by the following solution.1. You can check by run the following command.[root@system ~]# mysqlmysql> SELECT @@GLOBAL.sql_mode;+--------------------------------------------+| @@GLOBAL.sql_mode |+--------------------------------------------+| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |+--------------------------------------------+Output For MySQL 8.xmysql> SELECT @@GLOBAL.sql_mode;+-----------------------------------------------------------------------------------------------------------------------+| @@GLOBAL.sql_mode |+-----------------------------------------------------------------------------------------------------------------------+| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |+-----------------------------------------------------------------------------------------------------------------------+2. Run the following command to disable MySQL strict mode please edit file my.cnf.mysql> exit[root@system ~]# nano -w /etc/my.cnf[mysqld]sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"For MySQL 8.x[mysqld]sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" Ctrl + O + Enter (for save file)Ctrl + X (exit editor) 4. restart MySQL service[root@system ~]# /scripts/restartsrv_mysql3. You can check by run the following command again.mysql> SELECT @@GLOBAL.sql_mode;+--------------------------------------------+| @@GLOBAL.sql_mode |+--------------------------------------------+| NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |+--------------------------------------------+ Output For MySQL 8.xmysql> SELECT @@GLOBAL.sql_mode;+--------------------------------------------------------------------------------+| @@GLOBAL.sql_mode |+--------------------------------------------------------------------------------+| NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION |+--------------------------------------------------------------------------------+Reference: http://serverfault.com/questions/485091/mysql-strict-mode-stuck-on *4. Drop all tables (!! For first install RVsitebuilder only, after finished 3 above, please continue here)Go to WHM -> MySQL Service -> phpMyAdmin -> select database ,and click all table to drop 5. Go back to RVglobalsoft Manager -> RVsitebuilder Manager to setup again. ====================================