> Message: 2
> Date: Wed, 08 Jan 2003 14:47:50 +0100
> To: mantisbt-help@...
> From: Jeroen Latour <jlatour@...>
> Subject: Re: [Mantisbt-help] [Re: Mantisbt-help digest, Vol 1 #89 - 4
> Reply-To: mantisbt-help@...
> At 19:58 8-1-2003 +1000, you wrote:
> >The insert statement returns an error saying that the data already exists
> >& will be
> >duplicated (strange given that there is no data in the table!!).
> >If you could point me in the directions of an .sql statement that will
> >insert the required
> >data (I am a complete SQL newbie here), I'd be thankful ... Also, if you
> >could point me
> >in the direction of a good "SQL for beginners" tutorial where I can learn
> >the basics so that
> >I don't pester good people like yourself for a while, that would be good
> >as well :-)
> The insert statement should be:
> INSERT INTO mantis_user_table
> (id, username, email, password, date_created, last_visit, enabled,
> protected, access_level, login_count, cookie_string)
> ( '0000001', 'administrator', 'admin',
> '63a9f0ea7bb98050796b649e85481845', NOW(), NOW(), '1', '1', '90', '0',
> (taken from 0.17.5)
> You can execute that using the mysql command-line tool, or phpMyAdmin.
> If phpMyAdmin tells you mantis_user_table is empty, and this query still
> fails, something's really wrong. What's the exact error message?
> Also, which MySQL version are you using?
Well, the insert statement worked this time but Mantis still won't allow me access.
The error states that the user name/password is incorrect or my account may have been disabled.
The version of MySQL I am using is 3.23.52
I checked the user table after running the insert statement & it does show one user which when I
view the table contents in PHPMyAdmin shows that it is Administrator. I've tried dropping &
recreating the database several times prior to tonight & each time it Mantis doesn't create any
default users for some reason; at least now there is a bit of progression :-)
Registered Linux User #253351
Get it up & keep it up - Linux, viagra for the PC