Creating Website
RVSitebuilder 7 · Website design and content
Content Editor Troubleshooting
Fix common editor and content issues
Installation & Setup
Hosting providers and server administrators
Blog list (0)
I upgraded MySQL and got internal server error when accessing to RVsitebuilder. How can I fix it?
Please SSH access as root and run below command. perl /var/cpanel/rvglobalsoft/rvsitebuilder/panelmenus/cpanel/scripts/autofixphpini.pl
Installation process hang, very slow, download package invalid
There are some reasons for this error.• Your network is too slow.• Your server or network automatically kills the process while it downloading the file.• Your server or network reduces the bandwidth when it downloads a large file. Please SSH to your server as a root and try this command to check your download speed. wget http://download.rvglobalsoft.com/download.php/download/rvsitebuilder-library/file/rvslibrarypro_001.tar.bz2 If you can download it, please try to install RVsitebuilder again. If you cannot download it, you need to contact your ISP to check the download bandwidth. If still not work, please try it manual by following this link. If finally the methods above don't help, please submit support ticket to us.
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. ====================================