Technote Details :: Table does not exist

When using a form to add data into a table, instead of a successful SQL transaction, I get an error message saying "Table table_name does not exist".

 

• Products: The Transaction engine, NeXTensio 3.
• Operating System: All.
• Server Models: All.
• Dreamweaver version: any.

This happens because the database structure had been altered before the page was created and the actual use, and the table that is being used in the SQL transaction does not exist anymore.

Open your database management software and check the database structure. If needed, recreate the table with the exact same fields as used when creating the page that executes the SQL transaction. Otherwise, open the page and edit any server behavior that performs the SQL operation, and re-configure [].

Login to add a new note