Valgard Blondal wrote:
>
> Hi,
>
> I was wandering if someone could help on this.
>
> I am using mysql with php3 on a shared server, version 3.22.32
>
> I had been running this for few days without any problems, but
> when about 100 users were in to the database, the sign up form
> at http://www.nettelephone.com/sign_up.php3 did stop inserting
> new users in database, but did not produce any error code, so
> the user thought he was registered. Existing users had no problems
> logging to the database. When trying to insert a new record using
> phpmyadmin, we got the following error:
> > > SQL-query INSERT INTO main (id, email, password, firstname, lastname,
> > browser, gender, monthofbirth, dayofbirth, yearofbirth, country,
> > > zipcode, artculture, lifeTtyle, musicdrama,
> > outdoorrecreation, investment, businessnews, indoorhobbies, technology,
> > newsletter,
> > > thirdpartyemail) VALUES ('500', '[EMAIL PROTECTED]',
> > 'davrell1', 'Hans', 'Kind', 'IE', 'M', '05', '07', '1957', 'Netherlands',
> > '', 'Y', 'Y', '', '', '', '', '', '', '', '')
> > > produced
> > an error.
> > > MySQL said: Unknown
> > column 'lifeTtyle' in 'field list'
>
> Somehow the lifestyle field got corrupted and we reset that field.
> It is strange how the lifestyle field produced to "lifeTyle" in the error code,
> we have no clue why.
>
> After we reset the lifestyle field, everything was working normal and about
> 30 users registrated. But then the database stopped accepting more users
> again and when I tried to insert a record with phpmyadmin I got this error:
> SQL-query INSERT INTO main (id, email, password, firstname, lastname, browser,
>gender, monthofbirth, dayofbirth, yearofbirth, country, zipcode, artculture,
>musicdrama, outdoorrecreation, investment, businessnews, indoorhobbies, technology,
>newsletter, thirdpartyemail, lifestyles) VALUES ('128', 'hhhhh', 'hhhhh', 'hhhhh',
>'hhhhh', 'hhhh', 'm', '12', '12', '12', 'is', '111', 'y', 'y', 'y', 'y', 'y', 'y',
>'y', 'y', 'y', 'y') produced an error.
> MySQL said: Duplicate entry '127' for key 1
>
> I would appreciate if we could get some support on this, we just lunched a new
>service and we have no clue why this is happening.
>
> Best Regards
>
> Sigurjon V Jonsson
> [EMAIL PROTECTED]
Several suggestions:
Is 'id' an autoincrement tinyint? If it is you can only have 126
entries.
If the field name actually changed in the error message, you may have a
problem with
your memory, hard drive controller, or motherboard.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
