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.
Andy Southby wrote: > 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.) Executing the scripts directly requires you to search and replace %PREFIX% with any db prefix you may be using. The normal way is just to use the create tables button. Tony