CiviCRM Community Forums (archive)

Just installed on my Mac and after the all clear from Check Requirements, the installer isn't able to create tables in the database for CiviCRM, the error message attached  presents (when selecting to have loaded starting data) and the following with out loaded sample data
 
 Building database schema and setup files...Cannot execute /******************************************************* * * civicrm_county * *******************************************************/ INSERT INTO civicrm_worldregion (id, name) VALUES("1", "Europe and Central Asia"): DB Error: no such table
 
 I can't figure out why the table isn't being created. Anyone got any ideas?
 

Hi Dave, thanks for your help.

The mysql user does have CREATE TABLES privelges, yes. In fact, the user has been granted all priveleges (I wonder might that be the problem). As is it was just an install on a recent drupal install (which went very smoothly), I'm a little perplexed.

I tried that, and I also tried by allowing civicrm to create it's own db (given the user with the right priveleges). Neither of which worked. Maybe fresh eyes this morning might tell me if I've overlooked something.

I'm not knowledgeable enough to tell if the error message in my initial post attachment has any insightful information for me. Does it say anything to you?

Which got me thinking about the sql database that was trying to be created, which lead me to a work-around (or pointed me to where my problem was). I removed the localisation files (l10n and sql folders) from the setup and all worked fine then. I just need to figure out what I did wrong there.

Thanks for your responses and help. All working very well now.