database error: Out of range value for column 'id_member' at row 1

Started by comesee, November 26, 2020, 06:27:01 PM

Previous topic - Next topic

comesee


database error: Out of range value for column 'id_member' at row 1

Out of range value for column 'id_member' at row 1
File: /home/public/Sources/Subs-Members.php
Line: 771


when i tried to register member,i get this error message, i have copyright on the website.  check

dont lock this post

Oldiesmann

How many members do you have on your site currently? By default the column can handle values up to 16,777,215.
Michael Eshom
Christian Metal Fans

Kindred

Repeat again...

User has been denied support until they return the copyright and stop telling lies

Although  this globe dot com does now have a copyright..



Total Members: 4773119

There's your problem
Too many fake users.


Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

comesee


Oldiesmann

A member ID of 16777215 would be the problem. You'll need to change id_member in the members table (and several other tables) to INT instead of MEDIUMINT.
Michael Eshom
Christian Metal Fans

comesee

oldiesmann i changed it to int   and i get an error


Duplicate entry '1-8388607-agreement_accepted' for key 'PRIMARY'
File: /home/public/Sources/Subs-Members.php
Line: 791

Kindred

Basically,  your fake users have exceeded the design of smf.

You were told, last time,  that what you're asking to do is not a simple one click change.

Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Sir Osis of Liver

Don't suppose it ever occurred to you to run a legit forum with real members?

Naaaah.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

comesee


Kindred

I fail to believe that you have 16,777,215 actual users...


either you have millions of fake users or millions of spammers.

Either way, you are doing things which violate the basic precept of a forum
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Advertisement: