can't use "View/Delete Members" after conversion

[Yvette]

Hi,

After converting -

1) I can't View/Delete Members.  I've tried doing the conversion from YaBB Gold 1.1 to both YaBBSE 1.4.1 and YaBBSE 1.5.0.

When I go to Member Controls - View/Delete Members it says:
"The page you are looking for is currently unavailable. The Web site might be experiencing technical difficulties, or you may need to adjust your browser settings." etc

But the host/domain part of the URL is correct. Anyone know why I would get this error?

Everything else works fine.

2) The Notify by Email in IM - how do I have it off by default for everyone?  

3) The conversion put the word "Array" in everyone's Ignorelist in IM.  How do I delete that?

4) Where does MySQL/PHP store the data that used to be in the Members directory?

Thanks for any help.

Yvette

[[Unknown]]

1. Sounds like a server error.... what path is it sending you to?

2. UPDATE TABLE yabbse_member SET im_email_notify = 0
ALTER TABLE yabbse_member ALTER im_email_notify SET DEFAULT 0

3. Mistake in the converter, I guess...
UPDATE TABLE yabbse_member SET im_ignore_list = NULL

4. It stores it in MySQL.  I suggest using phpMyAdmin or something to access it. (with the above commands.)
It's not stored as files because this is MUCH slower.... I'm sure that's why you chose to convert.

-[Unknown]

[Yvette]

Thanks for the reply. The path View/Delete Members takes me to is:

http://www.vegweb.com/cgi/yabbse/index.php?board=1;action=viewmembers

There isn't anything in the errorlogs about this error.

I don't have a phpMyAdmin installed. Would it be php-config?

Yvette

[[Unknown]]

Works for me... I get:

"An Error Has Occurred!

You are not allowed to access this section"

However, you have quite a number of users on your board (14700)... perhaps you need to kill some of the old ones.  (that don't use the forum anymore...)

You can still access this manually by going to http://www.vegweb.com/cgi/yabbse/index.php?action=mlall and modifying their profiles.  (hit the delete button)

phpMyAdmin can be found at http://phpmyadmin.sourceforge.net/, and allows you to configure and play with MySQL through PHP.

-[Unknown]

[Yvette]

I got that message, too, when I logged of Admin, and go to the URL.

So you think perhaps 14,700 is to much for the script to handle, and that's why the error?  I've had that many people sign up since Dec 2001, after starting over from a 60,000 membership since 1996.  Is there a limit that YaBBSE/mysql, etc can handle (to the point where it slows things down or something)?

I'll look into setting up phpmyadmin - thanks for the link.

One other question, I had set the usernames of the previous YaBB 1.1 install to be case-senstive, and now since the conversion, some people are having trouble logging in. I take it that this YaBBSE doesn't use case-senisitive usernames, as I was able to log in as both YVETTE and Yvette.  Any suggestions?

Thanks,
Yvette

[[Unknown]]

No.... mySQL shouldn't have trouble with that many, it was just a thought.

BUT... this case sensitivity thing.... that is a problem.

That very well might be why you are having issues.

I don't know what you can do to fix that, however....

-[Unknown]

[Yvette]

2. UPDATE TABLE yabbse_member SET im_email_notify = 0
ALTER TABLE yabbse_member ALTER im_email_notify SET DEFAULT 0

3. Mistake in the converter, I guess...
UPDATE TABLE yabbse_member SET im_ignore_list = NULL

4. It stores it in MySQL.  I suggest using phpMyAdmin or something to access it. (with the above commands.)
It's not stored as files because this is MUCH slower.... I'm sure that's why you chose to convert.

-[Unknown]

I'm very much a newbie at this. I got phpMyAdmin set up, ran it and tried looking for UPDATE or SET in order to run the lines you listed above.  I also looked for a command line script.  Then I realized that the db.php used in mods for 1.5.0 issed commands that edited or added fields, so I put the above strings in a db.php (using yabbse_members instead of yabbse_member) and ran it from a browser.

ALTER TABLE yabbse_member ALTER im_email_notify SET DEFAULT 0 "worked" in this manner, but the others produced errors.  I'm probably going about this all wrong, so I'd appreciate any further direction that you could provide.

Also, it looks like the converter assigned 1/8/2003 (the day that I did the conversion) as a birthday for anyone who didn't have their birthday set.  See: http://www.vegweb.com/cgi/yabbse/index.php?action=viewprofile;user=veggie

When I enable the Calendar, and click on the link to it, my browser about crashes with the thousands of usernames listed on 1/8/2003 as having a birthday. I figure that I would have to set everyone's birthday value to null, using syntax similar to set the im_ignore_list to null.  Or is there a better way? Any ideas on what I'd do?

Yvette

[Yvette]

I read in one of the discussions about a mod to enter commands in "Run SQL query/queries on database yabbse "

So with the help of documentation, I did:

update yabbse_members set birthdate='0000-00-00' where birthdate like '2003-01-08';

I think it worked! I still have to go enabled the calendar & see.

Yvette

[[Unknown]]

Sorry, I think I made TWO typos....

the above update commands might work better as:

UPDATE yabbse_members SET im_email_notify = 0

UPDATE yabbse_members SET im_ignore_list = NULL

Sorry, basically every other command wants "TABLE" in there...

-[Unknown]