database problems fixed!

Thanks to David Bourget, the author of the xpapers project for his help here.

By running:

perl $XPAPERS/bin/setup/apply-sql-patches.pl 1.0 1.1

The extra fields (hisotricalFacetOf,facetRoot, historicalLeaf, summary, keyWorks, introductions, summaryUpdated, summaryChecked and advertiseChecked) now exist in the cats table and the errors referring to these are now gone. A lot more of the functions in xPapers now seem to work.

David also pointed me at a command line interface for xPapers, which allows you to manipulate the database (I wanted to make a user an admin). This can be done by running bin/cmd.pl, for example:

perl bin/cmd.pl

> load user 123

user blabla bla loaded

> set admin 1

field admin set to 1

>bye