ATutor

automatic attempt to create database

• harry_ej
  

  2008-02-11 12:21:06

  automatic attempt to create database

  i kept getting the collation error when i tried to install atutor 1.6:
  
  Database ..... is not in UTF8. Please set the database character set to UTF8 before continuing by using the following query: ALTER DATABASE `.....` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
  
  i created a database and collated it to utf 8 general ci
  
  the reason was that the installer attempted to create a new database even though i created one.
  I needed to rewrite (my host did as i have almost zilch knowledge of mysql) the install query in order for itt not to attempting to create a database
  
  After that the installation went smoothly.
  
  Maybe good to not that some hosing providers dont allow auto creation of databases.
  
  
  Things to describe:
  operating system - win xp
  version of ATutor -1.6 stable
  versions of php -5.1.6
  version of mysq l -4.1.20
  webserver & version -2.0.52
  copies of error messages -
  changes to default settings -
  web browser being used -
  and anything else relevant -
  
  
  regards,
  
  Harry

• greg
  

  2008-02-12 11:38:28

  Re: automatic attempt to create database

  Normally ATutor attempt to use an existing database if it exists, and is entered in step 2 of the installation. If it does not find one, it will attempt to create it.
  
  It may be your mysql user does not have table creation privileges. Are you able to confirm that it was indeed a database create problem, as opposed to a table create problem?

• harry_ej
  

  2008-02-13 02:37:09

  Re: automatic attempt to create database

  We looked into it and that really seems to be the case. I had a made a database and filled it's name in the form (databasename) together with the other info required to make connection and begin the dropping of the tables.
  
  The install script still attempted to creatte a new database. I do have table creation privilege as i have often made and dropped tables into a database with the phpmyadmin tool.
  
  My host however does not allow an auto installer to create an own database (max nr of databases allowd for my acount is 2) A new database has to be manually created through the control panel (mysql tool).
  
  My host then followed the install and noticed that the installer still tried to create a database. He then managed to rewrite the install script in such a way that the installer did not try to create an own database anymore but that it used my database.
  
  After that the install went smoothly.
  
  Note. Many webhosts would allow clients to have databases created through an installer and these ppl would not encounter this issue.