Well the first thing to do would be to look at the output of the mysql_error() function in PHP. This function will provide the textual error message from the MySQL server, which may shed some light on the problem. Another recommendation is to send this error message, along with any relevant information, to yourself with the mail() PHP function when an error is encountered. This may help identify trends.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
One area to watch for is users violating primary keys or UNIQUE indexes. Before inserting the row, check and make sure the row is truly unique, or catch the error and ask the user for new information.
Dig Deeper on Open source Web and application servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.