Here possibly occurring problems and their solutions are described.

Queries are not saved

If queries are not saved, which is usually to a lack of permissions. The „data“ directory in the root directory must be writable.

Set permissions for storing query

Enhanced vowel and special characters are shown coded in MS Excel

When exporting as  csv file the data are encoded with UTF-8. These files must be opened with the appropriate character set. Microsoft Excel detects this charset sometimes not automatically. Therefore, the charset must be specified explicitly.

Example: Open Exported data with Microsoft Excel

  1. Save generated CSV file
  2. Open Microsoft Excel
  3. Select in menu Data -> Import external data Select menu item data import
  4. Open the csv file
  5. Select the character encoding UTF-8 for the file
  6. Select appropriate Field Separator and Text Qualifier
Set as character encoding in UTF-8 in Microsoft Excel file origin
Set as character encoding in UTF-8 in Microsoft Excel file origin

Enhanced vowel and special characters are shown coded in data export tool

If files are edited and stored again under a different set of characters, it is possible that special characters are not displayed correctly. All php files must be re-coded in this case as ‚UTF-8 without BOM‘.

Error message with ‚max_post_size‘ when queried

The variable ‚max_post_size‘ defines the maximum size of the transmitted data form in MByte. If a very large database used or many records are retrieved, needs to be expanded in the php.ini the variable ‚max_post_size‘.

The Extended Version of the Data Export tool provides a whitelist / blacklist system to display the tables. By restricting the number of tables, the size of the form data to be transmitted can be reduced.

Error message with ’no fields transfered for export!‘ when queried

Probably the value of max_post_size in php.ini is set too low. Increase the value of max_post_size in php.ini or use the Whitelist / Blacklist system to display for specific tables.

Timeout of the server

With very large databases, it may result in server timeouts. Here the processing time for scripts should be adjusted in the server configuration. Alternatively, the limit can defined to display the records in the file ‚config / config.php‘.