New users adding.
Asked Modified Viewed 2,988 times
asked
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... .
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... .
answered
DOup, something gone wrong.
Deleted all manualy added users. Still same... .
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:
Thanks a lot for helping!!!!
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 =65536Also 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 =162Thanks a lot for helping!!!!
answered
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.
answered
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... .
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... .
answered
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.
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.
Xessive
Xessive 10
I am not always right, but I'm never wrong.
http://www.xessive.nl
http://www.xessive.nl
- Senior Member, joined since
- Contributed 327 posts on the community forums.
- Started 4 threads in the forums
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
Select the table and choose Repair Table from the dropdown menu
Edited by Xessive on 02-06-2008 22:05,
answered
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 21:42,
answered
looks okay. did you change anything else?
answered
Ups, sorry:
Quote
Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 82 Edit Drop user_id
answered
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.
answered
Quote
user_id smallint(7) UNSIGNED No auto_increment Change Drop Primary Index Unique Fulltext
answered
check what the cardinality of user_id is in prefix_users (you can see that on the structure page in phpmyadmin)
Category Forum
Bugs and Errors - 6Labels
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