Search found 60 matches

by neizvelebiliziran
Fri Mar 07, 2014 7:49 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Fixed. The problem was too high user_id number...
by neizvelebiliziran
Thu Feb 27, 2014 8:37 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

You probably have an incorrect cookie but you didn't provide the site address so it's only a guess. Fixing incorrect cookie settings I don't think that the problem is incorrect cookie, because only new memebers that registered after SQL error have the problem. I checked the cookie settings and ever...
by neizvelebiliziran
Thu Feb 27, 2014 7:43 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Can anybody help me?

There is still the error:
I have problem when an user has registered after the SQL error, he can't login (he will automatically logged out). Old users don't have this error.
by neizvelebiliziran
Thu Feb 06, 2014 12:50 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Done.

There is no error when someone tries to register.. Now, I have problem when an user has registered after the SQL error, he can't login (he will automatically logged out). Old users don't have this error. :roll: :roll:
by neizvelebiliziran
Thu Feb 06, 2014 11:58 am
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Ok, thanks.

But I can also purge sessions in ACP? Or I need to install Support Toolkit?
by neizvelebiliziran
Thu Feb 06, 2014 11:04 am
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Here is it ;) Other Stats Rows in sessions table: 3743 Rows in sessions_keys table: 290659 Number of users (config table): 47994 Number of users (users table): 48070 Number of topics (config table): 45113 Number of topics (topics table): 45115 Number of posts (config table): 281157 Number of posts (...
by neizvelebiliziran
Wed Feb 05, 2014 11:09 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Thanks Oyabun1! I will run this script later :)
by neizvelebiliziran
Wed Feb 05, 2014 6:21 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

I know, I fixed it.

Thanks for the help.
by neizvelebiliziran
Wed Feb 05, 2014 6:00 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

I changed the type of user_id column in phpbb_users table... Was it wrong?

EDIT: I did the same for phpbb_user_group table and it works!!

Thank you for the help guys, you are awesome!
by neizvelebiliziran
Wed Feb 05, 2014 5:14 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

I changed it to bigint, running following SQL ALTER TABLE `phpbb_users` CHANGE `user_id` `user_id` BIGINT( 12 ) UNSIGNED NOT NULL AUTO_INCREMENT , but still the same. Here is the error SQL ERROR [ mysqli ] Out of range value adjusted for column 'user_id' at row 1 [1264] SQL INSERT INTO phpbb_user_gr...
by neizvelebiliziran
Wed Feb 05, 2014 1:15 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Yeah, I see... But how to fix this error?
by neizvelebiliziran
Wed Feb 05, 2014 1:11 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

No :D

I have 47,894 users..
by neizvelebiliziran
Wed Feb 05, 2014 12:55 pm
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Debug mode enabled, now I get this error SQL ERROR [ mysqli ] Out of range value adjusted for column 'user_id' at row 1 [1264] SQL INSERT INTO phpbb_user_group (user_id, group_id, user_pending) VALUES (16777247, 2, 0) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FI...
by neizvelebiliziran
Wed Feb 05, 2014 9:12 am
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Re: Registration Error!

Support Request Template What version of phpBB are you using? phpBB 3.0.11 What is your board's URL? No answer given Who do you host your board with? KnownSRV How did you install your board? I used the download package from phpBB.com What is the most recent action performed on your board? Fresh Ins...
by neizvelebiliziran
Wed Feb 05, 2014 12:25 am
Forum: [3.0.x] Support Forum
Topic: Registration Error!
Replies: 27
Views: 1674

Registration Error!

Hello When someone wants to register on my forum, he gets following error General Error SQL ERROR [ mysqli ] Out of range value adjusted for column 'user_id' at row 1 [1264] An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists. Can anybody h...

Go to advanced search