Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: comesee on November 26, 2020, 06:27:01 PM

Title: database error: Out of range value for column 'id_member' at row 1
Post by: comesee on November 26, 2020, 06:27:01 PM

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
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Oldiesmann on November 26, 2020, 06:51:37 PM
How many members do you have on your site currently? By default the column can handle values up to 16,777,215.
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Kindred on November 26, 2020, 07:06:20 PM
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.


Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: comesee on November 26, 2020, 10:01:24 PM
i have a member with id   16777215 
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Oldiesmann on November 26, 2020, 11:51:53 PM
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.
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: comesee on November 27, 2020, 03:32:58 PM
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
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Kindred on November 27, 2020, 07:16:22 PM
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.

Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Sir Osis of Liver on November 27, 2020, 08:44:49 PM
Don't suppose it ever occurred to you to run a legit forum with real members?

Naaaah.
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: comesee on December 02, 2020, 06:49:53 PM
what fake user ,are you talking about,i dont have fake user
Title: Re: database error: Out of range value for column 'id_member' at row 1
Post by: Kindred on December 02, 2020, 07:03:16 PM
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