Thanks. I have fixed it.
Kern On Friday 16 April 2010 06:11:42 Craig Ringer wrote: > $ /home/craig/bacula-git/etc/create_sqlite3_database > > $ /home/craig/bacula-git/etc/make_sqlite3_tables > SQL error near line 41: near "INDEX": syntax error > SQL error near line 55: no such table: main.RestoreObject > > $ apt-cache policy sqlite3 > sqlite3: > Installed: 3.6.16-1ubuntu1 > Candidate: 3.6.16-1ubuntu1 > Version table: > *** 3.6.16-1ubuntu1 0 > 500 http://ftp.iinet.net.au karmic/main Packages > 100 /var/lib/dpkg/status > > > > > > > Looks like it might not like the in-line index specifier on line 64 of > the shell script. Removing: > > > INDEX(JobID) > > > and the preceeding comma fixes the issue. As the index is created > explicitly shortly thereafter, I'm guessing this was just a > copy'n'paste-o from another DB's schema definitions. > > -- > Craig Ringer > > --------------------------------------------------------------------------- >--- Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Bacula-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/bacula-devel ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
