Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
Edward, I tried it and yes I get an error from the %PREFIX% in the SQL. It was I while ago when I created the tables but do not remember %PREFIX% being there before? Unfortunatly my SQL level is basic to say the least, so I can only assume that this script is not suppose to be used standalone or needs an environmental 'PREFIX to be defined to a usefull value? As a solution though you could use the 'Create Tables' button on the 'Audit Settings' dialog which works for me. (I used MySQL 5.0 and CVSNT 2.5.03.2238.) Good luck, Andy. "Edward Patterson" <edward.patterson at benefitfocus.com> wrote in message news:mailman.1015.1140126596.17086.cvsnt at cvsnt.org... I am running CVSNT version 2.5.03.2151 and MySQL version 4.1.7. When trying to setup the auditing to the database it connects fine but errors on creating the tables in the database due to an error in the SQL syntax. According to the auditing tutorial, CVSNT has native support for MySQL but it does not say for what versions? Has anyone see this problem? **************************************************************************************** BENEFITFOCUS.COM CONFIDENTIALITY NOTICE: This electronic message is intended only for the individual or entity to which it is addressed and may contain information that is confidential and protected by law. Unauthorized review, use, disclosure, or dissemination of this communication or its contents in any way is prohibited and may be unlawful. If you are not the intended recipient or a person responsible for delivering this message to an intended recipient, please notify the original sender immediately by e-mail or telephone, return the original message to the original sender or to bfpostmaster at benefitfocus.com, and destroy all copies or derivations of the original message. Thank you. (BFeComNote Rev. 08/01/2005) ***************************************************************************************