1
kotis
Help with New User UID=16777215
  • 2007/8/1 18:00

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


Hi everyone,

I was trying to edit a user and accidentally changed his UID to a wrong number on MySQL. I deleted that user but a new registration took place meanwhile that was given the UID 16777215. After that UID no registration is possible (i tried it). I deleted the new user registration and i checked that the last UID in MySQL is low (17725). Unfortunately whenever a new registration takes place, it is given the UID 16777215.

I don't know why that happens... i tried everything and i could really use some help on this if somebody knows anything more. What i believe i have to find now, is where the system gets the next available UID from...

I will applreciate any given help...

Regards...

2
spacejoee
Re: Help with New User UID=16777215
  • 2007/8/1 18:09

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


Hi,
Maybe, this value "16777215" is actualy cached by your MySQL in memory. try to restart mysql.
Or : in you phpmyadmin, repair then optimize your XOOPS users table.

I m not sure if this will work. but this is what i would do at first before looking for other raisons.

Good luck.

(and excuse my english)

3
kotis
Re: Help with New User UID=16777215
  • 2007/8/1 18:14

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


Thank you very much for your reply spacejoee.... I tried restarting MySQL and i repaired / optimized the whole database... No luck yet unfortunately....

Please somebody... Help...

4
spacejoee
Re: Help with New User UID=16777215
  • 2007/8/1 18:18

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


Look if "16777215" or "16777214" is not present in the XOOPS session table. in phpmyadmin try to search where this value is. do a global search if nothing is present in the XOOPS session table

5
kotis
Re: Help with New User UID=16777215
  • 2007/8/1 18:47

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


Quote:

spacejoee wrote:
Look if "16777215" or "16777214" is not present in the XOOPS session table. in phpmyadmin try to search where this value is. do a global search if nothing is present in the XOOPS session table


I found no entries for 16777214... i only found some entries for 16777215 that i removed (in xoops_session, xoops_bb_reads_forum and xoops_bb_reads_topic). Then i tried a new registration but it was given the UID 16777215 once more.

I think this will drive me crazy...

6
spacejoee
Re: Help with New User UID=16777215
  • 2007/8/1 18:53

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


Try to flush your databse to reset index keys...

7
kotis
Re: Help with New User UID=16777215
  • 2007/8/1 18:54

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


This one looks like a solution....

http://www.frxoops.org/modules/newbb/ ... hp?topic_id=12206&forum=5

Anyone speaks french?

8
spacejoee
Re: Help with New User UID=16777215
  • 2007/8/1 19:02

  • spacejoee

  • Not too shy to talk

  • Posts: 106

  • Since: 2004/7/25


I speak french.
Quote:
- fais une sauvegarde de ta table xoops_users
- dans phpmyadmin, structure, modifie le champ uid , tout au bout à droite dans extra et supprime le champ autoincrément, tu valides
- tu recommences pour le remettre
- tu observes ce qui se passe (j'ai pas essayé)


1 - Make a backup of your XOOPS users table
2 - in phpmyadmin, structur, modifie the field UID, in the top at right, in extra, delet the field autoincrement. then validate.
3 - restart the step 2. and then add back the autoincrement field.
- he said the he didnot tried that. but in the post replie it looks that it worked for the webmaster who have the same probleme as you.

9
kotis
Re: Help with New User UID=16777215
  • 2007/8/1 19:09

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


Well... thanks to that French page, i figured out the solution.... On MySql -> Table: xoops_users -> Structure -> uid -> Browse -> Operations -> auto_increment field set to LastUID +1 (it was 16777215)

THAT'S IT!!!!

10
kotis
Re: Help with New User UID=16777215
  • 2007/8/1 19:12

  • kotis

  • Just popping in

  • Posts: 82

  • Since: 2002/12/23


spacejoee, thank you very much for your help...

Regards...

Login

Username:
Password:

Lost Password? Register now!

Who's Online

71 user(s) are online (46 user(s) are browsing Support Forums)


Members: 1


Guests: 70


Lilycollins3,

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jun 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits