Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

session file missing - now site not working!!!


cpo

Recommended Posts

hello,

 

i got hit with a bucket load of spam through email which send my webspace over the limit and i suspect corrupted my database

 

my home page now displays:

 

1146 - Table 'computerpartsonline_com_au_-_store.sessions' doesn't exist

 

select value from sessions where sesskey = '7fd1b56001b390b9f007e602ae34c837' and expiry > '1139894326'

 

 

[TEP STOP]

 

 

when i logon to myphp the sessions file is missing!! can this be replaced - or does the whole thing need to be re-installed?

 

thanks for you help

Meek

Link to comment
Share on other sites

Here's the db load data from oscommerce.sql

 

DROP TABLE IF EXISTS sessions;

CREATE TABLE sessions (

sesskey varchar(32) NOT NULL,

expiry int(11) unsigned NOT NULL,

value text NOT NULL,

PRIMARY KEY (sesskey)

);

 

You can just run that in phpMyAdmin. The table is initially empty.

Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux

Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...