Store is gone!!!!!!!!!!!!

[monkeyman]

I tried accessing my osc/admin page this morning to find that I get a session error and, no administration page. Then to my horror I went to my live store, and it is GONE with the same session error posted for all the public to see. What is going on?? How can I get my store back??

[boxtel]

I tried accessing my osc/admin page this morning to find that I get a session error and, no administration page. Then to my horror I went to my live store, and it is GONE with the same session error posted for all the public to see. What is going on?? How can I get my store back??

<{POST_SNAPBACK}>

well, what\'s the error ?

[monkeyman]

well, what\'s the error ?

<{POST_SNAPBACK}>

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

 

select value from sessions where sesskey = '605ef81b985bc97cb730bda9f7377cb3' and expiry > '1123760945'

 

[TEP STOP]

[boxtel]

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

 

select value from sessions where sesskey = '605ef81b985bc97cb730bda9f7377cb3' and expiry > '1123760945'

 

[TEP STOP]

<{POST_SNAPBACK}>

 

ah, that means that your index of the session table is corrupt, no big deal.

 

you can have your host repair that or do it yourself with your mysql management tool.

[Guest]

using phpmyadmin or mysql connector, attach to the database, then there is an option to 'repair' and select the specific table. while you are there, you may as well select all the tables and also 'optimize' all tables.

[monkeyman]

ah, that means that your index of the session table is corrupt, no big deal.

 

you can have your host repair that or do it yourself with your mysql management tool.

<{POST_SNAPBACK}>

[monkeyman]

ah, that means that your index of the session table is corrupt, no big deal.

 

you can have your host repair that or do it yourself with your mysql management tool.

<{POST_SNAPBACK}>

[boxtel]

<{POST_SNAPBACK}>

 

relax.

[monkeyman]

<{POST_SNAPBACK}>

Please walk me through this...I have attached the "osCommerce" database in mysql...what do I do next? A "query" or what? Thanks.

[Guest]

what are you using? you are going to have to give us detail, it does no one any good to walk you through something if you dont tell us what you are using.

in fact, you should use the internet search (your favorite) to find a tutorial on whatever application you have used to attach to the database, cuz if you 'muck' it up and you do not have a backup, well, you are .......

[monkeyman]

what are you using?  you are going to have to give us detail, it does no one any good to walk you through something if you dont tell us what you are using.

in fact, you should use the internet search (your favorite) to find a tutorial on whatever application you have used to attach to the database, cuz if you 'muck' it up and you do not have a backup, well, you are .......

<{POST_SNAPBACK}>

I am using phpMyAdmin

[Guest]

if you are using 'cpanel' once you select 'mysq' at the very top line of each database there is a repair button. you can use this to repair.

there also is an operations tab within phpmyadmin

[boxtel]

I am using phpMyAdmin

<{POST_SNAPBACK}>

 

select the session table, select operations, select repair table.

[monkeyman]

select the session table, select operations, select repair table.

<{POST_SNAPBACK}>

When I click on "operations", it just says:

 

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

 

Error

SQL-query:

 

SHOW COLUMNS FROM `sessions` FROM `osCommerce`

MySQL said:

 

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

 

...I notice that the "sessions" file in the database list states that it is "in use". Is this a clue as to what is going on?

[monkeyman]

When I click on "operations", it just says:

 

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

 

Error

SQL-query:

 

SHOW COLUMNS FROM `sessions` FROM `osCommerce`

MySQL said: 

 

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

 

...I notice that the "sessions" file in the database list states that it is "in use". Is this a clue as to what is going on?

<{POST_SNAPBACK}>

I just did a repair on the "sessions" file, and my storefront came back online...but I still cannot access the blue "administration" page (that has the online tools, etc.) where I access my orders. I have an order pending which is currently in limbo because I cannot get into this osc/admin page.

[boxtel]

When I click on "operations", it just says:

 

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

 

Error

SQL-query:

 

SHOW COLUMNS FROM `sessions` FROM `osCommerce`

MySQL said: 

 

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

 

...I notice that the "sessions" file in the database list states that it is "in use". Is this a clue as to what is going on?

<{POST_SNAPBACK}>

 

then I guess you will have to stop and restart Mysql.

[boxtel]

I just did a repair on the "sessions" file, and my storefront came back online...but I still cannot access the blue "administration" page (that has the online tools, etc.) where I access my orders. I have an order pending which is currently in limbo because I cannot get into this osc/admin page.

<{POST_SNAPBACK}>

 

so what is the error now ?

[monkeyman]

so what is the error now ?

<{POST_SNAPBACK}>

Everything seems to be OK now...THANKS TO ALL OF YOUR HELP, EVERYONE! The final "osc/admin" problem was simply the function of my browser not reloading a new version of the page from the point where I was having the problems earlier. Simply reloaded the page, and it came back.

Hurray for osCommerce! :lol:

[Guest]

I am have the same problem, with the session IN USE, plus the Whos_online is IN USE too.

 

I do not know much about databases.

 

What do you mean by

 

then I guess you will have to stop and restart Mysql.

 

I have shut down phpMyAdmin and restarted it and they still say IN USE