1033 Error and Host Mysql update

[exupawi]

We are getting the following error:

 

Error

 

SQL query: DocumentationEdit

 

SELECT COUNT( * ) AS num

FROM `staymyba_p_os2`.`orders_total`

 

MySQL said: Documentation

#1033 - Incorrect information in file: './staymyba_p_os2/orders_total.frm'

 

We just contacted Ipowerweb and they said they are updating to Mysql5.0 and that all problems should clear up tomorrow. Any input here? Is this the cause? If not any suggestions on a fix? I am wondering because we have had a lot of errors the past few days - see below

 

 

PROBLEM: 8/07/06 504 ? Received error with the ?whos_on_line? table.

 

 

PROBLEM: 8/12/06 1054 - Unknown column 'p.products_id' in 'on clause'

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '36'

 

[TEP STOP]

 

 

8/12 PROBLEM: The ?REVIEWS? page in ADMIN give the following error.

 

REVIEWS

 

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 '-20, 20' at line 1

 

select reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

 

[TEP STOP]

 

8/12 PROBLEM: The ?SPECIALS? page in ADMIN give the following error.

 

SPECIALS

 

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 '-20, 20' at line 1

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -20, 20

 

[TEP STOP]

 

8/12 ORDERS:

 

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 '-20, 20' at line 1

 

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

[TEP STOP]

[Guest]

install the latest osc upgrade

http://www.oscommerce.com/solutions/downloads