My apologies for crossposting to devel, but earlier efforts to post messages to user list have failed.
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' 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? I'm a novice with MySql and stumped about the inconsistencies. Any assistance is appreciated. Thanks, Dan -- -- Dan Thomas ------------------------------------------------------------------------- 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
