Need urgent help

[Guest]

I need help.

I'm working on a web store and I have a big problem here. I try to go to visite the shop , and I only find this error mesagge:

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/isqxxzf/public_html/catalog/includes/functions/database.php on line 45

1030 - Got error 127 from storage engine

 

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image from products p, products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' order by products_date_added desc limit 25

 

[TEP STOP]

 

When I go to my admin. It give me this error messagge:

1030 - Got error 127 from storage engine

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = '33' order by pd.products_name

 

[TEP STOP]

Please help me.

Visit My Website

[Guest]

sounds like your database might be down or faulty

 

How does it look from the admin area ie phpMyAdmin

 

do other things access your database

[Guest]

sounds like your database might be down or faulty

 

How does it look from the admin area ie phpMyAdmin

 

do other things access your database

 

Hi Deejay,

Thanks for your answer.

The strange thing here is that if I go to my admin everything works fine except« reports - Best Viewed Products» in that area I see that error

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/isqxxzf/public_html/catalog/administrador/includes/functions/database.php on line 45

1030 - Got error 127 from storage engine

 

select count(*) as total from products p, products_description pd, languages l where p.products_id = pd.products_id and l.languages_id = pd.language_id

 

[TEP STOP]

The error I mentioned in my previous post disappeared mysteriously. Can you please help me?

 

Thanks

[Gauravs]

How old is the site ,any idea how many rows are in the database?

This is a mysql error (thus good idea to check on mysql forums) and generally surfaces when database has grown over a period of time.

 

Google THIS and first result should help you more.

 

cheers

[Guest]

as the previous error dissapeared, I would take a punt that its maybe something going on at your servers end of things.

 

I would contact your hosts or wait to see if your current problem 'disappears' as well.

[Guest]

Hey guys thanks for your help.

Everything is ok now. The problem was the data base, it was corrupted. I made an automatic repair and everything is working perfectly now.

Thanks :thumbsup: