Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Sessions" gone in SQL


pocoyo34

Recommended Posts

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 !!!

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...