On Freitag, 23. November 2007, Thomas Bleher wrote: > When SMW is loaded via require_once() and enableSemantics(), but the > necessary database tables are not there, saving a wiki page can fail. > > This hit me today: I had installed SMW for a client I work for, but > Special:SMWAdmin did not have the necessary rights to create the tables. > I left SMW there so the DB admins could add the rights, call the special > page, and immediately after, disable the DB rights again. Today I got > the mail that page saves failed. > > I know that this is a small issue, and maybe it's not worth fixing, but > I think it would be nice if saving did not totally fail if the necessary > tables are not present at all, but continue with a warning. After all, > the information can later be regenerated.
Yes, good point again. We removed the explicit test for whether all tables were in place for performance reasons. But maybe one could just catch the DB error and do something more helpful. Note you can also use the script SMW_setup.php for creating the DB, and this script uses the DB credentials supplied in AdminSettings.php. So it is possible to leave the normal DB user without rights to create tables and to still setup the DB properly. Note also that some query functions of SMW use temporary tables, and that these also need to be created by the DB user. If the DB user should not be allowed to do that, then subcategory and subproperty reasoning fails and should be disabled (see parameters in SMW_Settings.php). Regards, Markus -- Markus Krötzsch Institut AIFB, Universät Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 [EMAIL PROTECTED] www http://korrekt.org
pgpu3S0okx2n2.pgp
Description: PGP signature
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
