Technote Details :: Database file permissions

I've created a NeXTensio List and Form. When I click the New link in the list to add a new record, the form page loads with an error message: "Internal Error". The developer details state:
"tNG_multiple.getFakeRecordset
SQL error: Access denied for user: 'username@localhost' to database 'name_db'. (MULTIPLE_FAKE_RS_ERROR)".

• Products: NeXTensio.

• Operating System: All.

• Server Models: PHP_MySQL.

• Dreamweaver version: any.

This happens because the NeXTensio form creates some temporary tables in the database, using the provided database connection, but the user does not have the necessary permissions. Although the user may seem to have full permissions on the database server, the temporary table creation permission might be missing. This does not mean that the user cannot create regular tables.

In order to be able to use the NeXTensio Form with your database connection, you must grant the user specified in the Dreamweaver database connection the rights to create temporary tables. To grant temporary table creation rights in MySQL, use the following command at the MySQL command line:

GRANT CREATE TEMPORARY TABLES ON database_name to user_name.


For more details regarding the GRANT command syntax, consult the MySQL user manual.