Lyoko Freak: 2005 - 2015. Return to the past now....

It is currently Sat Apr 27, 2024 3:54 pm

Sessions Errors

Forum and website news. This forum can contain important information that concerns you, so make sure you read our updates.

Moderators: The Administrators, Moderators


Sessions Errors

Postby Star Way » Tue Feb 14, 2006 5:53 pm

I don't know what happened, but everything got all messed up suddenly and... yeah. Hadda go mess around with the database and fix things.

Vchat20 saved the day again, though. Go kiss his shoes, please. I know I am.

Any bugs on any of your ends now, though? (Besides the fact that all the forums that you hadn't read yet are flagged as the opposite.)
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Lotho » Tue Feb 14, 2006 6:18 pm

*clap, clap, Vchat*

What did you have to do to fix it? The only error I saw was a duplicate entry error. (Which is wierd but should have timed out). Do you know what the error was?
User avatar
Lotho offline
Jeremie's Assistant
Jeremie's Assistant
 
Posts: 358
Joined: Sat Jul 16, 2005 4:11 am

Postby Star Way » Tue Feb 14, 2006 6:27 pm

From an email I received wrote:[Edited for security reasons]


For now, I've just gone into phpMyAdmin and deleted everything in the Sessions table. Vchat has pointed me towards a more permanent fix, however, and I'm working on that right now.
Last edited by Star Way on Wed Feb 15, 2006 5:35 pm, edited 1 time in total.
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby TB3 » Tue Feb 14, 2006 6:48 pm

What exactly went wrong? I mean what were the 'physical' effects.
LORD HIGH TRANSLATOR!

Joined Sept. 16th 2005, Post Tally 6423 (as of January 21st 2010)
User avatar
TB3 offline
Site Admin
Site Admin
 
Posts: 5467
Joined: Wed Dec 07, 2005 8:49 pm
Location: Knee-deep in Italian pronouns

Postby Lotho » Tue Feb 14, 2006 6:48 pm

What do you mean "a more permenant fix"? That is is the first time I have seen that happen on this forum and I don't exactly see any reason why it might happen again.
User avatar
Lotho offline
Jeremie's Assistant
Jeremie's Assistant
 
Posts: 358
Joined: Sat Jul 16, 2005 4:11 am

Postby Star Way » Tue Feb 14, 2006 6:54 pm

TB3 wrote:What exactly went wrong? I mean what were the 'physical' effects.


Beyond the error message, I really have no clue.

(One day I will learn PHP and MySQL, I swear. xD)

LothoFoxburr wrote:What do you mean "a more permenant fix"? That is is the first time I have seen that happen on this forum and I don't exactly see any reason why it might happen again.


I don't know anything more than what he told me... This link may give you answers, though: http://www.phpbb.com/phpBB/viewtopic.php?t=365289
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Lyokofreak » Tue Feb 14, 2006 6:58 pm

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '141' for key 2

[Edited for security reasons]

Line : 189
File : sessions.php

is exactly what i got

I actually ran outside my house in my boxers yelling NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

Star Way wrote:
TB3 wrote:What exactly went wrong? I mean what were the 'physical' effects.


Beyond the error message, I really have no clue.

(One day I will learn PHP and MySQL, I swear. xD)

LothoFoxburr wrote:What do you mean "a more permenant fix"? That is is the first time I have seen that happen on this forum and I don't exactly see any reason why it might happen again.


I don't know anything more than what he told me... This link may give you answers, though: http://www.phpbb.com/phpBB/viewtopic.php?t=365289


You cant try to make an HTML based forum? *Does that exist?* even though its oooooold
Last edited by Lyokofreak on Tue Feb 14, 2006 7:07 pm, edited 1 time in total.
How to write an infinite Jesus pwns loop in PHP:
while($_SERVER[PHP_SELF])
{
echo "Jesus pwns!";
}
User avatar
Lyokofreak offline
Star Fighter
Star Fighter
 
Posts: 1123
Joined: Sun Oct 09, 2005 10:41 am

Postby Star Way » Tue Feb 14, 2006 7:06 pm

LyoKoHaCk wrote:phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1062 Duplicate entry '141' for key 2

[Edited for security reasons]

Line : 189
File : sessions.php

is exactly what i got

I actually ran outside my house in my boxers yelling NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO


xDD;

Well, it's fixed now. So put some pants on and come back inside. :)
Last edited by Star Way on Wed Feb 15, 2006 5:34 pm, edited 1 time in total.
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Lyokofreak » Tue Feb 14, 2006 7:07 pm

Phew!
*runs inside*
Since this error has been corrected, is it locking time?
How to write an infinite Jesus pwns loop in PHP:
while($_SERVER[PHP_SELF])
{
echo "Jesus pwns!";
}
User avatar
Lyokofreak offline
Star Fighter
Star Fighter
 
Posts: 1123
Joined: Sun Oct 09, 2005 10:41 am

Postby Star Way » Tue Feb 14, 2006 7:12 pm

Ehh. I really only lock things in Site News when the threads get so out of control that there's no hope of ever getting back on topic. :P
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Lotho » Tue Feb 14, 2006 7:17 pm

TB3 wrote:What exactly went wrong? I mean what were the 'physical' effects.

I think that the phpbb_sessions table just had a little bug that allowed it to clog up. By cleaning it out it unclogged it which allowed people to log in.

Star Way wrote:I don't know anything more than what he told me...

Propaganda! :D

LyoKoHaCk wrote:You cant try to make an HTML based forum? *Does that exist?*

You wouldn't be able to post...or do almost anything you use a forum for actually...
User avatar
Lotho offline
Jeremie's Assistant
Jeremie's Assistant
 
Posts: 358
Joined: Sat Jul 16, 2005 4:11 am

Postby Overcaffeinated Sloth » Tue Feb 14, 2006 7:21 pm

Ehh, not to be picky, or off topic, but I thouthg VChat was a guy...

Overcaffeinated Sloth offline
 

Re: Sessions Errors

Postby DarkestSoul X21 » Tue Feb 14, 2006 7:27 pm

Star Way wrote:I don't know what happened, but everything got all messed up suddenly and... yeah. Hadda go mess around with the database and fix things.

Vchat20 saved the day again, though. Go kiss his shoes, please. I know I am.

Any bugs on any of your ends now, though? (Besides the fact that all the forums that you hadn't read yet are flagged as the opposite.)


whew, i been trying to get in for about 6 hours. Thanks Vchat20
Joined in 2005, left 2008, came back July 2011

Used to been XANAcomputer/lyokolover.
User avatar
DarkestSoul X21 offline
Lyoko Freak
Lyoko Freak
 
Posts: 3423
Joined: Sun Oct 30, 2005 8:27 pm
Location: Somewhere

Postby Star Way » Tue Feb 14, 2006 7:52 pm

...Ladies and gentlemen, this is your captain speaking... and we are still experiencing some technical difficulties, apparently.

UGH.

So I ran repair.php and stuff and now it's working, but I'm really ticked off anyway.
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Chad Rains » Tue Feb 14, 2006 7:58 pm

Now lets hope this is done and over with. Nasty bug imo. Even I am fairly confused as to what causes the problem. But it does seem to be widespread as a search of the phpbb forums show.
User avatar
Chad Rains offline
Lyoko Team Member
Lyoko Team Member
 
Posts: 808
Joined: Fri Nov 25, 2005 1:41 am
Location: Ressorts de Fleur Apartments outside of Kadic

Postby MY85 » Tue Feb 14, 2006 7:59 pm

From an email Star Way received wrote:[Edited for security reasons]


I got that, and by midday I got the other thing that says you can't access LF... something with the server... /home/kale/daisy... can't remember it well.
Lani wrote:Eh, in the end, people (real or cartoon) are naked and having a good time. What's wrong with that?
User avatar
MY85 offline
Senior Member
Senior Member
 
Posts: 11339
Joined: Sat Apr 23, 2005 9:11 pm

Postby Star Way » Tue Feb 14, 2006 8:23 pm

Everyone got that error. The details are no longer important.

*sigh* PhpBB... When I first got it, I had noted a post at the offical forum: "Known for being buggy."

I wondered what it meant. xD
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby Lotho » Tue Feb 14, 2006 8:32 pm

The funny thing is that with everyone is posting there ssid. Which sometimes could be used to hijack an account. ...Not that anyone but me thinks that way *feels ostracized*...
User avatar
Lotho offline
Jeremie's Assistant
Jeremie's Assistant
 
Posts: 358
Joined: Sat Jul 16, 2005 4:11 am

Postby MY85 » Tue Feb 14, 2006 8:36 pm

LothoFoxburr wrote:The funny thing is that with everyone is posting there ssid.


ssid? :umm:

LothoFoxburr wrote:Which sometimes could be used to hijack an account. ...Not that anyone but me thinks that way *feels ostracized*...


Somehow, it made me think of what happened to TB3's account... although, that's another story...
Lani wrote:Eh, in the end, people (real or cartoon) are naked and having a good time. What's wrong with that?
User avatar
MY85 offline
Senior Member
Senior Member
 
Posts: 11339
Joined: Sat Apr 23, 2005 9:11 pm

Postby Chad Rains » Tue Feb 14, 2006 8:37 pm

yeah, but with all the clearing of the sessions table thats been going on, all these session ids are pretty much moot. :P
User avatar
Chad Rains offline
Lyoko Team Member
Lyoko Team Member
 
Posts: 808
Joined: Fri Nov 25, 2005 1:41 am
Location: Ressorts de Fleur Apartments outside of Kadic

Postby Lotho » Tue Feb 14, 2006 9:21 pm

Vchat 2.0 wrote:yeah, but with all the clearing of the sessions table thats been going on, all these session ids are pretty much moot. :P


True, when the session table was wiped all the ssid's were erased and reassigned.
User avatar
Lotho offline
Jeremie's Assistant
Jeremie's Assistant
 
Posts: 358
Joined: Sat Jul 16, 2005 4:11 am

Postby Jazzy Josh » Tue Feb 14, 2006 9:29 pm

the really sad thing is that I had just logged in when it happened......hm......sessions......could I have accidentally caused it???
Image

@Jazzy Josh on Twitter.
User avatar
Jazzy Josh offline
Lyoko Team Member
Lyoko Team Member
 
Posts: 811
Joined: Sat Sep 24, 2005 2:49 am
Location: Western Carolina University

Postby Star Way » Wed Feb 15, 2006 5:32 pm

No. Don't worry. :)

This was just another glitch.

Edit: I think that, just to be safe, I'm going to listen to what Lotho is saying and remove the error messages from everyone's posts. ^^
Don't bother sending me messages or anything, I'm not in charge of the site anymore.

But I do love dancing.
User avatar
Star Way offline
Founder & Site Admin
Founder & Site Admin
 
Posts: 4919
Joined: Fri Apr 22, 2005 9:02 pm

Postby comex » Wed Feb 15, 2006 9:36 pm

Maybe something like
Code: Select all
 alter table phpbb_sessions drop primary key;

would work? That would allow there to be more than one session with the same id, but if it's accidentally adding sessions twice, why not let that happen and avoid the error? :P

comex offline
Popular Kid
Popular Kid
 
Posts: 145
Joined: Sat Nov 26, 2005 10:21 pm


Who is online

Users browsing this forum: No registered users and 85 guests