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.

mysql> SELECT @@GLOBAL.sql_mode;

+--------------------------------------------+

| @@GLOBAL.sql_mode |

+--------------------------------------------+

| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |

+--------------------------------------------+

1 row in set (0.00 sec)

2. Run the following command to disable MySQL strict mode

         mysql> SET GLOBAL sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";

Query OK, 0 rows affected (0.00 sec)

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 |

+--------------------------------------------+

1 row in set (0.00 sec)

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.

====================================