Once you run RVsitebuilder installation completely, but the RVsitebuilder setup puts the following error.
ErrorMESSAGE: MDB2 Error: no such field
TYPE: PEAR
DEBUG 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: -19
RVsitebuilder 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 ~]# mysql
mysql> SELECT @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
Output For MySQL 8.x
mysql> 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 + X (exit editor)
4. restart MySQL service
[root@system ~]# /scripts/restartsrv_mysql
3. 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.x
mysql> 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.
====================================
Comments
0 comments
Article is closed for comments.