> I have upgraded SMW 0.7 to 1.0 on three systems. One instance worked > without incident. Two instances have issues. There are two distinct > issues described below:
> Issue #1 > Each time I upgraded, changed the $wgDbuser and $wgDBpassword to root > account in LocalSettings.php before clicking the Initialize button on > the Admin functions special page. Each time, the table upgrade > completed without error. However, on two of three systems, switching > back to the unprivileged $wgDbuser and $wgDBpassword in > LocalSettings.php started throwing SQL errors when accessing page with > SMW <ask> query as follows: > Database error > A database query syntax error has occurred. This may indicate a bug in > the software. The last attempted database query was: > (SQL query hidden) from within function "". MySQL returned error > "1142: ALTER command denied to user 'wikiuser'@'localhost' for table > 'cats1' MW installation procedure specifies to set the following rights: create, select, insert, update, delete, lock tables SMW 0.7 also requires alter SMW 1.0 also requires drop, create temporarily tables, index rights. > Issue #2 > On third system only, attempting to run the SMW_refreshData.php -pv > results in follow error: > DB connection error: Access denied for user 'root`'@'localhost' (using > password: YES) (localhost) > The odd thing is, this username/password combination worked $wgDbuser > and $wgDBpassword in LocalSettings.php but don't work from the > AdminSettings.php? In AdminSettings.php these variables have different names: $wgDBadminuser, $wgDBadminpassword Dmitriy ------------------------------------------------------------------------- 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
