Recent activity
Recent activity (0)
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. ====================================
PEAR installation problem
You should not get this problem at all. If you got the "Cannot find pear on this server", please follow instruction here. 1. Locate php_bin [root@local ~]# /usr/local/bin/pear config-get php_binusr/local/bin/php 2. Locate php_dir [root@local ~]# /usr/local/bin/pear config-get php_dir/usr/local/lib/php 3. Replace @PHP-BIN@ on the below commands with the result of 1. and @PHP-DIR@ with the result of 2. and run these commands. @PHP-BIN@ -C -q -d disable_functions='' -d suhosin.executor.func.blacklist='' -d memory_limit=128M -d max_execution_time=3600 -d include_path=@PHP-DIR@ -d output_buffering=1 -d variables_order=EGPCS -d open_basedir= -d safe_mode=0 -d register_argc_argv=On -d auto_prepend_file= -d auto_append_file= @PHP-DIR@/pearcmd.php install -f /var/cpanel/rvglobalsoft/rvsitebuilder/scripts/RVSeagullMod-1.0.1.tgz @PHP-BIN@ -C -q -d disable_functions='' -d suhosin.executor.func.blacklist='' -d memory_limit=128M -d max_execution_time=3600 -d include_path=@PHP-DIR@ -d output_buffering=1 -d variables_order=EGPCS -d open_basedir= -d safe_mode=0 -d register_argc_argv=On -d auto_prepend_file= -d auto_append_file= @PHP-DIR@/pearcmd.php upgrade -f /var/cpanel/rvglobalsoft/rvsitebuilder/scripts/RVSeagullMod-1.0.1.tgz Watch the result of the command whether success or fail. If you run into the problem, please submit support ticket including root access.