Could not delete stale confirm data???

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Could not delete stale confirm data???

Post by KToadd » Wed Oct 01, 2008 11:58 pm

Every time someone tries to register on the forum, they get: "Could not delete stale confirm data" And that's it, no other error/debug message.

www.bluetongueskinks.net/forum

Please help! It's been this way for several days and doesn't seem to be working itself out like some errors.

User avatar
Dog Cow
Registered User
Posts: 2495
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: Could not delete stale confirm data???

Post by Dog Cow » Thu Oct 02, 2008 12:25 am

Yeah, that kills the registration feature on a lot of phpBB 2 forums.

If you don't have it on, edit the includes/constants.php file and set the DEBUG constant to a 1. That will give a more precise error message as to what is wrong.

AND/OR

via the MySQL monitor, phpMyAdmin, or some other utility, try running a query such as

Code: Select all

REPAIR TABLE phpbb_confirm;
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Thu Oct 02, 2008 4:21 am

Ran that code in the SQL tab..didn't seem to do the trick.

I'm not sure how to do your other suggestion...this is so frustrating! I can make webpages, but can't figure out this forum stuff worth a lick! Did I copy/paste that code into the right spot? Went to PHPmyadmin and pasted and submitted it in the SQL tab...

User avatar
Dog Cow
Registered User
Posts: 2495
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: Could not delete stale confirm data???

Post by Dog Cow » Thu Oct 02, 2008 2:10 pm

KToadd wrote:Ran that code in the SQL tab..didn't seem to do the trick.

I'm not sure how to do your other suggestion...this is so frustrating! I can make webpages, but can't figure out this forum stuff worth a lick! Did I copy/paste that code into the right spot? Went to PHPmyadmin and pasted and submitted it in the SQL tab...
Well, it sounds like you did the SQL thing correctly.

For the debug thing, open the file /includes/constants.php and right near the top, look for this:

Code: Select all

if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
}

// Debug Level
//define('DEBUG', 1); // Debugging on
define('DEBUG', 1); // Debugging off
Notice there are two lines which look the same, but one has two slashes in front like //. That means 'comment' and the code will not be executed. So, the second line is the line that counts. Yours is probably set like this:

Code: Select all

define('DEBUG', 0); // Debugging off
0 means off, so the debug messages will never display. What you want to do is change that 0 to a 1, then save the file. Now, the full debug error message should appear and we can see exactly what is wrong.
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Fri Oct 03, 2008 12:01 am

What in the world, all I see when I open the source to http://bluetongueskinks.net/forum/inclu ... stants.php is "Hacking attempt" -- is there a special way to open PHP files?

User avatar
ric323
Former Team Member
Posts: 22909
Joined: Tue Feb 06, 2007 12:33 am
Location: Melbourne, Australia
Name: Ric
Contact:

Re: Could not delete stale confirm data???

Post by ric323 » Fri Oct 03, 2008 3:42 am

KToadd wrote:What in the world, all I see when I open the source to http://bluetongueskinks.net/forum/inclu ... stants.php is "Hacking attempt" -- is there a special way to open PHP files?
"Open" does not mean "browse to".
You must download the file from your website to your PC using FTP, edit the file on your PC, then upload it back to your website using FTP again.
The Knowledge Base contains solutions to many common problems!
How to fix "Doesn't have a default value" and "Incorrect string value: xxx for column 'post_text' " errors.
How to do a clean re-install of the latest phpBB3 version.
Problems with permissions? Read phpBB3 Permissions

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Fri Oct 03, 2008 6:39 am

Great -- did it! Holy COW. See all those crazy numbers, there was about a million pages worth, so I cut it down. What do you think??



Could not delete stale confirm data

DEBUG MODE

SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes

DELETE FROM phpbb_confirm WHERE session_id NOT IN ('0000615ce3f66f97a95d6dd809248824', '0000daa7d329c0150fbab3cbcf676699', '00013b42c4500cf0de316704abaf3bb1', '0002042d73a9800ce8c85563b760dc36', '000c96a53b6ff8c563f09de2546ce55b', '0011b0cb47cdfa839d6339f9be7e9428', '0012e291676739fc3ca4775efae11002', '00138b76093c83c139dfab5e65eed64f', '0013d49cf344852b0aaacc87d2a7efb8', '0016c9dca06d3abc764597542371bbf5', '001b35d0a1f84b07c0840b4c606ff6ac', '001eab9acdc0330bc1e5261ee19065a2', '0020f6f64869c0a603a562ec72d0bd27', '00215bbe1502cfc82bf497a4d2d62b35', '0021dfae9bf2e6f19dfd25090cd893dd', '

Line : 1177
File : usercp_register.php

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Fri Oct 03, 2008 6:57 pm

Any ideas?

User avatar
3Di
Former Team Member
Posts: 14494
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Could not delete stale confirm data???

Post by 3Di » Fri Oct 03, 2008 8:02 pm

Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
✒️ Black Friday 2019 @ The Studio ▪️◾️

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: Could not delete stale confirm data???

Post by espicom » Sat Oct 04, 2008 2:07 am

It indicates that you have a busy board, and that your host has set a small size on packets being exchanged between MySQL and the world. The query is trying to clean up the confirm table, but it is also trying to preserve any entries that MIGHT be applicable to a current user session...

First thing to do is to truncate the phpbb_confirm table, which will clean out any stale data. The ultimate fix is to modify the query to rely solely on time, rather than active sessions, in clearing out old stuff. I think someone already made that MOD some time ago, but I'll have to look for it.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Sat Oct 04, 2008 5:19 am

Wow, I don't understand any of that... :oops: :oops: :oops:

Any step by step instructions? Thank you very much for answering by the way.

espicom
Registered User
Posts: 17905
Joined: Wed Dec 22, 2004 1:14 am
Location: Woodstock, IL

Re: Could not delete stale confirm data???

Post by espicom » Sat Oct 04, 2008 9:53 pm

In phpmyadmin, select the phpbb_confirm table. Click on the EMPTY button (not Drop!). This will ask you if you really want to TRUNCATE the table (that word is important! Do NOT say yes if it says DROP!).

That's step one.

Step two is harder, because it requires a modification to phpBB. And I'm not sure I still have my link to the fix. Ultimately, the problem is the host has restricted the communication packet size too far for how busy your board is, and you have to work around it.
Jeff
Fixing 1016/1030/1034 Errors | (obsolete link) | MySQL 4.1/5.x Client Error | phpBBv2 Logo in ACP
Support requests via PM are ignored!
"To be fully alive is to feel that everything is possible." - Eric Hoffer

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Sun Oct 05, 2008 7:43 am

I was easily able to truncate, thanks for the step by step. Didn't do the trick -- if you're able to provide step by step for the next part, I can do it! I can edit files through FTP just fine. Thanks -- I'm getting desperate!

User avatar
Dog Cow
Registered User
Posts: 2495
Joined: Fri Jan 28, 2005 12:14 am
Contact:

Re: Could not delete stale confirm data???

Post by Dog Cow » Sun Oct 05, 2008 7:10 pm

TRUNCATE the phpbb_sessions table as well. It will log everyone out, but it should fix the problem, at least temporarily.
Moof!
Mac GUI Vault: Retro Apple II & Macintosh computing archive.
Inside Allerton bookMac GUIMac 512K Blog

KToadd
Registered User
Posts: 104
Joined: Tue Feb 17, 2004 6:04 pm

Re: Could not delete stale confirm data???

Post by KToadd » Sun Oct 05, 2008 7:26 pm

Wow, that did the trick! How long should this last? Anyone have ideas for a long term fix?

I really appreciate people donating their time.

Locked

Return to “2.0.x Support Forum”