Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Please help? Deleted sessions file


WiseWombat

Recommended Posts

Hi is there any one that might have an idea how I can get myself out of this mess?

I installed phpmyadmin to delete sessions from my data base but I accidently deleted the file rather than emply it.

 

Here are some of the things Iv tried.

 

I have run my last database sql in mysql be it hasnt helped.

 

I have restored my system window xp to a number of earlier dates which did not work.

 

I have tried to replace my mysql file folder in programs files but it tells me that I

am unable to replace the file because it is protected and might be in use I dont know how to disablethis file so I can replace it?

 

I have unticked this file as it was read only but that hasnt help eather.

 

Could any please give me some advice is there any way to restore or replace what I have done.

 

Your help or any input what so ever will be greatly appreciated.

 

I do have a backup of mysql if that help, how do I replace it when the file is protected and in use?

 

Thanks Martin :'(

Here is the error and thanks again in advance.

 

1146 - Table 'wisewombat.sessions' doesn't exist

select value from sessions where sesskey = '8bc07cc6061fcaa50af33ff76bcd072f' and expiry > '1101557101'

[TEP STOP]

( WARNING )

I think I know what Im talking about.

BACK UP BACK UP BACK UP BACK UP

Link to comment
Share on other sites

When you say sessions file I am assuming that you really mean the sessions table from your database. If so go to phpmyadmin and run the following sql

 

CREATE TABLE `sessions` (

`sesskey` varchar(32) NOT NULL default '',

`expiry` int(11) unsigned NOT NULL default '0',

`value` text NOT NULL,

PRIMARY KEY (`sesskey`)

) TYPE=MyISAM;

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

When you say sessions file I am assuming that you really mean the sessions table from your database. If so go to phpmyadmin and run the following sql

 

CREATE TABLE `sessions` (

  `sesskey` varchar(32) NOT NULL default '',

  `expiry` int(11) unsigned NOT NULL default '0',

  `value` text NOT NULL,

  PRIMARY KEY  (`sesskey`)

) TYPE=MyISAM;

Thanks Richard

Your are a life saver I thought I would need to start from scratch.

Thats a aload of my mind it worked and thanks. :D

( WARNING )

I think I know what Im talking about.

BACK UP BACK UP BACK UP BACK UP

Link to comment
Share on other sites

Thanks Richard

Your are a life saver I thought I would need to start from scratch.

Thats a aload of my mind it worked and thanks. :D

 

No problem, glad it was such an easy fix.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...