This section contains some troubleshooting information for the User Data Repository.
Users Unable to Save Custom Data or Tables when using MySQL for the User Data Repository
If you are using MySQL to store the User Data Repository and users encounter problems saving tables or custom data (particularly large tables or groups), then you may need to increase the MySQL maximum packet size. The default value of this setting is 1MB, which means that MySQL will reject any query that is larger than 1MB in size.
If a user tries to save a table or custom data that exceeds the configured limit, then the user will see an error message in SuperWEB2 and a message similar to the following will appear in the SuperWEB2 logs (superweb2-stdout.log):
To resolve this issue:
- Stop the MySQL server.
- Edit the MySQL configuration file. This file is called my.ini on Windows deployments, and my.cnf on Linux deployments. It is located in the MySQL server program data directory (for example, C:\ProgramData\MySQL\MySQL Server 5.6 on Windows or /etc/mysql/ on Linux).
[mysqld]section, increase the maximum packet size. For example:
The appropriate packet size will depend on the size of the tables you are creating. You may need to experiment with some different values to find a setting that works for you.
- Restart the MySQL server.
Warning Message in Log Files - "Table Doesn't Exist" or "User Lacks Privilege or Object Not Found"
When you first start SuperWEB2 with the default user data repository configuration, or for the first time after setting up a connection to an external user data repository database, you may notice one of the following warning messages in the SuperWEB2 logs:
Table 'udr.txd' doesn't exist
user lacks privilege or object not found: TXD
These messages can be safely ignored. They are generated by SuperWEB2 checking to see if the user data repository tables have been created. When SuperWEB2 detects that the user data repository tables have not been created, it will automatically create them. Therefore these messages will not be displayed the next time you start it up.
The following are examples of the types of error message you may see in the log files: