Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Sessions" gone in SQL


pocoyo34

Recommended Posts

Posted

Hello everybody,

HELP ... I need somebody ...

I've shut down my "sessions" in the "phpmyadmin" backend ... Is there someone out there who can give me a screenshot of the original table values ? I cannot login to my admin panel ...

Thanks a lot !!!

 

Posted

What do you mean "shut down"? Did you DROP the table and need to re-create it? That is

DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
  sesskey varchar(128) NOT NULL,
  expiry int(11) unsigned NOT NULL,
  value text NOT NULL,
  PRIMARY KEY (sesskey)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

That's the 2.3.4.1BS Frozen version. Other versions may vary slightly.

To empty out a table, you TRUNCATE it, not DROP it. The exact command name may vary by phpMyAdmin version.

Posted

Mr. Phil,

That was exactly the thing I was looking for :) thank you so much !
This is a moment in which I believe in oscommerce and it's community !

Have a nice weekend

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...