Doh! Dropped sessions table - need HELP!

[Guest]

All,

 

I had the error below but instead of repairing the table I dropped it. Now I'm really hosed. Can anyone help by supplying the keys and keys information so I can rebuild the sessions table by hand? Sucks to be me...

 

 

 

1016 - Can't open file: 'sessions.MYI'. (errno: 145)

 

select value from sessions where sesskey = '05e2eeb8a7d70291319bd8b86c5b2037' and expiry > '1124233226'

 

[TEP STOP]

 

 

Thanks,

Todd

[Guest]

I've created the three keys but I know I don't have the key type nor attributes correct. Knowing that would be a HUGE help.

 

value

sesskey

expiry

 

 

Thanks,

Todd

[AlanR]

I've created the three keys but I know I don't have the key type nor attributes correct. Knowing that would be a HUGE help.

 

value

sesskey

expiry

Thanks,

Todd

<{POST_SNAPBACK}>

How's this?

 

[Guest]

Alan,

 

Perfect! Thanks a lot. Also dug around a bit and found it in upgrade_3.php:

 

osc_db_query("create table sessions (sesskey varchar(32) not null, expiry int(11) unsigned not null, value text not null, primary key (sesskey))");

 

 

Thanks again!

 

Todd

[Guest]

All,

 

Well my saga continues. Users now cannot login. At first I was seeing the 1062 - Duplicate entry error for sesskey I believe. Now nothing happens when I try to login. Session keys are entered into the table but the entire site still thinks I'm a guest. I try to add something to the cart, the cart remains empty. I try to login and access my account, nothing. So it seems that there may be something else going on here with the sessions table (or maybe something else). I've emptied the table as well as have truncated it. No luck.

 

Any ideas where I can look next?

 

Thanks,

Todd

[Guest]

Also, I don't know that I've ever seen where the session ID is always in the URL. After I've supposedly logged in I see this when I redirected back to the main index page. It also remains there when I click to create a new account. The sessions table starts filling up quickly with just me testing this. Lots of sessions.

 

osCsid=f2a90db165259a72023635bb171be62c

 

 

I emptied the sessions and whosonline tables, I logged in, and noticed that there were 4 new entries in the sessions table for just my single login. This can't be right. Is there a setting / config somewhere which controls this?

 

 

Todd

[AlanR]

Did you make sure and set sesskey as the primary key? Just a thought because I probably made my screen shot a little too small and clipped that. It is underlined in the one I posted which indicates it's the primary key.

[Guest]

Yes, the sesskey is primary. I also saw that in the code which created the table.

 

Keyname Unique Field Action

PRIMARY Yes sesskey Drop

 

 

I just edited my previous post where I see 4 sessions tables entries for a single login. This can't be right.

 

 

Thanks,

Todd

[AlanR]

Well, what I would do is export the database or just that table and check it against the stock osC demo db.

 

While you do that you may well find something you never thought of.

[Guest]

Good suggestion. Will compare the two and see where there might be a diff.

 

Thanks,

Todd

[Guest]

OK, I'm back in action. Dumping the sessions table structure from the sample DB and recreating it in my DB worked. Users can now login.

 

Question, though. I can't recall if the session ID always appeared in the page address. I'll get the page URL followed by the osCsid= even after I logout. Is this expected?

 

http://.../blah/.../index.php?osCsid=6401d3cc309968b7025ad171b92988a0

 

Thanks,

Todd