Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 6 Support
  4. Bugs and Errors - 6
  5. New users adding.

New users adding.

Asked Modified Viewed 2,978 times
Back to Forum Index Previous Topic Next Topic
Print
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
asked
Junior Member

I have added few users with phpmyadmin, because i needed it for some specific reasons.
I don.t now if it.s started then, but now i have problem that When registers new users, user ID is automaticaly last number of possible in mysql ( some 65335 ) and i need manualy chenge user ID to lowest, so while i didn.t changed user_id no one can.t register at site.
Now i can.t find reason of problem... .
0 replies

11 posts

M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

check what the cardinality of user_id is in prefix_users (you can see that on the structure page in phpmyadmin)
0 replies
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

Quote

user_id smallint(7) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
0 replies
M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

No, below the list of fields is a table titled Indices or so and there you'll find the cardinality of the auto_increment field.
0 replies
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

Ups, sorry:

Quote

Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 82 Edit Drop user_id
0 replies
M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

looks okay. did you change anything else?
0 replies
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

Quote

Rows 82
Row length ø 132
Row size ø 158 Bytes
Next Autoindex 65,536



I tryed change autoindex, but it.s still the same... .
Edited by leonids on 02-06-2008 22:42,
0 replies
X
Xessive
X
I am not always right, but I'm never wrong.
http://www.xessive.nl
  • Senior Member, joined since
  • Contributed 327 posts on the community forums.
  • Started 4 threads in the forums
answered
Senior Member

Maybe a Db repair would help. Make a backup before you do the repair.

Select the table and choose Repair Table from the dropdown menu
Edited by Xessive on 02-06-2008 23:05,
0 replies
W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

Delete those users you added manually via phpMyadmin.

Lookup last user_id of regular users.

Add 1 to that number and enter it in _users table, operations, table options, auto_increment.

That will bring back the auto_increment to what it was supposed to be.

Next time add users via the user admin in PHPFusion if you need to.
0 replies
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

repair doesn.t helping I tryed it.

WEC ok, i try your way. i had that feeling that it.s because i added manually users. But don.t have idea why it.s hapening... .
0 replies
W
WEC
W
WEC 10
  • Veteran Member, joined since
  • Contributed 946 posts on the community forums.
  • Started 5 threads in the forums
answered
Veteran Member

You should be able to insert new rows in the _user table in phpMyadmin without the auto_increment jumping to 65,536, but something obviously went wrong.
0 replies
L
leonids
L
  • Junior Member, joined since
  • Contributed 15 posts on the community forums.
  • Started 4 threads in the forums
  • Started this discussions
answered
Junior Member

DOup, something gone wrong.
Deleted all manualy added users. Still same... .

Code Download source
SQL query: 
ALTER TABLE fusion_users PACK_KEYS =1 CHECKSUM =0 DELAY_KEY_WRITE =0 AUTO_INCREMENT =65536


Also asking one my friend, who more knows about mysql, maybe he culd help.
Looks that it.s not php-fusions bug, but more looks like broken fingers :)

Yes!!! Fixed problem:
I.m just run this SQL query manualy:
Code Download source
ALTER TABLE fusion_users PACK_KEYS =1 CHECKSUM =0 DELAY_KEY_WRITE =0 AUTO_INCREMENT =162



Thanks a lot for helping!!!!
0 replies

Category Forum

Bugs and Errors - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 11 posts
  • Votes 0 votes
  • Topic users 4 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet