Strange error message after 2 years of site running perfect

[Guest]

Hello,

 

Have had my osc shop up and running perfect now for nearly 2 years and within the last 3-4 days the below error message now appear when you try to access the site, I can still access the admin section this just appears when I go onto the site.

 

 

1030 - Got error 127 from table handler

delete from whos_online where time_last_click < '1133798427'

[TEP STOP]

 

Anyone any ideas what this is and how I can fix it?

 

Thanks,

 

Jonny

[♥Vger]

Looks like an error has crept into your database. Pick a time when visits to the site are low and access your database via phpMyAdmin. Got to the whois_online table, select all entries for who is online and elect to drop them from the database. See if that fixes it.

 

However, it may also be an error with MySQL on your server, so it's worth while checking with your hosts to see if they've been 'updating' anything lately.

 

Vger

[Guest]

Hi Vger,

 

Just tried what you said and now I have htis error message:

 

 

1146 - Table 'suncusto_catalog.whos_online' doesn't exist

delete from whos_online where time_last_click < '1133865344'

[TEP STOP]

 

Also I dont know how to return the table to the database to the way it was Im very new with phpMyAdmin.

 

Anyone any ideas how to sort this problem the site has been down now for over a week and im loosing orders!

 

Any help greatly appreciated.

 

Thanks,

 

Jonny

[boxtel]

Hello,

 

Have had my osc shop up and running perfect now for nearly 2 years and within the last 3-4 days the below error message now appear when you try to access the site, I can still access the admin section this just appears when I go onto the site.

1030 - Got error 127 from table handler

delete from whos_online where time_last_click < '1133798427'

[TEP STOP]

 

Anyone any ideas what this is and how I can fix it?

 

Thanks,

 

Jonny

 

corrupted table, repair it.

[Guest]

What do I need to repair and how do I go about it, as I said before I'm very new to phpMyAdmin,

 

Thanks,

 

Jonny.

[boxtel]

Hi Vger,

 

Just tried what you said and now I have htis error message:

1146 - Table 'suncusto_catalog.whos_online' doesn't exist

delete from whos_online where time_last_click < '1133865344'

[TEP STOP]

 

Also I dont know how to return the table to the database to the way it was Im very new with phpMyAdmin.

 

Anyone any ideas how to sort this problem the site has been down now for over a week and im loosing orders!

 

Any help greatly appreciated.

 

Thanks,

 

Jonny

 

well, if you have now dropped the table, simply run the create table query again or better still get that query statement from your backup file if the table was no longer standard.

 

the statement should look something like :

 

DROP TABLE IF EXISTS 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(64) NOT NULL

);

[Guest]

ok have tried to add the tables back into the database from the ones supplied as I did not have a backup of the database to use.

 

I am now left with this error message:

 

1054 - Unknown column 'customer_id' in 'field list'

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'aa52a0517b29d40a042486c6a4fd57f2', '87.112.80.19', '1133876688', '1133876688', '/')

[TEP STOP]

 

I now have a valid backup of my database should i restore it so as it is back to the error message:

 

1146 - Table 'suncusto_catalog.whos_online' doesn't exist

delete from whos_online where time_last_click < '1133865344'

[TEP STOP]

 

Really need help with this one so as I can get the site up and running again, anyone any more ideas of what I can try yo get my site working?

 

Thanks,

 

Jonny.

[boxtel]

ok have tried to add the tables back into the database from the ones supplied as I did not have a backup of the database to use.

 

I am now left with this error message:

 

1054 - Unknown column 'customer_id' in 'field list'

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'aa52a0517b29d40a042486c6a4fd57f2', '87.112.80.19', '1133876688', '1133876688', '/')

[TEP STOP]

 

I now have a valid backup of my database should i restore it so as it is back to the error message:

 

1146 - Table 'suncusto_catalog.whos_online' doesn't exist

delete from whos_online where time_last_click < '1133865344'

[TEP STOP]

 

Really need help with this one so as I can get the site up and running again, anyone any more ideas of what I can try yo get my site working?

 

Thanks,

 

Jonny.

 

just simply run this sql statement on your database :

 

DROP TABLE IF EXISTS 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(64) NOT NULL

);

[Guest]

Hi Boxtel,

 

Thanks for the reply, IT WORKED! YEAH!

 

Thanks alot mate.

 

Any idea what it was and maybe how it can be prevented again.

 

Cheers,

 

Jonny