Help! Error keeps showing up

[llz925]

So I have not modified ANYTHING for weeks in the catalog folder or the database and now the oscommerce pages on the site (except for most of the admin area) give me this error:

___________________________________

 

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

 

delete from whos_online where time_last_click < '1218674420'

 

[TEP STOP]

___________________________________

 

What would be causing this? It looks like something is messed up in the database. My client said she has only used the admin side of the site to upload new products and she doesn't have access to the FTP site. The hosting company has not notified us of any changes to the account either.....HELP! please

Thanks

liz

[sLaV-]

Try repairing the database table - using phpMyAdmin select the whos_online table and repair it .. I've read that this normally fixes the problem

[llz925]

Sorry - I'm kind of a novice at this still in some respects - but is there just a command or something to click on in the phpMyAdmin that will repair it or is this something I need to manually reset?

 

 

 

 

Try repairing the database table - using phpMyAdmin select the whos_online table and repair it .. I've read that this normally fixes the problem

[sLaV-]

Sorry - I'm kind of a novice at this still in some respects - but is there just a command or something to click on in the phpMyAdmin that will repair it or is this something I need to manually reset?

 

Through phpMyAdmin click on the table whos_online on the left then once that table is loaded on the main screen click on the Operations tab at the top ... then under Table maintenance click on Repair table

[llz925]

Through phpMyAdmin click on the table whos_online on the left then once that table is loaded on the main screen click on the Operations tab at the top ... then under Table maintenance click on Repair table

 

 

Ok, I'm in the phpMyAdmin and I've got to the point above where you click on the Operations tab at the top, but then I don't see anything that says Table Maintenance or Repair.....This is what it says in the main screen:

 

Error

SQL query:

SHOW COLUMNS FROM `whos_online` FROM `partypower_store`

 

MySQL said:

#1105 - File './partypower_store/whos_online.MYD' not found (Errcode: 13)

[llz925]

Ok, I'm in the phpMyAdmin and I've got to the point above where you click on the Operations tab at the top, but then I don't see anything that says Table Maintenance or Repair.....This is what it says in the main screen:

 

Error

SQL query:

SHOW COLUMNS FROM `whos_online` FROM `partypower_store`

 

MySQL said:

#1105 - File './partypower_store/whos_online.MYD' not found (Errcode: 13)

 

 

Can anyone help me with this????please!

[arietis]

Can anyone help me with this????please!

 

the whos_online.myd is the internal data file name for that table. my guess is that the table got corrupted and now it's to the point where mysql is unable to repair it.

 

try this: in your original install files, find the install/oscommerce.sql file. in there, you'll find the schema for the table. it will look something like: CREATE TABLE whos_online ( ... );

 

then, go into phpmyadmin and enter the command:

drop table whos_online;

 

then, paste in the sql statements for the create table...everything, including what's between the parenthesis and the following semicolon.

 

that will completely recreate the table, and things should be better from there. fortunately, this is one table that is safe to delete and recreate because the data in it is created when users are on the site. there's nothing super important in here.

 

one caveat: if you've installed any contributions that have changed this table, you will need to find out what those are. but if it's stock osc, this should do fine.

[llz925]

the whos_online.myd is the internal data file name for that table. my guess is that the table got corrupted and now it's to the point where mysql is unable to repair it.

 

try this: in your original install files, find the install/oscommerce.sql file. in there, you'll find the schema for the table. it will look something like: CREATE TABLE whos_online ( ... );

 

then, go into phpmyadmin and enter the command:

drop table whos_online;

 

then, paste in the sql statements for the create table...everything, including what's between the parenthesis and the following semicolon.

 

that will completely recreate the table, and things should be better from there. fortunately, this is one table that is safe to delete and recreate because the data in it is created when users are on the site. there's nothing super important in here.

 

one caveat: if you've installed any contributions that have changed this table, you will need to find out what those are. but if it's stock osc, this should do fine.

Ok, found the .sql file from the install, I'm in phpMyAdmin in my database, but I've never had to modify or enter anything in here - where do I enter the "drop table whos_online;" code?

 

I see the following boxes:

Create new table on database

database command

Rename database to

Copy Database to

...and then there is some checkboxes and options below that.

 

I'm just afraid I'm going to screw this up more than it all ready is so I want to make sure I'm entering everything in the correct field!

[arietis]

Ok, found the .sql file from the install, I'm in phpMyAdmin in my database, but I've never had to modify or enter anything in here - where do I enter the "drop table whos_online;" code?

 

I see the following boxes:

Create new table on database

database command

Rename database to

Copy Database to

...and then there is some checkboxes and options below that.

 

I'm just afraid I'm going to screw this up more than it all ready is so I want to make sure I'm entering everything in the correct field!

 

it depends on the version of phpmyadmin you're using. it might be 'database command'. i've also seen versions with a tab that says 'sql'. basically, you're looking for a box that will allow you to enter raw sql commands.

 

if you want to test it out ahead of time, just enter the command select * from whos_online; it should come back with the same error message you've been seeing. and if it does then you'll know you can enter sql commands. :)

[llz925]

it depends on the version of phpmyadmin you're using. it might be 'database command'. i've also seen versions with a tab that says 'sql'. basically, you're looking for a box that will allow you to enter raw sql commands.

 

if you want to test it out ahead of time, just enter the command select * from whos_online; it should come back with the same error message you've been seeing. and if it does then you'll know you can enter sql commands. :)

 

Ok - great! thanks, it worked, but now I've got this message after I recreated the table:

 

SQL query:

 

DROP TABLE whos_online CREATE TABLE whos_online(

customer_id INT,

full_name VARCHAR( 64 ) NOT NULL ,

session_id VARCHAR( 128 ) NOT NULL ,

ip_address VARCHAR( 15 ) NOT NULL ,

time_entry VARCHAR( 14 ) NOT NULL ,

time_last_click VARCHAR( 14 ) NOT NULL ,

last_page_url VARCHAR( 255 ) NOT NULL

)

 

MySQL said:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE whos_online (

customer_id int,

full_name varc

[llz925]

Ok - great! thanks, it worked, but now I've got this message after I recreated the table:

 

SQL query:

 

DROP TABLE whos_online CREATE TABLE whos_online(

customer_id INT,

full_name VARCHAR( 64 ) NOT NULL ,

session_id VARCHAR( 128 ) NOT NULL ,

ip_address VARCHAR( 15 ) NOT NULL ,

time_entry VARCHAR( 14 ) NOT NULL ,

time_last_click VARCHAR( 14 ) NOT NULL ,

last_page_url VARCHAR( 255 ) NOT NULL

)

 

MySQL said:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE whos_online (

customer_id int,

full_name varc

 

Ok, I think I was missing a " ; " in there in two places. so I've fixed that and now I got the site to come back for a split second....but now I get this message on everypage:

 

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

 

select value from sessions where sesskey = 'aa98f18b5a28fb192aa337c8b8f1491a' and expiry > '1218769416'

 

[TEP STOP]

[llz925]

I also now can't login to the admin site either and i was able to before....omg is this getting all messed up! I have no idea how this happened to begin with which is the WORST part. :(

[BryceJr]

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

select value from sessions where sesskey = 'aa98f18b5a28fb192aa337c8b8f1491a' and expiry > '1218769416'

Go back to phpMyadmin and run this SQL query.

 

REPAIR TABLE sessions;

[llz925]

Go back to phpMyadmin and run this SQL query.

 

REPAIR TABLE sessions;

 

Thank you! You are a life saver! I've got the site up and running again (as far as I can tell without placing an order) but now at the very bottom of all the pages below the footer is this code: (will it ever end?!)

 

1062 - Duplicate entry 'aa98f18b5a28fb192aa337c8b8f1491a' for key 1

 

insert into sessions values ('aa98f18b5a28fb192aa337c8b8f1491a', '1218772670', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:2:\"22\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

[TEP STOP]

 

1062 - Duplicate entry 'aa98f18b5a28fb192aa337c8b8f1491a' for key 1

 

insert into sessions values ('aa98f18b5a28fb192aa337c8b8f1491a', '1218772670', 'cart|O:12:\"shoppingcart\":4:{s:8:\"contents\";a:0:{}s:5:\"total\";i:0;s:6:\"weight\";i:0;s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"USD\";navigation|O:17:\"navigationhistory\":2:{s:4:\"path\";a:1:{i:0;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:2:\"22\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}')

 

[TEP STOP]

[BryceJr]

In your phpMyadmin, look for sessions table.

 

Delete any sessions in those table. If everything works after this, that's good.

[llz925]

In your phpMyadmin, look for sessions table.

 

Delete any sessions in those table. If everything works after this, that's good.

 

 

Thanks, not sure how I did it, but I was able to find that table and I got rid of the junk code errors at the bottom of my page.

 

Many thanks again for all your help

Liz

[BryceJr]

You're welcome.

 

Make sure you keep a backup of your database.

[~Kira]

I just had to fix these two tables myself and of course went into the installation sql file to get the right commands.

 

The client was also hosting on yahoo and the store has been up since August with no problems.

 

Suddenly everything just went batty. I think yahoo must be having issues. And they don't even have Cpanel :(