I did some messing around with that statement, and eventually got it to run the insert:
primary_language_id needed to be an integer
updated_at and created_at needed values
insert into users set userid = 1, username = "babel@xxxxxxxxxxx",first_name="babel",last_name="fish",email="babel@xxxxxxxxxxx",primary_language_id = 1,password_hash = "HSD9a.ShTTdvo", is_committer = true, updated_on = NOW(), updated_at= NOW(),created_on = NOW(), created_at= NOW();
The result of that was actually a duplicate entry: "ERROR 1062 (23000): Duplicate entry '1' for key 1"
Viewing the babel database in Eclipse via Datatools returns an empty result set on that table
Executing a select via the MySQL CLI returns one row with the expected data in it
Could this conflicting view of the database be the cause of the connection issues John Ryding is having in his "Setting up development environment in windows" thread?
As a test, I am going to try a different version of MySQL...
Thanks!
--------------------------
Matthew Mazaika
IBM Eclipse
1.919.254.6224
![Inactive hide details for Denis Roy <denis.roy@xxxxxxxxxxx>]()
Denis Roy <
denis.roy@xxxxxxxxxxx>
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_______________________________________________
babel-dev mailing list
babel-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/babel-dev
