Installed KIckstart RC1 (after trying various betas), is absolutely great. Installed Demo content version, but when I choose 'all products', all I get is an error: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'username'@'%' to database 'mywebsite_501103_db1'.

Wrote to the provider, apparently I have all permissions granted on the database, so that can't be it it seems.. I tried re-indexing, etc etc, but cant get any search working, facets don't appear etc.

Any help very welcome! (No doubt I do something wrong somewhere..)

Comments

bojanz’s picture

bojanz commented
Category: bug » support

Something is wrong with the way you setup Drupal (with the way you configured your databases). Not sure how I can help.

xax’s picture

xax
Location London, UK
commented

Thanks for your answer, and sorry to bother you guys with this.. I guess that is where the problem must lie. Problem is I can't figure out what that problem could be. The only configuration of my database is name and password in the 'settings.php' - These settings must be correct or the whole site wouldn't work.. All other database things were set during kickstart install.

So I thought maybe my permissions are wrong, or there are some specific permissions I need for faceted search that I do not have? My provider tells me I have 'select, insert, update delete, create drop, index, alter, lock tables' all on, do I need another grant/permission?.

Again, any tip, suggestion, idea very welcome..

And let me say: wonderful job on kickstart 2! I built in Ubercart before but this is miles ahead (and omega..)

mlowther11’s picture

mlowther11 commented

I have the exactly the same issue, installation appeared to proceed without a hitch, everything works apart from search functions, interestingly the error isn't thrown when there really are 0 matches to search.
reindexing, clearing index then rebuilding, everything seems to work fine, but doesn't resolve issue.
doesn't appear to be any permission problems with the database here either

Only thing in logs is the search_api warning: Undefined data alteration commerce_kickstart_search_bundle_filter specified in index Product Display
This is mentioned here http://drupal.org/node/1741226 but probably not relevant

My current thinking is this is something to do with the set up of the hosting, I'm using a shared service from heart internet.

mlowther11’s picture

mlowther11 commented

UPDATE:
Issue resolved by getting ‘CREATE TEMP TABLE’ permissions on the database (this was turned off by default)

bojanz’s picture

bojanz commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Robert S’s picture

Robert S commented

Had the same problem (Commerce Kickstart, 7.x-2.6-core), #4 put me on the right track.
If somebody else will meet the same problem, I'll try to put it more explicitly: you need to give your database user more privileges then in normal Drupal installation. My file INSTALL.mysql.txt said that I should do

  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER
  ON databasename.*
  TO 'username'@'localhost' IDENTIFIED BY 'password';

but for Kickstart to function properly, it seems that one needs more:

  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES 
  ON databasename.*
  TO 'username'@'localhost' IDENTIFIED BY 'password';

Actually, now I see that online version has it right and even adds LOCK TABLES -- too bad I chose to read the offline version.

russelljns’s picture

russelljns commented

Hi I am also having the same issue as Robert S with the same version.

SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'username'@'%' to database 'database_name'

I see that I need to add some extra code but I really new to all this and don't have much experience. I am not sure what or where I am looking to put this extra code. I had a look at the file INSTALL.mysql.txt and I am guessing that I have to access mySQL which I have done via MyPHPAdmin (at this point I am already way out of my depth, but it hasnt stopped me getting this far!) I have found somewhere where I can Run SQL query/queries on the database, I have tried entering the code but it says there is an error in my syntax. What am I doing wrong? Sorry if I posted this in the wrong place, Im still learning.

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON databasename.*
TO 'username'@'localhost' IDENTIFIED BY 'password';

where:
databasename is replaced by my databasename
username is replaced by my username (the same as the database in this instance
and password is replaced by password.

Thanks for any help in advance.

kgolding’s picture

kgolding commented

I've just had the same issue on a fresh install. Heart Internet support very quickly added the ‘CREATE TEMP TABLE’ permissions on the database and the problem was fixed.