|
|
| Author |
Message |
Divvy
New User
Joined: 03 May 2007
Posts: 21
|
 Posted: July 28th 2008, 10:59 am Post subject: phpbb2mysql_t problems |
 |
|
Hi everyone,
Well, I know that phpbb 2.* ends, but I really need support on a little thing.
I and my users are getting some issues with the cookie called phpbb2mysql_t
Because when we read some posts, that cookie line goes bigger and bigger and sometimes I got this error:
| Quote:
|
Bad Request
Your browser sent a request that this server could not understand.
Size of a request header field exceeds server limit.
Cookie: phpbb2mysql_t=a%3A10%3A3A209951%3Bi%3A1217262239%3Bi%3A68300%3Bi%3A1217262244%3Bi%3A188834%3Bi%3A1217262727%3Bi%3A188833%3Bi%3A1217262736%3Bi%3A188836%3Bi%3A1217263316%3Bi%3A188715%3Bi%3A1217263744%3B%7D...........................................
Apache/1.3.41 Server at server.mysite.com Port 80
|
(I removed some values for security)
Can someone tell me how can I fix this? I know if I delete my browser cookies it works, but I want to prevent this... |
|
| Back to top |
|
 |
Ptirhiik
Dedicated User
Joined: 21 Jan 2003
Posts: 1404
|
| Posted: July 28th 2008, 11:41 pm Post subject: |
|
|
| What mods are you using ? |
|
| Back to top |
|
|
Divvy
New User
Joined: 03 May 2007
Posts: 21
|
| Posted: July 31st 2008, 6:40 pm Post subject: |
|
|
| Ptirhiik wrote:
|
|
What mods are you using ?
|
Thank you so much for your reply Ptirhiik 
Here it is...
Your board's URL: here
Version of phpBB2: 2.0.23
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)? fresh install, but db was imported from other forum with version 2.0.22 (then upgrade to 2.0.23)
Did you use an automated wizard provided by your host to install phpBB? No
MODs you have installed: Forum Permissions List 1.0.1, Rebuild Search 2.4.0, Post Count Resync 1.2.1, Log Actions MOD 1.1.6, Ban reason, Simple subforums 1.0.2, eXtreme Styles 2.4.0, Signatures control 1.2.4, Simply Merge Threads 1.0.1, DB Maintenance 1.3.8
When the problem started: from the beginning
Your level of expertise (be honest): good
Template(s) used: Subsilver
Language(s) used: portuguese/english
Version of PHP used: 4.4.8
Database and version used: 5.0.51a-community-log
What could be? This is very annoying... I need always to delete my cookies
I tried to replace current includes/sessions.php with the original and got the same problem.
So, the problem isn't in that file.
And I did a test.
I installed a fresh phpbb 2.0.23 and in the config.php I have put the other db details.
Well, got the same problem in there.
So, I think that this tell me that I dont have any problem in my files... maybe the problem is in DB? Is possible? If yes, where? I told above that I have imported my db from other forum.... maybe have some issue... but how to find?
Ive made a backup of my db though cpanel (Backups).
Here´s the header of my sql file:
| Code:
|
-- MySQL dump 10.11
--
-- Host: localhost Database: mula_maxpt
-- ------------------------------------------------------
-- Server version 5.0.51a-community-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `phpbb_auth_access`
--
DROP TABLE IF EXISTS `phpbb_auth_access`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpbb_auth_access` (
`group_id` mediumint(8) NOT NULL default '0',
`forum_id` smallint(5) unsigned NOT NULL default '0',
`auth_view` tinyint(1) NOT NULL default '0',
`auth_read` tinyint(1) NOT NULL default '0',
`auth_post` tinyint(1) NOT NULL default '0',
`auth_reply` tinyint(1) NOT NULL default '0',
`auth_edit` tinyint(1) NOT NULL default '0',
`auth_delete` tinyint(1) NOT NULL default '0',
`auth_sticky` tinyint(1) NOT NULL default '0',
`auth_announce` tinyint(1) NOT NULL default '0',
`auth_vote` tinyint(1) NOT NULL default '0',
`auth_pollcreate` tinyint(1) NOT NULL default '0',
`auth_attachments` tinyint(1) NOT NULL default '0',
`auth_mod` tinyint(1) NOT NULL default '0',
KEY `group_id` (`group_id`),
KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `phpbb_auth_access`
--
|
Here´s the sessions table:
| Code:
|
--
-- Table structure for table `phpbb_sessions`
--
DROP TABLE IF EXISTS `phpbb_sessions`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpbb_sessions` (
`session_id` char(32) NOT NULL default '',
`session_user_id` mediumint(8) NOT NULL default '0',
`session_start` int(11) NOT NULL default '0',
`session_time` int(11) NOT NULL default '0',
`session_ip` char(8) NOT NULL default '0',
`session_page` int(11) NOT NULL default '0',
`session_logged_in` tinyint(1) NOT NULL default '0',
`session_admin` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `session_user_id` (`session_user_id`),
KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `phpbb_sessions`
--
LOCK TABLES `phpbb_sessions` WRITE;
/*!40000 ALTER TABLE `phpbb_sessions` DISABLE KEYS */;
INSERT INTO `phpbb_sessions` (`session_id`, `session_user_id`, `session_start`, `session_time`, `session_ip`, `session_page`, `session_logged_in`, `session_admin`) VALUES ('removed by me);
/*!40000 ALTER TABLE `phpbb_sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phpbb_sessions_keys`
--
DROP TABLE IF EXISTS `phpbb_sessions_keys`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `phpbb_sessions_keys` (
`key_id` varchar(32) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`last_ip` varchar(8) NOT NULL default '0',
`last_login` int(11) NOT NULL default '0',
PRIMARY KEY (`key_id`,`user_id`),
KEY `last_login` (`last_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
|
And the footer:
| Code:
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2008-07-30 9:47:58
|
|
|
| Back to top |
|
|
Ptirhiik
Dedicated User
Joined: 21 Jan 2003
Posts: 1404
|
| Posted: August 1st 2008, 12:11 am Post subject: |
|
|
I don't think it is due to the db. Actually, it is a cookie problem: *_t cookie is used to store the topic ids (plus their last post time) you have read during the current session, to drop the unread flag on index/viewforum/viewtopic, so the unread topics shown are all created/replied since last visit minus the ids present in the cookie. This cookie has no duration (eg it is supposed to vanish as soon as you close the browser), and their it doesn't seem to do so. The error probably reflects an oversized number of chars for the cookie capacity. Check in viewtopic if it changed in some way compared to the originals scripts.
Note this effect can also be due to a not correctly defined server information in acp/config: eg not the correct cookie domain, or not the correct server domain. ie, if your board is settled @ forum.foo.com & www.foo.com/forum, the cookie domain has to be: .foo.com (dot in front, no sub-domain). A good idea is also to not let the default phpBB cookie name (phpmysql) : as phpBB per default doesn't set correct parameters (no domain, so the cookie is visible to all domains), cookies can be mixed with other domains also not correctly defined. |
|
| Back to top |
|
|
Divvy
New User
Joined: 03 May 2007
Posts: 21
|
| Posted: August 2nd 2008, 2:49 pm Post subject: |
|
|
| Ptirhiik wrote:
|
|
I don't think it is due to the db. Actually, it is a cookie problem: *_t cookie is used to store the topic ids (plus their last post time) you have read during the current session, to drop the unread flag on index/viewforum/viewtopic, so the unread topics shown are all created/replied since last visit minus the ids present in the cookie. This cookie has no duration (eg it is supposed to vanish as soon as you close the browser), and their it doesn't seem to do so. The error probably reflects an oversized number of chars for the cookie capacity. Check in viewtopic if it changed in some way compared to the originals scripts.
|
I only told that could be a db problem because I tested that db in a fresh phpbb install with all original files and got the same problem. |
|
| Back to top |
|
|
Ptirhiik
Dedicated User
Joined: 21 Jan 2003
Posts: 1404
|
| Posted: August 4th 2008, 11:49 am Post subject: |
|
|
So it seems to lead you to the second paragraph of my reply  . |
|
| Back to top |
|
|
Divvy
New User
Joined: 03 May 2007
Posts: 21
|
| Posted: August 5th 2008, 5:48 am Post subject: |
|
|
Here is the config in my ACP:
General config:
Cookies config:
P.S. Cookie domain is .mula-da-cooperativa.com |
|
| Back to top |
|
|
Ptirhiik
Dedicated User
Joined: 21 Jan 2003
Posts: 1404
|
| Posted: August 5th 2008, 11:22 am Post subject: |
|
|
| Change the cookie name to another one (a single word), and check if it still happens. If yes, it means there is a problem in the scripts, if no it means the cookies were used by another board on the same domain using the same cookie name. |
|
| Back to top |
|
|
|
Forums
Home
Register
Profile
Log in to check your private messages
Log in
FAQ
Search
Contact
Us 
