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]
