valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 232
Questions & Answers
Q: I am receiving the following email error message (Error MYSQL TEST). Have you got any suggestions on what I may be doing wrong. I have followed all the requirements and set up the table 'abc'.
A: This error indicates that the data cannot be added the specified database table. Recheck MYSQL Server Name, MYSQL User Name, MYSQL User Password, MYSQL Database Name, MYSQL Table Name. These must match existing settings in the MYSQL database. Also recheck that the existing table (MYSQL Table Name) has field names that correspond to form field names and text variable types are used. Remember if your form field is First_Name it displays as First Name in your browser but the MYSQL field must be First_Name. It is also recommended that the form is run on the same server as your MYSQL database. Also make sure that any MYSQL table fields that are not skipped can accept the MYSQL Empty Value or NULL values. If you have access to the error log files for your server you may be able to identify the problem by checking the error log entries. If you still have difficulty try stripping your form and database down to a single field ie subject to eliminate/minimize potential data mismatches and determine if it is an access or data issue.
Question and Answer Item 232 - Browse All Question and Answer Items