ATutor

help cant create user account

• ciuspo
  

  2006-01-05 07:38:40

  help cant create user account

  If you are asking for help, provide lots of detail so problems can be reproduced.
  
  Things to describe:
  operating system - windows Xp SP2
  version of ATutor - ATutor-1.5.2
  versions of php - php-4.4.1
  version of mysq l - mysql-essential-5.0.18-win32- mysql-administrator-1.1.6
  webserver & version - apache_1.3.34
  copies of error messages - "The following errors occurred:
  * Information could not be added to the database."
  web browser being used - Firefox
  
  Hi I'm newbi, and I have trobles creating new account.
  When I try to create new user (student or Instructor) i recive this message:
  
  
  The following errors occurred:
  * Information could not be added to the database.
  
  can someone help me please?

• joel
  

  2006-01-05 10:12:27

  Re: help can't create user account

  try installing ATutor again and double check that all the database tables are created correctly.

• redviper
  

  2006-01-31 11:02:19

  Re: help can't create user account

  I am having the same problem. I have used atutor for many years and have never had this problem. the only change i made was upgrading to the current stable version of mysql 5.0.18. I'm running this in nt mode.
  
  I have re-installed and tried to configure everything I know.
  
  would like some input on this issue if anyone has any. i'm stumped.

• joel
  

  2006-01-31 11:21:01

  Re: help can't create user account

  Either you're using the MySQLi library in PHP, which ATutor does not yet support, or you did not update your tables correctly when upgrading to the latest version of MySQL.
  
  This is the error you are dealing with: http://www.google.com/search?hl=en&q=mysql+php+error+1251&btnG=Google+Search
  
  Try installing phpMyAdmin and see if you can manage your database.

• redviper
  

  2006-01-31 11:23:50

  Re: help can't create user account

  When I try to manually create a user account in mysql, I get an error saying the field "preferences" does not have a default value and I cannot write to this field.
  
  significant?

• redviper
  

  2006-01-31 11:26:26

  Re: help can't create user account

  Iso, do I just comment out "extionsion=php_mysql" in my php.ini file?

• redviper
  

  2006-01-31 11:32:25

  Re: help can't create user account

  ok, weird.
  
  I was able to manually add a user into the member_id table in mysql only after I added memo information in the "preferences" field. I was able to do this by using navicat to select to see the memo, I wrote something in there, then it let me save the rest of the member record.
  
  ???

• redviper
  

  2006-01-31 11:49:59

  Re: help can't create user account

  ok, i think the issue is in atutor. here's why.
  
  I can create users if I add the first name and last name. This was not an astericked field, so, I was leaving this blank. Once I added the first and last name, users were created like normal.
  
  might want to update the code to either allow no first or last name or to asterick first and last name to show they are required fields.