Interesting ... Please try this instead: 
 
insert into users set userid = 1, username =
"babel@xxxxxxxxxxx",first_name="babel",last_name="fish",email="babel@xxxxxxxxxxx",primary_language_id
= "",password_hash = "HSD9a.ShTTdvo", is_committer = true,  updated_on
= NOW(), updated_at='',created_on = NOW(), created_at=''; 
 
Denis 
 
 
 
Matthew Mazaika wrote:
  I have the current configuration: 
   
Windows XP, SP2 
IIS 5.1 
PHP 5.2.5 (cli) (built: Nov 8 2007 23:18:51) 
mysql Ver 14.12 Distrib 5.0.51b, for Win32 (ia32) 
   
   
I have run into a problem just setting up the sample database. Using
the latest version from CVS of babel-setup.sql, version 1.31, the
following command appears to complete successfully - no error messages
are displayed: 
   
  "mysql -u root -p babel <
/var/www/babel/server/babel-setup.sql" 
   
   
When attempting to log in with the default credentials the following
error is displayed: 
   
  "Authentication failed. If
you just created a NEW BUGZILLA ACCOUNT wait a few minutes and try again." 
   
   
  I checked the database to verify the login
credentials, and found that there is no information in the "users"
table. All of the other tables have data within them. I tried to
manually execute the line to insert the default user, and the following
error was thrown: 
   
  "ERROR 1364 (HY000): Field
'updated_on' doesn't have a default value" 
   
   
  Does anyone have any suggestions as to why the users
table doesn't want to populate or any ideas on how to fix it? Thanks in
advance! 
   
-------------------------- 
Matthew Mazaika 
IBM Eclipse 
1.919.254.6224 
  
 
_______________________________________________
babel-dev mailing list
babel-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/babel-dev
   
 
 
-- 
Denis Roy
Manager, IT Infrastructure
Eclipse Foundation, Inc.  --  http://www.eclipse.org/
Office: 613.224.9461 x224 (Eastern time)
Cell: 819.210.6481
denis.roy@xxxxxxxxxxx 
 |