Paul van den Berg wrote:
> I login as user ‘Paul’ which has admin rights.
> Then I go to the Speciaal:SMWAdmin page and click the button.
> I get the next error :
> Setting up standard database configuration for SMW ...
> Setting up table `smw_relations` ...
> *http://paul-laptop/WPS%20logo.png**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 "SMWSQLStore::setupTable".
> MySQL returned error "1142: CREATE command denied to user
> 'Paul'@'localhost' for table 'smw_relations' (localhost)".
> Any ideas how I can fix this?
I had similar problems when I first set up MediaWiki and SMW.
You should check the permissions in MySQL of the database user (NOT the
MediaWiki user) as whom MediaWiki connects to MySQL. Look in your
MediaWiki LocalSettings.php for
$wgDBserver/$wgDBname/$wgDBuser/$wgDBpassword/$wgDBprefix} then use
something like phpMyAdmin's _Privileges_ to check that user's
privileges. It sounds like your $wgDBuser is named "Paul" which is also
one of your MediaWiki user accounts.
I ended up having to create several flavors of my MediaWiki DB user
"wikiuser" on different Hosts: wikiuser on Host %, wikiuser on
localhost, and wikiuser on localhost.domain, all with Global privileges
This might not be your problem at all,, but something in the area of
Privileges and database users seems amiss. Read more at