Possible Major Bug - Member Groups

[Doomfalcon]

I *had* about 6 'extra' member groups (one per line) and they've been fine up until now. Then, I tried to add a 7th...

I added it, checked back under 'member groups' and 3 of my original groups were deleted, plus the one I tried to add had disappeared.

I tried to add one of the deleted ones back, thinking I had made a mistake somewhere.

Now 2 more were deleted instead, when I checked.

I only have one extra member group now, and everytime I hit 'enter' and type in a new member group and hit Submit, nothing is added. I can edit the first 'extra' and it doesn't get deleted, but I CANNOT create new member groups.

Did I mention I don't have any backups of my forums?

Please help,
Doomfalcon

[mediman]

Can you pls check your db! what type has Field ID_GROUP in table membergroups?

Ooops, forgotten: Have you often (very often) changed your membergroups? What ID_GROUP has your latest membergroup you added?

mediman

[Doomfalcon]

I don't change membergroups too often... last time I changed them was months ago. I realized I have something like 8 groups, though, if that would make a difference... and I added 'Wandering Swordsman'

Edit: I also have no clue what youre talking about... I'm not too technical - I just followed the instructions to do things on the boards My older brother helped with whatever I couldn't figure out...

"Can you pls check your db! what type has Field ID_GROUP in table membergroups?"

...

[mediman]

What YaBB SE Version?
And plz. check your DB (maybe we have to change the Fieldtype, it shoiuld be BIGINT(4).

mediman

[Doomfalcon]

What's DB? Remember, I'm non-techinical and have *no clue* what you're talking about... Just tell me how to get to it and I can do it

[mediman]

DB means database! have you phpmyadmin?

[Doomfalcon]

Alright, *please* bear with me here... How do you access the database? And no, I don't have phpmyadmin.

Also, just as an aside: I created the boards in July of 2002, and the only update I've ever made was when I got the 7 repeated e-mails about a new hacker loophole

One more thing: I'm not even on the computer that has access to my web server... So I won't really be able to fix anything that needs access of the server until tomorrow afternoon. Sorry I just never expected something like this to happen.

[mediman]

This makes the thing a little bit more complicated!
where is your board hostet? (hosting company)

mediman

[[Unknown]]

Okay, first download phpMyAdmin.  http://www.phpmyadmin.net/

Upload the files, and it's installed.... this isn't hard, don't sweat.

Now, select your database from the list on the left.

Click on the SQL tab on the right.  (it's like the second or third one....)

Copy and paste this in the box, changing yabbse_ to whatever your database prefix is.

DROP TABLE yabbse_membergroups;
CREATE TABLE yabbse_membergroups (
 ID_GROUP smallint(6) NOT NULL auto_increment,
 membergroup tinytext NOT NULL,
 grouptype tinyint(1) NOT NULL default '0',
 PRIMARY KEY (ID_GROUP)
) TYPE=MyISAM;
INSERT INTO {$db_prefix}membergroups (ID_GROUP, membergroup, grouptype)
VALUES (1, 'Administrator', 0),
(2, 'Moderator', 0),
(3, 'Newbie', 0),
(4, 'Jr. Member', 0),
(5, 'Full Member', 0),
(6, 'Sr. Member', 0),
(7, 'YaBB God', 0),
(8, 'Global Moderator', 0);

And then go to your YaBB SE admin panel, and try to create the membergroups again.

I would also then delete phpmyadmin.

-[Unknown]

[mediman]

ID_GROUP should better be BIGINT(4) believe me  unknown... we have had here more ppl with trouble.. they changed there membergroups to often!

mediman

[[Unknown]]

ID_GROUP should better be BIGINT(4) believe me  unknown... we have had here more ppl with trouble.. they changed there membergroups to often!

mediman

*GASP* BIGINT?!?!?

SMALLINT allows you to change it 32,768 times.  MEDIUMINT allows for 8,388,607 changes.... and BIGINT...

BIGINT allows for 9,223,372,036,854,775,807 changes.

Are that many needed?  You can't even make that many posts!

-[Unknown]

[David]

It should really not auto increment from MySQL but rather the script do it.  

[mediman]

yes unknown smallint is okay (i was wrong) the ppl who have had trouble have had tinyint (and this goes from -127 to 127) and this was in any cases not enough!

i cant found the postings... it was b4 the big db crash on yabbse.com

mediman