Search found 40 matches

by jsundqui
Wed Mar 19, 2008 1:59 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

Had a bust weekend with kids and work.

Just getting back to this now.

I rebuilt the index on phpb_auth_access using this command from the link in your sig:

REPAIR TABLE phpbb_auth_access USE_FRM;

Unfortunately, the problem remains...
by jsundqui
Wed Mar 12, 2008 4:41 pm
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

No duplicate entries. The only difference with the "test" group is that it is group_type "0" rather than group_type "2" which I believe is the difference between a hidden group and an open group. I tried changing the group type of both the test group and one of the hidden groups in the admin panel. ...
by jsundqui
Tue Mar 11, 2008 10:37 pm
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

Yes, separate MySQL servers (each local to its respective box). As I noted above, I had just done a database backup on the production server so I could load it onto my mirror to test the 22-23 upgrade with as close a mirror as possible (it's not truly a mirror, just snapshots updated periodically). ...
by jsundqui
Tue Mar 11, 2008 2:37 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

OK, gave that a try.

Got the default decorations, etc. after pasting over the clean 2.0.23 files.

However, still got duplicate entries on the groupcp.php!

This was on my mirror system on a linux box at home.

J.S.
by jsundqui
Mon Mar 10, 2008 2:38 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

OK, I can give that try tomorrow. As I mentioned earlier, I keep a mirror of the site on a linux box at home. That box exhibits the same behavior. I think I would prefer to try this there rather than on the production server. There's a new fresh 16 inches of snow on the ground and the folks on the b...
by jsundqui
Mon Mar 10, 2008 1:47 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

I ran the query, and the value for hits is "1" for all group_id's.

Haven't edited any templates recently. Last time I edited a template was when I added in the disclaimer at the top of the forum index page (index_body.tpl)

J.S.
by jsundqui
Sun Mar 09, 2008 1:51 pm
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

Actually, that site you are looking at is not my site. I was the second poster to this thread (I always check to see if someone had the same problem - and solution - before. This time I only found the problem). My site is http://www.wnymba.org/index.php the groupcp page is http://www.wnymba.org/grou...
by jsundqui
Sun Mar 09, 2008 3:35 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

I see you replied before I edited that sentence out! My bad. I wrote that, then checked the script and wrote the later sentence saying so, but for got to delete my previous sentence! :mrgreen: I have not fixed anything else lately. I sure wish I had tried groupcp.php before I did the upgrade to see ...
by jsundqui
Sun Mar 09, 2008 3:26 am
Forum: 2.0.x Support Forum
Topic: mod_rewrite for spam/hack efforts in the URL
Replies: 5
Views: 153

Re: mod_rewrite for spam/hack efforts in the URL

The portal.php (again, I realize this is not phpBB, per se) accepts strings to redirect to some static pages separate from the board. But as far as I can tell, I am safe because there are only several specific static pages that it can go to. I guess I will just ignore these attacks for now. But ther...
by jsundqui
Sun Mar 09, 2008 3:20 am
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

Thanks for your suggestions. I checked out your sig. I ran the commands you suggested in phpMyAdmin. no dice. I uploaded your script and ran it. It came back with OK's on all tables. I tried running the old groupcp.php (version *.22) but got the same response. I even put the groupcp.php file from th...
by jsundqui
Sun Mar 09, 2008 2:42 am
Forum: 2.0.x Support Forum
Topic: mod_rewrite for spam/hack efforts in the URL
Replies: 5
Views: 153

Re: mod_rewrite for spam/hack efforts in the URL

Thanks. I've got the spammers pretty much at bay after putting in a couple of the suggestions "in the sticky" a couple of years ago, including a twist of my own I coded in that requires registrants to actually know something about the board's subject matter. No spam registrations in over a year now....
by jsundqui
Sat Mar 08, 2008 9:29 pm
Forum: 2.0.x Support Forum
Topic: Group table corrupted?
Replies: 19
Views: 553

Re: Group table corrupted?

OK, I know this post is three years old, but I am experiencing the same problem after upgrading from 2.0.22 to 2.0.23

Did anyone have a solution. I see Moustacy got his problem fixed, although the test page is NSFW!
by jsundqui
Sat Mar 08, 2008 5:34 pm
Forum: 2.0.x Support Forum
Topic: mod_rewrite for spam/hack efforts in the URL
Replies: 5
Views: 153

mod_rewrite for spam/hack efforts in the URL

I've used mod_rewrite for a while to guard against the common hack attempts, although the syntax is quite taxing. For example, for a while, I have been guarding against (a now old) SQL injection hack with the following in my .htaccess file: RewriteCond %{QUERY_STRING} ^(.*)highlight=\%2527 [OR] Rewr...
by jsundqui
Fri Sep 15, 2006 2:06 am
Forum: 2.0.x Support Forum
Topic: Deleted users by phpMyAdmin (wrong). Now how to fix?
Replies: 4
Views: 349

I did the DB maintenance MOD which worked well. Deleted a number of empty groups that were about the number of records I think I deleted ham handedly with phpmyadmin from users. Then I ended up putting in this MOD: http://www.phpbb.com/phpBB/viewtopic.php?t=404113 Which makes it much easier to delet...
by jsundqui
Fri Sep 08, 2006 2:00 am
Forum: 2.0.x Support Forum
Topic: Deleted users by phpMyAdmin (wrong). Now how to fix?
Replies: 4
Views: 349

Thanks for the tips. I always try stuff like this on my (not up to date) mirror of my site on my home linux box first. It will take a while to back up, and transfer the database over, etc. etc. I've got a day job, so I will get to this Saturday instead and let you know how it goes. Meanwhile, it loo...

Go to advanced search