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.
Obvious really! I think that's first thing I learnt when I started using databases a couple of months ago. Thanks for reminding. :-) "Tony Hoyle" <tony.hoyle at march-hare.com> wrote in message news:dt48o9$m9q$1 at paris.nodomain.org... > 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