Oct 24th, 2011, 10:10 AM
Hi celuch,
Hmm...! That's a strange one. The query looks just fine, so my hunch is that maybe the MySQL user you're using doesn't have permissions to create tables. Could you ask your hosting provider to confirm that that's the case? You may also be able to do this yourself through whatever administration section your host provides. The MySQL user that you're using (i.e. the account that you've specified in your /global/config.php file) needs to have full read-write permissions on table records and needs to be able to create and delete tables themselves.
Let me know how it goes. That seems the most likely cause!
- Ben
Hmm...! That's a strange one. The query looks just fine, so my hunch is that maybe the MySQL user you're using doesn't have permissions to create tables. Could you ask your hosting provider to confirm that that's the case? You may also be able to do this yourself through whatever administration section your host provides. The MySQL user that you're using (i.e. the account that you've specified in your /global/config.php file) needs to have full read-write permissions on table records and needs to be able to create and delete tables themselves.
Let me know how it goes. That seems the most likely cause!
- Ben